APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_HEADERS_INTERFACE

Line 146: l_rate_type po_headers_interface.rate_type%TYPE;

142: l_po_ou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
143: l_inverse_rate_display_flag VARCHAR2 (1) := 'N';
144: l_display_rate NUMBER;
145: l_progress VARCHAR2 (3) := '000';
146: l_rate_type po_headers_interface.rate_type%TYPE;
147: l_api_name CONSTANT VARCHAR2 (30) := 'get_rate_for_req_price';
148:
149: BEGIN
150:

Line 281: po_headers_interface phi,

277: phi.rate_date,
278: phi.document_subtype,
279: pli.unit_price
280: FROM po_lines_interface pli,
281: po_headers_interface phi,
282: po_line_types plt
283: WHERE phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id
284: AND phi.interface_header_id = pli.interface_header_id
285: AND pli.requisition_line_id IS NULL

Line 499: po_headers_interface phi,

495: NVL(pli.clm_base_line_num,prl.clm_base_line_num) ,
496: NVL(pli.contract_type,prl.contract_type) ,
497: NVL(pli.cost_constraint,prl.cost_constraint)
498: FROM po_lines_interface pli,
499: po_headers_interface phi,
500: po_requisition_lines_all prl,
501: po_line_types plt
502: WHERE pli.interface_line_id = pli2.interface_line_id
503: AND pli.interface_header_id = phi.interface_header_id

Line 644: po_headers_interface phi,

640: NVL(pli.CLM_FUNDED_FLAG, prl.CLM_FUNDED_FLAG) ,
641: NVL(pli.CLM_BASE_LINE_NUM,prl.CLM_BASE_LINE_NUM)
642: --
643: FROM po_lines_interface pli,
644: po_headers_interface phi,
645: po_requisition_lines_all prl --
646: WHERE pli.interface_line_id = pli2.interface_line_id
647: AND pli.interface_header_id = phi.interface_header_id
648: AND phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id

Line 883: po_headers_interface phi

879: prd.amount_funded --
880: FROM po_requisition_lines_all prl, --
881: po_req_distributions_all prd, --
882: po_lines_interface pli,
883: po_headers_interface phi
884: WHERE prd.requisition_line_id = prl.requisition_line_id
885: AND prl.requisition_line_id = pli.requisition_line_id
886: AND pli.interface_header_id = phi.interface_header_id
887: AND phi.interface_header_id = PO_AUTOCREATE_PARAMS.x_interface_header_id

Line 1580: po_headers_interface intf_headers,

1576: p_lines.clm_delivery_period_uom_tbl,
1577: p_lines.clm_promise_period_uom_tbl,
1578: p_lines.clm_pop_duration_uom_tbl
1579: FROM po_lines_interface intf_lines,
1580: po_headers_interface intf_headers,
1581: po_headers_draft_all draft_headers
1582: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1583: AND intf_headers.draft_id = draft_headers.draft_id
1584: AND intf_headers.po_header_id = draft_headers.po_header_id

Line 5043: po_headers_interface phi,

5039: null),--quantity_funded,
5040: Decode(plb.matching_basis, 'AMOUNT',(paa.allocated_funds * (prd.funds_remaining/ req_dist_amt.tot_funds_remaining)),
5041: NULL ) --amount_funded
5042: FROM po_lines_interface pli,
5043: po_headers_interface phi,
5044: pon_award_allocations paa,
5045: po_clmreq_dist_details_v prd,
5046: (SELECT requisition_line_id, Sum(prd.funds_remaining) AS tot_funds_remaining
5047: FROM po_clmreq_dist_details_v prd