eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BLANKET_WF dependencies on WF_PROCESS_ACTIVITIES

Line 607: from wf_item_activity_statuses wias, wf_process_activities wpa

603:
604: BEGIN
605: select wpa.activity_name
606: into l_activity_name
607: from wf_item_activity_statuses wias, wf_process_activities wpa
608: where item_type = OE_GLOBALS.G_WFI_BKT
609: and item_key = to_char(p_header_id)
610: and activity_status = 'NOTIFIED'
611: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION', 'BLANKET_SUBMIT_DRAFT_ELIGIBLE')

Line 672: from wf_item_activity_statuses wias, wf_process_activities wpa

668: END IF;
669: BEGIN
670: select wpa.activity_name
671: into l_activity_name
672: from wf_item_activity_statuses wias, wf_process_activities wpa
673: where item_type = OE_GLOBALS.G_WFI_BKT
674: and item_key = to_char(p_header_id)
675: and activity_status = 'NOTIFIED'
676: and wpa.activity_name = 'BLANKET_SUBMIT_DRAFT_ELIGIBLE'

Line 736: from wf_item_activity_statuses wias, wf_process_activities wpa

732: END IF;
733: BEGIN
734: select wpa.activity_name
735: into l_activity_name
736: from wf_item_activity_statuses wias, wf_process_activities wpa
737: where item_type = OE_GLOBALS.G_WFI_BKT
738: and item_key = to_char(p_header_id)
739: and activity_status = 'NOTIFIED'
740: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'

Line 813: from wf_item_activity_statuses wias, wf_process_activities wpa

809: END IF;
810: BEGIN
811: select wpa.activity_name
812: into l_activity_name
813: from wf_item_activity_statuses wias, wf_process_activities wpa
814: where item_type = OE_GLOBALS.G_WFI_BKT
815: and item_key = to_char(p_header_id)
816: and activity_status = 'NOTIFIED'
817: and wpa.activity_name in ('WAIT_FOR_START_DATE', 'BLANKET_NO_END_DATE', 'WAIT_FOR_EXPIRATION', 'WAIT_FOR_FINAL_EXPIRATION')

Line 916: from wf_item_activity_statuses wias, wf_process_activities wpa

912: END IF;
913: BEGIN
914: select wpa.activity_name
915: into l_activity_name
916: from wf_item_activity_statuses wias, wf_process_activities wpa
917: where item_type = OE_GLOBALS.G_WFI_BKT
918: and item_key = to_char(p_header_id)
919: and activity_status = 'NOTIFIED'
920: and wpa.activity_name = 'CLOSE_BLANKET_ELIGIBLE'