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 693: msc_trading_partner_sites mtps -- For supplier intransit LT project

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

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

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

Line 3556: msc_trading_partner_sites mtps

3552: SELECT mtsil.sr_tp_site_id, mtps.tp_site_code
3553: INTO l_other_cols.sr_supplier_site_id(j),
3554: l_other_cols.vendor_site_name(j)
3555: FROM msc_tp_site_id_lid mtsil,
3556: msc_trading_partner_sites mtps
3557: WHERE mtsil.tp_site_id = mtps.partner_site_id
3558: AND mtsil.sr_instance_id = l_sources.instance_id(j)
3559: AND mtsil.partner_type = 1
3560: AND mtps.partner_site_id =

Line 5871: -- MSC_TRADING_PARTNER_SITES TP,

5867: MSC_SYSTEM_ITEMS ITEM,
5868: MSC_SR_SOURCE_ORG SOURCE_ORG,
5869: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
5870: MSC_SOURCING_RULES MSR,
5871: -- MSC_TRADING_PARTNER_SITES TP,
5872: -- MSC_TP_SITE_ID_LID MTSIL,
5873: MSC_SR_ASSIGNMENTS MSRA
5874: WHERE
5875: MSRA.ASSIGNMENT_TYPE = 3 /* ITEM */

Line 6074: -- MSC_TRADING_PARTNER_SITES TP,

6070: x_atp_sources.Ship_Method,
6071: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6072: FROM
6073: MSC_ITEM_CATEGORIES CAT,
6074: -- MSC_TRADING_PARTNER_SITES TP,
6075: MSC_SR_SOURCE_ORG SOURCE_ORG,
6076: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6077: MSC_SOURCING_RULES MSR,
6078: MSC_SR_ASSIGNMENTS MSRA

Line 6360: -- MSC_TRADING_PARTNER_SITES TP,

6356: x_atp_sources.Ship_Method,
6357: x_atp_sources.Sup_Cap_Type -- For supplier intransit LT project
6358: FROM
6359: MSC_SYSTEM_ITEMS ITEM,
6360: -- MSC_TRADING_PARTNER_SITES TP,
6361: MSC_SR_SOURCE_ORG SOURCE_ORG,
6362: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6363: MSC_SOURCING_RULES MSR,
6364: MSC_SR_ASSIGNMENTS MSRA

Line 6943: -- MSC_TRADING_PARTNER_SITES TP,

6939: -1,
6940: '@@@'
6941: FROM
6942: MSC_SYSTEM_ITEMS ITEM,
6943: -- MSC_TRADING_PARTNER_SITES TP,
6944: MSC_SR_SOURCE_ORG SOURCE_ORG,
6945: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
6946: MSC_SOURCING_RULES MSR,
6947: MSC_SR_ASSIGNMENTS MSRA,

Line 7275: -- MSC_TRADING_PARTNER_SITES TP,

7271: -1,
7272: '@@@'
7273: FROM
7274: MSC_ITEM_CATEGORIES CAT,
7275: -- MSC_TRADING_PARTNER_SITES TP,
7276: MSC_SR_SOURCE_ORG SOURCE_ORG,
7277: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7278: MSC_SOURCING_RULES MSR,
7279: MSC_SR_ASSIGNMENTS MSRA,

Line 7747: -- MSC_TRADING_PARTNER_SITES TP,

7743: -1,
7744: '@@@'
7745: FROM
7746: MSC_SYSTEM_ITEMS ITEM,
7747: -- MSC_TRADING_PARTNER_SITES TP,
7748: MSC_SR_SOURCE_ORG SOURCE_ORG,
7749: MSC_SR_RECEIPT_ORG RECEIPT_ORG,
7750: MSC_SOURCING_RULES MSR,
7751: MSC_SR_ASSIGNMENTS MSRA,