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_SUBSCRIPTION_DETAILS

Line 557: ZX_SUBSCRIPTION_DETAILS sd_rates

553: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
554: ZX_TRX_HEADERS_GT Header,
555: ZX_TRANSACTION_LINES_GT Lines,
556: ZX_RATES_B rates,
557: ZX_SUBSCRIPTION_DETAILS sd_rates
558: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)
559: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
560: AND lines.tax_date --Bug 5018766
561: BETWEEN nvl(rates.effective_from,lines.tax_date)

Line 674: ZX_SUBSCRIPTION_DETAILS sd_rates

670: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
671: ZX_TRX_HEADERS_GT Header,
672: ZX_TRANSACTION_LINES_GT Lines,
673: ZX_RATES_B rates,
674: ZX_SUBSCRIPTION_DETAILS sd_rates
675: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)
676: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
677: AND lines.tax_date --Bug 5018766
678: BETWEEN nvl(rates.effective_from,lines.tax_date)

Line 788: ZX_SUBSCRIPTION_DETAILS sd_status,

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,
790: ZX_SUBSCRIPTION_DETAILS sd_rates
791: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
792: AND Status.tax = TaxLines.tax

Line 790: ZX_SUBSCRIPTION_DETAILS sd_rates

786: ZX_TRX_HEADERS_GT Header,
787: ZX_TRANSACTION_LINES_GT Lines,
788: ZX_SUBSCRIPTION_DETAILS sd_status,
789: ZX_RATES_B rates,
790: ZX_SUBSCRIPTION_DETAILS sd_rates
791: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
792: AND Status.tax = TaxLines.tax
793: --AND Status.default_status_flag = 'Y'
794: AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)

Line 1018: ZX_SUBSCRIPTION_DETAILS sd_rates

1014: FROM ZX_JURISDICTIONS_B Jur,
1015: ZX_TRX_HEADERS_GT Header,
1016: ZX_TRANSACTION_LINES_GT Lines,
1017: ZX_RATES_B rates,
1018: ZX_SUBSCRIPTION_DETAILS sd_rates
1019: WHERE
1020: Jur.tax = TaxLines.Tax
1021: AND Jur.tax_regime_code = TaxLines.Tax_Regime_Code
1022: --AND Jur.default_jurisdiction_flag = 'Y'

Line 1147: zx_subscription_details sd_rates,

1143: TaxLines.summary_tax_line_number summary_tax_line_number
1144: FROM zx_rates_b rates,
1145: zx_trx_headers_gt header,
1146: zx_transaction_lines_gt lines,
1147: zx_subscription_details sd_rates,
1148: zx_import_tax_lines_gt taxlines
1149: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1150: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1151: AND TaxLines.tax = rates.tax(+)

Line 1259: zx_subscription_details sd_rates,

1255: TaxLines.summary_tax_line_number summary_tax_line_number
1256: FROM zx_rates_b rates,
1257: zx_trx_headers_gt header,
1258: zx_transaction_lines_gt lines,
1259: zx_subscription_details sd_rates,
1260: zx_import_tax_lines_gt taxlines
1261: WHERE TaxLines.tax_regime_Code = rates.tax_regime_code(+)
1262: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1263: AND TaxLines.tax = rates.tax(+)

Line 1418: zx_subscription_details sd_tax,

1414: ZX_TRX_HEADERS_GT Header,
1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,
1419: zx_subscription_details sd_rates
1420: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'
1421: AND TaxLines.tax_amt is NULL
1422: AND TaxLines.tax_rate is not NULL

Line 1419: zx_subscription_details sd_rates

1415: ZX_TRANSACTION_LINES_GT Lines,
1416: ZX_TAXES_B tax,
1417: zx_rates_b rate,
1418: zx_subscription_details sd_tax,
1419: zx_subscription_details sd_rates
1420: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'
1421: AND TaxLines.tax_amt is NULL
1422: AND TaxLines.tax_rate is not NULL
1423: AND TaxLines.application_id = taxLink.application_id

Line 1685: zx_subscription_details sd_reg,

1681: -- zx_import_tax_lines_gt temp_gt,
1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1688: -- zx_subscription_details sd_rates
1689: WHERE taxlines_gt.trx_id = header.trx_id

Line 1686: zx_subscription_details sd_tax,

1682: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1688: -- zx_subscription_details sd_rates
1689: WHERE taxlines_gt.trx_id = header.trx_id
1690: AND taxlines_gt.application_id = Header.application_id

Line 1687: zx_subscription_details sd_status

1683: zx_transaction_lines_gt lines_gt,
1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1688: -- zx_subscription_details sd_rates
1689: WHERE taxlines_gt.trx_id = header.trx_id
1690: AND taxlines_gt.application_id = Header.application_id
1691: AND taxlines_gt.entity_code = Header.entity_code

Line 1688: -- zx_subscription_details sd_rates

1684: ZX_JURISDICTIONS_B jur,
1685: zx_subscription_details sd_reg,
1686: zx_subscription_details sd_tax,
1687: zx_subscription_details sd_status
1688: -- zx_subscription_details sd_rates
1689: WHERE taxlines_gt.trx_id = header.trx_id
1690: AND taxlines_gt.application_id = Header.application_id
1691: AND taxlines_gt.entity_code = Header.entity_code
1692: AND taxlines_gt.event_class_code = Header.event_class_code

Line 4043: zx_subscription_details zxsd

4039: lines_gt.input_tax_classification_code IS NOT NULL)
4040: --Changed for Bug#7504455--
4041: AND NOT EXISTS (SELECT 1
4042: FROM zx_rates_b rates,
4043: zx_subscription_details zxsd
4044: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4045: lines_gt.input_tax_classification_code)
4046: AND rates.tax_regime_code = zxsd.tax_regime_code
4047: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 4073: zx_subscription_details zxsd

