APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_TRADING_PARTNERS

Line 264: msc_trading_partners tp,

260: a.supplier_item_description
261: from
262: msc_sup_dem_entries a,
263: msc_trading_partner_maps map,
264: msc_trading_partners tp,
265: msc_assignment_sets assignmentset,
266: msc_sr_assignments assignment,
267: msc_sr_receipt_org rec_org,
268: msc_sr_source_org src_org,

Line 1854: FROM msc_item_suppliers i, msc_items s, msc_trading_partners tp, msc_trading_partner_maps map_cust, msc_company_sites cust_site,

1850:
1851: CURSOR item_suppliers_cur is
1852: SELECT nvl(i.min_minmax_quantity,0) min_minmax_quantity, nvl(i.max_minmax_quantity,0) max_minmax_quantity,
1853: i.processing_lead_time AS processing_lead_time
1854: FROM msc_item_suppliers i, msc_items s, msc_trading_partners tp, msc_trading_partner_maps map_cust, msc_company_sites cust_site,
1855: msc_trading_partner_maps map_supp, msc_company_sites supp_site, msc_trading_partner_maps map_rel,
1856: msc_company_relationships rel
1857: WHERE i.plan_id = -1
1858: -- AND i.vmi_flag = 1

Line 2292: FROM msc_trading_partner_maps maps, msc_trading_partners tp

2288: IF p_consigned = UNCONSIGNED AND p_source_org_id IS NOT NULL THEN
2289: BEGIN
2290: SELECT maps.company_key
2291: INTO l_source_site_id
2292: FROM msc_trading_partner_maps maps, msc_trading_partners tp
2293: WHERE tp.partner_type = ASCP_TP_MAP_TYPE_ORG
2294: AND tp.sr_instance_id = p_sr_instance_id
2295: AND tp.sr_tp_id = p_source_org_id
2296: AND tp.partner_id = maps.tp_key

Line 3055: msc_trading_partners tp

3051:
3052: select maps.company_key
3053: into l_source_site_id
3054: from msc_trading_partner_maps maps,
3055: msc_trading_partners tp
3056: where tp.partner_type = 3
3057: and tp.sr_instance_id = p_sr_instance_id
3058: and tp.sr_tp_id = p_source_org_id
3059: and tp.partner_id = maps.tp_key