APPS.OE_CREDIT_WF dependencies on OE_ORDER_LINES_ALL

Line 451: from oe_order_lines_all L

447: AND wfas.activity_status = 'NOTIFIED'
448: AND wpa.activity_item_type = 'OEOL'
449: AND wfas.item_type = 'OEOL' and wfas.item_key
450: in (select line_id
451: from oe_order_lines_all L
452: where L.header_id = l_hold_entity_id);
453: --
454: --OR (item_type = 'OECHGORD' and item_key
455: -- in (select to_char(P.wf_key_id)

Line 651: , oe_order_lines_all ol

647: UNION
648: SELECT wfas.item_type, wfas.item_key
649: FROM wf_item_activity_statuses wfas
650: , wf_process_activities wpa
651: , oe_order_lines_all ol
652: WHERE wfas.item_type='OEOL'
653: AND wfas.process_activity = wpa.instance_id
654: AND wpa.activity_item_type='OEOL'
655: AND wpa.activity_name = 'OE_CREDIT_HOLD_NTF'

Line 945: FROM oe_order_lines_all

941: WHERE wfas.item_type = 'OEOL'
942: AND wfas.process_activity = wpa.instance_id
943: AND wpa.activity_item_type = 'OEOL'
944: AND wfas.item_key IN ( SELECT to_char(line_id)
945: FROM oe_order_lines_all
946: WHERE header_id = l_header_id)
947: AND wpa.activity_name = 'PICK_RELEASE';
948: -- Checks if the next activity is pick release
949: CURSOR next_pick_rel IS