APPS.PO_AUTO_LINE_PROCESS_PVT dependencies on PO_HEADERS

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 1581: po_headers_draft_all draft_headers

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
1585: AND intf_lines.interface_header_id = p_interface_header_id

Line 1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --

1654: --
1655: l_base_unit_price po_lines.base_unit_price%TYPE := NULL; --
1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --
1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
1660: l_needby_prf VARCHAR2(1);
1661: l_shipto_prf VARCHAR2(1);
1662: x_quote_header_id NUMBER := NULL;

Line 1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --

1655: l_base_unit_price po_lines.base_unit_price%TYPE := NULL; --
1656: l_contractor_status PO_REQUISITION_LINES_ALL.contractor_status%TYPE;
1657: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
1658: l_type_lookup_code po_headers_all.type_lookup_code%type; --
1659: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
1660: l_needby_prf VARCHAR2(1);
1661: l_shipto_prf VARCHAR2(1);
1662: x_quote_header_id NUMBER := NULL;
1663: x_quote_line_id NUMBER := NULL;

Line 1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;

1663: x_quote_line_id NUMBER := NULL;
1664: l_routing_name VARCHAR2 (100);
1665: g_chktype_TRACKING_QTY_IND CONSTANT MTL_SYSTEM_ITEMS_B.TRACKING_QUANTITY_IND%TYPE := 'PS';
1666: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL;
1667: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;
1668: l_uom_convert VARCHAR2(2) := fnd_profile.value('PO_REQ_BPA_UOM_CONVERT');
1669: l_ga_uom PO_LINES.unit_meas_lookup_code%TYPE;
1670: l_quantity_in_ga_uom PO_LINES_INTERFACE.quantity%TYPE;
1671: l_conversion_rate NUMBER :=1;

Line 2033: po_headers_all poh

2029: poh.type_lookup_code
2030: INTO l_ga_uom,
2031: l_from_type_lookup_code
2032: FROM po_lines_all pol,
2033: po_headers_all poh
2034: WHERE pol.po_line_id = p_lines.from_line_id_tbl(i)
2035: AND poh.po_header_id =p_lines.from_header_id_tbl(i)
2036: AND poh.po_header_id =pol.po_header_id;
2037: EXCEPTION

Line 2682: FROM po_headers_all

2678: SELECT type_lookup_code,
2679: global_agreement_flag
2680: INTO l_type_lookup_code,
2681: l_global_agreement_flag
2682: FROM po_headers_all
2683: WHERE po_header_id=p_lines.from_header_id_tbl(i);
2684:
2685: -- if the source document is global agreement.
2686: IF l_type_lookup_code='BLANKET' AND l_global_agreement_flag='Y' THEN

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