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_PTP_IMPORT dependencies on ZX_SUBSCRIPTION_DETAILS

Line 4499: zx_subscription_details sd

4495: AND NOT EXISTS
4496: (
4497: SELECT 1
4498: FROM zx_taxes_b ztvl,
4499: zx_subscription_details sd
4500: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4501: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4502: AND (sd.view_options_code in ('NONE', 'VFC')
4503: or

Line 4527: zx_subscription_details sd

4523: AND NOT EXISTS
4524: (
4525: SELECT 1
4526: FROM zx_taxes_vl ztvl,
4527: zx_subscription_details sd
4528: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4529: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4530: AND (sd.view_options_code in ('NONE', 'VFC')
4531: or

Line 4564: zx_subscription_details sd

4560: UPDATE zx_exemptions_int exe_int
4561: SET tax_code = (
4562: SELECT ztvl.tax
4563: FROM zx_taxes_vl ztvl,
4564: zx_subscription_details sd
4565: WHERE ztvl.tax_regime_code = sd.tax_regime_code
4566: AND ztvl.content_owner_id = sd.parent_first_pty_org_id
4567: AND (sd.view_options_code in ('NONE', 'VFC')
4568: or

Line 4605: zx_subscription_details zsd

4601: AND NOT EXISTS
4602: (
4603: SELECT 1
4604: FROM zx_status_b zsvl,
4605: zx_subscription_details zsd
4606: WHERE zsvl.allow_exemptions_flag = 'Y'
4607: AND zsd.tax_regime_code = zsvl.tax_regime_code
4608: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id
4609: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR

Line 4634: zx_subscription_details zsd

4630: AND NOT EXISTS
4631: (
4632: SELECT 1
4633: FROM zx_status_vl zsvl,
4634: zx_subscription_details zsd
4635: WHERE zsvl.allow_exemptions_flag = 'Y'
4636: AND zsd.tax_regime_code = zsvl.tax_regime_code
4637: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id
4638: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR

Line 4673: zx_subscription_details zsd

4669: UPDATE zx_exemptions_int exe_int
4670: SET tax_status_code = (
4671: SELECT zsvl.TAX_STATUS_CODE
4672: FROM zx_status_vl zsvl,
4673: zx_subscription_details zsd
4674: WHERE zsvl.allow_exemptions_flag = 'y'
4675: AND zsd.tax_regime_code = zsvl.tax_regime_code
4676: AND zsd.parent_first_pty_org_id = zsvl.content_owner_id
4677: AND (NVL(zsd.view_options_code,'NONE') IN ('NONE', 'VFC') OR

Line 4790: FROM zx_rates_b zrvl, zx_subscription_details sd

4786: WHERE (( tax_rate_code IS NOT NULL
4787: AND NOT EXISTS
4788: (
4789: SELECT 1
4790: FROM zx_rates_b zrvl, zx_subscription_details sd
4791: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4792: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4793: AND (sd.view_options_code in ('NONE', 'VFC')
4794: or

Line 4819: FROM zx_rates_vl zrvl, zx_subscription_details sd

4815: AND tax_rate_name IS NOT NULL
4816: AND NOT EXISTS
4817: (
4818: SELECT 1
4819: FROM zx_rates_vl zrvl, zx_subscription_details sd
4820: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4821: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4822: AND (sd.view_options_code in ('NONE', 'VFC')
4823: or

Line 4859: FROM zx_rates_vl zrvl, zx_subscription_details sd

4855: -- value to id conversion for tax_rate_code
4856: UPDATE zx_exemptions_int exe_int
4857: SET TAX_RATE_CODE = (
4858: SELECT zrvl.tax_rate_code
4859: FROM zx_rates_vl zrvl, zx_subscription_details sd
4860: WHERE zrvl.tax_regime_code = sd.tax_regime_code
4861: AND zrvl.content_owner_id = sd.parent_first_pty_org_id
4862: AND (sd.view_options_code in ('NONE', 'VFC')
4863: or