APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_SYSTEM_ITEMS

Line 529: FROM mtl_system_items msi

525: INSERT INTO po_session_gt(key, num1, char1)
526: SELECT l_key,
527: l_num_list_tbl(i),
528: decode(msi.outside_operation_flag,'Y','O', decode(msi.stock_enabled_flag,'Y','E','D'))
529: FROM mtl_system_items msi
530: WHERE p_dest_type_code_tbl(i) IS NOT NULL
531: AND msi.organization_id = p_ship_to_org_id_tbl(i)
532: AND msi.inventory_item_id = p_item_id_tbl(i);
533:

Line 722: FROM mtl_system_items msi

718: AND ( p_item_id_tbl(i) IS NULL
719: OR ( p_item_id_tbl(i) IS NOT NULL
720: AND EXISTS(
721: SELECT NULL
722: FROM mtl_system_items msi
723: WHERE msi.organization_id = NVL(p_ship_to_org_id_tbl(i), msi.organization_id)
724: AND msi.inventory_item_id = p_item_id_tbl(i)
725: AND ( msi.restrict_subinventories_code = 2
726: OR ( msi.restrict_subinventories_code = 1