DBA Data[Home] [Help]

APPS.MSC_CL_SUPPLIER_RESP dependencies on MSC_TP_SITE_ID_LID

Line 149: msc_tp_site_id_lid mtsil,

145: mss.NEED_BY_DATE,
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