[Home] [Help]
1090: ln.customer_company IS NOT NULL AND
1091: NOT EXISTS (SELECT c.company_id
1092: FROM msc_companies c,
1093: msc_companies c1,
1094: msc_company_relationships r
1095: WHERE UPPER(c.company_name) = UPPER(ln.customer_company) and
1096: UPPER(c1.company_name) = UPPER(NVL(ln.publisher_company, ln.posting_party_name)) and
1097: r.subject_id = c1.company_id and
1098: r.object_id = c.company_id and
1132: ln.supplier_company IS NOT NULL AND
1133: NOT EXISTS (SELECT c.company_id
1134: FROM msc_companies c,
1135: msc_companies c1,
1136: msc_company_relationships r
1137: WHERE UPPER(c.company_name) = UPPER(ln.supplier_company) and
1138: UPPER(c1.company_name) = UPPER(NVL(ln.publisher_company, ln.posting_party_name)) and
1139: r.subject_id = c1.company_id and
1140: r.object_id = c.company_id and
1770: ln.customer_company IS NOT NULL AND
1771: NOT EXISTS (SELECT c.company_id
1772: FROM msc_companies c,
1773: msc_companies c1,
1774: msc_company_relationships r
1775: WHERE UPPER(c.company_name) = UPPER(ln.customer_company) and
1776: UPPER(c1.company_name) = UPPER(NVL(ln.publisher_company,
1777: ln.posting_party_name)) and
1778: r.subject_id = c1.company_id and
1811: ln.supplier_company IS NOT NULL AND
1812: NOT EXISTS (SELECT c.company_id
1813: FROM msc_companies c,
1814: msc_companies c1,
1815: msc_company_relationships r
1816: WHERE UPPER(c.company_name) = UPPER(ln.supplier_company) and
1817: UPPER(c1.company_name) = UPPER(NVL(ln.publisher_company, ln.posting_party_name)) and
1818: r.subject_id = c1.company_id and
1819: r.object_id = c.company_id and
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
1959: where mis.plan_id = -1 and
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
1996: mic.customer_item_name = nvl(ln.owner_item_name,
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
2108: WHERE rel.relationship_type = 2
2109: AND rel.subject_id = 1
2110: AND Upper(c0.company_name) = Upper(ln.publisher_company)
2111: AND rel.object_id = c0.company_id
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
2498: where mis.plan_id = -1 and
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
2532: where mic.plan_id = -1 and
3687: msc_companies c,
3688: msc_company_sites s,
3689: msc_companies c1,
3690: msc_company_sites s1,
3691: msc_company_relationships r
3692: WHERE ln.parent_header_id = p_header_id AND
3693: ln.line_id between p_start_line and p_end_line AND
3694: NVL(ln.row_status, G_PROCESS) = G_SUCCESS AND
3695: UPPER(c.company_name) = UPPER(NVL(ln.publisher_company, ln.posting_party_name)) AND
3923: msc_companies c,
3924: msc_company_sites s,
3925: msc_companies c1,
3926: msc_company_sites s1,
3927: msc_company_relationships r
3928: WHERE ln.parent_header_id = p_header_id AND
3929: ln.line_id between p_start_line and p_end_line AND
3930: ln.bucket_type IS NULL AND
3931: NVL(ln.row_status, G_PROCESS) = G_SUCCESS AND
4241: msc_companies c,
4242: msc_company_sites s,
4243: msc_companies c1,
4244: msc_company_sites s1,
4245: msc_company_relationships r
4246: WHERE ln.parent_header_id = p_header_id AND
4247: ln.line_id between p_start_line and p_end_line AND
4248: flv.lookup_type = 'MSC_X_BUCKET_TYPE' AND
4249: UPPER(flv.meaning) = NVL(UPPER(ln.bucket_type), G_NULL_STRING) AND
4585: msc_companies c,
4586: msc_company_sites s,
4587: msc_companies c1,
4588: msc_company_sites s1,
4589: msc_company_relationships r
4590: WHERE ln.parent_header_id = p_header_id AND
4591: ln.line_id between p_start_line and p_end_line AND
4592: flv.lookup_type = 'MSC_X_BUCKET_TYPE' AND
4593: UPPER(flv.meaning) = NVL(UPPER(ln.bucket_type), G_NULL_STRING) AND
4929: msc_companies c,
4930: msc_company_sites s,
4931: msc_companies c1,
4932: msc_company_sites s1,
4933: msc_company_relationships r
4934: WHERE ln.parent_header_id = p_header_id AND
4935: ln.line_id between p_start_line and p_end_line AND
4936: flv.lookup_type = 'MSC_X_BUCKET_TYPE' AND
4937: UPPER(flv.meaning) = NVL(UPPER(ln.bucket_type), G_NULL_STRING) AND
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
7400: WHERE rel.relationship_type = 2
7401: AND rel.subject_id = 1
7402: AND rel.object_id = t_supp_id(j)
7403: AND maps.company_key = rel.relationship_id
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
7781: msi.sr_instance_id = mis.sr_instance_id and
7782: msi.inventory_item_id = mis.inventory_item_id and
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
7826: mis.organization_id = mtp.sr_tp_id and
7827: mis.sr_instance_id = mtp.sr_instance_id and
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
8547: --NVL(mic.customer_site_id, map1.tp_key) = map1.tp_key and
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
8648: --NVL(mic.customer_site_id, map1.tp_key) = map1.tp_key and
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
10053: mssn.parent_header_id = p_header_id AND
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
10082: mssn.parent_header_id = p_header_id AND