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.AP_APPROVAL_MATCHED_PKG dependencies on AP_INVOICE_LINES

Line 304: ap_invoice_lines_all ail

300: po_line_locations PLL,
301: po_lines PL,
302: rcv_transactions RTXN,
303: rcv_shipment_lines RSL,
304: ap_invoice_lines_all ail
305: WHERE I.invoice_id = p_invoice_id
306: AND I.invoice_id = D.invoice_id
307: AND D.invoice_line_number = p_inv_line_number
308: AND D.invoice_id= ail.invoice_id

Line 501: FROM ap_invoice_lines ail

497:
498: BEGIN
499: SELECT ail.rcv_transaction_id
500: INTO l_rcv_transaction_id
501: FROM ap_invoice_lines ail
502: WHERE ail.invoice_id = p_invoice_id
503: AND ail.line_number = p_inv_line_number;
504: EXCEPTION
505: WHEN NO_DATA_FOUND THEN NULL;

Line 861: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

857: END IF;
858:
859: l_related_id := l_invoice_distribution_id;
860:
861: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
862: p_invoice_id,
863: p_inv_line_number) + 1;
864:
865: INSERT INTO ap_invoice_distributions (

Line 1114: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

1110: END IF;
1111:
1112: l_related_id := l_invoice_distribution_id;
1113:
1114: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
1115: p_invoice_id,
1116: p_inv_line_number) + 1;
1117:
1118: INSERT INTO ap_invoice_distributions (

Line 2107: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),

2103: CURSOR Matched_Cur IS
2104: SELECT PLL.line_location_id,
2105: PLL.po_line_id,
2106: SUM(L.amount),
2107: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),
2108: --bug 5182413
2109: SUM(nvl(L.quantity_invoiced,0)),
2110: PLL.price_override, -- BUG 4123171
2111: ROUND((nvl(PLL.quantity,0) - nvl(PLL.quantity_cancelled,0)), 15),

Line 2146: ap_invoice_lines L,

2142: I.org_id -- Bug 5500101
2143: FROM po_lines PL,
2144: rcv_transactions RTXN,
2145: rcv_shipment_lines RSL,
2146: ap_invoice_lines L,
2147: ap_invoices I,
2148: po_line_locations PLL,
2149: po_headers PH,
2150: po_releases PR

Line 2211: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413

2207: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044
2208: L.discarded_flag,L.cancelled_flag,
2209: PLL.matching_basis,PLL.payment_type,I.invoice_type_lookup_code,
2210: I.org_id,
2211: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413
2212: l_line_location_id NUMBER(15);
2213: l_po_line_id NUMBER(15);
2214: l_inv_line_amount NUMBER;
2215: l_adj_qty_invoiced NUMBER;

Line 2288: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;

2284: l_billed_amount_used NUMBER;
2285: l_txn_uom VARCHAR2(25);
2286: l_po_uom VARCHAR2(25);
2287: l_item_id NUMBER;
2288: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign

Line 2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;

2285: l_txn_uom VARCHAR2(25);
2286: l_po_uom VARCHAR2(25);
2287: l_item_id NUMBER;
2288: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
2289: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2290: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2291:
2292: --Contract Payments: Tolerances Redesign
2293: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 2504: FROM ap_invoice_lines_all

2500: -- l_final_matching_exists := 'Y'; --bug5759169
2501:
2502: BEGIN
2503: SELECT 1 INTO l_final_match_count
2504: FROM ap_invoice_lines_all
2505: WHERE po_line_location_id = l_line_location_id
2506: AND nvl(final_match_flag,'N') in ('D','Y')
2507: AND nvl(discarded_flag,'N')<>'Y'
2508: AND nvl(cancelled_flag,'N')<>'Y'

Line 3973: UPDATE ap_invoice_lines AIL

