eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_INTERFACE_S dependencies on PO_LINES_ALL

Line 136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;

132: period_name gl_period_statuses.period_name%type,
133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */
134:
135: --
136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;
137: TYPE interface_header_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_header_id%TYPE INDEX BY PLS_INTEGER;
138: TYPE interface_line_id_tbl IS TABLE OF PO_ATTR_VALUES_INTERFACE.interface_line_id%TYPE INDEX BY PLS_INTEGER;
139: --
140:

Line 3117: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --

3113: l_outside_operation_flag PO_LINE_TYPES_B.outside_operation_flag%TYPE;
3114: l_receiving_flag PO_LINE_TYPES_B.receiving_flag%TYPE;
3115: l_receive_close_tolerance PO_LINE_TYPES_B.receive_close_tolerance%TYPE;
3116: --
3117: l_negotiated_by_preparer_flag po_lines_all.negotiated_by_preparer_flag%type; --
3118: l_type_lookup_code po_headers_all.type_lookup_code%type; --
3119: l_global_agreement_flag po_headers_all.global_agreement_flag%type; --
3120:
3121: -- oneoff 3201308 start

Line 3136: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL; --bug 3495772

3132:
3133: l_routing_name RCV_ROUTING_HEADERS.routing_name%TYPE; --
3134:
3135: l_progress VARCHAR2(3) := '000'; --< Bug 3210331 >
3136: l_manual_price_change_flag po_lines_all.manual_price_change_flag%TYPE := NULL; --bug 3495772
3137: l_from_type_lookup_code PO_HEADERS.type_lookup_code%type;--bug#3612701
3138:
3139: --
3140: x_secondary_unit_def MTL_UNITS_OF_MEASURE.UNIT_OF_MEASURE%TYPE;

Line 3293: FROM PO_LINES_ALL --

3289: x_po_unit_price,
3290: x_po_transaction_reason_code,
3291: x_price_break_lookup_code,
3292: l_manual_price_change_flag --bug 3495772
3293: FROM PO_LINES_ALL --
3294: WHERE PO_HEADER_ID = interface.po_header_id
3295: AND LINE_NUM = interface.line_num
3296: FOR UPDATE OF quantity;
3297:

Line 3316: FROM po_lines_all --

3312: /* Bug 2534534 Reverting the fix done in 1951084 */
3313: -- BEGIN
3314: SELECT po_line_id
3315: INTO x_po_line_id
3316: FROM po_lines_all --
3317: WHERE po_header_id = interface.po_header_id
3318: AND line_num = interface.line_num
3319: FOR UPDATE OF quantity;
3320:

Line 3469: FROM po_lines_all pol,po_headers_all poh

3465: --bug#3612701 modified the sql to fetch type lookup code
3466: --of the source document as well.
3467: SELECT pol.unit_meas_lookup_code,poh.type_lookup_code
3468: INTO l_ga_uom,l_from_type_lookup_code
3469: FROM po_lines_all pol,po_headers_all poh
3470: WHERE pol.po_line_id = interface.from_line_id
3471: and poh.po_header_id=interface.from_header_id
3472: and poh.po_header_id=pol.po_header_id;
3473: --bug#3612701

Line 4230: FROM po_lines_all

4226: -- if the source document is global agreement.
4227: IF l_type_lookup_code='BLANKET' and l_global_agreement_flag='Y' THEN
4228: l_progress := '395';
4229: SELECT negotiated_by_preparer_flag into l_negotiated_by_preparer_flag
4230: FROM po_lines_all
4231: WHERE po_line_id=interface.from_line_id;
4232: --if the source document is quotation.
4233: ELSIF l_type_lookup_code='QUOTATION' THEN
4234: l_negotiated_by_preparer_flag := 'Y';

Line 4370: INSERT INTO po_lines_all --

