APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_COMPANY_SITES

Line 271: msc_company_sites site,

267: msc_sr_receipt_org rec_org,
268: msc_sr_source_org src_org,
269: msc_trading_partner_maps map1,
270: msc_trading_partner_maps map2,
271: msc_company_sites site,
272: msc_companies cp,
273: msc_company_relationships rel
274: where plan_id = -1
275: and a.publisher_order_type = UNALLOCATED_ONHAND

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 1855: msc_trading_partner_maps map_supp, msc_company_sites supp_site, msc_trading_partner_maps map_rel,

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
1859: AND i.inventory_item_id = s.inventory_item_id