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

Line 446: gl_sets_of_books gsob

442: fnd_id_flex_segments segment,
443: fnd_segment_attribute_values qual,
444: ar_system_parameters_all asp,
445: ar_vat_tax_all_b avt,
446: gl_sets_of_books gsob
447: WHERE str.id_flex_code = 'RLOC'
448: AND str.application_id = 222
449: AND str.application_id = segment.application_id
450: AND str.id_flex_num = segment.id_flex_num

Line 2185: gl_sets_of_books gsob,

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
2188: AND ptp.party_type_code = 'OU'
2189: AND avt.org_id = asp.org_id

Line 2600: gl_sets_of_books gsob,

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
2603: AND avt.org_id = l_org_id
2604: AND ptp.party_type_code = 'OU'

Line 5228: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),

5224: 'JL.CL.ARXSUVAT.VAT_TAX',
5225: fnd_flex_ext.get_ccid
5226: ( 'SQLGL',
5227: 'GL#',
5228: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),
5229: sysdate,
5230: codes.global_attribute5),
5231: NULL) NON_REC_ACCOUNT_CCID, -- Bug 4779027
5232: DECODE(nvl(codes.validate_flag, 'N'),

Line 5583: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),

5579: 'JL.CL.ARXSUVAT.VAT_TAX',
5580: fnd_flex_ext.get_ccid
5581: ( 'SQLGL',
5582: 'GL#',
5583: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),
5584: sysdate,
5585: codes.global_attribute5),
5586: NULL) NON_REC_ACCOUNT_CCID, -- Bug 4779027
5587: DECODE(nvl(codes.validate_flag, 'N'),

Line 5939: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),

5935: 'JL.CL.ARXSUVAT.VAT_TAX',
5936: fnd_flex_ext.get_ccid
5937: ( 'SQLGL',
5938: 'GL#',
5939: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),
5940: sysdate,
5941: codes.global_attribute5),
5942: NULL) L_NON_REC_ACCOUNT_CCID, -- Bug 4779027
5943: DECODE(nvl(codes.validate_flag, 'N'),

Line 7680: GL_SETS_OF_BOOKS SOB,

7676: FROM
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

Line 8033: GL_SETS_OF_BOOKS SOB,

8029: FROM
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