APPS.OE_SHIPPING_INTEGRATION_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 4750: FROM oe_order_lines,wf_item_activity_statuses wias,

4746: --
4747:
4748: CURSOR c_lines IS
4749: SELECT line_id
4750: FROM oe_order_lines,wf_item_activity_statuses wias,
4751: wf_process_activities wpa
4752: WHERE header_id = l_header_id
4753: AND top_model_line_id = l_top_model_line_id
4754: AND link_to_line_id = p_line_id

Line 5505: from wf_item_activity_statuses wias,

5501: ELSE
5502:
5503: select activity_status
5504: into l_activity_status_code
5505: from wf_item_activity_statuses wias,
5506: wf_process_activities wpa
5507: where wias.item_type = 'OEOL'
5508: and wias.item_key = to_char(l_line_tbl(l_line_index).line_id)
5509: and wias.process_activity = wpa.instance_id

Line 6226: from wf_process_activities p, wf_item_activity_statuses s

6222: BEGIN
6223:
6224: select activity_result_code
6225: into l_ship_confirm_status
6226: from wf_process_activities p, wf_item_activity_statuses s
6227: where p.instance_id = s.process_activity
6228: and item_type = 'OEOL'
6229: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6230: and p.activity_name = 'SHIP_LINE'

Line 6247: from wf_process_activities p, wf_item_activity_statuses s

6243: WHEN TOO_MANY_ROWS THEN
6244:
6245: select count(1)
6246: into l_count_reserve
6247: from wf_process_activities p, wf_item_activity_statuses s
6248: where p.instance_id = s.process_activity
6249: and item_type = 'OEOL'
6250: and item_key = to_char(OE_LINE_SECURITY.g_record.line_id)
6251: and p.activity_name = 'SHIP_LINE'