4069: lines_gt.input_tax_classification_code IS NOT NULL) AND
4070: --Changed for Bug#7504455--
4071: NOT EXISTS (SELECT 1
4072: FROM zx_rates_b rates,
4073: zx_subscription_details zxsd
4074: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4075: lines_gt.input_tax_classification_code)
4076: AND rates.tax_regime_code = zxsd.tax_regime_code
4077: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 4090: zx_subscription_details zxsd

4086: lines_gt.input_tax_classification_code IS NOT NULL) AND
4087: --Changed for Bug#7504455--
4088: NOT EXISTS (SELECT 1
4089: FROM zx_rates_b rates,
4090: zx_subscription_details zxsd
4091: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4092: lines_gt.input_tax_classification_code)
4093: AND rates.tax_regime_code = zxsd.tax_regime_code
4094: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 5405: zx_subscription_details sd_reg,

5401: -- zx_import_tax_lines_gt temp_gt,
5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5408: -- zx_subscription_details sd_rates
5409: WHERE taxlines_gt.trx_id = header.trx_id

Line 5406: zx_subscription_details sd_tax,

5402: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5408: -- zx_subscription_details sd_rates
5409: WHERE taxlines_gt.trx_id = header.trx_id
5410: AND taxlines_gt.application_id = Header.application_id

Line 5407: zx_subscription_details sd_status

5403: zx_transaction_lines_gt lines_gt,
5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5408: -- zx_subscription_details sd_rates
5409: WHERE taxlines_gt.trx_id = header.trx_id
5410: AND taxlines_gt.application_id = Header.application_id
5411: AND taxlines_gt.entity_code = Header.entity_code

Line 5408: -- zx_subscription_details sd_rates

5404: ZX_JURISDICTIONS_B jur,
5405: zx_subscription_details sd_reg,
5406: zx_subscription_details sd_tax,
5407: zx_subscription_details sd_status
5408: -- zx_subscription_details sd_rates
5409: WHERE taxlines_gt.trx_id = header.trx_id
5410: AND taxlines_gt.application_id = Header.application_id
5411: AND taxlines_gt.entity_code = Header.entity_code
5412: AND taxlines_gt.event_class_code = Header.event_class_code

Line 5715: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD

5711: ( lines_gt.subscription_date NOT BETWEEN
5712: NVL(sd_REG.effective_from,lines_gt.subscription_date)
5713: AND NVL(sd_REG.effective_to, lines_gt.subscription_date)
5714: AND NOT EXISTS (
5715: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD
5716: WHERE ZSD.TAX_REGIME_CODE = REGIME.TAX_REGIME_CODE
5717: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
5718: AND lines_gt.subscription_date BETWEEN
5719: NVL(ZSD.effective_from,lines_gt.subscription_date)

Line 5735: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD

5731: lines_gt.subscription_date NOT BETWEEN
5732: NVL(sd_tax.effective_from,lines_gt.subscription_date)
5733: AND NVL(sd_tax.effective_to, lines_gt.subscription_date)
5734: AND NOT EXISTS (
5735: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD
5736: WHERE ZSD.TAX_REGIME_CODE = tax.TAX_REGIME_CODE
5737: AND ZSD.parent_first_pty_org_id = tax.content_owner_id
5738: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
5739: AND lines_gt.subscription_date BETWEEN

Line 5756: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD

5752: lines_gt.subscription_date NOT BETWEEN
5753: NVL(sd_status.effective_from,lines_gt.subscription_date)
5754: AND NVL(sd_status.effective_to, lines_gt.subscription_date)
5755: AND NOT EXISTS (
5756: SELECT 1 FROM ZX_SUBSCRIPTION_DETAILS ZSD
5757: WHERE ZSD.TAX_REGIME_CODE = status.TAX_REGIME_CODE
5758: AND ZSD.parent_first_pty_org_id = status.content_owner_id
5759: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
5760: AND lines_gt.subscription_date BETWEEN

Line 5774: zx_subscription_details sd_reg,

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
5778: AND taxlines_gt.application_id = Header.application_id

Line 5775: zx_subscription_details sd_tax,

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
5778: AND taxlines_gt.application_id = Header.application_id
5779: AND taxlines_gt.entity_code = Header.entity_code

Line 5776: zx_subscription_details sd_status

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
5778: AND taxlines_gt.application_id = Header.application_id
5779: AND taxlines_gt.entity_code = Header.entity_code
5780: AND taxlines_gt.event_class_code = Header.event_class_code

Line 6167: zx_subscription_details sd_rates

6163: zx_rates_b off_rate,
6164: zx_import_tax_lines_gt temp_gt,
6165: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6166: zx_transaction_lines_gt lines_gt,
6167: zx_subscription_details sd_rates
6168: WHERE taxlines_gt.trx_id = header.trx_id
6169: AND taxlines_gt.application_id = Header.application_id
6170: AND taxlines_gt.entity_code = Header.entity_code
6171: AND taxlines_gt.event_class_code = Header.event_class_code

Line 6427: zx_subscription_details sd_rates

6423: zx_rates_b off_rate,
6424: zx_import_tax_lines_gt temp_gt,
6425: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
6426: zx_transaction_lines_gt lines_gt,
6427: zx_subscription_details sd_rates
6428: WHERE taxlines_gt.trx_id = header.trx_id
6429: AND taxlines_gt.application_id = Header.application_id
6430: AND taxlines_gt.entity_code = Header.entity_code
6431: AND taxlines_gt.event_class_code = Header.event_class_code