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_WITHHOLDING_PKG dependencies on AP_TAX_CODES

Line 98: ap_tax_codes_all TC,

94: , aatd.checkrun_id
95: , TC.description --Bug5502917
96: FROM ap_awt_temp_distributions_all AATD,
97: ap_invoices_all AI,
98: ap_tax_codes_all TC,
99: ap_invoice_distributions_all AID --bug 7930936
100: WHERE AATD.invoice_id = InvId
101: AND AATD.group_id = GRP_ID
102: AND AATD.invoice_id = AI.invoice_id

Line 157: ap_tax_codes_all TC,

153: , SUM(AATD.base_withholding_amount) BASE_AMOUNT
154: , MIN(AATD.accounting_date) ACCOUNTING_DATE
155: FROM ap_awt_temp_distributions_all AATD,
156: ap_invoices_all AI,
157: ap_tax_codes_all TC,
158: ap_invoice_distributions_all AID --bug 7930936
159: WHERE AATD.invoice_id = InvId
160: AND AATD.invoice_id = AI.invoice_id
161: AND AATD.tax_name = TC.name(+)

Line 1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;

1295: P_New_Invoice_Id IN NUMBER DEFAULT NULL,
1296: P_create_dists IN VARCHAR2 DEFAULT NULL) --Bug7685907 bug8207324 bug8236169
1297: IS
1298: new_invoice_id ap_invoices.invoice_id%TYPE;
1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;

Line 1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;

1296: P_create_dists IN VARCHAR2 DEFAULT NULL) --Bug7685907 bug8207324 bug8236169
1297: IS
1298: new_invoice_id ap_invoices.invoice_id%TYPE;
1299: tax_authority_id ap_tax_codes.awt_vendor_id%TYPE;
1300: tax_authority_site_id ap_tax_codes.awt_vendor_site_id%TYPE;
1301: base_currency ap_system_parameters.base_currency_code%TYPE;
1302: new_invoice_base_descr ap_invoices.description%TYPE;
1303: inv_terms_date DATE;
1304: ta_terms_id po_vendor_sites.terms_id%TYPE;

Line 1378: ap_tax_codes_all ATC,

1374: , APID.org_id
1375: , APID.awt_related_id awt_related_id -- bug 9913164
1376: FROM ap_invoice_distributions_all APID,
1377: ap_invoice_distributions_all APID1,
1378: ap_tax_codes_all ATC,
1379: ap_invoices_all AI
1380: WHERE (APID.invoice_id = InvId)
1381: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))
1382: AND (APID.distribution_line_number = NVL(P_dist_Line_No,APID.distribution_line_number))

Line 1428: ap_tax_codes_all ATC,

1424: , APID.org_id
1425: , APID.awt_related_id awt_related_id -- bug 9913164
1426: FROM ap_invoice_distributions_all APID,
1427: ap_invoice_distributions_all APID1,
1428: ap_tax_codes_all ATC,
1429: ap_invoices_all AI
1430: WHERE (APID.invoice_id = InvId)
1431: AND (APID.invoice_line_number = NVL(P_Inv_Line_No,line_num))
1432: AND (APID.distribution_line_number = NVL(P_dist_Line_No,APID.distribution_line_number))

Line 1470: ap_tax_codes_all ATC,

1466: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1467: , APID.invoice_line_number
1468: FROM ap_invoice_distributions_all APID,
1469: ap_invoice_distributions_all APID1,
1470: ap_tax_codes_all ATC,
1471: AP_INVOICES_ALL AI
1472: WHERE (APID.invoice_id = InvId)
1473: AND (APID.line_type_lookup_code = 'AWT')
1474: AND (NVL(APID.awt_flag , 'M' ) = 'A' )

Line 1507: ap_tax_codes_all ATC,

1503: , sum(-1 * NVL(APID.base_amount,APID.amount)) invoice_amount --bug 8597105
1504: , APID.invoice_line_number
1505: FROM ap_invoice_distributions_all APID,
1506: ap_invoice_distributions_all APID1,
1507: ap_tax_codes_all ATC,
1508: AP_INVOICES_ALL AI
1509: WHERE (APID.invoice_id = InvId)
1510: AND (APID.line_type_lookup_code = 'AWT')
1511: AND (NVL(APID.awt_flag , 'M' ) = 'A' )

Line 1669: FROM ap_tax_codes_all t,

1665: s.pay_group_lookup_code,
1666: s.accts_pay_code_combination_id,
1667: s.party_site_id,
1668: pv.party_id
1669: FROM ap_tax_codes_all t,
1670: ap_system_parameters_all p,
1671: po_vendor_sites_all s,
1672: po_vendors pv
1673: WHERE t.tax_id = TaxId

Line 2465: l_tax_name ap_tax_codes.name%TYPE;

2461: p_checkrun_id in number default null)
2462: IS
2463: l_awt_flag ap_invoices.awt_flag%TYPE;
2464: l_inv_curr_code ap_invoices.invoice_currency_code%TYPE;
2465: l_tax_name ap_tax_codes.name%TYPE;
2466: l_payment_date DATE := p_awt_date;
2467: l_org_id number; --4742265
2468:
2469: -- The variable "l_AWT_success" checks general WT calculations in the first

Line 3737: ap_tax_codes_all TC

3733: , TC.tax_id tax_code_id
3734: , aatd.checkrun_id
3735: FROM ap_awt_temp_distributions_all AATD,
3736: ap_invoices_all AI,
3737: ap_tax_codes_all TC
3738: WHERE AATD.invoice_id = InvId
3739: AND AATD.invoice_id = AI.invoice_id
3740: AND TC.name(+) = AATD.tax_name
3741: AND TC.tax_type = 'AWT' -- BUG 3665866

