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_ALL

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 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 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 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