3969: (SELECT PD.po_distribution_id
3970: FROM po_distributions_ap_v PD
3971: WHERE line_location_id = p_line_location_id);
3972:
3973: UPDATE ap_invoice_lines AIL
3974: SET final_match_flag = p_final_match_flag
3975: WHERE AIL.po_line_location_id = p_line_location_id
3976: AND AIL.invoice_id=p_invoice_id;--bug5759169
3977:

Line 4558: ap_invoice_lines ail

4554: BEGIN
4555: SELECT count(*)
4556: INTO l_rec_exception_count
4557: FROM rcv_transactions rt,
4558: ap_invoice_lines ail
4559: WHERE rt.receipt_exception_flag = 'Y'
4560: AND rt.transaction_type = 'RECEIVE'
4561: AND rt.po_line_location_id = ail.po_line_location_id
4562: AND ail.po_line_location_id = p_line_location_id

Line 4675: FROM ap_invoice_lines AIL

4671: +-----------------------------------------------------------------*/
4672:
4673: CURSOR corrected_invoices IS
4674: SELECT distinct corrected_inv_id
4675: FROM ap_invoice_lines AIL
4676: WHERE AIL.invoice_id = p_invoice_id
4677: AND ( ( AIL.po_line_location_id is not null and
4678: AIL.po_line_location_id = p_line_location_id )
4679: OR( AIL.rcv_transaction_id is not null and

Line 4705: FROM ap_invoice_lines AIL

4701: +------------------------------------------------------------------*/
4702:
4703: SELECT count(*)
4704: INTO l_correction_count
4705: FROM ap_invoice_lines AIL
4706: WHERE AIL.invoice_id = p_invoice_id
4707: AND po_line_location_id = p_line_location_id
4708: AND corrected_inv_id is not null
4709: AND corrected_inv_id <> p_invoice_id;

Line 4905: FROM ap_invoice_lines AIL

4901: sum( decode( AIL.match_type, 'PRICE_CORRECTION', 0,
4902: nvl(AIL.quantity_invoiced,0)) )
4903: INTO l_sum_pc_inv_amount,
4904: l_sum_qty_invoiced
4905: FROM ap_invoice_lines AIL
4906: WHERE AIL.po_line_location_id = p_line_location_id
4907: AND ( AIL.corrected_inv_id = p_invoice_id
4908: OR (AIL.invoice_id = p_invoice_id and
4909: AIL.corrected_inv_id is null) )

Line 4946: FROM ap_invoice_lines AIL

4942: )
4943: )
4944: INTO l_sum_pc_inv_amount,
4945: l_sum_qty_invoiced
4946: FROM ap_invoice_lines AIL
4947: WHERE AIL.po_line_location_id = p_line_location_id
4948: AND ( AIL.corrected_inv_id = p_invoice_id
4949: OR (AIL.invoice_id = p_invoice_id and
4950: AIL.corrected_inv_id is null) )

Line 5178: FROM ap_invoice_lines L

5174:
5175:
5176: SELECT nvl(trunc(sum(quantity_invoiced),5),0) --7021414
5177: INTO p_qty_billed
5178: FROM ap_invoice_lines L
5179: WHERE L.po_line_location_id = p_line_location_id
5180: AND ( (L.invoice_id = p_invoice_id and
5181: L.match_type = 'ITEM_TO_PO' ) -- query condition 1
5182: or (L.corrected_inv_id = p_invoice_id and

Line 5186: FROM ap_invoice_lines L2

5182: or (L.corrected_inv_id = p_invoice_id and
5183: L.match_type = 'QTY_CORRECTION') -- query condition 2
5184: or (L.invoice_id IN
5185: ( SELECT corrected_inv_id
5186: FROM ap_invoice_lines L2
5187: WHERE L2.invoice_id = p_invoice_id
5188: AND L2.po_line_location_id = p_line_location_id
5189: AND L2.match_type = 'QTY_CORRECTION') and
5190: L.match_type = 'ITEM_TO_PO' ) -- query condition 3

Line 5193: FROM ap_invoice_lines L3

5189: AND L2.match_type = 'QTY_CORRECTION') and
5190: L.match_type = 'ITEM_TO_PO' ) -- query condition 3
5191: or ( L.corrected_inv_id IN
5192: ( SELECT corrected_inv_id
5193: FROM ap_invoice_lines L3
5194: WHERE L3.invoice_id = p_invoice_id
5195: AND L3.po_line_location_id = p_line_location_id
5196: AND L3.match_type = 'QTY_CORRECTION') and
5197: L.match_type = 'QTY_CORRECTION' ) ) -- query condition 4

