APPS.OE_CREDIT_WF dependencies on WF_PROCESS_ACTIVITIES

Line 435: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

431: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
432: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
433: Cursor blocked_process IS
434: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
435: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
436: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')
437: AND wfas.process_activity = wpa.instance_id
438: AND wfas.activity_status = 'NOTIFIED'
439: AND wfas.item_type = 'OEOH'

Line 444: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

440: AND wpa.activity_item_type = 'OEOH'
441: and wfas.item_key = to_char(l_hold_entity_id)
442: UNION
443: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
444: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
445: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')
446: AND wfas.process_activity = wpa.instance_id
447: AND wfas.activity_status = 'NOTIFIED'
448: AND wpa.activity_item_type = 'OEOL'

Line 640: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

636: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
637: l_order_number NUMBER;
638: Cursor ntf_process_data IS
639: SELECT wfas.item_type, wfas.item_key
640: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
641: WHERE wfas.item_type='OEOH'
642: AND wfas.process_activity = wpa.instance_id
643: AND wpa.activity_item_type='OEOH'
644: AND wpa.activity_name = 'OE_CREDIT_HOLD_NTF'

Line 650: , wf_process_activities wpa

646: AND wfas.item_key = to_char(l_header_id)
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'

Line 940: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

936: l_fromact_id NUMBER; -- activity instance id of the parent process
937: -- Gets the number of order lines that have gone through pick release
938: CURSOR pick_rel IS
939: SELECT count(*)
940: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
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)

Line 956: FROM wf_process_activities pa

952: WHERE atr.from_process_activity = l_fromact_id
953: AND result_code = 'APPROVED'
954: AND to_process_activity IN
955: (SELECT pa.instance_id
956: FROM wf_process_activities pa
957: WHERE pa.activity_name = 'PICK_RELEASE'
958: AND pa.activity_item_type = itemtype);
959: --
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;