4366: -- bug 4887900 END
4367:
4368: -- Added note_to_vendor - iali 08/26/99
4369: /*Bug 1391523 . Added market price to the INSERT statement */
4370: INSERT INTO po_lines_all --
4371: ( po_line_id,
4372: last_update_date,
4373: last_updated_by,
4374: po_header_id,

Line 4938: from po_lines_all pl --

4934: l_progress := '540';
4935: begin
4936: select pl.quantity
4937: into l_db_quantity
4938: from po_lines_all pl --
4939: where pl.po_line_id = x_po_line_id;
4940: exception
4941: when others then
4942: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 5042: UPDATE po_lines_all

5038:
5039: -- Bug 2879460 Update the price on the PO only with the price
5040: -- from the pricing API and not with the interface price
5041:
5042: UPDATE po_lines_all
5043: -- Bug 3417479
5044: -- SET unit_price = x_unit_price,
5045: -- base_unit_price = l_base_unit_price,
5046: SET unit_price = nvl(x_unit_price, unit_price),

Line 5096: UPDATE po_lines_all --

5092: END IF;
5093:
5094: -- Bug 9324837
5095: -- Added update to secondary_quantity and commented the seconday null updates.
5096: UPDATE po_lines_all --
5097: --fix 8976669
5098: --Added a Decode for the nvl function as quantity should not be set to 0 for Fixed Price Services
5099: SET quantity = Decode(x_order_type_lookup_code,'FIXED PRICE',NULL,Nvl(quantity,0)) + nvl(x_quantity,0),
5100: secondary_quantity = (CASE -- secondary uom controlled item

Line 5134: UPDATE po_lines_all

5130: interface.item_id,
5131: x_secondary_unit_def,
5132: x_secondary_quantity_def) ;
5133:
5134: UPDATE po_lines_all
5135: SET secondary_quantity = x_secondary_quantity_def,
5136: secondary_unit_of_measure = x_secondary_unit_def
5137: WHERE po_line_id = x_po_line_id ;
5138:

Line 5781: FROM po_lines_all pol

5777: -- select out the UOM from po line
5778: BEGIN
5779: SELECT pol.unit_meas_lookup_code
5780: INTO x_temp_uom
5781: FROM po_lines_all pol
5782: WHERE po_line_id = x_po_line_id;
5783: EXCEPTION
5784: WHEN NO_DATA_FOUND THEN
5785: x_temp_uom := interface.unit_meas_lookup_code;

Line 5875: from po_lines_all pol , --

5871: IF (g_document_subtype='RELEASE') THEN -- Bug 2735840
5872: l_progress := '020';
5873: select unit_meas_lookup_code
5874: into x_po_uom
5875: from po_lines_all pol , --
5876: po_headers_all poh --
5877: where pol.po_header_id = poh.po_header_id
5878: and pol.po_header_id = interface.po_header_id
5879: and pol.line_num = interface.line_num;

Line 5885: FROM po_lines_all

5881: ELSE -- Autocreating a PO that references a GA
5882: l_progress := '030';
5883: SELECT unit_meas_lookup_code
5884: INTO x_po_uom
5885: FROM po_lines_all
5886: WHERE po_line_id = interface.from_line_id;
5887: END IF; -- g_document_subtype
5888: -- Bug 2735840 END
5889: EXCEPTION

Line 5958: po_lines_all pol --

5954: BEGIN
5955: SELECT poll.line_location_id,poll.secondary_unit_of_measure --
5956: INTO x_line_location_id,x_secondary_unit_of_measure
5957: FROM po_line_locations_all poll, --
5958: po_lines_all pol --
5959: WHERE poll.po_header_id = interface.po_header_id
5960: AND poll.po_line_id = pol.po_line_id
5961: AND poll.shipment_num = interface.shipment_num
5962: AND pol.line_num = interface.line_num

Line 5992: po_lines_all pol, --

5988: INTO x_line_location_id,
5989: l_manual_price_change_flag, --bug 3495772
5990: x_secondary_unit_of_measure
5991: FROM po_line_locations_all poll, --
5992: po_lines_all pol, --
5993: po_releases_all por --
5994: WHERE poll.po_header_id = interface.po_header_id
5995: AND poll.po_line_id = pol.po_line_id
5996: AND poll.shipment_num = interface.shipment_num

Line 6030: FROM po_lines_all --

6026:
6027: -- Find out if the line is using cumulative or non-cumlative pricing
6028: SELECT decode(price_break_lookup_code, 'CUMULATIVE', 'Y', 'N')
6029: INTO x_price_break_type
6030: FROM po_lines_all --
6031: WHERE po_line_id = x_po_line_id;
6032:
6033: IF (x_price_break_type = 'Y') THEN
6034: x_cumulative_flag := TRUE;

Line 6105: FROM po_lines_all --

6101: l_progress := '110';
6102: begin
6103: SELECT unit_price
6104: INTO x_price
6105: FROM po_lines_all --
6106: WHERE po_line_id=x_po_line_id;
6107: exception
6108: when others then
6109: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 7310: from po_lines_all pol , --

7306: IF (g_document_subtype='RELEASE') THEN -- Bug 2735840
7307: l_progress := '090';
7308: select unit_meas_lookup_code
7309: into x_po_uom
7310: from po_lines_all pol , --
7311: po_headers_all poh --
7312: where pol.po_header_id = poh.po_header_id
7313: and pol.po_header_id = interface.po_header_id
7314: and pol.line_num = interface.line_num;

Line 7320: FROM po_lines_all

7316: ELSE -- Autocreating a PO that references a GA
7317: l_progress := '100';
7318: SELECT unit_meas_lookup_code
7319: INTO x_po_uom
7320: FROM po_lines_all
7321: WHERE po_line_id = interface.from_line_id;
7322: END IF; -- g_document_subtype
7323: -- Bug 2735840 END
7324:

Line 8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;

8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
8563: -- Bug 3463242 END
8564:
8565: l_item_in_linv_pou VARCHAR2(1):= 'Y'; -- Bug 3433867
8566:

Line 9861: po_lines_all pol --

9857: FROM po_lines_interface pli,
9858: po_headers_interface phi,
9859: po_requisition_lines_all prl, --
9860: po_line_types plt,
9861: po_lines_all pol --
9862: WHERE pli.interface_line_id = pli2.interface_line_id
9863: AND pli.interface_header_id = phi.interface_header_id
9864: AND phi.interface_header_id = x_interface_header_id
9865: AND pli.requisition_line_id = prl.requisition_line_id(+)

Line 10065: ,po_lines_all pol --13876074

10061: FROM po_lines_interface pli,
10062: po_headers_interface phi,
10063: po_requisition_lines_all prl, --
10064: po_line_types plt
10065: ,po_lines_all pol --13876074
10066: WHERE pli.interface_line_id = pli2.interface_line_id
10067: AND pli.interface_header_id = phi.interface_header_id
10068: AND phi.interface_header_id = x_interface_header_id
10069: AND pli.requisition_line_id = prl.requisition_line_id(+)

Line 10548: l_contract_id PO_LINES_ALL.contract_id%TYPE; --

10544: x_consigned_flag VARCHAR2(1) := 'N'; --CONSIGNED FPI
10545: x_create_new_line VARCHAR2(1) := 'N'; --GA FPI
10546: l_supplier_ref_number PO_LINES_INTERFACE.supplier_ref_number%TYPE; --
10547:
10548: l_contract_id PO_LINES_ALL.contract_id%TYPE; --
10549:
10550: /* Bug 3201308 start */
10551: l_needby_prf varchar2(1);
10552: l_shipto_prf varchar2(1);

Line 10964: po_lines_all pl

10960:
10961: SELECT NVL(max(pl.line_num),0)
10962: INTO x_line_num
10963: FROM po_headers_all ph,
10964: po_lines_all pl
10965: WHERE pl.po_header_id = ph.po_header_id
10966: AND ph.segment1 = x_document_num
10967: AND ph.type_lookup_code =
10968: DECODE(g_document_type, 'RFQ', g_document_type, x_document_subtype)

Line 11375: FROM po_lines_all pol,

11371: SELECT pol.po_line_id,
11372: pol.line_num
11373: INTO x_po_line_id,
11374: x_po_line_num
11375: FROM po_lines_all pol,
11376: po_headers_all poh
11377: WHERE poh.segment1 = x_document_num
11378: AND pol.line_num = x_interface_line_num
11379: AND poh.type_lookup_code =

Line 11509: FROM po_lines_all POL2

11505: SELECT line_num
11506: , po_line_id
11507: INTO x_po_line_num
11508: , x_po_line_id
11509: FROM po_lines_all POL2
11510: , po_headers_all POH
11511: , po_line_types_b PLT --
11512: WHERE POH.segment1 = x_document_num
11513: AND POH.po_header_id = POL2.po_header_id

Line 11525: FROM po_lines_all pol --

11521: --
11522: --
11523: AND pol2.line_num =
11524: (SELECT /*+ NO_UNNEST */ MIN(line_num)
11525: FROM po_lines_all pol --
11526: WHERE pol.po_header_id = poh.po_header_id
11527: AND NVL(CANCEL_FLAG,'N') = 'N'
11528: AND LINE_TYPE_ID = x_line_type_id
11529: AND nvl(pol.ITEM_ID, -1) = nvl(x_item_id, -1) -- bgu, For one time item

Line 11623: FROM po_lines_all POL2,

11619: SELECT line_num,
11620: po_line_id
11621: INTO x_po_line_num,
11622: x_po_line_id
11623: FROM po_lines_all POL2,
11624: po_headers_all POH
11625: WHERE POH.segment1 = x_document_num
11626: AND POH.po_header_id = POL2.po_header_id
11627: AND NVL(poh.org_id, -99) = NVL(g_purchasing_ou_id, -99) --

Line 11632: FROM PO_LINES_ALL pol

11628: AND POH.type_lookup_code = 'RFQ'
11629: AND pol2.line_num =
11630: (
11631: SELECT /*+ NO_UNNEST */ MIN(line_num)
11632: FROM PO_LINES_ALL pol
11633: WHERE pol.po_header_id = poh.po_header_id
11634: AND LINE_TYPE_ID = x_line_type_id
11635: AND nvl(pol.ITEM_ID, -1) = nvl(x_item_id, -1)
11636: AND nvl(pol.ITEM_DESCRIPTION,'null') =

Line 11996: po_lines_all pl

11992:
11993: SELECT NVL(max(pl.line_num), 0)
11994: INTO x_line_num
11995: FROM po_headers_all ph,
11996: po_lines_all pl
11997: WHERE pl.po_header_id = ph.po_header_id
11998: AND ph.segment1 = x_document_num
11999: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99)
12000: AND ph.type_lookup_code =

Line 12227: FROM po_lines_all pol,

12223: BEGIN
12224:
12225: SELECT pol.po_line_id
12226: INTO x_po_line_id
12227: FROM po_lines_all pol,
12228: po_headers_all poh,
12229: po_lines_interface pli
12230: WHERE pol.po_header_id = poh.po_header_id
12231: AND poh.segment1 = x_document_num

Line 12882: po_lines_all POL

12878:
12879: SELECT POL.po_line_id
12880: INTO l_po_line_id
12881: FROM po_headers_interface PHI,
12882: po_lines_all POL
12883: WHERE PHI.interface_header_id = x_interface_header_id
12884: AND PHI.po_header_id = POL.po_header_id
12885: AND POL.line_num = x_po_line_num;
12886: ELSE

Line 12907: PO_LINES_ALL POL, --

12903: ,PLL.line_location_id
12904: INTO x_po_shipment_num,
12905: x_line_location_to_check
12906: FROM PO_LINE_LOCATIONS_ALL PLL, --
12907: PO_LINES_ALL POL, --
12908: PO_LINE_TYPES PLT --
12909: WHERE POL.PO_LINE_ID = l_po_line_id -- bug2788115
12910: AND POL.po_line_id = PLL.po_line_id --
12911: AND POL.line_type_id = PLT.line_type_id --

Line 13558: po_lines_all pl --

13554: l_progress := '030';
13555: select nvl(max(line_num),0)
13556: into x_line_num
13557: from po_headers_all ph, --
13558: po_lines_all pl --
13559: where pl.po_header_id = ph.po_header_id
13560: and ph.segment1 = x_document_num
13561: AND NVL(ph.org_id, -99) = NVL(g_purchasing_ou_id, -99); --
13562:

Line 13851: FROM po_lines_all pol,

13847: p_item_rev_control IN NUMBER,
13848: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13849: ) IS
13850: SELECT MIN(pol.line_num)
13851: FROM po_lines_all pol,
13852: po_requisition_lines_all prl --
13853: WHERE pol.po_header_id = p_po_header_id
13854: AND prl.requisition_line_id = p_requisition_line_id
13855: AND NVL(pol.cancel_flag,'N') = 'N'

Line 13901: OR ((NOT EXISTS (SELECT 1 FROM po_lines_all pol2

13897: -- IF THE REQ IS SOURCED TO THE DOC,BUT THE ALREADY SOURCED LINE IS INVALID,THEN TAKE THE OTHER VALID LINE FROM SOURCE DOCUMENT
13898: --OR TRUNC(NVL(POL.EXPIRATION_DATE,SYSDATE + 1)) >= TRUNC(DECODE(POL.EXPIRATION_DATE,NULL,SYSDATE, NVL(PRL.NEED_BY_DATE,SYSDATE))) ) --13876074
13899: --Bug 13876074, ensure to pick another source line
13900: --only if the current source line reference is not valid.
13901: OR ((NOT EXISTS (SELECT 1 FROM po_lines_all pol2
13902: WHERE pol2.po_header_id = pol.po_header_id
13903: AND TRUNC(NVL(pol2.expiration_date,SYSDATE + 1))
13904: >= TRUNC(SYSDATE)
13905: AND prl.blanket_po_line_num = pol2.line_num))

Line 13965: FROM po_lines_all pol,

13961: p_item_rev_control IN NUMBER,
13962: x_allow_different_uoms IN VARCHAR2 -- Bug 2707576
13963: ) IS
13964: SELECT MIN(pol.line_num)
13965: FROM po_lines_all pol,
13966: po_requisition_lines_all prl --
13967: WHERE pol.po_header_id = p_po_header_id
13968: AND prl.requisition_line_id = p_requisition_line_id
13969: AND NVL(pol.cancel_flag,'N') = 'N'

Line 14013: OR ((NOT EXISTS (SELECT 1 FROM po_lines_all pol2

14009: -- IF THE REQ IS SOURCED TO THE DOC,BUT THE ALREADY SOURCED LINE IS INVALID,THEN TAKE THE OTHER VALID LINE FROM SOURCE DOCUMENT
14010: --OR TRUNC(NVL(POL.EXPIRATION_DATE,SYSDATE + 1)) >= TRUNC(DECODE(POL.EXPIRATION_DATE,NULL,SYSDATE,NVL(PRL.NEED_BY_DATE,SYSDATE))) ) --13876074
14011: --Bug 13876074, ensure to pick another source line
14012: --only if the current source line reference is not valid.
14013: OR ((NOT EXISTS (SELECT 1 FROM po_lines_all pol2
14014: WHERE pol2.po_header_id = pol.po_header_id
14015: AND TRUNC(NVL(pol2.expiration_date,SYSDATE + 1))
14016: >= TRUNC(SYSDATE)
14017: AND prl.blanket_po_line_num = pol2.line_num))

Line 14146: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --

14142: l_ship_org_id_line mtl_system_items.organization_id%type;
14143: l_ship_org_code varchar2(3);
14144: l_ship_org_name varchar2(60);
14145:
14146: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE; --
14147:
14148: BEGIN
14149: -- Standard start of API savepoint
14150: SAVEPOINT create_price_break_pvt;

Line 14197: FROM po_lines_all pol

14193: -- Get value basis from line
14194:
14195: SELECT pol.order_type_lookup_code
14196: INTO l_value_basis
14197: FROM po_lines_all pol
14198: WHERE pol.po_line_id = p_po_line_id;
14199:
14200: l_progress := '025';
14201:

Line 14889: -- p_po_line_id: id of the line in po_lines_all

14885: -- payitem. Also create DELIVERY and ADVANCE payitems as necessary.
14886: --Parameters:
14887: -- IN:
14888: -- p_interface_line_id: id of the line in po_lines_interface
14889: -- p_po_line_id: id of the line in po_lines_all
14890: -- p_precision: precision of the currency desired. Used to round amounts.
14891: -- p_ext_precision: extended precision of the currency desired.
14892: -- Used to round prices
14893: -- OUT:

Line 14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;

14912:
14913: d_progress NUMBER;
14914: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitems';
14915:
14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;

Line 14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

14913: d_progress NUMBER;
14914: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitems';
14915:
14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;

Line 14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;

14914: d_module VARCHAR2(70) := 'po.plsql.PO_INTERFACE_S.create_payitems';
14915:
14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;
14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;

Line 14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;

14915:
14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;
14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14923:

Line 14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;

14916: l_po_header_id PO_LINES_ALL.po_header_id%TYPE;
14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;
14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14923:
14924: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;

Line 14921: l_line_amount PO_LINES_ALL.amount%TYPE;

14917: l_line_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;
14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14923:
14924: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14925: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;

Line 14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;

14918: l_line_matching_basis PO_LINES_ALL.matching_basis%TYPE;
14919: l_line_unit_price PO_LINES_ALL.unit_price%TYPE;
14920: l_line_quantity PO_LINES_ALL.quantity%TYPE;
14921: l_line_amount PO_LINES_ALL.amount%TYPE;
14922: l_line_purchase_basis PO_LINES_ALL.purchase_basis%TYPE;
14923:
14924: l_payment_type PO_LINE_LOCATIONS_ALL.payment_type%TYPE;
14925: l_shipment_type PO_LINE_LOCATIONS_ALL.shipment_type%TYPE;
14926: l_payitem_quantity PO_LINE_LOCATIONS_ALL.quantity%TYPE;

Line 15012: FROM po_lines_all pol

15008: , l_line_unit_price
15009: , l_line_quantity
15010: , l_line_amount
15011: , l_line_purchase_basis
15012: FROM po_lines_all pol
15013: WHERE pol.po_line_id = p_po_line_id;
15014:
15015: d_progress := 20;
15016:

Line 15620: -- p_po_line_id: id of the line in po_lines_all

15616: --Parameters:
15617: -- IN:
15618: -- p_req_line_id: id of the requisition line that is the source of
15619: -- the po line; null if no backing req.
15620: -- p_po_line_id: id of the line in po_lines_all
15621: -- p_interface_line_id: id of the line in po_lines_interface
15622: -- p_precision: precision of the currency desired. Used to round amounts.
15623: -- p_ext_precision: extended precision of the currency desired.
15624: -- Used to round prices