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_LINE_STATUS_PUB dependencies on OE_GLOBALS

Line 86: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN

82: SELECT wias.end_date
83: INTO x_result_date
84: FROM wf_item_activity_statuses wias,
85: wf_process_activities wpa
86: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
87: AND wias.item_key = to_char(p_line_id)
88: AND wias.process_activity = wpa.instance_id
89: AND wpa.activity_name = 'CLOSE_LINE';
90:

Line 185: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN

181: SELECT wias.end_date
182: INTO x_result_date
183: FROM wf_item_activity_statuses wias,
184: wf_process_activities wpa
185: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
186: AND wias.item_key = to_char(p_line_id)
187: AND wias.process_activity = wpa.instance_id
188: AND wpa.activity_name = 'CLOSE_LINE';
189:

Line 273: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN

269: SELECT nvl(wias.activity_result_code, 'N'), wias.end_date
270: INTO x_result, x_result_date
271: FROM wf_item_activity_statuses wias,
272: wf_process_activities wpa
273: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
274: AND wias.item_key = to_char(p_line_id)
275: AND wias.process_activity = wpa.instance_id
276: AND wpa.activity_name = 'PUR_REL_THE_LINE';
277:

Line 278: IF x_result = OE_GLOBALS.G_WFR_COMPLETE THEN

274: AND wias.item_key = to_char(p_line_id)
275: AND wias.process_activity = wpa.instance_id
276: AND wpa.activity_name = 'PUR_REL_THE_LINE';
277:
278: IF x_result = OE_GLOBALS.G_WFR_COMPLETE THEN
279: x_result := 'Y';
280: ELSE
281: x_result := 'N';
282: x_result_date := null;

Line 383: -- WHERE item_type = OE_GLOBALS.G_WFI_LIN

379: -- IF x_result = 'Y' THEN
380: -- SELECT end_date
381: -- INTO x_result_date
382: -- FROM wf_item_activity_statuses
383: -- WHERE item_type = OE_GLOBALS.G_WFI_LIN
384: -- AND item_key = p_line_id
385: -- AND process_activity IN (SELECT wpa.instance_id
386: -- FROM wf_process_activities wpa
387: -- WHERE wpa.activity_item_type = OE_GLOBALS.G_WFI_LIN

Line 387: -- WHERE wpa.activity_item_type = OE_GLOBALS.G_WFI_LIN

383: -- WHERE item_type = OE_GLOBALS.G_WFI_LIN
384: -- AND item_key = p_line_id
385: -- AND process_activity IN (SELECT wpa.instance_id
386: -- FROM wf_process_activities wpa
387: -- WHERE wpa.activity_item_type = OE_GLOBALS.G_WFI_LIN
388: -- AND wpa.activity_name = 'SHIP_LINE');
389: -- ELSE
390: -- x_result_date := null;
391: -- END IF;

Line 637: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN

633: SELECT wias.end_date
634: INTO x_result_date
635: FROM wf_item_activity_statuses wias,
636: wf_process_activities wpa
637: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
638: AND wias.item_key = to_char(p_line_id)
639: AND wias.process_activity = wpa.instance_id
640: AND wpa.activity_name = 'RMA_WAIT_FOR_RECEIVING';
641: ELSE

Line 737: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN

733: SELECT wias.end_date
734: INTO x_result_date
735: FROM wf_item_activity_statuses wias,
736: wf_process_activities wpa
737: WHERE wias.item_type = OE_GLOBALS.G_WFI_LIN
738: AND wias.item_key = to_char(p_line_id)
739: AND wias.process_activity = wpa.instance_id
740: AND wpa.activity_name = 'INVOICE_INTERFACE';
741:

Line 754: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR

750: SELECT wias.end_date
751: INTO x_result_date
752: FROM wf_item_activity_statuses wias,
753: wf_process_activities wpa
754: WHERE wias.item_type = OE_GLOBALS.G_WFI_HDR
755: AND wias.item_key = l_header_id
756: AND wias.process_activity = wpa.instance_id
757: AND wpa.activity_name = 'HEADER_INVOICE_INTERFACE';
758: END;