DBA Data[Home] [Help]

APPS.MSC_X_VMI_UTIL_NEW dependencies on MSC_ITEMS

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