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_SUBSCRIPTION_DETAILS

Line 845: ZX_SUBSCRIPTION_DETAILS sd_rates

841: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
842: ZX_TRX_HEADERS_GT Header,
843: --ZX_TRANSACTION_LINES_GT Lines,
844: ZX_RATES_B rates,
845: ZX_SUBSCRIPTION_DETAILS sd_rates
846: WHERE TaxLines_gt.tax_rate_code = rates.tax_rate_code(+)
847: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
848: AND Taxlines_gt.tax_date --Bug 5018766
849: BETWEEN nvl(rates.effective_from,Taxlines_gt.tax_date)

Line 976: ZX_SUBSCRIPTION_DETAILS sd_rates

972: ZX_IMPORT_TAX_LINES_GT TaxLines_gt,
973: ZX_TRX_HEADERS_GT Header,
974: --ZX_TRANSACTION_LINES_GT Lines,
975: ZX_RATES_B rates,
976: ZX_SUBSCRIPTION_DETAILS sd_rates
977: WHERE TaxLines_gt.tax_rate_id = rates.tax_rate_id(+)
978: AND (Taxlines_gt.tax_rate_code IS NOT NULL OR Taxlines_gt.tax_rate_id IS NOT NULL)
979: AND Taxlines_gt.tax_date --Bug 5018766
980: BETWEEN nvl(rates.effective_from,Taxlines_gt.tax_date)

Line 1101: ZX_SUBSCRIPTION_DETAILS sd_status,

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,
1103: ZX_SUBSCRIPTION_DETAILS sd_rates
1104: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
1105: AND Status.tax = TaxLines.tax

Line 1103: ZX_SUBSCRIPTION_DETAILS sd_rates

1099: ZX_TRX_HEADERS_GT Header,
1100: --ZX_TRANSACTION_LINES_GT Lines,
1101: ZX_SUBSCRIPTION_DETAILS sd_status,
1102: ZX_RATES_B rates,
1103: ZX_SUBSCRIPTION_DETAILS sd_rates
1104: WHERE Status.tax_regime_code = TaxLines.tax_regime_code
1105: AND Status.tax = TaxLines.tax
1106: --AND Status.default_status_flag = 'Y'
1107: AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)

Line 1348: ZX_SUBSCRIPTION_DETAILS sd_rates

1344: FROM ZX_JURISDICTIONS_B Jur,
1345: ZX_TRX_HEADERS_GT Header,
1346: --ZX_TRANSACTION_LINES_GT Lines,
1347: ZX_RATES_B rates,
1348: ZX_SUBSCRIPTION_DETAILS sd_rates
1349: WHERE Jur.tax = TaxLines.Tax
1350: AND Jur.tax_regime_code = TaxLines.Tax_Regime_Code
1351: --AND Jur.default_jurisdiction_flag = 'Y'
1352: AND Jur.tax_jurisdiction_code = rates.tax_jurisdiction_code(+)

Line 1484: zx_subscription_details sd_rates,

1480: TaxLines_gt.summary_tax_line_number summary_tax_line_number
1481: FROM zx_rates_b rates,
1482: zx_trx_headers_gt header,
1483: --zx_transaction_lines_gt lines,
1484: zx_subscription_details sd_rates,
1485: zx_import_tax_lines_gt taxlines_gt
1486: WHERE TaxLines_gt.tax_regime_Code = rates.tax_regime_code(+)
1487: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1488: AND TaxLines_gt.tax = rates.tax(+)

Line 1626: zx_subscription_details sd_rates,

1622: TaxLines_gt.summary_tax_line_number summary_tax_line_number
1623: FROM zx_rates_b rates,
1624: zx_trx_headers_gt header,
1625: --zx_transaction_lines_gt lines,
1626: zx_subscription_details sd_rates,
1627: zx_import_tax_lines_gt taxlines_gt
1628: WHERE TaxLines_gt.tax_regime_Code = rates.tax_regime_code(+)
1629: -- AND (Taxlines.tax_rate_code IS NOT NULL OR Taxlines.tax_rate_id IS NOT NULL)
1630: AND TaxLines_gt.tax = rates.tax(+)

Line 1760: zx_subscription_details sd_tax,

1756: ZX_TRX_HEADERS_GT Header,
1757: ZX_TRANSACTION_LINES_GT Lines,
1758: ZX_TAXES_B tax,
1759: zx_rates_b rate,
1760: zx_subscription_details sd_tax,
1761: zx_subscription_details sd_rates
1762: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'
1763: AND TaxLines.tax_amt is NULL
1764: AND TaxLines.tax_rate is not NULL

Line 1761: zx_subscription_details sd_rates

