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_ATP_PROC dependencies on MSC_TRADING_PARTNER_SITES

Line 692: msc_trading_partner_sites mtps -- For supplier intransit LT project

688: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
689: FROM
690: msc_item_sourcing s,
691: msc_ship_set_temp msst,
692: msc_trading_partner_sites mtps -- For supplier intransit LT project
693: WHERE
694: s.inventory_item_id = msst.inventory_item_id
695: AND s.organization_id = p_organization_id
696: AND s.sr_instance_id = p_instance_id

Line 905: msc_trading_partner_sites mtps -- For supplier intransit LT project

901: x_atp_sources.Lead_Time,
902: x_atp_sources.Ship_Method,
903: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
904: FROM msc_item_sourcing s,
905: msc_trading_partner_sites mtps -- For supplier intransit LT project
906: WHERE s.inventory_item_id = l_inv_item_id
907: AND s.organization_id = p_organization_id
908: AND s.sr_instance_id = p_instance_id
909: /*AND s.assignment_set_id = p_assign_set_id*/

Line 3547: msc_trading_partner_sites mtps

3543: SELECT mtsil.sr_tp_site_id, mtps.tp_site_code
3544: INTO l_other_cols.sr_supplier_site_id(j),
3545: l_other_cols.vendor_site_name(j)
3546: FROM msc_tp_site_id_lid mtsil,
3547: msc_trading_partner_sites mtps
3548: WHERE mtsil.tp_site_id = mtps.partner_site_id
3549: AND mtsil.sr_instance_id = l_sources.instance_id(j)
3550: AND mtsil.partner_type = 1
3551: AND mtps.partner_site_id =

Line 5860: -- MSC_TRADING_PARTNER_SITES TP,

5856: MSC_SYSTEM_ITEMS ITEM,
5857: MSC_SR_SOURCE_ORG SOURCE_ORG,
5858: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5859: MSC_SOURCING_RULES MSR,
5860: -- MSC_TRADING_PARTNER_SITES TP,
5861: -- MSC_TP_SITE_ID_LID MTSIL,
5862: MSC_SR_ASSIGNMENTS MSRA
5863: WHERE
5864: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */

Line 6063: -- MSC_TRADING_PARTNER_SITES TP,

6059: x_atp_sources.Ship_Method,
6060: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6061: FROM
6062: MSC_ITEM_CATEGORIES CAT,
6063: -- MSC_TRADING_PARTNER_SITES TP,
6064: MSC_SR_SOURCE_ORG SOURCE_ORG,
6065: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6066: MSC_SOURCING_RULES MSR,
6067: MSC_SR_ASSIGNMENTS MSRA

Line 6349: -- MSC_TRADING_PARTNER_SITES TP,

6345: x_atp_sources.Ship_Method,
6346: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6347: FROM
6348: MSC_SYSTEM_ITEMS ITEM,
6349: -- MSC_TRADING_PARTNER_SITES TP,
6350: MSC_SR_SOURCE_ORG SOURCE_ORG,
6351: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6352: MSC_SOURCING_RULES MSR,
6353: MSC_SR_ASSIGNMENTS MSRA

Line 6932: -- MSC_TRADING_PARTNER_SITES TP,

6928: -1,
6929: '@@@'
6930: FROM
6931: MSC_SYSTEM_ITEMS ITEM,
6932: -- MSC_TRADING_PARTNER_SITES TP,
6933: MSC_SR_SOURCE_ORG SOURCE_ORG,
6934: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6935: MSC_SOURCING_RULES MSR,
6936: MSC_SR_ASSIGNMENTS MSRA,

Line 7264: -- MSC_TRADING_PARTNER_SITES TP,

7260: -1,
7261: '@@@'
7262: FROM
7263: MSC_ITEM_CATEGORIES CAT,
7264: -- MSC_TRADING_PARTNER_SITES TP,
7265: MSC_SR_SOURCE_ORG SOURCE_ORG,
7266: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7267: MSC_SOURCING_RULES MSR,
7268: MSC_SR_ASSIGNMENTS MSRA,

Line 7736: -- MSC_TRADING_PARTNER_SITES TP,

7732: -1,
7733: '@@@'
7734: FROM
7735: MSC_SYSTEM_ITEMS ITEM,
7736: -- MSC_TRADING_PARTNER_SITES TP,
7737: MSC_SR_SOURCE_ORG SOURCE_ORG,
7738: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7739: MSC_SOURCING_RULES MSR,
7740: MSC_SR_ASSIGNMENTS MSRA,