APPS.PO_VAL_DISTRIBUTIONS2 dependencies on MTL_SYSTEM_ITEMS

Line 541: FROM mtl_system_items msi

537: INSERT INTO po_session_gt(key, num1, char1)
538: SELECT l_key,
539: l_num_list_tbl(i),
540: decode(msi.outside_operation_flag,'Y','O', decode(msi.stock_enabled_flag,'Y','E','D'))
541: FROM mtl_system_items msi
542: WHERE p_dest_type_code_tbl(i) IS NOT NULL
543: AND msi.organization_id = p_ship_to_org_id_tbl(i)
544: AND msi.inventory_item_id = p_item_id_tbl(i);
545:

Line 734: FROM mtl_system_items msi

730: AND ( p_item_id_tbl(i) IS NULL
731: OR ( p_item_id_tbl(i) IS NOT NULL
732: AND EXISTS(
733: SELECT NULL
734: FROM mtl_system_items msi
735: WHERE msi.organization_id = NVL(p_ship_to_org_id_tbl(i), msi.organization_id)
736: AND msi.inventory_item_id = p_item_id_tbl(i)
737: AND ( msi.restrict_subinventories_code = 2
738: OR ( msi.restrict_subinventories_code = 1