APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_REQUISITION_LINES

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

3437: * p_user_id: User performing the action
3438: * p_login_id: Last update login_id
3439: * IN OUT PARAMETERS
3440: * p_sequence: Sequence number of last reported error
3441: * Modifies: Updates the PO_REQUISITION_LINES table with RATE information.
3442: * Inserts error msgs in online_report_text_gt table, uses global_temp
3443: * tables for processing
3444: * Effects: This procedure runs the document submission checks for
3445: * REQUISITIONS

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 15743: FROM po_requisition_lines

15739: REQS_IN_POOL_FLAG ,
15740: VMI_FLAG ,
15741: BID_NUMBER ,
15742: BID_LINE_NUMBER
15743: FROM po_requisition_lines
15744: WHERE requisition_header_id = p_document_id;
15745:
15746: l_progress := '001';
15747: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 15926: FROM po_req_distributions PRD, po_requisition_lines PRL

15922: PRD.RECOVERY_RATE ,
15923: PRD.TAX_RECOVERY_OVERRIDE_FLAG ,
15924: PRD.OKE_CONTRACT_LINE_ID ,
15925: PRD.OKE_CONTRACT_DELIVERABLE_ID
15926: FROM po_req_distributions PRD, po_requisition_lines PRL
15927: WHERE PRD.requisition_line_id = PRL.requisition_line_id AND
15928: PRL.requisition_header_id = p_document_id;
15929:
15930: l_progress := '001';

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