APPS.OE_CREDIT_WF dependencies on OE_ORDER_LINES

Line 445: from oe_order_lines_all L

441: AND wfas.activity_status = 'NOTIFIED'
442: AND wpa.activity_item_type = 'OEOL'
443: AND wfas.item_type = 'OEOL' and wfas.item_key
444: in (select line_id
445: from oe_order_lines_all L
446: where L.header_id = l_hold_entity_id);
447: --
448: --OR (item_type = 'OECHGORD' and item_key
449: -- in (select to_char(P.wf_key_id)

Line 645: , oe_order_lines_all ol

641: UNION
642: SELECT wfas.item_type, wfas.item_key
643: FROM wf_item_activity_statuses wfas
644: , wf_process_activities wpa
645: , oe_order_lines_all ol
646: WHERE wfas.item_type='OEOL'
647: AND wfas.process_activity = wpa.instance_id
648: AND wpa.activity_item_type='OEOL'
649: AND wpa.activity_name = 'OE_CREDIT_HOLD_NTF'

Line 802: FROM oe_order_lines

798: l_header_id NUMBER;
799: -- Retrieves header id if it's a Line workflow
800: CURSOR line_header IS
801: SELECT header_id
802: FROM oe_order_lines
803: WHERE line_id = to_number(itemkey);
804: -- Retrieves header id if it's a Change Order workflow
805: -- Not used anymore
806: --CURSOR pending_rec_header IS

Line 917: FROM oe_order_lines_all

913: WHERE wfas.item_type = 'OEOL'
914: AND wfas.process_activity = wpa.instance_id
915: AND wpa.activity_item_type = 'OEOL'
916: AND wfas.item_key IN ( SELECT line_id
917: FROM oe_order_lines_all
918: WHERE header_id = l_header_id)
919: AND wpa.activity_name = 'PICK_RELEASE';
920: -- Checks if the next activity is pick release
921: CURSOR next_pick_rel IS