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_SCE_LOADS_PKG dependencies on MSC_TRADING_PARTNER_MAPS

Line 1914: msc_trading_partner_maps map,

1910: UNION
1911: select msi.inventory_item_id
1912: from msc_system_items msi,
1913: msc_trading_partners part,
1914: msc_trading_partner_maps map,
1915: msc_company_sites cs,
1916: msc_companies c
1917: where msi.plan_id = -1 and
1918: msi.item_name = nvl(ln.owner_item_name,

Line 1952: msc_trading_partner_maps map,

1948: UNION
1949: select mis.inventory_item_id
1950: from msc_item_suppliers mis,
1951: msc_trading_partners mtp,
1952: msc_trading_partner_maps map,
1953: msc_trading_partner_maps map1,
1954: msc_trading_partner_maps map2,
1955: msc_company_relationships r,
1956: msc_company_sites cs,

Line 1953: msc_trading_partner_maps map1,

1949: select mis.inventory_item_id
1950: from msc_item_suppliers mis,
1951: msc_trading_partners mtp,
1952: msc_trading_partner_maps map,
1953: msc_trading_partner_maps map1,
1954: msc_trading_partner_maps map2,
1955: msc_company_relationships r,
1956: msc_company_sites cs,
1957: msc_companies c,

Line 1954: msc_trading_partner_maps map2,

1950: from msc_item_suppliers mis,
1951: msc_trading_partners mtp,
1952: msc_trading_partner_maps map,
1953: msc_trading_partner_maps map1,
1954: msc_trading_partner_maps map2,
1955: msc_company_relationships r,
1956: msc_company_sites cs,
1957: msc_companies c,
1958: msc_company_sites cs1

Line 1990: msc_trading_partner_maps map,

1986: ln.item_name IS NULL
1987: UNION
1988: select mic.inventory_item_id
1989: from msc_item_customers mic,
1990: msc_trading_partner_maps map,
1991: msc_trading_partner_maps map1,
1992: msc_company_relationships r,
1993: msc_company_sites cs,
1994: msc_companies c

Line 1991: msc_trading_partner_maps map1,

1987: UNION
1988: select mic.inventory_item_id
1989: from msc_item_customers mic,
1990: msc_trading_partner_maps map,
1991: msc_trading_partner_maps map1,
1992: msc_company_relationships r,
1993: msc_company_sites cs,
1994: msc_companies c
1995: where mic.plan_id = -1 and

Line 2035: msc_trading_partner_maps map,

2031: NVL(ln.row_status, G_PROCESS) = G_PROCESS and
2032: not exists ( select msi.inventory_item_id
2033: from msc_system_items msi,
2034: msc_trading_partners part,
2035: msc_trading_partner_maps map,
2036: msc_company_sites cs,
2037: msc_companies c
2038: where msi.plan_id = -1 and
2039: msi.item_name = ln.item_name and

Line 2059: msc_trading_partner_maps map,

2055: /* For Consumption Advice, Item should be valid in the Org modelled as the customer (publisher) */
2056: union select 1
2057: from msc_system_items msi,
2058: msc_trading_partners part,
2059: msc_trading_partner_maps map,
2060: msc_company_sites cs,
2061: msc_companies c
2062: where
2063: msi.plan_id = -1 and

Line 2101: msc_trading_partner_maps maps,

2097: FROM msc_companies c0,
2098: msc_company_sites s0,
2099: msc_trading_partners mtp,
2100: msc_trading_partners mtp1,
2101: msc_trading_partner_maps maps,
2102: msc_trading_partner_maps maps1,
2103: msc_trading_partner_maps maps2,
2104: msc_trading_partner_sites mtps,
2105: msc_company_sites cs,

Line 2102: msc_trading_partner_maps maps1,

2098: msc_company_sites s0,
2099: msc_trading_partners mtp,
2100: msc_trading_partners mtp1,
2101: msc_trading_partner_maps maps,
2102: msc_trading_partner_maps maps1,
2103: msc_trading_partner_maps maps2,
2104: msc_trading_partner_sites mtps,
2105: msc_company_sites cs,
2106: msc_companies c,

Line 2103: msc_trading_partner_maps maps2,

2099: msc_trading_partners mtp,
2100: msc_trading_partners mtp1,
2101: msc_trading_partner_maps maps,
2102: msc_trading_partner_maps maps1,
2103: msc_trading_partner_maps maps2,
2104: msc_trading_partner_sites mtps,
2105: msc_company_sites cs,
2106: msc_companies c,
2107: msc_company_relationships rel

Line 2144: msc_trading_partner_maps m,

2140: flv.language = p_language)) AND
2141: exists( select 'exist'
2142: from msc_companies c,
2143: msc_company_sites s,
2144: msc_trading_partner_maps m,
2145: msc_trading_partners t
2146: where upper(c.company_name) = upper(ln.publisher_company)
2147: and c.company_id = s.company_id
2148: and upper(s.company_site_name) = upper(ln.publisher_site)

Line 2451: msc_trading_partner_maps map,

2447: UNION
2448: select msi.inventory_item_id
2449: from msc_system_items msi,
2450: msc_trading_partners part,
2451: msc_trading_partner_maps map,
2452: msc_company_sites cs,
2453: msc_companies c,
2454: msc_supdem_lines_interface ln
2455: where msi.plan_id = -1 and

Line 2492: msc_trading_partner_maps map,

2488: ln.item_name IS NULL
2489: UNION
2490: select mis.inventory_item_id
2491: from msc_item_suppliers mis,
2492: msc_trading_partner_maps map,
2493: msc_trading_partner_maps map1,
2494: msc_company_relationships r,
2495: msc_company_sites cs,
2496: msc_companies c,

Line 2493: msc_trading_partner_maps map1,

2489: UNION
2490: select mis.inventory_item_id
2491: from msc_item_suppliers mis,
2492: msc_trading_partner_maps map,
2493: msc_trading_partner_maps map1,
2494: msc_company_relationships r,
2495: msc_company_sites cs,
2496: msc_companies c,
2497: msc_supdem_lines_interface ln

Line 2526: msc_trading_partner_maps map,

2522: ln.item_name IS NULL
2523: UNION
2524: select mic.inventory_item_id
2525: from msc_item_customers mic,
2526: msc_trading_partner_maps map,
2527: msc_trading_partner_maps map1,
2528: msc_company_relationships r,
2529: msc_company_sites cs,
2530: msc_companies c,

Line 2527: msc_trading_partner_maps map1,

2523: UNION
2524: select mic.inventory_item_id
2525: from msc_item_customers mic,
2526: msc_trading_partner_maps map,
2527: msc_trading_partner_maps map1,
2528: msc_company_relationships r,
2529: msc_company_sites cs,
2530: msc_companies c,
2531: msc_supdem_lines_interface ln

Line 7393: msc_trading_partner_maps maps,

7389: t_cust_site(j),
7390: t_cust_site_id(j)
7391: FROM msc_trading_partners mtp,
7392: msc_trading_partners mtp1,
7393: msc_trading_partner_maps maps,
7394: msc_trading_partner_maps maps1,
7395: msc_trading_partner_maps maps2,
7396: msc_trading_partner_sites mtps,
7397: msc_company_sites cs,

Line 7394: msc_trading_partner_maps maps1,

7390: t_cust_site_id(j)
7391: FROM msc_trading_partners mtp,
7392: msc_trading_partners mtp1,
7393: msc_trading_partner_maps maps,
7394: msc_trading_partner_maps maps1,
7395: msc_trading_partner_maps maps2,
7396: msc_trading_partner_sites mtps,
7397: msc_company_sites cs,
7398: msc_companies c,

Line 7395: msc_trading_partner_maps maps2,

7391: FROM msc_trading_partners mtp,
7392: msc_trading_partners mtp1,
7393: msc_trading_partner_maps maps,
7394: msc_trading_partner_maps maps1,
7395: msc_trading_partner_maps maps2,
7396: msc_trading_partner_sites mtps,
7397: msc_company_sites cs,
7398: msc_companies c,
7399: msc_company_relationships rel

Line 7774: msc_trading_partner_maps map,

7770: from msc_item_suppliers mis,
7771: msc_system_items msi,
7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,
7775: msc_trading_partner_maps map1,
7776: msc_trading_partner_maps map2,
7777: msc_trading_partners mtp,
7778: msc_company_relationships r

Line 7775: msc_trading_partner_maps map1,

7771: msc_system_items msi,
7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,
7775: msc_trading_partner_maps map1,
7776: msc_trading_partner_maps map2,
7777: msc_trading_partners mtp,
7778: msc_company_relationships r
7779: where itm.inventory_item_id (+)= msi.base_item_id and

Line 7776: msc_trading_partner_maps map2,

7772: msc_items itm,
7773: msc_items itm1,
7774: msc_trading_partner_maps map,
7775: msc_trading_partner_maps map1,
7776: msc_trading_partner_maps map2,
7777: msc_trading_partners mtp,
7778: msc_company_relationships r
7779: where itm.inventory_item_id (+)= msi.base_item_id and
7780: msi.organization_id = mis.organization_id and

Line 7819: msc_trading_partner_maps map,

7815: nvl(mis.description,itm.description),
7816: mis.uom_code
7817: from msc_item_suppliers mis,
7818: msc_items itm,
7819: msc_trading_partner_maps map,
7820: msc_trading_partner_maps map1,
7821: msc_trading_partner_maps map2,
7822: msc_trading_partners mtp,
7823: msc_company_relationships r

Line 7820: msc_trading_partner_maps map1,

7816: mis.uom_code
7817: from msc_item_suppliers mis,
7818: msc_items itm,
7819: msc_trading_partner_maps map,
7820: msc_trading_partner_maps map1,
7821: msc_trading_partner_maps map2,
7822: msc_trading_partners mtp,
7823: msc_company_relationships r
7824: where mis.inventory_item_id = p_item_id and

Line 7821: msc_trading_partner_maps map2,

7817: from msc_item_suppliers mis,
7818: msc_items itm,
7819: msc_trading_partner_maps map,
7820: msc_trading_partner_maps map1,
7821: msc_trading_partner_maps map2,
7822: msc_trading_partners mtp,
7823: msc_company_relationships r
7824: where mis.inventory_item_id = p_item_id and
7825: mis.plan_id = -1 and

Line 8499: msc_trading_partner_maps map

8495: l_planner_code--Bug 4424426
8496: from msc_system_items msi,
8497: msc_items itm,
8498: msc_trading_partners part,
8499: msc_trading_partner_maps map
8500: where msi.inventory_item_id = t_item_id(j) and
8501: msi.organization_id = part.sr_tp_id and
8502: msi.sr_instance_id = part.sr_instance_id and
8503: msi.plan_id = -1 and

Line 8541: msc_trading_partner_maps map,

8537: l_base_item_id,
8538: l_base_item_name,
8539: l_planner_code--Bug 4424426
8540: from msc_item_customers mic,
8541: msc_trading_partner_maps map,
8542: msc_trading_partner_maps map1,
8543: msc_company_relationships r
8544: where mic.inventory_item_id = t_item_id(j) and
8545: mic.plan_id = -1 and

Line 8542: msc_trading_partner_maps map1,

8538: l_base_item_name,
8539: l_planner_code--Bug 4424426
8540: from msc_item_customers mic,
8541: msc_trading_partner_maps map,
8542: msc_trading_partner_maps map1,
8543: msc_company_relationships r
8544: where mic.inventory_item_id = t_item_id(j) and
8545: mic.plan_id = -1 and
8546: mic.customer_id = map.tp_key and

Line 8574: msc_trading_partner_maps map

8570: l_base_item_name
8571: from msc_system_items msi,
8572: msc_items itm,
8573: msc_trading_partners part,
8574: msc_trading_partner_maps map
8575: where itm.inventory_item_id (+)=
8576: msi.base_item_id and
8577: msi.inventory_item_id = t_item_id(j) and
8578: msi.organization_id = part.sr_tp_id and

Line 8623: msc_trading_partner_maps map

8619: l_desc,
8620: l_uom
8621: from msc_system_items msi,
8622: msc_trading_partners part,
8623: msc_trading_partner_maps map
8624: where msi.plan_id = -1 and
8625: msi.inventory_item_id = t_item_id(j) and
8626: msi.organization_id = part.sr_tp_id and
8627: msi.sr_instance_id = part.sr_instance_id and

Line 8642: msc_trading_partner_maps map,

8638: into l_item_name,
8639: l_desc,
8640: l_uom
8641: from msc_item_customers mic,
8642: msc_trading_partner_maps map,
8643: msc_trading_partner_maps map1,
8644: msc_company_relationships r
8645: where mic.inventory_item_id = t_item_id(j) and
8646: mic.plan_id = -1 and

Line 8643: msc_trading_partner_maps map1,

8639: l_desc,
8640: l_uom
8641: from msc_item_customers mic,
8642: msc_trading_partner_maps map,
8643: msc_trading_partner_maps map1,
8644: msc_company_relationships r
8645: where mic.inventory_item_id = t_item_id(j) and
8646: mic.plan_id = -1 and
8647: mic.customer_id = map.tp_key and

Line 8684: msc_trading_partner_maps map

8680: l_desc,
8681: l_uom
8682: from msc_system_items msi,
8683: msc_trading_partners part,
8684: msc_trading_partner_maps map
8685: where msi.plan_id = -1 and
8686: msi.inventory_item_id = t_item_id(j) and
8687: msi.organization_id = part.sr_tp_id and
8688: msi.sr_instance_id = part.sr_instance_id and

Line 10023: msc_trading_partner_maps mtpm,

10019: UNION ALL
10020: SELECT msi.inventory_item_id
10021: FROM msc_system_items msi,
10022: msc_trading_partners mtp,
10023: msc_trading_partner_maps mtpm,
10024: msc_company_sites mcs,
10025: msc_companies mc
10026: WHERE msi.plan_id = -1 AND
10027: mssn.parent_header_id = p_header_id AND

Line 10047: msc_trading_partner_maps map,

10043:
10044: UNION ALL
10045: SELECT mis.inventory_item_id
10046: FROM msc_item_suppliers mis,
10047: msc_trading_partner_maps map,
10048: msc_trading_partner_maps map1,
10049: msc_company_relationships r,
10050: msc_company_sites cs,
10051: msc_companies c

Line 10048: msc_trading_partner_maps map1,

10044: UNION ALL
10045: SELECT mis.inventory_item_id
10046: FROM msc_item_suppliers mis,
10047: msc_trading_partner_maps map,
10048: msc_trading_partner_maps map1,
10049: msc_company_relationships r,
10050: msc_company_sites cs,
10051: msc_companies c
10052: WHERE mis.plan_id = -1 and

Line 10076: msc_trading_partner_maps map,

10072:
10073: UNION ALL
10074: SELECT mic.inventory_item_id
10075: FROM msc_item_customers mic,
10076: msc_trading_partner_maps map,
10077: msc_trading_partner_maps map1,
10078: msc_company_relationships r,
10079: msc_company_sites cs,
10080: msc_companies c

Line 10077: msc_trading_partner_maps map1,

10073: UNION ALL
10074: SELECT mic.inventory_item_id
10075: FROM msc_item_customers mic,
10076: msc_trading_partner_maps map,
10077: msc_trading_partner_maps map1,
10078: msc_company_relationships r,
10079: msc_company_sites cs,
10080: msc_companies c
10081: WHERE mic.plan_id = -1 and

Line 10140: msc_trading_partner_maps mtpm

10136: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10137: NOT EXISTS (SELECT msi.serial_number_control_code
10138: FROM msc_system_items msi,
10139: msc_trading_partners mtp,
10140: msc_trading_partner_maps mtpm
10141: WHERE msi.plan_id = -1 AND
10142: msi.inventory_item_id = mssn.inventory_item_id AND
10143: msi.sr_instance_id = mtp.sr_instance_id AND
10144: msi.organization_id = mtp.sr_tp_id AND