1757: ZX_TRANSACTION_LINES_GT Lines,
1758: ZX_TAXES_B tax,
1759: zx_rates_b rate,
1760: zx_subscription_details sd_tax,
1761: zx_subscription_details sd_rates
1762: WHERE Taxlines.TAX_LINE_ALLOCATION_FLAG = 'Y'
1763: AND TaxLines.tax_amt is NULL
1764: AND TaxLines.tax_rate is not NULL
1765: AND TaxLines.application_id = taxLink.application_id

Line 2023: zx_subscription_details sd_reg,

2019: -- zx_import_tax_lines_gt temp_gt,
2020: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2021: zx_transaction_lines_gt lines_gt,
2022: ZX_JURISDICTIONS_B jur,
2023: zx_subscription_details sd_reg,
2024: zx_subscription_details sd_tax,
2025: zx_subscription_details sd_status
2026: -- zx_subscription_details sd_rates
2027: WHERE taxlines_gt.trx_id = header.trx_id

Line 2024: zx_subscription_details sd_tax,

2020: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
2021: zx_transaction_lines_gt lines_gt,
2022: ZX_JURISDICTIONS_B jur,
2023: zx_subscription_details sd_reg,
2024: zx_subscription_details sd_tax,
2025: zx_subscription_details sd_status
2026: -- zx_subscription_details sd_rates
2027: WHERE taxlines_gt.trx_id = header.trx_id
2028: AND taxlines_gt.application_id = Header.application_id

Line 2025: zx_subscription_details sd_status

2021: zx_transaction_lines_gt lines_gt,
2022: ZX_JURISDICTIONS_B jur,
2023: zx_subscription_details sd_reg,
2024: zx_subscription_details sd_tax,
2025: zx_subscription_details sd_status
2026: -- zx_subscription_details sd_rates
2027: WHERE taxlines_gt.trx_id = header.trx_id
2028: AND taxlines_gt.application_id = Header.application_id
2029: AND taxlines_gt.entity_code = Header.entity_code

Line 2026: -- zx_subscription_details sd_rates

2022: ZX_JURISDICTIONS_B jur,
2023: zx_subscription_details sd_reg,
2024: zx_subscription_details sd_tax,
2025: zx_subscription_details sd_status
2026: -- zx_subscription_details sd_rates
2027: WHERE taxlines_gt.trx_id = header.trx_id
2028: AND taxlines_gt.application_id = Header.application_id
2029: AND taxlines_gt.entity_code = Header.entity_code
2030: AND taxlines_gt.event_class_code = Header.event_class_code

Line 4504: zx_subscription_details zxsd

4500: lines_gt.input_tax_classification_code IS NOT NULL)
4501: --Changed for Bug#7504455--
4502: AND NOT EXISTS (SELECT 1
4503: FROM zx_rates_b rates,
4504: zx_subscription_details zxsd
4505: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4506: lines_gt.input_tax_classification_code)
4507: AND rates.tax_regime_code = zxsd.tax_regime_code
4508: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 4534: zx_subscription_details zxsd

4530: lines_gt.input_tax_classification_code IS NOT NULL) AND
4531: --Changed for Bug#7504455--
4532: NOT EXISTS (SELECT 1
4533: FROM zx_rates_b rates,
4534: zx_subscription_details zxsd
4535: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4536: lines_gt.input_tax_classification_code)
4537: AND rates.tax_regime_code = zxsd.tax_regime_code
4538: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 4551: zx_subscription_details zxsd

