APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_LINE_LOCATIONS_MERGE_V

Line 309: FROM PO_LINE_LOCATIONS_MERGE_V PLL --

305: SELECT PLL.shipment_num,
306: PLL.line_location_id
307: INTO x_po_shipment_num,
308: x_line_location_to_check
309: FROM PO_LINE_LOCATIONS_MERGE_V PLL --
310: WHERE PLL.PO_LINE_ID = x_po_line_id
311: AND pll.draft_id =PO_AUTOCREATE_PARAMS.g_draft_id
312: AND((TO_CHAR(PLL.need_by_date - (to_number(SUBSTR(TO_CHAR(PLL.need_by_date, 'DD-MM-YYYY HH24:MI:SS'), 18, 2)) / 86400), 'DD-MM-YYYY HH24:MI:SS') =
313: TO_CHAR(x_need_by_date - (to_number(SUBSTR(TO_CHAR(x_need_by_date, 'DD-MM-YYYY HH24:MI:SS'), 18, 2)) / 86400), 'DD-MM-YYYY HH24:MI:SS') )

Line 344: FROM PO_LINE_LOCATIONS_MERGE_V PLL --

340: SELECT PLL.shipment_num,
341: PLL.line_location_id
342: INTO x_po_shipment_num,
343: x_line_location_to_check
344: FROM PO_LINE_LOCATIONS_MERGE_V PLL --
345: WHERE PLL.PO_LINE_ID = x_po_line_id
346: AND draft_id =PO_AUTOCREATE_PARAMS.g_draft_id
347: AND PLL.SHIP_TO_LOCATION_ID = x_ship_to_location_id
348: AND PLL.SHIP_TO_ORGANIZATION_ID = x_destination_org_id

Line 378: FROM PO_LINE_LOCATIONS_MERGE_V PLL --

374: SELECT PLL.shipment_num,
375: PLL.line_location_id
376: INTO x_po_shipment_num,
377: x_line_location_to_check
378: FROM PO_LINE_LOCATIONS_MERGE_V PLL --
379: WHERE PLL.PO_LINE_ID = x_po_line_id
380: AND pll.draft_id =PO_AUTOCREATE_PARAMS.g_draft_id
381: AND NVL(PLL.drop_ship_flag, 'N') <> 'Y' -- cannot add to Drop Ship Shipments
382: AND NVL(PLL.CONSIGNED_FLAG, 'N') = NVL(x_consigned_flag, 'N')

Line 409: FROM PO_LINE_LOCATIONS_MERGE_V PLL, --

405: -- SQL WHY : if the above values match then we need to determine if we need to create
406: -- a new shipment or not
407: SELECT PLL.shipment_num
408: INTO x_po_shipment_num
409: FROM PO_LINE_LOCATIONS_MERGE_V PLL, --
410: PO_REQUISITION_LINES_ALL PRL, --
411: PO_SYSTEM_PARAMETERS_ALL PSP --
412: WHERE PLL.LINE_LOCATION_ID = x_line_location_to_check
413: AND pll.draft_id =PO_AUTOCREATE_PARAMS.g_draft_id