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 2099: gl_sets_of_books gsob,

2095: FROM
2096: ar_vat_tax_all_b avt,
2097: zx_party_tax_profile ptp,
2098: ar_system_parameters_all asp,
2099: gl_sets_of_books gsob,
2100: zx_regimes_b zrb
2101: WHERE avt.org_id = ptp.party_id
2102: AND ptp.party_type_code = 'OU'
2103: AND avt.org_id = asp.org_id

Line 2513: gl_sets_of_books gsob,

2509: FROM
2510: ar_vat_tax_all_b avt,
2511: zx_party_tax_profile ptp,
2512: ar_system_parameters_all asp,
2513: gl_sets_of_books gsob,
2514: zx_regimes_b zrb
2515: WHERE avt.org_id = ptp.party_id
2516: AND avt.org_id = l_org_id
2517: AND ptp.party_type_code = 'OU'

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

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

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

5569: 'JL.CL.ARXSUVAT.VAT_TAX',
5570: fnd_flex_ext.get_ccid
5571: ( 'SQLGL',
5572: 'GL#',
5573: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),
5574: sysdate,
5575: codes.global_attribute5),
5576: NULL) NON_REC_ACCOUNT_CCID, -- Bug 4779027
5577: DECODE(nvl(codes.validate_flag, 'N'),

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

5923: 'JL.CL.ARXSUVAT.VAT_TAX',
5924: fnd_flex_ext.get_ccid
5925: ( 'SQLGL',
5926: 'GL#',
5927: (SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = codes.set_of_books_id),
5928: sysdate,
5929: codes.global_attribute5),
5930: NULL) L_NON_REC_ACCOUNT_CCID, -- Bug 4779027
5931: DECODE(nvl(codes.validate_flag, 'N'),

Line 7668: GL_SETS_OF_BOOKS SOB,

7664: FROM
7665: ZX_RATES_B RATES,
7666: ZX_UPDATE_CRITERIA_RESULTS results,
7667: AR_SYSTEM_PARAMETERS_ALL ARP,
7668: GL_SETS_OF_BOOKS SOB,
7669: ZX_PARTY_TAX_PROFILE PTP
7670: WHERE
7671: -- Bug 4691005 : 1. removed nvl source_id
7672: -- 2. added condition for tax_class

Line 8021: GL_SETS_OF_BOOKS SOB,

8017: FROM
8018: ZX_RATES_B RATES,
8019: ZX_UPDATE_CRITERIA_RESULTS results,
8020: AR_SYSTEM_PARAMETERS_ALL ARP,
8021: GL_SETS_OF_BOOKS SOB,
8022: ZX_PARTY_TAX_PROFILE PTP
8023: WHERE
8024: -- Bug 4691005 : 1. removed nvl source_id
8025: -- 2. added condition for tax_class