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 397: FROM ap_invoice_lines ail

393:
394: BEGIN
395: SELECT ail.rcv_transaction_id
396: INTO l_rcv_transaction_id
397: FROM ap_invoice_lines ail
398: WHERE ail.invoice_id = p_invoice_id
399: AND ail.line_number = p_inv_line_number;
400: EXCEPTION
401: WHEN NO_DATA_FOUND THEN NULL;

Line 675: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

671: END IF;
672:
673: l_related_id := l_invoice_distribution_id;
674:
675: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
676: p_invoice_id,
677: p_inv_line_number) + 1;
678:
679: INSERT INTO ap_invoice_distributions (

Line 921: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(

917: END IF;
918:
919: l_related_id := l_invoice_distribution_id;
920:
921: l_max_dist_line_number := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
922: p_invoice_id,
923: p_inv_line_number) + 1;
924:
925: INSERT INTO ap_invoice_distributions (

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

1875: CURSOR Matched_Cur IS
1876: SELECT PLL.line_location_id,
1877: PLL.po_line_id,
1878: SUM(L.amount),
1879: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N'),
1880: --bug 5182413
1881: SUM(nvl(L.quantity_invoiced,0)),
1882: PLL.price_override, -- BUG 4123171
1883: ROUND((nvl(PLL.quantity,0) - nvl(PLL.quantity_cancelled,0)), 15),

Line 1918: ap_invoice_lines L,

1914: I.org_id -- Bug 5500101
1915: FROM po_lines PL,
1916: rcv_transactions RTXN,
1917: rcv_shipment_lines RSL,
1918: ap_invoice_lines L,
1919: ap_invoices I,
1920: po_line_locations PLL,
1921: po_headers PH,
1922: po_releases PR

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

1979: decode(PLL.unit_meas_lookup_code,null,PL.unit_meas_lookup_code,PLL.unit_meas_lookup_code), -- BUG 4184044
1980: L.discarded_flag,L.cancelled_flag,
1981: PLL.matching_basis,PLL.payment_type,I.invoice_type_lookup_code,
1982: I.org_id,
1983: NVL(AP_INVOICE_LINES_UTILITY_PKG.get_approval_status(p_invoice_id,L.line_number),'N');-- Bug 5182413
1984: l_line_location_id NUMBER(15);
1985: l_po_line_id NUMBER(15);
1986: l_inv_line_amount NUMBER;
1987: l_adj_qty_invoiced NUMBER;

Line 2060: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;

2056: l_billed_amount_used NUMBER;
2057: l_txn_uom VARCHAR2(25);
2058: l_po_uom VARCHAR2(25);
2059: l_item_id NUMBER;
2060: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
2061: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2062: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2063:
2064: --Contract Payments: Tolerances Redesign

Line 2061: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;

2057: l_txn_uom VARCHAR2(25);
2058: l_po_uom VARCHAR2(25);
2059: l_item_id NUMBER;
2060: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
2061: l_cancelled_flag ap_invoice_lines.cancelled_flag%TYPE;
2062: l_matching_basis po_line_locations.matching_basis%TYPE; -- Amount Based Matching
2063:
2064: --Contract Payments: Tolerances Redesign
2065: l_invoice_type_lookup_code ap_invoices_all.invoice_type_lookup_code%TYPE;

Line 3530: UPDATE ap_invoice_lines AIL

3526: (SELECT PD.po_distribution_id
3527: FROM po_distributions_ap_v PD
3528: WHERE line_location_id = p_line_location_id);
3529:
3530: UPDATE ap_invoice_lines AIL
3531: SET final_match_flag = p_final_match_flag
3532: WHERE AIL.po_line_location_id = p_line_location_id
3533: AND AIL.invoice_id=p_invoice_id;--bug5759169
3534:

Line 4115: ap_invoice_lines ail

4111: BEGIN
4112: SELECT count(*)
4113: INTO l_rec_exception_count
4114: FROM rcv_transactions rt,
4115: ap_invoice_lines ail
4116: WHERE rt.receipt_exception_flag = 'Y'
4117: AND rt.transaction_type = 'RECEIVE'
4118: AND rt.po_line_location_id = ail.po_line_location_id
4119: AND ail.po_line_location_id = p_line_location_id

Line 4232: FROM ap_invoice_lines AIL

4228: +-----------------------------------------------------------------*/
4229:
4230: CURSOR corrected_invoices IS
4231: SELECT distinct corrected_inv_id
4232: FROM ap_invoice_lines AIL
4233: WHERE AIL.invoice_id = p_invoice_id
4234: AND ( ( AIL.po_line_location_id is not null and
4235: AIL.po_line_location_id = p_line_location_id )
4236: OR( AIL.rcv_transaction_id is not null and

Line 4262: FROM ap_invoice_lines AIL

4258: +------------------------------------------------------------------*/
4259:
4260: SELECT count(*)
4261: INTO l_correction_count
4262: FROM ap_invoice_lines AIL
4263: WHERE AIL.invoice_id = p_invoice_id
4264: AND po_line_location_id = p_line_location_id
4265: AND corrected_inv_id is not null
4266: AND corrected_inv_id <> p_invoice_id;

Line 4462: FROM ap_invoice_lines AIL

4458: sum( decode( AIL.match_type, 'PRICE_CORRECTION', 0,
4459: nvl(AIL.quantity_invoiced,0)) )
4460: INTO l_sum_pc_inv_amount,
4461: l_sum_qty_invoiced
4462: FROM ap_invoice_lines AIL
4463: WHERE AIL.po_line_location_id = p_line_location_id
4464: AND ( AIL.corrected_inv_id = p_invoice_id
4465: OR (AIL.invoice_id = p_invoice_id and
4466: AIL.corrected_inv_id is null) )

Line 4530: FROM ap_invoice_lines AIL

4526: )
4527: )
4528: INTO l_sum_pc_inv_amount,
4529: l_sum_qty_invoiced
4530: FROM ap_invoice_lines AIL
4531: WHERE AIL.po_line_location_id = p_line_location_id
4532: AND ( AIL.corrected_inv_id = p_invoice_id
4533: OR (AIL.invoice_id = p_invoice_id and
4534: AIL.corrected_inv_id is null) )

Line 4756: FROM ap_invoice_lines L

4752:
4753:
4754: SELECT nvl(trunc(sum(quantity_invoiced),5),0) --7021414
4755: INTO p_qty_billed
4756: FROM ap_invoice_lines L
4757: WHERE L.po_line_location_id = p_line_location_id
4758: AND ( (L.invoice_id = p_invoice_id and
4759: L.match_type = 'ITEM_TO_PO' ) -- query condition 1
4760: or (L.corrected_inv_id = p_invoice_id and

Line 4764: FROM ap_invoice_lines L2

4760: or (L.corrected_inv_id = p_invoice_id and
4761: L.match_type = 'QTY_CORRECTION') -- query condition 2
4762: or (L.invoice_id IN
4763: ( SELECT corrected_inv_id
4764: FROM ap_invoice_lines L2
4765: WHERE L2.invoice_id = p_invoice_id
4766: AND L2.po_line_location_id = p_line_location_id
4767: AND L2.match_type = 'QTY_CORRECTION') and
4768: L.match_type = 'ITEM_TO_PO' ) -- query condition 3

Line 4771: FROM ap_invoice_lines L3

4767: AND L2.match_type = 'QTY_CORRECTION') and
4768: L.match_type = 'ITEM_TO_PO' ) -- query condition 3
4769: or ( L.corrected_inv_id IN
4770: ( SELECT corrected_inv_id
4771: FROM ap_invoice_lines L3
4772: WHERE L3.invoice_id = p_invoice_id
4773: AND L3.po_line_location_id = p_line_location_id
4774: AND L3.match_type = 'QTY_CORRECTION') and
4775: L.match_type = 'QTY_CORRECTION' ) ) -- query condition 4

Line 4784: FROM ap_invoice_lines L

4780:
4781:
4782: SELECT nvl(trunc(sum(quantity_invoiced),5),0)
4783: INTO p_qty_billed
4784: FROM ap_invoice_lines L
4785: WHERE L.po_line_location_id = p_line_location_id
4786: AND ( (L.invoice_id = p_invoice_id and
4787: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 1
4788: or (L.corrected_inv_id = p_invoice_id and

Line 4792: FROM ap_invoice_lines L2

4788: or (L.corrected_inv_id = p_invoice_id and
4789: L.match_type = 'QTY_CORRECTION') -- query condition 2
4790: or (L.invoice_id IN
4791: ( SELECT corrected_inv_id
4792: FROM ap_invoice_lines L2
4793: WHERE L2.invoice_id = p_invoice_id
4794: AND L2.po_line_location_id = p_line_location_id
4795: AND L2.match_type = 'QTY_CORRECTION') and
4796: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3

Line 4799: FROM ap_invoice_lines L3

4795: AND L2.match_type = 'QTY_CORRECTION') and
4796: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3
4797: or (L.corrected_inv_id IN
4798: ( SELECT corrected_inv_id
4799: FROM ap_invoice_lines L3
4800: WHERE L3.invoice_id = p_invoice_id
4801: AND L3.po_line_location_id = p_line_location_id
4802: AND L3.match_type = 'QTY_CORRECTION') and
4803: L.match_type = 'QTY_CORRECTION' ) ) -- query condition 4

Line 4995: FROM ap_invoice_lines L

4991:
4992:
4993: SELECT trunc(sum(amount),5)
4994: INTO p_amt_billed
4995: FROM ap_invoice_lines L
4996: WHERE L.po_line_location_id = p_line_location_id
4997: AND ( (L.invoice_id = p_invoice_id and
4998: L.match_type = 'ITEM_TO_PO' ) -- query condition 1
4999: or (L.corrected_inv_id = p_invoice_id and

Line 5003: FROM ap_invoice_lines L2

4999: or (L.corrected_inv_id = p_invoice_id and
5000: L.match_type = 'AMOUNT_CORRECTION') -- query condition 2
5001: or (L.invoice_id IN
5002: ( SELECT corrected_inv_id
5003: FROM ap_invoice_lines L2
5004: WHERE L2.invoice_id = p_invoice_id
5005: AND L2.po_line_location_id = p_line_location_id
5006: AND L2.match_type = 'AMOUNT_CORRECTION') and
5007: L.match_type = 'ITEM_TO_PO' ) -- query condition 3

Line 5010: FROM ap_invoice_lines L3

5006: AND L2.match_type = 'AMOUNT_CORRECTION') and
5007: L.match_type = 'ITEM_TO_PO' ) -- query condition 3
5008: or ( L.corrected_inv_id IN
5009: ( SELECT corrected_inv_id
5010: FROM ap_invoice_lines L3
5011: WHERE L3.invoice_id = p_invoice_id
5012: AND L3.po_line_location_id = p_line_location_id
5013: AND L3.match_type = 'AMOUNT_CORRECTION') and
5014: L.match_type = 'AMOUNT_CORRECTION' ) ); -- query condition 4

Line 5022: FROM ap_invoice_lines L

5018:
5019:
5020: SELECT trunc(sum(amount),5)
5021: INTO p_amt_billed
5022: FROM ap_invoice_lines L
5023: WHERE L.po_line_location_id = p_line_location_id
5024: AND ( (L.invoice_id = p_invoice_id and
5025: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 1
5026: or (L.corrected_inv_id = p_invoice_id and

Line 5030: FROM ap_invoice_lines L2

5026: or (L.corrected_inv_id = p_invoice_id and
5027: L.match_type = 'AMOUNT_CORRECTION') -- query condition 2
5028: or (L.invoice_id IN
5029: ( SELECT corrected_inv_id
5030: FROM ap_invoice_lines L2
5031: WHERE L2.invoice_id = p_invoice_id
5032: AND L2.po_line_location_id = p_line_location_id
5033: AND L2.match_type = 'AMOUNT_CORRECTION') and
5034: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3

Line 5037: FROM ap_invoice_lines L3

5033: AND L2.match_type = 'AMOUNT_CORRECTION') and
5034: L.match_type = 'ITEM_TO_RECEIPT' ) -- query condition 3
5035: or (L.corrected_inv_id IN
5036: ( SELECT corrected_inv_id
5037: FROM ap_invoice_lines L3
5038: WHERE L3.invoice_id = p_invoice_id
5039: AND L3.po_line_location_id = p_line_location_id
5040: AND L3.match_type = 'AMOUNT_CORRECTION') and
5041: L.match_type = 'AMOUNT_CORRECTION' ) ); -- query condition 4

Line 5310: FROM ap_invoice_lines L

5306: END IF;
5307:
5308: SELECT sum( NVL(L.amount, 0) )
5309: INTO p_ship_trx_amt
5310: FROM ap_invoice_lines L
5311: WHERE L.po_line_location_id = p_line_location_id
5312: AND ( (L.invoice_id = p_invoice_id and
5313: L.match_type IN ('ITEM_TO_PO', -- query condition 1
5314: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching

Line 5318: FROM ap_invoice_lines L2

5314: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5315: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5316: or (L.invoice_id IN
5317: ( SELECT corrected_inv_id
5318: FROM ap_invoice_lines L2
5319: WHERE L2.po_line_location_id = p_line_location_id
5320: AND L2.invoice_id = p_invoice_id
5321: AND L2.corrected_inv_id is not null ) and
5322: L.match_type IN ('ITEM_TO_PO', -- query condition 3

Line 5326: FROM ap_invoice_lines L3

5322: L.match_type IN ('ITEM_TO_PO', -- query condition 3
5323: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5324: or (L.corrected_inv_id IN
5325: ( SELECT corrected_inv_id
5326: FROM ap_invoice_lines L3
5327: WHERE L3.po_line_location_id = p_line_location_id
5328: AND L3.invoice_id = p_invoice_id
5329: AND L3.corrected_inv_id is not null ) ) );
5330: -- query condition 4

Line 5344: FROM ap_invoice_lines L

5340: END IF;
5341:
5342: SELECT sum(NVL(L.amount, 0))
5343: INTO p_ship_trx_amt
5344: FROM ap_invoice_lines L
5345: WHERE L.po_line_location_id = p_line_location_id
5346: AND ( (L.invoice_id = p_invoice_id and
5347: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 1
5348: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching

Line 5352: FROM ap_invoice_lines L2

5348: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
5349: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5350: or (L.invoice_id IN
5351: ( SELECT corrected_inv_id
5352: FROM ap_invoice_lines L2
5353: WHERE L2.po_line_location_id = p_line_location_id
5354: AND L2.invoice_id = p_invoice_id
5355: AND L2.corrected_inv_id is not null ) and
5356: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3

Line 5360: FROM ap_invoice_lines L3

5356: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3
5357: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
5358: or (L.corrected_inv_id IN
5359: ( SELECT corrected_inv_id
5360: FROM ap_invoice_lines L3
5361: WHERE L3.po_line_location_id = p_line_location_id
5362: AND L3.invoice_id = p_invoice_id
5363: AND L3.corrected_inv_id is not null ) ) );
5364: -- query condition 4

Line 5605: , ap_invoice_lines L --Bug6824860

5601: INTO p_ship_base_amt_var
5602: FROM ap_invoice_distributions D
5603: , po_distributions_ap_v PD
5604: , ap_invoices I
5605: , ap_invoice_lines L --Bug6824860
5606: WHERE D.po_distribution_id = PD.po_distribution_id
5607: AND PD.line_location_id = p_line_location_id
5608: AND D.invoice_id = I.invoice_id
5609: AND L.invoice_id = I.invoice_id --Bug6824860

Line 5715: FROM ap_invoice_lines L,

5711: ,nvl(L.amount,0)
5712: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
5713: )
5714: INTO p_ship_base_amt
5715: FROM ap_invoice_lines L,
5716: ap_invoices AI
5717: WHERE AI.invoice_id = L.invoice_id
5718: AND L.po_line_location_id = p_line_location_id
5719: AND ( (L.invoice_id = p_invoice_id and

Line 5725: FROM ap_invoice_lines L2

5721: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5722: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5723: or (L.invoice_id IN
5724: ( SELECT corrected_inv_id
5725: FROM ap_invoice_lines L2
5726: WHERE L2.po_line_location_id = p_line_location_id
5727: AND L2.invoice_id = p_invoice_id
5728: AND L2.corrected_inv_id is not null ) and
5729: L.match_type IN ('ITEM_TO_PO', -- query condition 3

Line 5733: FROM ap_invoice_lines L3

5729: L.match_type IN ('ITEM_TO_PO', -- query condition 3
5730: 'ITEM_TO_SERVICE_PO')) -- Amount Based Matching
5731: or (L.corrected_inv_id IN
5732: ( SELECT corrected_inv_id
5733: FROM ap_invoice_lines L3
5734: WHERE L3.po_line_location_id = p_line_location_id
5735: AND L3.invoice_id = p_invoice_id
5736: AND L3.corrected_inv_id is not null ) ) );
5737: -- query condition 4

Line 5755: FROM ap_invoice_lines L,

5751: ,nvl(L.amount,0)
5752: ,nvl(L.base_amount, (L.amount * AI.exchange_rate )) )
5753: )
5754: INTO p_ship_base_amt
5755: FROM ap_invoice_lines L,
5756: ap_invoices AI
5757: WHERE AI.invoice_id = L.invoice_id
5758: AND L.po_line_location_id = p_line_location_id
5759: AND ( (L.invoice_id = p_invoice_id and

Line 5765: FROM ap_invoice_lines L2

5761: 'ITEM_TO_SERVICE_RECEIPT')) -- Amount Based Matching
5762: or (L.corrected_inv_id = p_invoice_id ) -- query condition 2
5763: or (L.invoice_id IN
5764: ( SELECT corrected_inv_id
5765: FROM ap_invoice_lines L2
5766: WHERE L2.po_line_location_id = p_line_location_id
5767: AND L2.invoice_id = p_invoice_id
5768: AND L2.corrected_inv_id is not null ) and
5769: L.match_type IN ('ITEM_TO_RECEIPT', -- query condition 3

Line 5773: FROM ap_invoice_lines L3

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

Line 5813: FROM ap_invoice_lines_all

5809:
5810: BEGIN
5811: SELECT 'Price Difference or Quantity Has Decimals'
5812: INTO l_check
5813: FROM ap_invoice_lines_all
5814: WHERE invoice_id = p_invoice_id
5815: AND po_line_location_id = p_line_location_id
5816: AND (unit_price <> p_po_unit_price OR
5817: quantity_invoiced <> trunc(quantity_invoiced));

Line 5873: FROM ap_invoice_lines

5869:
5870: Print_Debug(l_debug_loc, 'exec_pay_when_paid_check - begin for invoice_id : '|| p_invoice_id);
5871:
5872: FOR i IN (SELECT DISTINCT po_header_id
5873: FROM ap_invoice_lines
5874: WHERE invoice_id = p_invoice_id
5875: AND po_header_id is NOT NULL)
5876: LOOP
5877:

Line 5952: FROM ap_invoice_lines

5948:
5949: Print_Debug(l_debug_loc,'exec_po_deliverable_check - begin for invoice_id : '|| p_invoice_id);
5950:
5951: FOR i IN (SELECT DISTINCT po_header_id
5952: FROM ap_invoice_lines
5953: WHERE invoice_id = p_invoice_id
5954: AND po_header_id is NOT NULL)
5955: LOOP
5956: