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_ETAX_UTILITY_PKG dependencies on ZX_TRX_HEADERS_GT

Line 2307: FROM zx_trx_headers_gt gt,

2303: ai.invoice_id invoice_id,
2304: ai.batch_id batch_id,
2305: ai.set_of_books_id set_of_books_id,
2306: zd.account_source_tax_rate_id account_source_tax_rate_id
2307: FROM zx_trx_headers_gt gt,
2308: zx_rec_nrec_dist zd,
2309: zx_lines zl,
2310: ap_invoices_all ai,
2311: ap_supplier_sites_all pvs,

Line 2620: FROM zx_trx_headers_gt gt,

2616: ai.invoice_id invoice_id,
2617: ai.batch_id batch_id,
2618: ai.set_of_books_id set_of_books_id,
2619: zd.account_source_tax_rate_id account_source_tax_rate_id
2620: FROM zx_trx_headers_gt gt,
2621: zx_rec_nrec_dist zd,
2622: zx_lines zl,
2623: ap_invoices_all ai,
2624: ap_supplier_sites_all pvs,

Line 2878: FROM zx_trx_headers_gt gt,

2874: 'N', (zd.prd_tax_amt - zd.rec_nrec_tax_amt), NULL),
2875: NULL) prepay_tax_diff_amount,
2876: aid.invoice_distribution_id invoice_distribution_id,
2877: zd.account_source_tax_rate_id
2878: FROM zx_trx_headers_gt gt,
2879: zx_rec_nrec_dist zd,
2880: zx_lines zl,
2881: ap_invoices_all ai,
2882: ap_invoice_distributions_all aid,

Line 3108: FROM zx_trx_headers_gt gt,

3104: NULL extra_po_erv,
3105: NULL prepay_tax_diff_amount,
3106: aid.invoice_distribution_id invoice_distribution_id,
3107: zd.account_source_tax_rate_id account_source_tax_rate_id
3108: FROM zx_trx_headers_gt gt,
3109: zx_rec_nrec_dist zd,
3110: zx_lines zl,
3111: ap_invoices_all ai,
3112: ap_invoice_distributions_all aid,

Line 3311: FROM zx_trx_headers_gt gt,

3307: ai.invoice_id invoice_id,
3308: ai.batch_id batch_id,
3309: ai.set_of_books_id set_of_books_id,
3310: zd.account_source_tax_rate_id account_source_tax_rate_id
3311: FROM zx_trx_headers_gt gt,
3312: zx_rec_nrec_dist zd,
3313: zx_lines zl,
3314: ap_invoices_all ai,
3315: ap_supplier_sites_all pvs,

Line 3506: FROM zx_trx_headers_gt gt,

3502: 'N', (zd.prd_tax_amt - zd.rec_nrec_tax_amt), NULL),
3503: NULL) prepay_tax_diff_amount,
3504: aid.invoice_distribution_id invoice_distribution_id,
3505: zd.account_source_tax_rate_id
3506: FROM zx_trx_headers_gt gt,
3507: zx_rec_nrec_dist zd,
3508: zx_lines zl,
3509: ap_invoices_all ai,
3510: ap_self_assessed_tax_dist_all aid,

Line 4737: FROM zx_trx_headers_gt gt,

4733: DELETE FROM ap_invoice_distributions_all aid
4734: WHERE aid.invoice_distribution_id IN
4735: (SELECT /*+ leading(gt) cardinality(gt,1) */
4736: dist.invoice_distribution_id
4737: FROM zx_trx_headers_gt gt,
4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 4765: FROM zx_trx_headers_gt gt,

4761: DELETE FROM ap_self_assessed_tax_dist_all aid
4762: WHERE aid.invoice_distribution_id IN
4763: (SELECT /*+ leading(gt) cardinality(gt,1) */
4764: dist.invoice_distribution_id
4765: FROM zx_trx_headers_gt gt,
4766: ap_self_assessed_tax_dist_all dist
4767: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4768: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4769: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 4797: FROM zx_trx_headers_gt gt,

4793: AND rownum = 1)
4794: WHERE aid.invoice_distribution_id IN
4795: (SELECT /*+ leading(gt) cardinality(gt,1) */
4796: dist.invoice_distribution_id
4797: FROM zx_trx_headers_gt gt,
4798: ap_invoice_distributions_all dist
4799: WHERE gt.application_id = 200
4800: AND gt.entity_code = 'AP_INVOICES'
4801: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')