Item Assignment Details Query - ASCP

SELECT
 (
    SELECT
      meaning
    FROM
      fnd_lookup_values_vl
    WHERE
      lookup_type  ='MRP_ASSIGNMENT_TYPE'
    AND lookup_code=m.ASSIGNMENT_TYPE
  )
  Assignment_type,
    ( select msib.segment1 from mtl_system_items_b msib where m.inventory_item_id=msib.inventory_item_id
AND m.organization_id=msib.organization_id) Item
, m.ORGANIZATION_CODE
, m.organization_id
, m.entity_name
, m.description
, m.sourcing_rule_type_text
, m.sourcing_rule_name
, m.inventory_item_id
, m.creation_date
  ,m.ASSIGNMENT_ID
, m.ASSIGNMENT_SET_ID
FROM
  MRP_SR_ASSIGNMENTS_v m
  , MRP_ASSIGNMENT_SETS mas
  where m.assignment_set_id=:P_ASSIGNMENT_SET_ID
 and mas.assignment_set_id=m.assignment_set_id
  and m.organization_id=:P_ORG_ID
;