DBA Data[Home] [Help]

APPS.MSC_SCE_LOADS_PKG dependencies on MSC_TRADING_PARTNER_SITES

Line 2104: msc_trading_partner_sites mtps,

2100: msc_trading_partners mtp1,
2101: msc_trading_partner_maps maps,
2102: msc_trading_partner_maps maps1,
2103: msc_trading_partner_maps maps2,
2104: msc_trading_partner_sites mtps,
2105: msc_company_sites cs,
2106: msc_companies c,
2107: msc_company_relationships rel
2108: WHERE rel.relationship_type = 2

Line 7396: msc_trading_partner_sites mtps,

7392: msc_trading_partners mtp1,
7393: msc_trading_partner_maps maps,
7394: msc_trading_partner_maps maps1,
7395: msc_trading_partner_maps maps2,
7396: msc_trading_partner_sites mtps,
7397: msc_company_sites cs,
7398: msc_companies c,
7399: msc_company_relationships rel
7400: WHERE rel.relationship_type = 2

Line 7855: msc_trading_partner_sites mtps,

7851: ) IS
7852: SELECT mis.vmi_flag,
7853: mis.enable_vmi_auto_replenish_flag
7854: FROM msc_trading_partners mtp,
7855: msc_trading_partner_sites mtps,
7856: msc_trading_partners mtp1,
7857: msc_item_suppliers mis
7858: WHERE Upper(mtp.partner_name) = Upper(p_supplier)
7859: AND mtp.partner_type = 1