Line 5206: FROM ap_invoice_lines L

5202:
5203:
5204: SELECT nvl(trunc(sum(quantity_invoiced),5),0)
5205: INTO p_qty_billed
5206: FROM ap_invoice_lines L
5207: WHERE L.po_line_location_id = p_line_location_id
5208: AND ( (L.invoice_id = p_invoice_id and
5209: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 1
5210: or (L.corrected_inv_id = p_invoice_id and

Line 5214: FROM ap_invoice_lines L2

5210: or (L.corrected_inv_id = p_invoice_id and
5211: L.match_type = 'QTY_CORRECTION') -- query condition 2
5212: or (L.invoice_id IN
5213: ( SELECT corrected_inv_id
5214: FROM ap_invoice_lines L2
5215: WHERE L2.invoice_id = p_invoice_id
5216: AND L2.po_line_location_id = p_line_location_id
5217: AND L2.match_type = 'QTY_CORRECTION') and
5218: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3

Line 5221: FROM ap_invoice_lines L3

5217: AND L2.match_type = 'QTY_CORRECTION') and
5218: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3
5219: or (L.corrected_inv_id IN
5220: ( SELECT corrected_inv_id
5221: FROM ap_invoice_lines L3
5222: WHERE L3.invoice_id = p_invoice_id
5223: AND L3.po_line_location_id = p_line_location_id
5224: AND L3.match_type = 'QTY_CORRECTION') and
5225: L.match_type = 'QTY_CORRECTION' ) ) -- query condition 4

Line 5417: FROM ap_invoice_lines L

5413:
5414:
5415: SELECT trunc(sum(amount),5)
5416: INTO p_amt_billed
5417: FROM ap_invoice_lines L
5418: WHERE L.po_line_location_id = p_line_location_id
5419: AND ( (L.invoice_id = p_invoice_id and
5420: L.match_type = 'ITEM_TO_PO' ) -- query condition 1
5421: or (L.corrected_inv_id = p_invoice_id and

Line 5425: FROM ap_invoice_lines L2

5421: or (L.corrected_inv_id = p_invoice_id and
5422: L.match_type = 'AMOUNT_CORRECTION') -- query condition 2
5423: or (L.invoice_id IN
5424: ( SELECT corrected_inv_id
5425: FROM ap_invoice_lines L2
5426: WHERE L2.invoice_id = p_invoice_id
5427: AND L2.po_line_location_id = p_line_location_id
5428: AND L2.match_type = 'AMOUNT_CORRECTION') and
5429: L.match_type = 'ITEM_TO_PO' ) -- query condition 3

Line 5432: FROM ap_invoice_lines L3

5428: AND L2.match_type = 'AMOUNT_CORRECTION') and
5429: L.match_type = 'ITEM_TO_PO' ) -- query condition 3
5430: or ( L.corrected_inv_id IN
5431: ( SELECT corrected_inv_id
5432: FROM ap_invoice_lines L3
5433: WHERE L3.invoice_id = p_invoice_id
5434: AND L3.po_line_location_id = p_line_location_id
5435: AND L3.match_type = 'AMOUNT_CORRECTION') and
5436: L.match_type = 'AMOUNT_CORRECTION' ) ); -- query condition 4

Line 5444: FROM ap_invoice_lines L

5440:
5441:
5442: SELECT trunc(sum(amount),5)
5443: INTO p_amt_billed
5444: FROM ap_invoice_lines L
5445: WHERE L.po_line_location_id = p_line_location_id
5446: AND ( (L.invoice_id = p_invoice_id and
5447: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 1
5448: or (L.corrected_inv_id = p_invoice_id and

Line 5452: FROM ap_invoice_lines L2

5448: or (L.corrected_inv_id = p_invoice_id and
5449: L.match_type = 'AMOUNT_CORRECTION') -- query condition 2
5450: or (L.invoice_id IN
5451: ( SELECT corrected_inv_id
5452: FROM ap_invoice_lines L2
5453: WHERE L2.invoice_id = p_invoice_id
5454: AND L2.po_line_location_id = p_line_location_id
5455: AND L2.match_type = 'AMOUNT_CORRECTION') and
5456: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3

Line 5459: FROM ap_invoice_lines L3

5455: AND L2.match_type = 'AMOUNT_CORRECTION') and
5456: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3
5457: or (L.corrected_inv_id IN
5458: ( SELECT corrected_inv_id
5459: FROM ap_invoice_lines L3
5460: WHERE L3.invoice_id = p_invoice_id
5461: AND L3.po_line_location_id = p_line_location_id
5462: AND L3.match_type = 'AMOUNT_CORRECTION') and
5463: L.match_type = 'AMOUNT_CORRECTION' ) ); -- query condition 4

Line 5732: FROM ap_invoice_lines L

5728: END IF;
5729:
5730: SELECT sum( NVL(L.amount, 0) )
5731: INTO p_ship_trx_amt
5732: FROM ap_invoice_lines L
5733: WHERE L.po_line_location_id = p_line_location_id
5734: AND ( (L.invoice_id = p_invoice_id and
5735: L.match_type IN ('ITEM_TO_PO', -- query condition 1
5736: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching

Line 5740: FROM ap_invoice_lines L2

5736: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5737: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5738: or (L.invoice_id IN
5739: ( SELECT corrected_inv_id
5740: FROM ap_invoice_lines L2
5741: WHERE L2.po_line_location_id = p_line_location_id
5742: AND L2.invoice_id = p_invoice_id
5743: AND L2.corrected_inv_id is not null ) and
5744: L.match_type IN ('ITEM_TO_PO', -- query condition 3

Line 5748: FROM ap_invoice_lines L3

5744: L.match_type IN ('ITEM_TO_PO', -- query condition 3
5745: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5746: or (L.corrected_inv_id IN
5747: ( SELECT corrected_inv_id
5748: FROM ap_invoice_lines L3
5749: WHERE L3.po_line_location_id = p_line_location_id
5750: AND L3.invoice_id = p_invoice_id
5751: AND L3.corrected_inv_id is not null ) ) );
5752: -- query condition 4

Line 5766: FROM ap_invoice_lines L

5762: END IF;
5763:
5764: SELECT sum(NVL(L.amount, 0))
5765: INTO p_ship_trx_amt
5766: FROM ap_invoice_lines L
5767: WHERE L.po_line_location_id = p_line_location_id
5768: AND ( (L.invoice_id = p_invoice_id and
5769: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 1
5770: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching

Line 5774: FROM ap_invoice_lines L2

5770: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
5771: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5772: or (L.invoice_id IN
5773: ( SELECT corrected_inv_id
5774: FROM ap_invoice_lines L2
5775: WHERE L2.po_line_location_id = p_line_location_id
5776: AND L2.invoice_id = p_invoice_id
5777: AND L2.corrected_inv_id is not null ) and
5778: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3

Line 5782: FROM ap_invoice_lines L3

5778: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3
5779: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
5780: or (L.corrected_inv_id IN
5781: ( SELECT corrected_inv_id
5782: FROM ap_invoice_lines L3
5783: WHERE L3.po_line_location_id = p_line_location_id
5784: AND L3.invoice_id = p_invoice_id
5785: AND L3.corrected_inv_id is not null ) ) );
5786: -- query condition 4

Line 6018: , ap_invoice_lines L --Bug6824860

6014: INTO p_ship_base_amt_var
6015: FROM ap_invoice_distributions D
6016: , po_distributions_ap_v PD
6017: , ap_invoices I
6018: , ap_invoice_lines L --Bug6824860
6019: WHERE D.po_distribution_id = PD.po_distribution_id
6020: AND PD.line_location_id = p_line_location_id
6021: AND D.invoice_id = I.invoice_id
6022: AND L.invoice_id = I.invoice_id --Bug6824860

Line 6038: , ap_invoice_lines L

6034: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6035: INTO p_ship_base_amt_var
6036: FROM ap_invoice_distributions D
6037: , ap_invoices I
6038: , ap_invoice_lines L
6039: ,rcv_transactions RT
6040: WHERE D.rcv_transaction_id = RT.transaction_id
6041: AND RT.transaction_id=p_rcv_transaction_id
6042: AND D.invoice_id = I.invoice_id

Line 6076: , ap_invoice_lines L --Bug6824860

6072: INTO p_ship_base_amt_var
6073: FROM ap_invoice_distributions D
6074: , po_distributions_ap_v PD
6075: , ap_invoices I
6076: , ap_invoice_lines L --Bug6824860
6077: WHERE D.po_distribution_id = PD.po_distribution_id
6078: AND PD.line_location_id = p_line_location_id
6079: AND D.invoice_id = I.invoice_id
6080: AND L.invoice_id = I.invoice_id --Bug6824860

Line 6096: , ap_invoice_lines L

6092: SELECT SUM(DECODE(p_inv_curr_code, p_base_curr_code, nvl(D.amount,0),nvl(D.base_amount,D.amount)))
6093: INTO p_ship_base_amt_var
6094: FROM ap_invoice_distributions D
6095: , ap_invoices I
6096: , ap_invoice_lines L
6097: ,rcv_transactions RT
6098: WHERE D.rcv_transaction_id = RT.transaction_id
6099: AND RT.transaction_id=p_rcv_transaction_id
6100: AND D.invoice_id = I.invoice_id

Line 6211: FROM ap_invoice_lines L,

6207: ,nvl(L.amount,0)
6208: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
6209: )
6210: INTO p_ship_base_amt
6211: FROM ap_invoice_lines L,
6212: ap_invoices AI
6213: WHERE AI.invoice_id = L.invoice_id
6214: AND L.po_line_location_id = p_line_location_id
6215: AND ( (L.invoice_id = p_invoice_id and

Line 6221: FROM ap_invoice_lines L2

6217: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
6218: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
6219: or (L.invoice_id IN
6220: ( SELECT corrected_inv_id
6221: FROM ap_invoice_lines L2
6222: WHERE L2.po_line_location_id = p_line_location_id
6223: AND L2.invoice_id = p_invoice_id
6224: AND L2.corrected_inv_id is not null ) and
6225: L.match_type IN ('ITEM_TO_PO', -- query condition 3

Line 6229: FROM ap_invoice_lines L3

6225: L.match_type IN ('ITEM_TO_PO', -- query condition 3
6226: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
6227: or (L.corrected_inv_id IN
6228: ( SELECT corrected_inv_id
6229: FROM ap_invoice_lines L3
6230: WHERE L3.po_line_location_id = p_line_location_id
6231: AND L3.invoice_id = p_invoice_id
6232: AND L3.corrected_inv_id is not null ) ) );
6233: -- query condition 4

Line 6251: FROM ap_invoice_lines L,

6247: ,nvl(L.amount,0)
6248: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
6249: )
6250: INTO p_ship_base_amt
6251: FROM ap_invoice_lines L,
6252: ap_invoices AI
6253: WHERE AI.invoice_id = L.invoice_id
6254: AND L.rcv_transaction_id = p_rcv_transaction_id /*Added for Bug 14726598 as additional fix*/
6255: AND ( (L.invoice_id = p_invoice_id and

Line 6261: FROM ap_invoice_lines L2

6257: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
6258: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
6259: or (L.invoice_id IN
6260: ( SELECT corrected_inv_id
6261: FROM ap_invoice_lines L2
6262: WHERE L2.po_line_location_id = p_line_location_id
6263: AND L2.invoice_id = p_invoice_id
6264: AND L2.corrected_inv_id is not null ) and
6265: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3

Line 6269: FROM ap_invoice_lines L3

6265: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3
6266: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
6267: or (L.corrected_inv_id IN
6268: ( SELECT corrected_inv_id
6269: FROM ap_invoice_lines L3
6270: WHERE L3.po_line_location_id = p_line_location_id
6271: AND L3.invoice_id = p_invoice_id
6272: AND L3.corrected_inv_id is not null ) ) );
6273: -- query condition 4

Line 6311: FROM ap_invoice_lines_all

6307: -- bug8704810
6308: -- SELECT 'Price Difference or Quantity Has Decimals' .. bug8704810
6309: SELECT 'Price Difference' -- bug8704810
6310: INTO l_check
6311: FROM ap_invoice_lines_all
6312: WHERE invoice_id = p_invoice_id
6313: AND po_line_location_id = p_line_location_id
6314: AND unit_price <> p_po_unit_price;
6315:

Line 6372: FROM ap_invoice_lines

6368:
6369: Print_Debug(l_debug_loc, 'exec_pay_when_paid_check - begin for invoice_id : '|| p_invoice_id);
6370:
6371: FOR i IN (SELECT DISTINCT po_header_id
6372: FROM ap_invoice_lines
6373: WHERE invoice_id = p_invoice_id
6374: AND po_header_id is NOT NULL)
6375: LOOP
6376:

Line 6451: FROM ap_invoice_lines

6447:
6448: Print_Debug(l_debug_loc,'exec_po_deliverable_check - begin for invoice_id : '|| p_invoice_id);
6449:
6450: FOR i IN (SELECT DISTINCT po_header_id
6451: FROM ap_invoice_lines
6452: WHERE invoice_id = p_invoice_id
6453: AND po_header_id is NOT NULL)
6454: LOOP
6455:

Line 6537: from ap_invoice_lines

6533:
6534: --BUG# 9868268
6535: CURSOR Matched_Shpmnts_Cur IS
6536: select distinct po_line_location_id
6537: from ap_invoice_lines
6538: where invoice_id = p_invoice_id
6539: and po_line_location_id is not null --Bug16406697
6540: and line_type_lookup_code not in ('TAX','PREPAY');
6541:

Line 6574: l_po_header_id ap_invoice_lines_all.po_header_id%TYPE;

6570: l_hold_name VARCHAR2(30);
6571: l_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
6572: l_quantity_cancelled PO_DISTRIBUTIONS_ALL.quantity_cancelled%TYPE ;
6573: l_amount_cancelled PO_DISTRIBUTIONS_ALL.amount_cancelled%TYPE ;
6574: l_po_header_id ap_invoice_lines_all.po_header_id%TYPE;
6575:
6576:
6577: BEGIN
6578:

Line 6608: ap_invoice_lines ail

6604: l_hold_required := 'N';
6605:
6606: For rec_part_funds_check in (select distinct aid.po_distribution_id
6607: from ap_invoice_distributions aid,
6608: ap_invoice_lines ail
6609: where ail.po_line_location_id =l_line_location_id
6610: and ail.invoice_id = P_INVOICE_ID
6611: and ail.invoice_id = aid.invoice_id
6612: and ail.line_number = aid.invoice_line_number