APPS.OE_LINE_STATUS_PUB dependencies on WF_PROCESS_ACTIVITIES

Line 85: wf_process_activities wpa

81: IF x_result = 'Y' THEN
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';

Line 184: wf_process_activities wpa

180: IF x_result = 'Y' THEN
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';

Line 272: wf_process_activities wpa

268:
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';

Line 386: -- FROM wf_process_activities wpa

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
388: -- AND wpa.activity_name = 'SHIP_LINE');
389: -- ELSE
390: -- x_result_date := null;

Line 636: wf_process_activities wpa

632: IF x_result = 'Y' THEN
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';

Line 736: wf_process_activities wpa

732: BEGIN
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';

Line 753: wf_process_activities wpa

749:
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';