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_MIGRATE_AR_TAX_DEF dependencies on ZX_PARTY_TAX_PROFILE

Line 249: zx_party_tax_profile zptp

245: p_tax,
246: p_tax_status_code,
247: p_tax_rate_code
248: FROM zx_rates_b zrb,
249: zx_party_tax_profile zptp
250: WHERE
251: zptp.party_type_code = 'OU'
252: AND zptp.party_tax_profile_id = zrb.content_owner_id
253: AND zrb.record_type_code = 'MIGRATED'

Line 471: FROM zx_party_tax_profile ptp,

467:
468: CURSOR loc_rate_csr IS
469: SELECT tax_regime_code,tax,party_tax_profile_id,
470: org_id,location_tax_account,set_of_books_id
471: FROM zx_party_tax_profile ptp,
472: ar_system_parameters_all asp,
473: zx_taxes_b tax
474: WHERE ptp.party_type_code = 'OU'
475: AND ptp.party_id = asp.org_id

Line 2183: zx_party_tax_profile ptp,

2179: NULL L_TAX_EXMPT_SOURCE_TAX,
2180: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2181: FROM
2182: ar_vat_tax_all_b avt,
2183: zx_party_tax_profile ptp,
2184: ar_system_parameters_all asp,
2185: gl_sets_of_books gsob,
2186: zx_regimes_b zrb
2187: WHERE avt.org_id = ptp.party_id

Line 2598: zx_party_tax_profile ptp,

2594: NULL L_TAX_EXMPT_SOURCE_TAX,
2595: 'N' L_APPLICABLE_BY_DEFAULT_FLAG --Bug 4905771
2596: FROM
2597: ar_vat_tax_all_b avt,
2598: zx_party_tax_profile ptp,
2599: ar_system_parameters_all asp,
2600: gl_sets_of_books gsob,
2601: zx_regimes_b zrb
2602: WHERE avt.org_id = ptp.party_id

Line 3101: zx_party_tax_profile ptp,

3097: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3098: FROM
3099: zx_status_b status,
3100: ar_vat_tax_all_b codes,
3101: zx_party_tax_profile ptp,
3102: ar_system_parameters_all asp
3103: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3104: AND status.tax = 'LOCATION'
3105: AND status.tax_status_code = 'STANDARD'

Line 3436: zx_party_tax_profile ptp,

3432: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
3433: FROM
3434: zx_status_b status,
3435: ar_vat_tax_all_b codes,
3436: zx_party_tax_profile ptp,
3437: ar_system_parameters_all asp
3438: WHERE status.tax_regime_code like '%-SALES-TAX-%'
3439: AND status.tax = 'LOCATION'
3440: AND status.tax_status_code = 'STANDARD'

Line 3601: FROM zx_party_tax_profile ptp,

3597:
3598: CURSOR loc_rate_csr IS
3599: SELECT tax_regime_code,tax,party_tax_profile_id,
3600: org_id,location_tax_account,set_of_books_id
3601: FROM zx_party_tax_profile ptp,
3602: ar_system_parameters_all asp,
3603: zx_taxes_b tax
3604: WHERE ptp.party_type_code = 'OU'
3605: AND ptp.party_id = asp.org_id

Line 4399: zx_party_tax_profile ptp,

4395: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4396: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4397: FROM
4398: ar_vat_tax_all_b avt,
4399: zx_party_tax_profile ptp,
4400: ar_system_parameters_all asp,
4401: zx_regimes_b zrb,
4402: zx_taxes_b ztb
4403: WHERE ptp.party_type_code = 'OU'

Line 4731: zx_party_tax_profile ptp,

4727: DECODE(avt.tax_class, 'I', 'INPUT', 'O', 'OUTPUT') L_TAX_CLASS,
4728: avt.DESCRIPTION DESCRIPTION -- Bug 4705196
4729: FROM
4730: ar_vat_tax_all_b avt,
4731: zx_party_tax_profile ptp,
4732: ar_system_parameters_all asp,
4733: zx_regimes_b zrb,
4734: zx_taxes_b ztb
4735: WHERE ptp.party_type_code = 'OU'

Line 4786: -- zx_party_tax_profile ptp

4782: -- location_tax_account_rec,
4783: -- set_of_books_id_rec,
4784: -- location_structure_id_rec
4785: -- FROM ar_system_parameters_all asp,
4786: -- zx_party_tax_profile ptp
4787: -- WHERE ptp.party_type_code = 'OU'
4788: -- AND ptp.party_id = asp.org_id
4789: -- AND asp.tax_database_view_set IN ('_A', '_V');
4790: -- ELSE

Line 4803: -- zx_party_tax_profile ptp

