DBA Data[Home] [Help]

APPS.MSC_SECRULE_PKG dependencies on MSC_TRADING_PARTNERS

Line 595: , msc_trading_partners tp

591: BEGIN
592: select s.inventory_item_id into l_item_id
593: from
594: msc_item_suppliers s
595: , msc_trading_partners tp
596: where
597: s.supplier_id = tp.partner_id
598: and tp.partner_type = 1
599: and tp.partner_name = nvl(p_company_name,sys_context('msc','company_name'))

Line 618: , msc_trading_partners tp

614: BEGIN
615: select s.inventory_item_id into l_item_id
616: from
617: msc_item_customers s
618: , msc_trading_partners tp
619: where
620: s.customer_id = tp.partner_id
621: and tp.partner_type = 2
622: and tp.partner_name = nvl(p_company_name,sys_context('msc','company_name'))