DBA Data[Home] [Help]

APPS.MSC_X_EX5_PKG dependencies on MSC_TRADING_PARTNERS

Line 128: msc_trading_partners tp2 ,

124: itm.supplier_id,
125: itm.supplier_site_id,
126: itm.sr_instance_id
127: FROM msc_item_suppliers itm,
128: msc_trading_partners tp2 ,
129: msc_trading_partner_sites tps,
130: MSC_X_ITEM_SUPPLIERS_GTT iut,
131: MSC_X_ITEM_ORGS_GTT iot,
132: MSC_X_ITEM_SITES_GTT ist

Line 451: msc_trading_partners tp ,

447: msi.item_name,
448: msi.description,
449: itm.supplier_item_name
450: FROM msc_item_suppliers itm,
451: msc_trading_partners tp ,
452: msc_trading_partners tp2 ,
453: msc_trading_partner_sites tps ,
454: msc_system_items msi
455: WHERE tp.sr_tp_id = p_tx_org_id

Line 452: msc_trading_partners tp2 ,

448: msi.description,
449: itm.supplier_item_name
450: FROM msc_item_suppliers itm,
451: msc_trading_partners tp ,
452: msc_trading_partners tp2 ,
453: msc_trading_partner_sites tps ,
454: msc_system_items msi
455: WHERE tp.sr_tp_id = p_tx_org_id
456: AND tp.sr_instance_id = p_tx_instance_id