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_INVOICE_LINES_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1607: FROM ap_invoice_distributions_all -- Bug 7195488 Moac synonym replaced

1603: BEGIN
1604:
1605: SELECT nvl(max(distribution_line_number),0)
1606: INTO l_max_dist_line_num
1607: FROM ap_invoice_distributions_all -- Bug 7195488 Moac synonym replaced
1608: WHERE invoice_id = X_invoice_id
1609: AND invoice_line_number = X_line_number;
1610:
1611: RETURN(l_max_dist_line_num);

Line 1849: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;

1845:
1846: l_distribution_count NUMBER := 0;
1847: l_sum_matched_qty NUMBER := 0;
1848: l_sum_matched_amt NUMBER := 0;
1849: l_dist_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE;
1850: l_matching_basis po_line_locations_all.matching_basis%TYPE;
1851: i NUMBER := 1;
1852: l_max_line_num
1853: ap_invoice_distributions.distribution_line_number%TYPE;

Line 1925: FROM ap_invoice_distributions_all AID, --Inv dists

1921: --Added below cursor for bug#8928639
1922:
1923: CURSOR prepay_inv_cur IS
1924: SELECT distinct aid1.invoice_id,aid1.invoice_line_number
1925: FROM ap_invoice_distributions_all AID, --Inv dists
1926: ap_invoice_distributions_all AID1 --prepay dists
1927: WHERE aid.invoice_id = p_line_rec.invoice_id
1928: AND aid.invoice_line_number = p_line_rec.line_number
1929: AND aid1.invoice_distribution_id = aid.prepay_distribution_id;

Line 1926: ap_invoice_distributions_all AID1 --prepay dists

1922:
1923: CURSOR prepay_inv_cur IS
1924: SELECT distinct aid1.invoice_id,aid1.invoice_line_number
1925: FROM ap_invoice_distributions_all AID, --Inv dists
1926: ap_invoice_distributions_all AID1 --prepay dists
1927: WHERE aid.invoice_id = p_line_rec.invoice_id
1928: AND aid.invoice_line_number = p_line_rec.line_number
1929: AND aid1.invoice_distribution_id = aid.prepay_distribution_id;
1930:

Line 1946: FROM ap_invoice_distributions_all AID ,

1942: aid.line_type_lookup_code,
1943: pll.matching_basis,
1944: aid1.invoice_id prepay_invoice_id,
1945: aid1.invoice_line_number prepay_line_number
1946: FROM ap_invoice_distributions_all AID ,
1947: po_line_locations pll,
1948: ap_invoice_distributions_all AID1
1949: WHERE aid.invoice_id = p_line_rec.invoice_id
1950: AND aid.invoice_line_number = p_line_rec.line_number

Line 1948: ap_invoice_distributions_all AID1

1944: aid1.invoice_id prepay_invoice_id,
1945: aid1.invoice_line_number prepay_line_number
1946: FROM ap_invoice_distributions_all AID ,
1947: po_line_locations pll,
1948: ap_invoice_distributions_all AID1
1949: WHERE aid.invoice_id = p_line_rec.invoice_id
1950: AND aid.invoice_line_number = p_line_rec.line_number
1951: --Contract Payments: Added the 'PREPAY' to the clause
1952: AND aid.line_type_lookup_code in ('ITEM','ACCRUAL', 'IPV','ERV','PREPAY','RETAINAGE')

Line 1974: from ap_invoice_distributions_all aid

1970: AND arl.chrg_invoice_line_number = ail.line_number
1971: and ail.line_type_lookup_code IN ('FREIGHT','MISCELLANEOUS')
1972: AND exists
1973: (select aid.invoice_line_number
1974: from ap_invoice_distributions_all aid
1975: where aid.invoice_id = ail.invoice_id
1976: and aid.invoice_line_number = ail.line_number);
1977:
1978: l_chrg_line_rec ap_invoice_lines_all%rowtype;

Line 1992: ,ap_invoice_distributions_all aid

1988: 'ITEM_TO_SERVICE_PO', 0,
1989: 'ITEM_TO_SERVICE_RECEIPT', 0,
1990: NVL(AID.corrected_quantity, 0) + NVL(AID.quantity_invoiced,0))) quantity
1991: from ap_invoice_lines_all ail
1992: ,ap_invoice_distributions_all aid
1993: ,po_distributions_all pod
1994: ,po_line_locations_all pll
1995: where ail.invoice_id = p_line_rec.invoice_id
1996: and ail.line_number = p_line_rec.line_number

