eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_M2A_PUSH dependencies on MSC_TRADING_PARTNERS

Line 921: from msc_trading_partners

917:
918:
919: IF pSUPPLIER_ID IS NOT NULL THEN
920: select sr_tp_id into lv_sr_tp_id
921: from msc_trading_partners
922: where sr_instance_id = pINSTANCE_ID
923: and partner_id = pSUPPLIER_ID;
924: END IF;
925:

Line 1471: ||' msc_trading_partners ORG ,'

1467: ||' NUMBER1 '
1468: ||' FROM MSC_SUPPLIES ms,'
1469: ||' MSC_TP_ID_LID mtil,'
1470: ||' MSC_TP_SITE_ID_LID mtsil ,'
1471: ||' msc_trading_partners ORG ,'
1472: ||' MSC_SYSTEM_ITEMS msi'
1473: ||' WHERE ms.plan_id = :PLAN_ID'
1474: ||' AND ms.sr_instance_id = :pINSTANCE_ID'
1475: ||' AND msi.organization_id = ms.organization_id'

Line 1491: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'

1487: ||' AND mtsil.tp_site_id = nvl(source_supplier_site_id,ms.supplier_site_id)'
1488: ||' AND mtsil.partner_type = 1'
1489: ||' AND mtsil.sr_instance_id = ms.sr_instance_id'
1490: ||' AND nvl(source_supplier_site_id,ms.supplier_site_id) IS NOT NULL'
1491: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'
1492: ||' where msi1.inventory_item_id = ms.inventory_item_id '
1493: ||' and msi1.organization_id = ms.organization_id '
1494: ||' and msi1.plan_id = ms.plan_id '
1495: ||' AND msi1.sr_instance_id = ms.sr_instance_id '

Line 1751: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'

1747: ||' AND mtil.tp_id = nvl(ms.source_supplier_id,ms.supplier_id)'
1748: ||' AND mtil.partner_type = 1'
1749: ||' AND mtil.sr_instance_id = ms.sr_instance_id'
1750: ||' AND nvl(source_supplier_site_id,ms.supplier_site_id) IS NULL '
1751: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'
1752: ||' where msi1.inventory_item_id = ms.inventory_item_id '
1753: ||' and msi1.organization_id = ms.organization_id '
1754: ||' and msi1.plan_id = ms.plan_id '
1755: ||' AND msi1.sr_instance_id = ms.sr_instance_id '

Line 2010: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'

2006: ||' AND msi.inventory_item_id = ms.inventory_item_id'
2007: ||' AND msi.sr_instance_id = ms.sr_instance_id'
2008: ||' AND msi.plan_id = ms.plan_id'
2009: ||' and trunc(ms.NEW_SCHEDULE_DATE) BETWEEN (:pHORIZON_START_DATE) and (:pHORIZON_END_DATE)'
2010: ||' AND NOT EXISTS (select 1 from msc_system_items msi1 , msc_trading_partners mtp'
2011: ||' where msi1.inventory_item_id = ms.inventory_item_id '
2012: ||' and msi1.organization_id = ms.organization_id '
2013: ||' and msi1.plan_id = ms.plan_id '
2014: ||' AND msi1.sr_instance_id = ms.sr_instance_id '