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.ZX_VALIDATE_API_PKG dependencies on ZX_STATUS_B

Line 785: FROM ZX_STATUS_B Status,

781:
782: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
783: SET tax_status_code =
784: (SELECT Status.tax_status_code
785: FROM ZX_STATUS_B Status,
786: ZX_TRX_HEADERS_GT Header,
787: ZX_TRANSACTION_LINES_GT Lines,
788: ZX_SUBSCRIPTION_DETAILS sd_status,
789: ZX_RATES_B rates,

Line 859: FROM ZX_STATUS_B

855: AND NVL(sd_status.effective_to,
856: lines.subscription_date
857: )
858: OR status.effective_from = (SELECT MIN(effective_from)
859: FROM ZX_STATUS_B
860: WHERE tax_regime_code = status.tax_regime_code and
861: tax = status.tax and
862: tax_status_code = status.tax_status_code and
863: content_owner_id = status.content_owner_id

Line 1678: ZX_STATUS_B status ,

1674: taxlines_gt.summary_tax_line_number
1675: FROM ZX_TRX_HEADERS_GT header,
1676: ZX_REGIMES_B regime ,
1677: ZX_TAXES_B tax ,
1678: ZX_STATUS_B status ,
1679: -- ZX_RATES_B rate ,
1680: -- zx_rates_b off_rate,
1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 1852: FROM ZX_STATUS_B

1848: /*OR status.effective_from =
1849: (
1850: SELECT
1851: min(effective_from)
1852: FROM ZX_STATUS_B
1853: WHERE tax_regime_code = status.tax_regime_code
1854: AND tax = status.tax
1855: AND tax_status_code = status.tax_status_code
1856: AND content_owner_id = status.content_owner_id

Line 5398: ZX_STATUS_B status ,

5394: /* end bug 3676878 */
5395: FROM ZX_TRX_HEADERS_GT header,
5396: ZX_REGIMES_B regime ,
5397: ZX_TAXES_B tax ,
5398: ZX_STATUS_B status ,
5399: -- ZX_RATES_B rate ,
5400: -- zx_rates_b off_rate,
5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 5576: FROM ZX_STATUS_B

5572: /*OR status.effective_from =
5573: (
5574: SELECT
5575: min(effective_from)
5576: FROM ZX_STATUS_B
5577: WHERE tax_regime_code = status.tax_regime_code
5578: AND tax = status.tax
5579: AND tax_status_code = status.tax_status_code
5580: AND content_owner_id = status.content_owner_id

Line 5773: ZX_STATUS_B status ,

5769: zx_transaction_lines_gt lines_gt,
5770: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5771: ZX_REGIMES_B regime ,
5772: ZX_TAXES_B tax ,
5773: ZX_STATUS_B status ,
5774: zx_subscription_details sd_reg,
5775: zx_subscription_details sd_tax,
5776: zx_subscription_details sd_status
5777: where taxlines_gt.trx_id = header.trx_id