Line 2014: FROM ap_invoice_distributions_all aid

2010:
2011: -- bug 5572121
2012: cursor dist_debug_cur is
2013: Select *
2014: FROM ap_invoice_distributions_all aid
2015: WHERE aid.invoice_id = p_line_rec.invoice_id;
2016:
2017: --bugfix:5638822
2018: l_recouped_amount ap_invoices_all.invoice_amount%type;

Line 2042: l_award_id ap_invoice_distributions_all.award_id%TYPE;

2038: l_invoice_rec AP_APPROVAL_PKG.Invoice_Rec;
2039: l_base_currency_code AP_SYSTEM_PARAMETERS.BASE_CURRENCY_CODE%TYPE;
2040:
2041: -- Bug 8623061 - Start
2042: l_award_id ap_invoice_distributions_all.award_id%TYPE;
2043:
2044: cursor c_distribution_list_cur is
2045: SELECT *
2046: FROM ap_invoice_distributions_all aid

Line 2046: FROM ap_invoice_distributions_all aid

2042: l_award_id ap_invoice_distributions_all.award_id%TYPE;
2043:
2044: cursor c_distribution_list_cur is
2045: SELECT *
2046: FROM ap_invoice_distributions_all aid
2047: WHERE aid.parent_reversal_id IS NOT NULL
2048: AND aid.invoice_id = p_line_rec.invoice_id
2049: AND aid.invoice_line_number = p_line_rec.line_number
2050: AND aid.reversal_flag = 'Y'

Line 2244: from ap_invoice_distributions_all tax_dist,

2240: tax_dist.summary_tax_line_id summary_tax_line_id,
2241: 'N' rcv_charge_addition_flag,
2242: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount,
2243: tax_dist.pay_awt_group_id pay_awt_group_id
2244: from ap_invoice_distributions_all tax_dist,
2245: ap_invoice_distributions_all item_dist,
2246: zx_rec_nrec_dist zx_dist
2247: where tax_dist.invoice_id = c_invoice_id
2248: and tax_dist.invoice_id = zx_dist.trx_id

Line 2245: ap_invoice_distributions_all item_dist,

2241: 'N' rcv_charge_addition_flag,
2242: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount,
2243: tax_dist.pay_awt_group_id pay_awt_group_id
2244: from ap_invoice_distributions_all tax_dist,
2245: ap_invoice_distributions_all item_dist,
2246: zx_rec_nrec_dist zx_dist
2247: where tax_dist.invoice_id = c_invoice_id
2248: and tax_dist.invoice_id = zx_dist.trx_id
2249: and zx_dist.application_id = 200

Line 2453: ap_invoice_distributions_all item_dist,

2449: zx_dist.self_assessed_flag self_assessed_flag,
2450: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
2451: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount
2452: from ap_self_assessed_tax_dist_all tax_dist,
2453: ap_invoice_distributions_all item_dist,
2454: zx_rec_nrec_dist zx_dist
2455: where tax_dist.invoice_id = c_invoice_id
2456: and tax_dist.invoice_id = zx_dist.trx_id
2457: and zx_dist.application_id = 200

Line 2727: FROM ap_invoice_distributions_all aid

