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_SELF_ASSESSED_TAX_DIST_ALL

Line 2452: from ap_self_assessed_tax_dist_all tax_dist,

2448: 'N' rcv_charge_addition_flag,
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

Line 2472: FROM ap_self_assessed_tax_dist_all aid

2468: and zx_dist.reverse_flag = 'Y'
2469:
2470: AND NOT EXISTS
2471: (SELECT aid.detail_tax_dist_id
2472: FROM ap_self_assessed_tax_dist_all aid
2473: WHERE aid.invoice_id = c_invoice_id
2474: AND aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
2475: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
2476: ;

Line 3243: l_debug_info := 'Inserting reverse entries into ap_self_assessed_tax_dist_all';

3239:
3240: IF l_sa_reverse_dist_count>0 THEN
3241:
3242: ----------------------------------------------------------------------------
3243: l_debug_info := 'Inserting reverse entries into ap_self_assessed_tax_dist_all';
3244: Print (l_api_name,l_debug_info);
3245: ----------------------------------------------------------------------------
3246: OPEN c_rev_self_assess_tax_dist_1(l_chrg_line_rec.invoice_id,
3247: l_chrg_line_rec.line_number);

Line 3253: INSERT INTO ap_self_assessed_tax_dist_all (

3249: FETCH c_rev_self_assess_tax_dist_1
3250: INTO l_self_assess_rev_tax_dist_1;
3251: EXIT WHEN c_rev_self_assess_tax_dist_1%NOTFOUND;
3252:
3253: INSERT INTO ap_self_assessed_tax_dist_all (
3254: accounting_date,
3255: accrual_posted_flag,
3256: assets_addition_flag,
3257: assets_tracking_flag,

Line 3665: UPDATE ap_self_assessed_tax_dist_all aid

3661: l_debug_info := 'Update reversal_flag';
3662: Print (l_api_name,l_debug_info);
3663: -----------------------------------------------------------------
3664:
3665: UPDATE ap_self_assessed_tax_dist_all aid
3666: SET reversal_flag = (select reverse_flag
3667: from zx_rec_nrec_dist zx
3668: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
3669: WHERE aid.invoice_id = p_line_rec.invoice_id

Line 3677: UPDATE ap_self_assessed_tax_dist_all aid

3673: l_debug_info := 'Update related_flag';
3674: Print (l_api_name,l_debug_info);
3675: -----------------------------------------------------------------
3676:
3677: UPDATE ap_self_assessed_tax_dist_all aid
3678: SET aid.related_id =
3679: (SELECT invoice_distribution_id
3680: FROM ap_self_assessed_tax_dist_all aid1
3681: WHERE aid1.invoice_id = aid.invoice_id

Line 3680: FROM ap_self_assessed_tax_dist_all aid1

3676:
3677: UPDATE ap_self_assessed_tax_dist_all aid
3678: SET aid.related_id =
3679: (SELECT invoice_distribution_id
3680: FROM ap_self_assessed_tax_dist_all aid1
3681: WHERE aid1.invoice_id = aid.invoice_id
3682: AND aid1.invoice_line_number = aid.invoice_line_number
3683: AND aid1.parent_reversal_id =
3684: (SELECT related_id

Line 3685: FROM ap_self_assessed_tax_dist_all aid2

3681: WHERE aid1.invoice_id = aid.invoice_id
3682: AND aid1.invoice_line_number = aid.invoice_line_number
3683: AND aid1.parent_reversal_id =
3684: (SELECT related_id
3685: FROM ap_self_assessed_tax_dist_all aid2
3686: WHERE aid2.invoice_id = aid.invoice_id
3687: AND aid2.invoice_line_number = aid.invoice_line_number
3688: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
3689: )

Line 5580: ap_self_assessed_tax_dist_all tax_dist,

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
5584: and tax_dist.invoice_id = item_dist.invoice_id

Line 5678: FROM ap_self_assessed_tax_dist_all asat,

5674: --------------------------------------------------------------------------------------------
5675:
5676: SELECT ' self assess Tax Distributions Exist'
5677: INTO l_dummy
5678: FROM ap_self_assessed_tax_dist_all asat,
5679: zx_rec_nrec_dist zx_dist
5680: WHERE asat.invoice_id = p_invoice_id
5681: AND asat.invoice_line_number = p_line_number
5682: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id