APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on WF_PROCESS_ACTIVITIES

Line 4769: wf_process_activities wpa

4765:
4766: CURSOR c_lines IS
4767: SELECT line_id
4768: FROM oe_order_lines,wf_item_activity_statuses wias,
4769: wf_process_activities wpa
4770: WHERE header_id = l_header_id
4771: AND top_model_line_id = l_top_model_line_id
4772: AND link_to_line_id = p_line_id
4773: AND item_type_code = 'INCLUDED'

Line 5526: wf_process_activities wpa

5522:
5523: select activity_status
5524: into l_activity_status_code
5525: from wf_item_activity_statuses wias,
5526: wf_process_activities wpa
5527: where wias.item_type = 'OEOL'
5528: and wias.item_key = to_char(l_line_tbl(l_line_index).line_id)
5529: and wias.process_activity = wpa.instance_id
5530: and wpa.activity_name = 'SHIP_LINE'

Line 6251: from wf_process_activities p, wf_item_activity_statuses s

6247: BEGIN
6248:
6249: select activity_result_code
6250: into l_ship_confirm_status
6251: from wf_process_activities p, wf_item_activity_statuses s
6252: where p.instance_id = s.process_activity
6253: and item_type = 'OEOL'
6254: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6255: and p.activity_name = 'SHIP_LINE'

Line 6272: from wf_process_activities p, wf_item_activity_statuses s

6268: WHEN TOO_MANY_ROWS THEN
6269:
6270: select count(1)
6271: into l_count_reserve
6272: from wf_process_activities p, wf_item_activity_statuses s
6273: where p.instance_id = s.process_activity
6274: and item_type = 'OEOL'
6275: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6276: and p.activity_name = 'SHIP_LINE'