DBA Data[Home] [Help]

APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_TP_ID_LID

Line 1674: msc_tp_id_lid mtil,

1670: cursor newTpMap is
1671: select DISTINCT mtp.partner_id,
1672: mcr.relationship_id
1673: from msc_trading_partners mtp,
1674: msc_tp_id_lid mtil,
1675: msc_company_id_lid mcil,
1676: msc_company_relationships mcr
1677: where mtp.partner_id = mtil.tp_id
1678: and mtil.sr_instance_id = p_instance_id

Line 1944: msc_tp_id_lid mtil,

1940: mic.list_price,
1941: mic.planner_code,
1942: mic.refresh_number
1943: from msc_st_item_customers mic,
1944: msc_tp_id_lid mtil,
1945: msc_tp_site_id_lid mtsil,
1946: msc_item_id_lid t1
1947: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id
1948: AND t1.sr_instance_id= mic.sr_instance_id