APPS.OE_LINE_STATUS_PUB dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 84: FROM wf_item_activity_statuses wias,

80: Get_Cancelled_Status(p_line_id => p_line_id, x_result => x_result);
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

Line 183: FROM wf_item_activity_statuses wias,

179: Get_Closed_Status(p_line_id => p_line_id, x_result => x_result);
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

Line 271: FROM wf_item_activity_statuses wias,

267: BEGIN
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

Line 382: -- FROM wf_item_activity_statuses

378: -- Get_Ship_Status(p_line_id => p_line_id, x_result => x_result);
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

Line 635: FROM wf_item_activity_statuses wias,

631: Get_Received_Status(p_line_id => p_line_id, x_result => x_result);
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

Line 735: FROM wf_item_activity_statuses wias,

731:
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

Line 752: FROM wf_item_activity_statuses wias,

748: WHERE line_id = p_line_id;
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