4547: lines_gt.input_tax_classification_code IS NOT NULL) AND
4548: --Changed for Bug#7504455--
4549: NOT EXISTS (SELECT 1
4550: FROM zx_rates_b rates,
4551: zx_subscription_details zxsd
4552: WHERE rates.tax_rate_code = NVL(lines_gt.output_tax_classification_code,
4553: lines_gt.input_tax_classification_code)
4554: AND rates.tax_regime_code = zxsd.tax_regime_code
4555: AND rates.content_owner_id = zxsd.first_pty_org_id

Line 5432: zx_subscription_details sd_reg,

5428: -- zx_import_tax_lines_gt temp_gt,
5429: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5430: --zx_transaction_lines_gt lines_gt,
5431: ZX_JURISDICTIONS_B jur,
5432: zx_subscription_details sd_reg,
5433: zx_subscription_details sd_tax,
5434: zx_subscription_details sd_status
5435: -- zx_subscription_details sd_rates
5436: WHERE taxlines_gt.trx_id = header.trx_id

Line 5433: zx_subscription_details sd_tax,

5429: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
5430: --zx_transaction_lines_gt lines_gt,
5431: ZX_JURISDICTIONS_B jur,
5432: zx_subscription_details sd_reg,
5433: zx_subscription_details sd_tax,
5434: zx_subscription_details sd_status
5435: -- zx_subscription_details sd_rates
5436: WHERE taxlines_gt.trx_id = header.trx_id
5437: AND taxlines_gt.application_id = Header.application_id

Line 5434: zx_subscription_details sd_status

5430: --zx_transaction_lines_gt lines_gt,
5431: ZX_JURISDICTIONS_B jur,
5432: zx_subscription_details sd_reg,
5433: zx_subscription_details sd_tax,
5434: zx_subscription_details sd_status
5435: -- zx_subscription_details sd_rates
5436: WHERE taxlines_gt.trx_id = header.trx_id
5437: AND taxlines_gt.application_id = Header.application_id
5438: AND taxlines_gt.entity_code = Header.entity_code

Line 5435: -- zx_subscription_details sd_rates

5431: ZX_JURISDICTIONS_B jur,
5432: zx_subscription_details sd_reg,
5433: zx_subscription_details sd_tax,
5434: zx_subscription_details sd_status
5435: -- zx_subscription_details sd_rates
5436: WHERE taxlines_gt.trx_id = header.trx_id
5437: AND taxlines_gt.application_id = Header.application_id
5438: AND taxlines_gt.entity_code = Header.entity_code
5439: AND taxlines_gt.event_class_code = Header.event_class_code

Line 7416: FROM ZX_SUBSCRIPTION_DETAILS ZSD

7412: NOT BETWEEN NVL(sd_REG.effective_from,taxlines_gt.subscription_date)
7413: AND NVL(sd_REG.effective_to, taxlines_gt.subscription_date)
7414: AND NOT EXISTS (
7415: SELECT 1
7416: FROM ZX_SUBSCRIPTION_DETAILS ZSD
7417: WHERE ZSD.TAX_REGIME_CODE = REGIME.TAX_REGIME_CODE
7418: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
7419: AND taxlines_gt.subscription_date
7420: BETWEEN NVL(ZSD.effective_from,taxlines_gt.subscription_date)

Line 7441: FROM ZX_SUBSCRIPTION_DETAILS ZSD

7437: NOT BETWEEN NVL(sd_tax.effective_from,taxlines_gt.subscription_date)
7438: AND NVL(sd_tax.effective_to, taxlines_gt.subscription_date)
7439: AND NOT EXISTS (
7440: SELECT 1
7441: FROM ZX_SUBSCRIPTION_DETAILS ZSD
7442: WHERE ZSD.TAX_REGIME_CODE = tax.TAX_REGIME_CODE
7443: AND ZSD.parent_first_pty_org_id = tax.content_owner_id
7444: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
7445: AND taxlines_gt.subscription_date

Line 7475: FROM ZX_SUBSCRIPTION_DETAILS ZSD

7471: NOT BETWEEN NVL(sd_status.effective_from,taxlines_gt.subscription_date)
7472: AND NVL(sd_status.effective_to, taxlines_gt.subscription_date)
7473: AND NOT EXISTS (
7474: SELECT 1
7475: FROM ZX_SUBSCRIPTION_DETAILS ZSD
7476: WHERE ZSD.TAX_REGIME_CODE = status.TAX_REGIME_CODE
7477: AND ZSD.parent_first_pty_org_id = status.content_owner_id
7478: AND ZSD.FIRST_PTY_ORG_ID = g_first_pty_org_id
7479: AND taxlines_gt.subscription_date

Line 7497: zx_subscription_details sd_reg,

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
7501: AND taxlines_gt.application_id = header.application_id

Line 7498: zx_subscription_details sd_tax,

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
7501: AND taxlines_gt.application_id = header.application_id
7502: AND taxlines_gt.entity_code = header.entity_code

Line 7499: zx_subscription_details sd_status

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
7501: AND taxlines_gt.application_id = header.application_id
7502: AND taxlines_gt.entity_code = header.entity_code
7503: AND taxlines_gt.event_class_code = header.event_class_code

Line 7896: zx_subscription_details sd_rates

7892: zx_rates_b off_rate,
7893: zx_import_tax_lines_gt temp_gt,
7894: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
7895: --zx_transaction_lines_gt lines_gt,
7896: zx_subscription_details sd_rates
7897: WHERE taxlines_gt.trx_id = header.trx_id
7898: AND taxlines_gt.application_id = Header.application_id
7899: AND taxlines_gt.entity_code = Header.entity_code
7900: AND taxlines_gt.event_class_code = Header.event_class_code

Line 8173: zx_subscription_details sd_rates

8169: zx_rates_b off_rate,
8170: zx_import_tax_lines_gt temp_gt,
8171: ZX_IMPORT_TAX_LINES_GT taxlines_gt,
8172: --zx_transaction_lines_gt lines_gt,
8173: zx_subscription_details sd_rates
8174: WHERE taxlines_gt.trx_id = header.trx_id
8175: AND taxlines_gt.application_id = Header.application_id
8176: AND taxlines_gt.entity_code = Header.entity_code
8177: AND taxlines_gt.event_class_code = Header.event_class_code