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.

[Home] [Help]

APPS.ZX_VALIDATE_API_PKG dependencies on ZX_STATUS_B

Line 1098: FROM ZX_STATUS_B Status,

1094:
1095: UPDATE ZX_IMPORT_TAX_LINES_GT TaxLines
1096: SET tax_status_code =
1097: (SELECT Status.tax_status_code
1098: FROM ZX_STATUS_B Status,
1099: ZX_TRX_HEADERS_GT Header,
1100: --ZX_TRANSACTION_LINES_GT Lines,
1101: ZX_SUBSCRIPTION_DETAILS sd_status,
1102: ZX_RATES_B rates,

Line 1168: FROM ZX_STATUS_B

1164: AND (Taxlines.subscription_date
1165: BETWEEN NVL(sd_status.effective_from,Taxlines.subscription_date)
1166: AND NVL(sd_status.effective_to,Taxlines.subscription_date)
1167: OR status.effective_from = (SELECT MIN(effective_from)
1168: FROM ZX_STATUS_B
1169: WHERE tax_regime_code = status.tax_regime_code and
1170: tax = status.tax and
1171: tax_status_code = status.tax_status_code and
1172: content_owner_id = status.content_owner_id

Line 2016: ZX_STATUS_B status ,

2012: taxlines_gt.summary_tax_line_number
2013: FROM ZX_TRX_HEADERS_GT header,
2014: ZX_REGIMES_B regime ,
2015: ZX_TAXES_B tax ,
2016: ZX_STATUS_B status ,
2017: -- ZX_RATES_B rate ,
2018: -- zx_rates_b off_rate,
2019: -- zx_import_tax_lines_gt temp_gt,
2020: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 2169: FROM ZX_STATUS_B

2165: /*OR status.effective_from =
2166: (
2167: SELECT
2168: min(effective_from)
2169: FROM ZX_STATUS_B
2170: WHERE tax_regime_code = status.tax_regime_code
2171: AND tax = status.tax
2172: AND tax_status_code = status.tax_status_code
2173: AND content_owner_id = status.content_owner_id

Line 5425: ZX_STATUS_B status ,

5421: /* end bug 3676878 */
5422: FROM ZX_TRX_HEADERS_GT header,
5423: ZX_REGIMES_B regime ,
5424: ZX_TAXES_B tax ,
5425: ZX_STATUS_B status ,
5426: -- ZX_RATES_B rate ,
5427: -- zx_rates_b off_rate,
5428: -- zx_import_tax_lines_gt temp_gt,
5429: ZX_IMPORT_TAX_LINES_GT taxlines_gt,

Line 5582: FROM ZX_STATUS_B

5578: /*OR status.effective_from =
5579: (
5580: SELECT
5581: min(effective_from)
5582: FROM ZX_STATUS_B
5583: WHERE tax_regime_code = status.tax_regime_code
5584: AND tax = status.tax
5585: AND tax_status_code = status.tax_status_code
5586: AND content_owner_id = status.content_owner_id

Line 7496: ZX_STATUS_B status ,

7492: --zx_transaction_lines_gt lines_gt,
7493: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7494: ZX_REGIMES_B regime ,
7495: ZX_TAXES_B tax ,
7496: ZX_STATUS_B status ,
7497: zx_subscription_details sd_reg,
7498: zx_subscription_details sd_tax,
7499: zx_subscription_details sd_status
7500: where taxlines_gt.trx_id = header.trx_id