APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_LINE_LOCATIONS_MERGE_V

Line 61: FROM po_line_locations_merge_v

57: SELECT need_by_date,
58: ship_to_location_id,
59: ship_to_organization_id,
60: consigned_flag
61: FROM po_line_locations_merge_v
62: WHERE po_line_id = p_po_line_id_to_compare
63: AND draft_id = p_draft_id; --Autocreate grouping
64:
65: FUNCTION get_req_line_delivery_info(

Line 4197: , po_line_locations_merge_v pll

4193: , prl.requisition_line_id
4194: , pol.line_num
4195: FROM po_requisition_lines_all prl
4196: , po_lines_merge_v pol
4197: , po_line_locations_merge_v pll
4198: , po_lines_merge_v src_line
4199: WHERE pol.po_header_id = p_add_to_po_header_id
4200: AND pol.draft_id = p_draft_id
4201: AND pll.po_line_id = pol.po_line_id

Line 4350: , po_line_locations_merge_v pll

4346: , pol.line_num
4347: , pol.line_num_display
4348: FROM po_requisition_lines_all prl
4349: , po_lines_merge_v pol
4350: , po_line_locations_merge_v pll
4351: , po_lines_merge_v src_line
4352: WHERE pol.po_header_id = p_add_to_po_header_id
4353: AND nvl(pol.draft_id,-1) = nvl(p_draft_id,-1)
4354: AND pll.po_line_id = pol.po_line_id

Line 5709: po_line_locations_merge_v pllm

5705: BEGIN
5706: SELECT line_num, line_num_display
5707: INTO x_po_line_num, x_po_line_num_disp
5708: FROM po_lines_merge_v plm,
5709: po_line_locations_merge_v pllm
5710: WHERE plm.po_line_id = pllm.po_line_id
5711: AND plm.draft_id = pllm.draft_id
5712: AND pllm.line_location_id = p_po_shipment_id
5713: AND pllm.draft_id = p_draft_id;