DBA Data[Home] [Help]

APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_TP_ID_LID

Line 1591: msc_tp_id_lid mtil,

1587: cursor newTpMap is
1588: select DISTINCT mtp.partner_id,
1589: mcr.relationship_id
1590: from msc_trading_partners mtp,
1591: msc_tp_id_lid mtil,
1592: msc_company_id_lid mcil,
1593: msc_company_relationships mcr
1594: where mtp.partner_id = mtil.tp_id
1595: and mtil.sr_instance_id = p_instance_id

Line 1861: msc_tp_id_lid mtil,

1857: mic.list_price,
1858: mic.planner_code,
1859: mic.refresh_number
1860: from msc_st_item_customers mic,
1861: msc_tp_id_lid mtil,
1862: msc_tp_site_id_lid mtsil,
1863: msc_item_id_lid t1
1864: where t1.SR_INVENTORY_ITEM_ID = mic.inventory_item_id
1865: AND t1.sr_instance_id= mic.sr_instance_id