DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 4044: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;

4040: l_requesting_org_id NumTab;
4041: l_display_rate NUMBER;
4042: l_return_status VARCHAR2(1);
4043: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
4044: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4045: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4046: --
4047:
4048: l_is_complex_po BOOLEAN := FALSE; --

Line 4045: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;

4041: l_display_rate NUMBER;
4042: l_return_status VARCHAR2(1);
4043: l_error_message_name FND_NEW_MESSAGES.message_name%TYPE;
4044: l_req_line_price_pou_base_curr PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4045: l_req_line_price_ext_precn PO_REQUISITION_LINES_ALL.unit_price%TYPE;
4046: --
4047:
4048: l_is_complex_po BOOLEAN := FALSE; --
4049:

Line 4182: FROM PO_REQUISITION_LINES_ALL PRL, --

4178: PRL.unit_meas_lookup_code,
4179: min(POL.line_num),
4180: min(POLL.shipment_num),
4181: min(PRL.org_id) --
4182: FROM PO_REQUISITION_LINES_ALL PRL, --
4183: PO_LINE_LOCATIONS_GT POLL,
4184: PO_LINES POL
4185: WHERE PRL.line_location_id = POLL.line_location_id
4186: AND POLL.line_location_id = p_line_location_id

Line 4198: FROM PO_REQUISITION_LINES_ALL PRL, --

4194: sum(PD.quantity_ordered),
4195: min(POL.line_num),
4196: min(POLL.shipment_num),
4197: min(PRL.org_id) --
4198: FROM PO_REQUISITION_LINES_ALL PRL, --
4199: PO_LINE_LOCATIONS_GT POLL,
4200: PO_LINES POL,
4201: PO_DISTRIBUTIONS PD,
4202: PO_REQ_DISTRIBUTIONS_ALL PRD --