DBA Data[Home] [Help]

APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_ITEM_ID_LID

Line 150: msc_item_id_lid miil

146: mss.ACK_REFERENCE_NUMBER
147: from msc_st_supplies mss,
148: msc_tp_id_lid mtil,
149: msc_tp_site_id_lid mtsil,
150: msc_item_id_lid miil
151: where mss.order_type = G_MRP_PO_ACK
152: and mss.sr_instance_id = p_instance_id
153: and mss.supplier_id = mtil.sr_tp_id
154: and mss.sr_instance_id = mtil.sr_instance_id