APPS.OE_CREDIT_WF dependencies on WF_PROCESS_ACTIVITIES

Line 429: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

425: l_hold_release_rec OE_Hold_Sources_Pvt.Hold_Release_REC :=
426: OE_Hold_Sources_Pvt.G_MISS_Hold_Release_REC;
427: Cursor blocked_process IS
428: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
429: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
430: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')
431: AND wfas.process_activity = wpa.instance_id
432: AND wfas.activity_status = 'NOTIFIED'
433: AND wfas.item_type = 'OEOH'

Line 438: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

434: AND wpa.activity_item_type = 'OEOH'
435: and wfas.item_key = to_char(l_hold_entity_id)
436: UNION
437: SELECT wfas.item_type, wfas.item_key, wpa.activity_name, wfas.activity_status
438: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
439: WHERE wpa.activity_name IN ('OE_CREDIT_HOLD_NTF','OE_HOLD_BLOCK','WAIT_FOR_NTF_RESULT')
440: AND wfas.process_activity = wpa.instance_id
441: AND wfas.activity_status = 'NOTIFIED'
442: AND wpa.activity_item_type = 'OEOL'

Line 634: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

630: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;
631: l_order_number NUMBER;
632: Cursor ntf_process_data IS
633: SELECT wfas.item_type, wfas.item_key
634: FROM wf_item_activity_statuses wfas, wf_process_activities wpa
635: WHERE wfas.item_type='OEOH'
636: AND wfas.process_activity = wpa.instance_id
637: AND wpa.activity_item_type='OEOH'
638: AND wpa.activity_name = 'OE_CREDIT_HOLD_NTF'

Line 644: , wf_process_activities wpa

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

Line 912: FROM wf_item_activity_statuses wfas, wf_process_activities wpa

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

Line 928: FROM wf_process_activities pa

924: WHERE atr.from_process_activity = l_fromact_id
925: AND result_code = 'APPROVED'
926: AND to_process_activity IN
927: (SELECT pa.instance_id
928: FROM wf_process_activities pa
929: WHERE pa.activity_name = 'PICK_RELEASE'
930: AND pa.activity_item_type = itemtype);
931: --
932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;