APPS.MSC_POST_PRO dependencies on MSC_SUPPLIER_FLEX_FENCES

Line 1717: FROM msc_supplier_flex_fences

1713: BEGIN
1714:
1715: SELECT count(*)
1716: INTO l_count
1717: FROM msc_supplier_flex_fences
1718: WHERE plan_id = p_plan_id
1719: AND sr_instance_id = p_instance_id
1720: AND organization_id = p_organization_id
1721: AND inventory_item_id = p_inventory_item_id

Line 7825: FROM msc_supplier_flex_fences msff

7821: AND NOT EXISTS --Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
7822: --AND (I.inventory_item_id, S.supplier_id, nvl(S.supplier_site_id,-1)) NOT IN
7823: -- Bug 3912422
7824: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
7825: FROM msc_supplier_flex_fences msff
7826: WHERE plan_id = p_plan_id
7827: AND msff.inventory_item_id = s.inventory_item_id --\
7828: AND msff.supplier_id = s.supplier_id -- } Bug 3912422
7829: AND msff.supplier_site_id = s.supplier_site_id --/

Line 7902: FROM msc_supplier_flex_fences msff

7898: AND NOT EXISTS --Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
7899: --AND (i.inventory_item_id, p.supplier_id, nvl(p.supplier_site_id,-1)) NOT IN
7900: -- Bug 3912422
7901: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
7902: FROM msc_supplier_flex_fences msff
7903: WHERE plan_id = p_plan_id
7904: AND msff.inventory_item_id = p.inventory_item_id --\
7905: AND msff.supplier_id = p.supplier_id -- } Bug 3912422
7906: AND msff.supplier_site_id = p.supplier_site_id --/

Line 7987: FROM msc_supplier_flex_fences msff

7983: AND NOT EXISTS -- Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
7984: --AND (i.inventory_item_id, p.supplier_id, nvl(p.supplier_site_id,-1)) NOT IN
7985: -- Bug 3912422
7986: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
7987: FROM msc_supplier_flex_fences msff
7988: WHERE plan_id = p_plan_id
7989: AND msff.inventory_item_id = p.inventory_item_id --\
7990: AND msff.supplier_id = p.supplier_id -- } Bug 3912422
7991: AND msff.supplier_site_id = p.supplier_site_id --/