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 2401: SELECT /+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) / -- 9485828

2397:
2398: -- bug10140354 begin
2399:
2400: cursor frozen_dist_del IS
2401: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2402: detail_tax_dist_id,aid.summary_tax_line_id , invoice_id
2403: FROM ap_invoice_distributions_all aid,
2404: zx_trx_headers_gt gt
2405: WHERE aid.line_type_lookup_code IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV')

Line 2404: zx_trx_headers_gt gt

2400: cursor frozen_dist_del IS
2401: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2402: detail_tax_dist_id,aid.summary_tax_line_id , invoice_id
2403: FROM ap_invoice_distributions_all aid,
2404: zx_trx_headers_gt gt
2405: WHERE aid.line_type_lookup_code IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV')
2406: AND (aid.accounting_event_id IS NOT NULL OR
2407: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2408: NVL(aid.posted_flag,'N') ='Y' OR

Line 2429: SELECT /+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) / -- 9485828

2425:
2426: j NUMBER;
2427:
2428: cursor frozen_self_dist_del IS
2429: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2430: detail_tax_dist_id, aid.summary_tax_line_id , invoice_id
2431:
2432: FROM ap_self_assessed_tax_dist_all aid,
2433: zx_trx_headers_gt gt

Line 2433: zx_trx_headers_gt gt

2429: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2430: detail_tax_dist_id, aid.summary_tax_line_id , invoice_id
2431:
2432: FROM ap_self_assessed_tax_dist_all aid,
2433: zx_trx_headers_gt gt
2434: WHERE aid.line_type_lookup_code IN ('NONREC_TAX','REC_TAX')
2435: AND (aid.accounting_event_id IS NOT NULL OR
2436: NVL(aid.match_status_flag,'N') IN ('A','T') OR
2437: NVL(aid.posted_flag,'N') ='Y' OR

Line 2696: FROM zx_trx_headers_gt gt,

2692: parent_tax_line.pay_awt_group_id), --Bug6648050 -- bug 9035846 -- bug9117319
2693: NULL),
2694: NULL) pay_awt_group_id, --Bug8345264
2695: zd.account_source_tax_rate_id account_source_tax_rate_id
2696: FROM zx_trx_headers_gt gt,
2697: zx_rec_nrec_dist zd,
2698: zx_lines zl,
2699: ap_invoices_all ai,
2700: ap_supplier_sites_all pvs,

Line 3043: FROM zx_trx_headers_gt gt,

3039: parent_tax_line.pay_awt_group_id), --Bug6648050 -- bug 9035846 -- bug9117319 --bug9200123
3040: NULL),
3041: NULL) pay_awt_group_id, --Bug8345264
3042: zd.account_source_tax_rate_id account_source_tax_rate_id
3043: FROM zx_trx_headers_gt gt,
3044: zx_rec_nrec_dist zd,
3045: zx_lines zl,
3046: ap_invoices_all ai,
3047: ap_supplier_sites_all pvs,

Line 3321: FROM zx_trx_headers_gt gt,

3317: NULL) prepay_tax_diff_amount,
3318: aid.invoice_distribution_id invoice_distribution_id,
3319: aid.pay_awt_group_id pay_awt_group_id, --bug8345264
3320: zd.account_source_tax_rate_id
3321: FROM zx_trx_headers_gt gt,
3322: zx_rec_nrec_dist zd,
3323: zx_lines zl,
3324: ap_invoices_all ai,
3325: ap_invoice_distributions_all aid,

Line 3562: FROM zx_trx_headers_gt gt,

3558: NULL prepay_tax_diff_amount,
3559: aid.invoice_distribution_id invoice_distribution_id,
3560: aid.pay_awt_group_id pay_awt_group_id, --Bug8345264
3561: zd.account_source_tax_rate_id account_source_tax_rate_id
3562: FROM zx_trx_headers_gt gt,
3563: zx_rec_nrec_dist zd,
3564: zx_lines zl,
3565: ap_invoices_all ai,
3566: ap_invoice_distributions_all aid,

Line 3782: FROM zx_trx_headers_gt gt,

3778: ai.batch_id batch_id,
3779: ai.set_of_books_id set_of_books_id,
3780: parent_taxable_dist.pay_awt_group_id pay_awt_group_id, --Bug8345264
3781: zd.account_source_tax_rate_id account_source_tax_rate_id
3782: FROM zx_trx_headers_gt gt,
3783: zx_rec_nrec_dist zd,
3784: zx_lines zl,
3785: ap_invoices_all ai,
3786: ap_supplier_sites_all pvs,

Line 3981: FROM zx_trx_headers_gt gt,

3977: NULL) prepay_tax_diff_amount,
3978: aid.invoice_distribution_id invoice_distribution_id,
3979: parent_taxable_dist.pay_awt_group_id pay_awt_group_id, --Bug8345264
3980: zd.account_source_tax_rate_id
3981: FROM zx_trx_headers_gt gt,
3982: zx_rec_nrec_dist zd,
3983: zx_lines zl,
3984: ap_invoices_all ai,
3985: ap_self_assessed_tax_dist_all aid,

Line 5817: FROM zx_trx_headers_gt gt,

5813: DELETE FROM ap_invoice_distributions_all aid
5814: WHERE aid.invoice_distribution_id IN
5815: (SELECT /*+ leading(gt) cardinality(gt,1) */
5816: dist.invoice_distribution_id
5817: FROM zx_trx_headers_gt gt,
5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 5912: FROM zx_trx_headers_gt gt,

5908: DELETE FROM ap_self_assessed_tax_dist_all aid
5909: WHERE aid.invoice_distribution_id IN
5910: (SELECT /*+ leading(gt) cardinality(gt,1) */
5911: dist.invoice_distribution_id
5912: FROM zx_trx_headers_gt gt,
5913: ap_self_assessed_tax_dist_all dist
5914: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5915: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5916: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,

Line 5945: FROM zx_trx_headers_gt gt,

5941: AND rownum = 1)
5942: WHERE aid.invoice_distribution_id IN
5943: (SELECT /*+ leading(gt) cardinality(gt,1) */
5944: dist.invoice_distribution_id
5945: FROM zx_trx_headers_gt gt,
5946: ap_invoice_distributions_all dist
5947: WHERE gt.application_id = 200
5948: AND gt.entity_code = 'AP_INVOICES'
5949: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')