APPS.PO_AUTOCREATE_MAINPROC_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 410: PO_REQUISITION_LINES_ALL PRL, --

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
414: AND PRL.REQUISITION_LINE_ID = x_requisition_line_id

Line 480: po_requisition_lines_all prl, --

476: 'INVENTORY', 'Y', 'SHOP FLOOR', 'Y')
477: INTO x_receipt_required_flag
478: FROM po_lines_interface pli,
479: po_headers_interface phi,
480: po_requisition_lines_all prl, --
481: mtl_system_items msi,
482: po_line_types plt,
483: po_vendors pov,
484: po_system_parameters_all psp, --

Line 528: PO_REQUISITION_LINES_ALL PRL, --

524: PLI.requisition_line_id
525: INTO x_po_shipment_num,
526: x_req_line_to_check
527: FROM PO_LINES_INTERFACE PLI,
528: PO_REQUISITION_LINES_ALL PRL, --
529: --bug 1942696 hr_location changes to reflect the new view
530: MTL_SYSTEM_ITEMS MSI,
531: PO_LINE_TYPES PLT,
532: PO_SYSTEM_PARAMETERS_ALL PSP, --

Line 618: PO_REQUISITION_LINES_ALL PRL, --

614: */
615: SELECT PLI.shipment_num
616: INTO x_po_shipment_num
617: FROM PO_LINES_INTERFACE PLI,
618: PO_REQUISITION_LINES_ALL PRL, --
619: MTL_SYSTEM_ITEMS MSI,
620: PO_LINE_TYPES PLT,
621: PO_SYSTEM_PARAMETERS_ALL PSP, --
622: FINANCIALS_SYSTEM_PARAMS_ALL FSP, --

Line 1109: x_note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE;

1105: x_item_revision VARCHAR2 (3);
1106: x_unit_meas_lookup_code VARCHAR2 (25);
1107: x_transaction_reason_code VARCHAR2 (25);
1108: x_need_by_date DATE;
1109: x_note_to_receiver po_requisition_lines_all.note_to_receiver%TYPE;
1110: x_oke_contract_header_id NUMBER;
1111: x_oke_contract_version_id NUMBER;
1112: x_vendor_product_num VARCHAR2 (30);
1113: x_deliver_to_location_id NUMBER;

Line 1345: FROM po_requisition_lines_all prl

1341: l_progress := '035';
1342: UPDATE po_lines_interface pli
1343: SET pli.line_num =
1344: (SELECT prl.line_num
1345: FROM po_requisition_lines_all prl
1346: WHERE prl.requisition_line_id = pli.requisition_line_id
1347: )
1348: WHERE pli.interface_header_id = x_interface_header_id
1349: AND pli.line_num IS NULL

Line 1892: po_requisition_lines_all prl,

1888: -- SQL Join: business logic for combining two lines
1889: SELECT MIN (pli.line_num)
1890: INTO x_po_line_num
1891: FROM po_lines_interface pli,
1892: po_requisition_lines_all prl,
1893: po_line_types_b plt --
1894: WHERE pli.interface_header_id = x_interface_header_id
1895: AND pli.line_num IS NOT NULL
1896: AND prl.requisition_line_id <> x_requisition_line_id