4799: -- location_tax_account_rec,
4800: -- set_of_books_id_rec,
4801: -- location_structure_id_rec
4802: -- FROM ar_system_parameters_all asp,
4803: -- zx_party_tax_profile ptp
4804: -- WHERE ptp.party_type_code = 'OU'
4805: -- AND ptp.party_id = asp.org_id
4806: -- AND asp.org_id = l_org_id
4807: -- AND asp.tax_database_view_set IN ('_A', '_V');

Line 5246: zx_party_tax_profile ptp,

5242: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5243: FROM
5244: zx_update_criteria_results results,
5245: ar_vat_tax_all_b codes,
5246: zx_party_tax_profile ptp,
5247: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5248: WHERE
5249: results.tax_code_id = codes.vat_tax_id
5250: AND results.tax_class = 'OUTPUT'

Line 5601: zx_party_tax_profile ptp,

5597: 'N' ALLOW_EXCEPTIONS_FLAG --Bug 5505935
5598: FROM
5599: zx_update_criteria_results results,
5600: ar_vat_tax_all_b codes,
5601: zx_party_tax_profile ptp,
5602: ar_system_parameters_all asp --Bug 3985196: Tax Vendor Handling
5603: WHERE
5604: results.tax_code_id = codes.vat_tax_id
5605: AND results.tax_class = 'OUTPUT'

Line 5952: zx_party_tax_profile ptp,

5948: DECODE (codes.TAXABLE_BASIS, 'AFTER_EPD', 'STANDARD_TB_DISCOUNT','STANDARD_TB') L_TAXABLE_BASIS_FORMULA,
5949: codes.DESCRIPTION DESCRIPTION -- Bug 4705196
5950: FROM
5951: ar_vat_tax_all_b codes,
5952: zx_party_tax_profile ptp,
5953: ar_system_parameters_all params,
5954: jl_zz_ar_tx_categ_all categs
5955: WHERE
5956: codes.tax_type <> 'TAX_GROUP'

Line 6135: zx_party_tax_profile zptp

6131: BEGIN
6132: SELECT ztb.tax
6133: INTO l_tax
6134: FROM zx_taxes_b ztb,
6135: zx_party_tax_profile zptp
6136: WHERE ztb.content_owner_id = zptp.party_tax_profile_id
6137: AND zptp.party_type_code = 'OU'
6138: AND zptp.party_id = l_org_id
6139: AND ztb.tax = 'LOCATION'

Line 7681: ZX_PARTY_TAX_PROFILE PTP

7677: ZX_RATES_B RATES,
7678: ZX_UPDATE_CRITERIA_RESULTS results,
7679: AR_SYSTEM_PARAMETERS_ALL ARP,
7680: GL_SETS_OF_BOOKS SOB,
7681: ZX_PARTY_TAX_PROFILE PTP
7682: WHERE
7683: -- Bug 4691005 : 1. removed nvl source_id
7684: -- 2. added condition for tax_class
7685: RESULTS.tax_code_id = rates.tax_rate_id

Line 8034: ZX_PARTY_TAX_PROFILE PTP

8030: ZX_RATES_B RATES,
8031: ZX_UPDATE_CRITERIA_RESULTS results,
8032: AR_SYSTEM_PARAMETERS_ALL ARP,
8033: GL_SETS_OF_BOOKS SOB,
8034: ZX_PARTY_TAX_PROFILE PTP
8035: WHERE
8036: -- Bug 4691005 : 1. removed nvl source_id
8037: -- 2. added condition for tax_class
8038: RESULTS.tax_code_id = rates.tax_rate_id

Line 8829: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile

8825: update zx_taxes_b_tmp
8826: set allow_manual_entry_flag = 'N',
8827: allow_tax_override_flag = 'N',
8828: object_version_number = object_version_number + 1
8829: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8830: where party_id= to_number(l_org_id(i))
8831: and party_type_code='OU')
8832: and record_type_code='MIGRATED';
8833:

Line 8843: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile

8839: BEGIN
8840: update zx_status_b_tmp
8841: set allow_rate_override_flag = 'N',
8842: object_version_number = object_version_number + 1
8843: where content_owner_id = (select party_tax_profile_id from zx_party_tax_profile
8844: where party_id= to_number(l_org_id(i))
8845: and party_type_code='OU')
8846: and record_type_code='MIGRATED';
8847:

Line 10317: FROM zx_party_tax_profile

10313: l_allow_exceptions_flag VARCHAR2(100);
10314: BEGIN
10315: FOR cursor_rec IN (SELECT party_id,
10316: party_tax_profile_id
10317: FROM zx_party_tax_profile
10318: WHERE party_tax_profile_id IN (SELECT content_owner_id
10319: FROM zx_rates_b
10320: WHERE tax_class = 'OUTPUT'
10321: INTERSECT