2723:
2724: l_itm_dist_count := 0;
2725: -- query to get the Distributions for that standard invoice
2726: SELECT COUNT(*) INTO l_itm_dist_count
2727: FROM ap_invoice_distributions_all aid
2728: WHERE aid.invoice_id = p_line_rec.invoice_id
2729: AND aid.prepay_distribution_id is not null
2730: AND NOT EXISTS (SELECT 1
2731: FROM ap_invoice_distributions_all item

Line 2731: FROM ap_invoice_distributions_all item

2727: FROM ap_invoice_distributions_all aid
2728: WHERE aid.invoice_id = p_line_rec.invoice_id
2729: AND aid.prepay_distribution_id is not null
2730: AND NOT EXISTS (SELECT 1
2731: FROM ap_invoice_distributions_all item
2732: WHERE item.invoice_id = p_line_rec.invoice_id
2733: AND item.prepay_distribution_id is null)
2734: AND ROWNUM =1;
2735:

Line 2904: l_debug_info := 'Inserting reverse entries into ap_invoice_distributions_all after line discard';

2900:
2901: IF l_reverse_dist_count>0 THEN
2902:
2903: ---------------------------------------------------------------------------------------------------
2904: l_debug_info := 'Inserting reverse entries into ap_invoice_distributions_all after line discard';
2905: Print (l_api_name,l_debug_info);
2906: ---------------------------------------------------------------------------------------------------
2907: OPEN c_reverse_tax_dist_1(l_chrg_line_rec.invoice_id,
2908: l_chrg_line_rec.line_number);

Line 2914: INSERT INTO ap_invoice_distributions_all (

2910: FETCH c_reverse_tax_dist_1
2911: INTO l_reverse_tax_dist;
2912: EXIT WHEN c_reverse_tax_dist_1%NOTFOUND;
2913:
2914: INSERT INTO ap_invoice_distributions_all (
2915: accounting_date,
2916: accrual_posted_flag,
2917: assets_addition_flag,
2918: assets_tracking_flag,

Line 3625: UPDATE ap_invoice_distributions_all aid

3621: l_debug_info := 'Update reversal_flag';
3622: Print (l_api_name,l_debug_info);
3623: -----------------------------------------------------------------
3624:
3625: UPDATE ap_invoice_distributions_all aid
3626: SET reversal_flag = (select reverse_flag
3627: from zx_rec_nrec_dist zx
3628: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
3629: WHERE aid.invoice_id = p_line_rec.invoice_id

Line 3640: FROM ap_invoice_distributions_all aid1

3636:
3637: UPDATE ap_invoice_distributions aid
3638: SET aid.related_id =
3639: (SELECT invoice_distribution_id
3640: FROM ap_invoice_distributions_all aid1
3641: WHERE aid1.invoice_id = aid.invoice_id
3642: AND aid1.invoice_line_number = aid.invoice_line_number
3643: AND aid1.parent_reversal_id =
3644: (SELECT related_id

Line 3645: FROM ap_invoice_distributions_all aid2

3641: WHERE aid1.invoice_id = aid.invoice_id
3642: AND aid1.invoice_line_number = aid.invoice_line_number
3643: AND aid1.parent_reversal_id =
3644: (SELECT related_id
3645: FROM ap_invoice_distributions_all aid2
3646: WHERE aid2.invoice_id = aid.invoice_id
3647: AND aid2.invoice_line_number = aid.invoice_line_number
3648: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
3649: )

Line 4198: FROM ap_invoice_distributions_all

4194: --Prepay distributions , but not the TAX related to ITEM dists, since DETERMINE_RECOVERY
4195: --will take care of the TAX on ITEM dists.
4196: SELECT count(*)
4197: INTO l_distribution_count
4198: FROM ap_invoice_distributions_all
4199: WHERE invoice_id = p_line_rec.invoice_id
4200: AND invoice_line_number = p_line_rec.line_number
4201: AND ((line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV') and
4202: prepay_distribution_id IS NULL) OR

Line 4261: INSERT INTO ap_invoice_distributions_all(

4257: --consideration 'Prepay' and its related Tax distributions.
4258:
4259: -- Removed the below HAVING clause, for the 7376114, to allow zero amount ITEM lines to be reversed.
4260:
4261: INSERT INTO ap_invoice_distributions_all(
4262: invoice_id,
4263: invoice_line_number,
4264: dist_code_combination_id,
4265: invoice_distribution_id,

Line 4580: FROM ap_invoice_distributions_all

4576: awt_related_id, -- Bug 8745752
4577: retained_invoice_dist_id, -- Bug 8824235
4578: pay_awt_group_id, /* Bug 9821980 */
4579: 'N' /*Bug#11067286*/
4580: FROM ap_invoice_distributions_all
4581: WHERE invoice_id = p_line_rec.invoice_id
4582: AND invoice_line_number = p_line_rec.line_number
4583: AND line_type_lookup_code NOT IN
4584: ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')

Line 4589: FROM ap_invoice_distributions_all

4585: AND (line_type_lookup_code <> 'AWT' OR
4586: (line_type_lookup_code = 'AWT' AND awt_flag <> 'A'))
4587: AND dist_code_combination_id
4588: IN (SELECT dist_code_combination_id
4589: FROM ap_invoice_distributions_all
4590: WHERE invoice_id = p_line_rec.invoice_id
4591: AND invoice_line_number = p_line_rec.line_number
4592: GROUP BY dist_code_combination_id,
4593: po_distribution_id,

Line 4609: FROM ap_invoice_distributions_all

4605: rcv_transaction_id) -- Bug 4159731
4606: AND nvl(po_distribution_id,-99) IN
4607: (SELECT
4608: NVL(po_distribution_id, -99)
4609: FROM ap_invoice_distributions_all
4610: WHERE invoice_id = p_line_rec.invoice_id
4611: AND invoice_line_number = p_line_rec.line_number
4612: GROUP BY dist_code_combination_id,
4613: po_distribution_id,

Line 4652: UPDATE ap_invoice_distributions_all aid

4648: AND aid.invoice_line_number = p_line_rec.line_number
4649: AND aid.reversal_flag = 'Y';
4650:
4651: -- Updating Retained_Amount_Remaining 8824235
4652: UPDATE ap_invoice_distributions_all aid
4653: SET aid.retained_amount_remaining = aid.retained_amount_remaining -
4654: NVL((SELECT sum(d2.amount)
4655: FROM ap_invoice_distributions_all d2
4656: WHERE d2.parent_reversal_id is not null

Line 4655: FROM ap_invoice_distributions_all d2

4651: -- Updating Retained_Amount_Remaining 8824235
4652: UPDATE ap_invoice_distributions_all aid
4653: SET aid.retained_amount_remaining = aid.retained_amount_remaining -
4654: NVL((SELECT sum(d2.amount)
4655: FROM ap_invoice_distributions_all d2
4656: WHERE d2.parent_reversal_id is not null
4657: AND d2.reversal_flag = 'Y'
4658: AND d2.invoice_id = p_line_rec.invoice_id
4659: AND d2.invoice_line_number = p_line_rec.line_number

Line 4664: FROM ap_invoice_distributions_all d3

4660: AND d2.match_status_flag = 'N'
4661: AND d2.retained_invoice_dist_id = aid.invoice_distribution_id), 0)
4662: WHERE invoice_distribution_id in
4663: (SELECT DISTINCT retained_invoice_dist_id
4664: FROM ap_invoice_distributions_all d3
4665: WHERE d3.reversal_flag = 'Y'
4666: AND d3.invoice_id = p_line_rec.invoice_id
4667: AND d3.invoice_line_number = p_line_rec.line_number
4668: AND d3.parent_reversal_id is not null

Line 4851: FROM ap_invoice_distributions_all aid1,

4847: --Bug 7526679
4848: -- The query is modified to select the total amount of latest reversed tax distributions.
4849: SELECT sum(aid1.amount)
4850: INTO l_unapplied_tax_amount
4851: FROM ap_invoice_distributions_all aid1,
4852: ap_invoice_distributions_all aid2
4853: WHERE aid1.invoice_id = p_line_rec.invoice_id
4854: AND aid1.invoice_id = aid2.invoice_id
4855: AND aid1.invoice_line_number = l_tax_line_number(l_loop_counter) /*Bug 9841966: added loop counter*/

Line 4852: ap_invoice_distributions_all aid2

4848: -- The query is modified to select the total amount of latest reversed tax distributions.
4849: SELECT sum(aid1.amount)
4850: INTO l_unapplied_tax_amount
4851: FROM ap_invoice_distributions_all aid1,
4852: ap_invoice_distributions_all aid2
4853: WHERE aid1.invoice_id = p_line_rec.invoice_id
4854: AND aid1.invoice_id = aid2.invoice_id
4855: AND aid1.invoice_line_number = l_tax_line_number(l_loop_counter) /*Bug 9841966: added loop counter*/
4856: AND aid2.invoice_line_number = p_line_rec.line_number

Line 5130: INSERT INTO ap_invoice_distributions_all(

5126: l_debug_info := 'Insert reverse charge distributions';
5127: Print (l_api_name,l_debug_info);
5128: ------------------------------------------------------
5129:
5130: INSERT INTO ap_invoice_distributions_all(
5131: invoice_id,
5132: invoice_line_number,
5133: dist_code_combination_id,
5134: invoice_distribution_id,

Line 5425: FROM ap_invoice_distributions_all

5421: intended_use, -- intended_use
5422: 'N', -- rcv_charge_addition_flag
5423: pay_awt_group_id, /* Bug 9821980 */
5424: 'Y'
5425: FROM ap_invoice_distributions_all
5426: WHERE invoice_id = p_inv_line_rec.invoice_id
5427: AND invoice_line_number = p_inv_line_rec.line_number
5428: AND (reversal_flag is null
5429: or reversal_flag = 'N')

Line 5516: from ap_invoice_distributions_all item_dist,

5512: zx_dist.trx_level_type reversed_trx_level_type,
5513: zx_dist.trx_line_id reversed_trx_line_id,
5514: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
5515: zx_dist.tax_line_id reversed_tax_line_id
5516: from ap_invoice_distributions_all item_dist,
5517: ap_invoice_distributions_all tax_dist,
5518: ap_invoice_distributions_all reverse_dist,
5519: zx_rec_nrec_dist zx_dist
5520: where tax_dist.invoice_id = p_inv_line_rec.invoice_id

Line 5517: ap_invoice_distributions_all tax_dist,

5513: zx_dist.trx_line_id reversed_trx_line_id,
5514: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
5515: zx_dist.tax_line_id reversed_tax_line_id
5516: from ap_invoice_distributions_all item_dist,
5517: ap_invoice_distributions_all tax_dist,
5518: ap_invoice_distributions_all reverse_dist,
5519: zx_rec_nrec_dist zx_dist
5520: where tax_dist.invoice_id = p_inv_line_rec.invoice_id
5521: and tax_dist.invoice_id = item_dist.invoice_id

Line 5518: ap_invoice_distributions_all reverse_dist,

5514: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
5515: zx_dist.tax_line_id reversed_tax_line_id
5516: from ap_invoice_distributions_all item_dist,
5517: ap_invoice_distributions_all tax_dist,
5518: ap_invoice_distributions_all reverse_dist,
5519: zx_rec_nrec_dist zx_dist
5520: where tax_dist.invoice_id = p_inv_line_rec.invoice_id
5521: and tax_dist.invoice_id = item_dist.invoice_id
5522: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 5579: from ap_invoice_distributions_all item_dist,

5575: zx_dist.trx_level_type reversed_trx_level_type,
5576: zx_dist.trx_line_id reversed_trx_line_id,
5577: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
5578: zx_dist.tax_line_id reversed_tax_line_id
5579: from ap_invoice_distributions_all item_dist,
5580: ap_self_assessed_tax_dist_all tax_dist,
5581: ap_invoice_distributions_all reverse_dist,
5582: zx_rec_nrec_dist zx_dist
5583: where tax_dist.invoice_id = p_inv_line_rec.invoice_id

Line 5581: ap_invoice_distributions_all reverse_dist,

5577: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
5578: zx_dist.tax_line_id reversed_tax_line_id
5579: from ap_invoice_distributions_all item_dist,
5580: ap_self_assessed_tax_dist_all tax_dist,
5581: ap_invoice_distributions_all reverse_dist,
5582: zx_rec_nrec_dist zx_dist
5583: where tax_dist.invoice_id = p_inv_line_rec.invoice_id
5584: and tax_dist.invoice_id = item_dist.invoice_id
5585: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 5640: FROM ap_invoice_distributions_all item_dist,

5636: --------------------------------------------------------------------------------------------
5637:
5638: SELECT 'Tax Distributions Exist'
5639: INTO l_dummy
5640: FROM ap_invoice_distributions_all item_dist,
5641: ap_invoice_distributions_all tax_dist
5642: WHERE tax_dist.invoice_id = p_invoice_id
5643: and tax_dist.invoice_id = item_dist.invoice_id
5644: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id

Line 5641: ap_invoice_distributions_all tax_dist

5637:
5638: SELECT 'Tax Distributions Exist'
5639: INTO l_dummy
5640: FROM ap_invoice_distributions_all item_dist,
5641: ap_invoice_distributions_all tax_dist
5642: WHERE tax_dist.invoice_id = p_invoice_id
5643: and tax_dist.invoice_id = item_dist.invoice_id
5644: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
5645: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX', 'TIPV', 'TRV', 'TERV')