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 7854: FROM msc_supplier_flex_fences msff

7850: AND NOT EXISTS --Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
7851: --AND (I.inventory_item_id, S.supplier_id, nvl(S.supplier_site_id,-1)) NOT IN
7852: -- Bug 3912422
7853: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
7854: FROM msc_supplier_flex_fences msff
7855: WHERE plan_id = p_plan_id
7856: AND msff.inventory_item_id = s.inventory_item_id --\
7857: AND msff.supplier_id = s.supplier_id -- } Bug 3912422
7858: AND msff.supplier_site_id = s.supplier_site_id --/

Line 7931: FROM msc_supplier_flex_fences msff

7927: AND NOT EXISTS --Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
7928: --AND (i.inventory_item_id, p.supplier_id, nvl(p.supplier_site_id,-1)) NOT IN
7929: -- Bug 3912422
7930: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
7931: FROM msc_supplier_flex_fences msff
7932: WHERE plan_id = p_plan_id
7933: AND msff.inventory_item_id = p.inventory_item_id --\
7934: AND msff.supplier_id = p.supplier_id -- } Bug 3912422
7935: AND msff.supplier_site_id = p.supplier_site_id --/

Line 8016: FROM msc_supplier_flex_fences msff

8012: AND NOT EXISTS -- Bug 3912422, Replaced 'NOT IN' by 'NOT EXISTS'
8013: --AND (i.inventory_item_id, p.supplier_id, nvl(p.supplier_site_id,-1)) NOT IN
8014: -- Bug 3912422
8015: (SELECT 'x' -- summary is not supported with flex flences : summary enhancement
8016: FROM msc_supplier_flex_fences msff
8017: WHERE plan_id = p_plan_id
8018: AND msff.inventory_item_id = p.inventory_item_id --\
8019: AND msff.supplier_id = p.supplier_id -- } Bug 3912422
8020: AND msff.supplier_site_id = p.supplier_site_id --/