APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 5957: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;

5953: l_requesting_org_id NumTab;
5954: l_display_rate NUMBER;
5955: l_return_status VARCHAR2(1);
5956: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
5957: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5958: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5959: --
5960:
5961: l_is_complex_po BOOLEAN := FALSE; --

Line 5958: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;

5954: l_display_rate NUMBER;
5955: l_return_status VARCHAR2(1);
5956: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
5957: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5958: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;
5959: --
5960:
5961: l_is_complex_po BOOLEAN := FALSE; --
5962: -- Start of Bug# 13857241

Line 6109: FROM PO_REQUISITION_LINES_ALL PRL, --

6105: PRL.unit_meas_lookup_code,
6106: min(POL.line_num),
6107: min(POLL.shipment_num),
6108: min(PRL.org_id) --
6109: FROM PO_REQUISITION_LINES_ALL PRL, --
6110: PO_LINE_LOCATIONS_GT POLL,
6111: PO_LINES POL
6112: WHERE PRL.line_location_id = POLL.line_location_id
6113: AND POLL.line_location_id = p_line_location_id

Line 6127: FROM PO_REQUISITION_LINES_ALL PRL, --

6123: PRL.unit_meas_lookup_code,
6124: MIN(POL.line_num) ,
6125: MIN(POLL.shipment_num) ,
6126: MIN(PRL.org_id) --
6127: FROM PO_REQUISITION_LINES_ALL PRL, --
6128: PO_LINE_LOCATIONS_GT POLL ,
6129: PO_LINES POL
6130: WHERE PRL.line_location_id = POLL.line_location_id
6131: AND POLL.line_location_id = p_line_location_id

Line 6144: FROM PO_REQUISITION_LINES_ALL PRL, --

6140: sum(PD.quantity_ordered),
6141: min(POL.line_num),
6142: min(POLL.shipment_num),
6143: min(PRL.org_id) --
6144: FROM PO_REQUISITION_LINES_ALL PRL, --
6145: PO_LINE_LOCATIONS_GT POLL,
6146: PO_LINES POL,
6147: PO_DISTRIBUTIONS PD,
6148: PO_REQ_DISTRIBUTIONS_ALL PRD --

Line 6166: FROM PO_REQUISITION_LINES_ALL PRL, --

6162: sum(PD.quantity_ordered),
6163: min(POL.line_num),
6164: min(POLL.shipment_num),
6165: min(PRL.org_id) --
6166: FROM PO_REQUISITION_LINES_ALL PRL, --
6167: PO_LINE_LOCATIONS_GT POLL,
6168: PO_LINES POL,
6169: PO_DISTRIBUTIONS PD,
6170: PO_REQ_DISTRIBUTIONS_ALL PRD --

Line 6379: FROM PO_REQUISITION_LINES_ALL PRL,

6375: INTO l_is_same_foreign_currency
6376: FROM DUAL
6377: WHERE NOT EXISTS
6378: (SELECT DISTINCT 1
6379: FROM PO_REQUISITION_LINES_ALL PRL,
6380: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
6381: GL_SETS_OF_BOOKS SOB
6382: WHERE PRL.LINE_LOCATION_ID = l_line_location_id(shipment_line)
6383: AND FSP.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

Line 25825: po_requisition_lines_all PRL,

25821: POLL.shipment_num,
25822: POD.distribution_num
25823: FROM po_distributions_gt POD,
25824: po_req_distributions_all PRD,
25825: po_requisition_lines_all PRL,
25826: po_requisition_headers_all PRH,
25827: po_line_locations_gt POLL,
25828: po_lines_gt POL
25829: WHERE POD.po_header_id = p_document_id