APPS.MSC_X_PEGGING_FUNC dependencies on MSC_SUP_DEM_SECURITY_V

Line 81: (select 1 from msc_sup_dem_security_v security

77: SELECT a.transaction_id
78: BULK COLLECT INTO var_ids
79: FROM msc_sup_dem_entries a -- msc_sup_dem_entries_ui_v
80: WHERE exists
81: (select 1 from msc_sup_dem_security_v security
82: where security.transaction_id = a.transaction_id )
83: AND Level < RECEIPT_LEVEL
84: START WITH a.transaction_id = var_start_id
85: CONNECT BY PRIOR a.order_number = a.end_order_number

Line 153: (select 1 from msc_sup_dem_security_v security

149: SELECT count(a.transaction_id)
150: INTO v_ret_num
151: FROM msc_sup_dem_entries a-- msc_sup_dem_entries_ui_v
152: WHERE exists
153: (select 1 from msc_sup_dem_security_v security
154: where security.transaction_id = a.transaction_id )
155: AND a.transaction_id <> arg_transid -- else the starting rec will be counted as one
156: START WITH a.transaction_id = arg_transid
157: CONNECT BY

Line 238: (select 1 from msc_sup_dem_security_v security

234: FROM msc_sup_dem_entries a
235: WHERE a.plan_id = -1
236: AND a.publisher_order_type = SALES_ORDER
237: AND exists
238: (select 1 from msc_sup_dem_security_v security
239: where security.transaction_id = a.transaction_id )
240: AND Level < LEVEL_3
241: START with a.transaction_id = arg_transid
242: CONNECT BY PRIOR a.order_number = a.end_order_number

Line 381: (select 1 from msc_sup_dem_security_v security

377: FROM msc_sup_dem_entries a
378: WHERE a.plan_id = -1
379: AND a.publisher_order_type = PURCHASE_ORDER
380: AND exists
381: (select 1 from msc_sup_dem_security_v security
382: where security.transaction_id = a.transaction_id )
383: START with a.transaction_id = arg_transid
384: CONNECT BY PRIOR a.order_number = a.end_order_number
385: AND PRIOR nvl(a.release_number, -1) = nvl(a.end_order_rel_number, -1)

Line 447: (select 1 from msc_sup_dem_security_v security

443: FROM msc_sup_dem_entries sd -- msc_sup_dem_entries_ui_v
444: WHERE sd.publisher_order_type = PURCHASE_ORDER
445: AND sd.plan_id = -1
446: AND exists
447: (select 1 from msc_sup_dem_security_v security
448: where security.transaction_id = sd.transaction_id )
449: AND level = v_level
450: START WITH transaction_id = arg_transid
451: CONNECT BY

Line 548: (select 1 from msc_sup_dem_security_v security

544: FROM msc_sup_dem_entries a
545: WHERE a.plan_id = -1
546: AND a.publisher_order_type = SALES_ORDER
547: AND exists
548: (select 1 from msc_sup_dem_security_v security
549: where security.transaction_id = a.transaction_id )
550: AND a.receipt_date <= v_need_by_date
551: AND LEVEL < LEVEL_3
552: START with a.transaction_id = arg_transid

Line 655: (select 1 from msc_sup_dem_security_v security

651: FROM msc_sup_dem_entries a
652: WHERE a.plan_id = -1
653: AND a.publisher_order_type = SALES_ORDER
654: AND exists
655: (select 1 from msc_sup_dem_security_v security
656: where security.transaction_id = a.transaction_id )
657: AND a.receipt_date > v_need_by_date
658: AND LEVEL < LEVEL_3
659: START with a.transaction_id = arg_transid

Line 735: (select 1 from msc_sup_dem_security_v security

731: FROM msc_sup_dem_entries a
732: WHERE a.plan_id = -1
733: AND a.publisher_order_type = ASN
734: AND exists
735: (select 1 from msc_sup_dem_security_v security
736: where security.transaction_id = a.transaction_id )
737: AND LEVEL < LEVEL_4
738: START with a.transaction_id = arg_transid
739: CONNECT BY PRIOR a.order_number = a.end_order_number