DBA Data[Home] [Help]

APPS.MSC_SCE_PUBLISH_PKG dependencies on MSC_ITEM_SUPPLIERS

Line 1499: from msc_item_suppliers mis,

1495: p_supp_site_id in number
1496: ) IS
1497: select distinct mis.processing_lead_time,
1498: mis.using_organization_id
1499: from msc_item_suppliers mis,
1500: msc_trading_partner_maps m,
1501: msc_trading_partner_maps m2,
1502: msc_company_relationships r
1503: where mis.plan_id = -1 and

Line 1666: from msc_item_suppliers mis,

1662: mis.uom_code
1663: into t_supp_item_name(j),
1664: t_supp_item_desc(j),
1665: t_tp_uom(j)
1666: from msc_item_suppliers mis,
1667: msc_trading_partner_maps m,
1668: msc_trading_partner_maps m2,
1669: msc_company_relationships r
1670: where mis.plan_id = -1 and