APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_LINES

Line 1655: * Modifies: Updates the PO_REQUISITION_LINES table with RATE information.

1651: * p_user_id: User performing the action
1652: * p_login_id: Last update login_id
1653: * IN OUT PARAMETERS
1654: * p_sequence: Sequence number of last reported error
1655: * Modifies: Updates the PO_REQUISITION_LINES table with RATE information.
1656: * Inserts error msgs in online_report_text_gt table, uses global_temp
1657: * tables for processing
1658: * Effects: This procedure runs the document submission checks for
1659: * REQUISITIONS

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 --

Line 12225: FROM po_requisition_lines

12221: REQS_IN_POOL_FLAG ,
12222: VMI_FLAG ,
12223: BID_NUMBER ,
12224: BID_LINE_NUMBER
12225: FROM po_requisition_lines
12226: WHERE requisition_header_id = p_document_id;
12227:
12228: l_progress := '001';
12229: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 12408: FROM po_req_distributions PRD, po_requisition_lines PRL

12404: PRD.RECOVERY_RATE ,
12405: PRD.TAX_RECOVERY_OVERRIDE_FLAG ,
12406: PRD.OKE_CONTRACT_LINE_ID ,
12407: PRD.OKE_CONTRACT_DELIVERABLE_ID
12408: FROM po_req_distributions PRD, po_requisition_lines PRL
12409: WHERE PRD.requisition_line_id = PRL.requisition_line_id AND
12410: PRL.requisition_header_id = p_document_id;
12411:
12412: l_progress := '001';