Line 3776: ap_tax_codes_all TC

3772: , aatd.checkrun_id
3773: , AATD.accounting_date
3774: FROM ap_awt_temp_distributions_all AATD,
3775: ap_invoices_all AI,
3776: ap_tax_codes_all TC
3777: WHERE AATD.invoice_id = InvId
3778: AND AATD.invoice_id = AI.invoice_id
3779: AND TC.name(+) = AATD.tax_name
3780: AND TC.tax_type = 'AWT'

Line 3808: FROM ap_tax_codes_all

3804: ret BOOLEAN;
3805:
3806: CURSOR c_get_limit IS
3807: SELECT 'Limit ExISts'
3808: FROM ap_tax_codes_all
3809: WHERE tax_id = TaxId
3810: AND awt_period_type IS not NULL;
3811:
3812: dummy CHAR(12);

Line 3884: ap_tax_codes_all C

3880: DECLARE
3881: CURSOR c_get_awt_period IS
3882: SELECT p.period_name
3883: FROM ap_other_periods P,
3884: ap_tax_codes_all C
3885: WHERE (rec_temp_gross.accounting_date BETWEEN
3886: p.start_date AND p.end_date)
3887: AND p.period_type = c.awt_period_type
3888: AND c.name = rec_temp_gross.tax_name

Line 3966: ap_tax_codes_all C

3962: DECLARE
3963: CURSOR c_get_awt_period IS
3964: SELECT p.period_name
3965: FROM ap_other_periods P,
3966: ap_tax_codes_all C
3967: WHERE (rec_temp.accounting_date BETWEEN
3968: p.start_date AND p.end_date)
3969: AND p.period_type = c.awt_period_type
3970: AND c.name = rec_temp.tax_name

Line 4389: ap_tax_codes TC

4385: , AID.global_attribute19
4386: , AID.global_attribute20
4387: /* End of fix for bug#8462050*/
4388: FROM ap_invoice_distributions AID,
4389: ap_tax_codes TC
4390: --,ap_invoices AI --Bug8547506
4391: WHERE AID.invoice_id = ParentId
4392: AND TC.tax_id (+) = AID.withholding_tax_code_id /* Bug 5382525 */
4393: --Bug8547506 Undoing changes done for bug6660355

Line 4530: ap_tax_codes TC

4526: , AID.global_attribute19
4527: , AID.global_attribute20
4528: /* End of fix for bug#8462050*/
4529: FROM ap_invoice_distributions AID,
4530: ap_tax_codes TC
4531: WHERE AID.awt_invoice_payment_id = ParentId
4532: AND TC.tax_id(+) = AID.withholding_tax_code_id /* 5382525 */
4533: AND AID.invoice_line_number = NVL(P_Inv_Line_No,
4534: AID.invoice_line_number)

Line 4560: ap_tax_codes TC

4556: , AID.awt_gross_amount
4557:
4558: /* End of fix for bug#8462050*/
4559: FROM ap_invoice_distributions AID,
4560: ap_tax_codes TC
4561: WHERE AID.awt_invoice_payment_id = ParentId
4562: AND TC.tax_id(+) = AID.withholding_tax_code_id /* 5382525 */
4563: AND NVL(AID.awt_flag, 'M') = 'A';
4564:

Line 4581: ap_tax_codes TC

4577: , AID.awt_invoice_payment_id
4578: , AID.awt_gross_amount
4579: /* End of fix for bug#8462050*/
4580: FROM ap_invoice_distributions AID,
4581: ap_tax_codes TC
4582: --,ap_invoices AI --Bug8547506
4583: WHERE AID.invoice_id = ParentId
4584: AND TC.tax_id (+) = AID.withholding_tax_code_id
4585: AND AID.invoice_line_number = NVL(P_Inv_Line_No,

Line 4722: ap_tax_codes T

4718: msg VARCHAR2(240);
4719: CURSOR c_get_period (distDate IN DATE, TaxId IN NUMBER) IS
4720: SELECT period_name
4721: FROM ap_other_periods P,
4722: ap_tax_codes T
4723: WHERE t.tax_id = TaxId
4724: AND p.period_type = t.awt_period_type
4725: AND p.application_id = 200
4726: AND p.module = 'AWT'

Line 4932: ap_tax_codes T

4928: msg VARCHAR2(240);
4929: CURSOR c_get_period (distDate IN DATE, TaxId IN NUMBER) IS
4930: SELECT period_name
4931: FROM ap_other_periods P,
4932: ap_tax_codes T
4933: WHERE t.tax_id = TaxId
4934: AND p.period_type = t.awt_period_type
4935: AND p.application_id = 200
4936: AND p.module = 'AWT'

Line 5792: ap_tax_codes_all C

5788: DECLARE
5789: CURSOR c_get_awt_period IS
5790: SELECT p.period_name
5791: FROM ap_other_periods P,
5792: ap_tax_codes_all C
5793: WHERE (rec_orphan_awt_buckets_w.accounting_date BETWEEN
5794: p.start_date AND p.end_date)
5795: AND p.period_type = c.awt_period_type
5796: AND c.name = rec_orphan_awt_buckets_w.tax_name

Line 5859: ap_tax_codes_all C

5855: DECLARE
5856: CURSOR c_get_awt_period IS
5857: SELECT p.period_name
5858: FROM ap_other_periods P,
5859: ap_tax_codes_all C
5860: WHERE (rec_orphan_awt_buckets_g.accounting_date BETWEEN
5861: p.start_date AND p.end_date)
5862: AND p.period_type = c.awt_period_type
5863: AND c.name = rec_orphan_awt_buckets_g.tax_name