APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on FND_GLOBAL

Line 116: fnd_global.user_id , --CREATED_BY

112: 'MIGRATED' , --RECORD_TYPE_CODE
113: NULL , --LEDGER_ID
114: NULL , --CHART_OF_ACCOUNTS_ID
115: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
116: fnd_global.user_id , --CREATED_BY
117: SYSDATE , --CREATION_DATE
118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

Line 118: fnd_global.user_id , --LAST_UPDATED_BY

114: NULL , --CHART_OF_ACCOUNTS_ID
115: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
116: fnd_global.user_id , --CREATED_BY
117: SYSDATE , --CREATION_DATE
118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID

Line 120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

116: fnd_global.user_id , --CREATED_BY
117: SYSDATE , --CREATION_DATE
118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID
123: fnd_global.conc_program_id , --Program Id
124: fnd_global.conc_login_id , --Program Login ID

Line 121: fnd_global.conc_request_id , --Request Id

117: SYSDATE , --CREATION_DATE
118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID
123: fnd_global.conc_program_id , --Program Id
124: fnd_global.conc_login_id , --Program Login ID
125: 1

Line 122: fnd_global.prog_appl_id , --Program Application ID

118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID
123: fnd_global.conc_program_id , --Program Id
124: fnd_global.conc_login_id , --Program Login ID
125: 1
126: FROM DUAL

Line 123: fnd_global.conc_program_id , --Program Id

119: SYSDATE , --LAST_UPDATE_DATE
120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID
123: fnd_global.conc_program_id , --Program Id
124: fnd_global.conc_login_id , --Program Login ID
125: 1
126: FROM DUAL
127: WHERE not exists (select 1

Line 124: fnd_global.conc_login_id , --Program Login ID

120: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
121: fnd_global.conc_request_id , --Request Id
122: fnd_global.prog_appl_id , --Program Application ID
123: fnd_global.conc_program_id , --Program Id
124: fnd_global.conc_login_id , --Program Login ID
125: 1
126: FROM DUAL
127: WHERE not exists (select 1
128: from ZX_DET_FACTOR_TEMPL_B

Line 161: fnd_global.user_id , --CREATED_BY

157: 'MIGRATED' , --RECORD_TYPE_CODE
158: NULL , --LEDGER_ID
159: NULL , --CHART_OF_ACCOUNTS_ID
160: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
161: fnd_global.user_id , --CREATED_BY
162: SYSDATE , --CREATION_DATE
163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

Line 163: fnd_global.user_id , --LAST_UPDATED_BY

159: NULL , --CHART_OF_ACCOUNTS_ID
160: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
161: fnd_global.user_id , --CREATED_BY
162: SYSDATE , --CREATION_DATE
163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID

Line 165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

161: fnd_global.user_id , --CREATED_BY
162: SYSDATE , --CREATION_DATE
163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID
168: fnd_global.conc_program_id , --Program Id
169: fnd_global.conc_login_id , --Program Login ID

Line 166: fnd_global.conc_request_id , --Request Id

162: SYSDATE , --CREATION_DATE
163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID
168: fnd_global.conc_program_id , --Program Id
169: fnd_global.conc_login_id , --Program Login ID
170: 1

Line 167: fnd_global.prog_appl_id , --Program Application ID

163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID
168: fnd_global.conc_program_id , --Program Id
169: fnd_global.conc_login_id , --Program Login ID
170: 1
171: FROM DUAL

Line 168: fnd_global.conc_program_id , --Program Id

164: SYSDATE , --LAST_UPDATE_DATE
165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID
168: fnd_global.conc_program_id , --Program Id
169: fnd_global.conc_login_id , --Program Login ID
170: 1
171: FROM DUAL
172: WHERE not exists (select 1

Line 169: fnd_global.conc_login_id , --Program Login ID

165: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
166: fnd_global.conc_request_id , --Request Id
167: fnd_global.prog_appl_id , --Program Application ID
168: fnd_global.conc_program_id , --Program Id
169: fnd_global.conc_login_id , --Program Login ID
170: 1
171: FROM DUAL
172: WHERE not exists (select 1
173: from ZX_DET_FACTOR_TEMPL_B

Line 197: fnd_global.user_id ,--CREATED_BY

193: Initcap(B.DET_FACTOR_TEMPL_CODE) ,--DET_FACTOR_TEMPL_NAME
194: B.DET_FACTOR_TEMPL_CODE ,--DET_FACTOR_TEMPL_DESC
195: B.DET_FACTOR_TEMPL_ID ,--DET_FACTOR_TEMPL_ID
196: SYSDATE ,--CREATION_DATE
197: fnd_global.user_id ,--CREATED_BY
198: SYSDATE ,--LAST_UPDATE_DATE
199: fnd_global.user_id ,--LAST_UPDATED_BY
200: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
201: FROM

Line 199: fnd_global.user_id ,--LAST_UPDATED_BY

195: B.DET_FACTOR_TEMPL_ID ,--DET_FACTOR_TEMPL_ID
196: SYSDATE ,--CREATION_DATE
197: fnd_global.user_id ,--CREATED_BY
198: SYSDATE ,--LAST_UPDATE_DATE
199: fnd_global.user_id ,--LAST_UPDATED_BY
200: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
201: FROM
202: FND_LANGUAGES L,
203: ZX_DET_FACTOR_TEMPL_B B

Line 200: fnd_global.conc_login_id --LAST_UPDATE_LOGIN

196: SYSDATE ,--CREATION_DATE
197: fnd_global.user_id ,--CREATED_BY
198: SYSDATE ,--LAST_UPDATE_DATE
199: fnd_global.user_id ,--LAST_UPDATED_BY
200: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
201: FROM
202: FND_LANGUAGES L,
203: ZX_DET_FACTOR_TEMPL_B B
204: WHERE

Line 262: fnd_global.conc_request_id , --Request Id

258: 'N' INTERNAL_FLAG,
259: 'N' RECORD_ONLY_FLAG,
260: SYSDATE , --CREATION_DATE
261: SYSDATE , --LAST_UPDATE_DATE
262: fnd_global.conc_request_id , --Request Id
263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

Line 263: fnd_global.prog_appl_id , --Program Application ID

259: 'N' RECORD_ONLY_FLAG,
260: SYSDATE , --CREATION_DATE
261: SYSDATE , --LAST_UPDATE_DATE
262: fnd_global.conc_request_id , --Request Id
263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY

Line 264: fnd_global.conc_program_id , --Program Id

260: SYSDATE , --CREATION_DATE
261: SYSDATE , --LAST_UPDATE_DATE
262: fnd_global.conc_request_id , --Request Id
263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY

Line 265: fnd_global.conc_login_id , --Program Login ID

261: SYSDATE , --LAST_UPDATE_DATE
262: fnd_global.conc_request_id , --Request Id
263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY
269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

Line 267: fnd_global.user_id , --CREATED_BY

263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY
269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
270: 1 OBJECT_VERSION_NUMBER
271: FROM DUAL

Line 268: fnd_global.user_id , --LAST_UPDATED_BY

264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY
269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
270: 1 OBJECT_VERSION_NUMBER
271: FROM DUAL
272: WHERE NOT EXISTS (SELECT 1

Line 269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY
269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
270: 1 OBJECT_VERSION_NUMBER
271: FROM DUAL
272: WHERE NOT EXISTS (SELECT 1
273: FROM ZX_DETERMINING_FACTORS_B

Line 324: fnd_global.conc_request_id , --Request Id

320: 'N' INTERNAL_FLAG,
321: 'N' RECORD_ONLY_FLAG,
322: SYSDATE , --CREATION_DATE
323: SYSDATE , --LAST_UPDATE_DATE
324: fnd_global.conc_request_id , --Request Id
325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

Line 325: fnd_global.prog_appl_id , --Program Application ID

321: 'N' RECORD_ONLY_FLAG,
322: SYSDATE , --CREATION_DATE
323: SYSDATE , --LAST_UPDATE_DATE
324: fnd_global.conc_request_id , --Request Id
325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY

Line 326: fnd_global.conc_program_id , --Program Id

322: SYSDATE , --CREATION_DATE
323: SYSDATE , --LAST_UPDATE_DATE
324: fnd_global.conc_request_id , --Request Id
325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY

Line 327: fnd_global.conc_login_id , --Program Login ID

323: SYSDATE , --LAST_UPDATE_DATE
324: fnd_global.conc_request_id , --Request Id
325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY
331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

Line 329: fnd_global.user_id , --CREATED_BY

325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY
331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
332: 1 OBJECT_VERSION_NUMBER
333: FROM DUAL

Line 330: fnd_global.user_id , --LAST_UPDATED_BY

326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY
331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
332: 1 OBJECT_VERSION_NUMBER
333: FROM DUAL
334: WHERE NOT EXISTS (SELECT 1

Line 331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY
331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
332: 1 OBJECT_VERSION_NUMBER
333: FROM DUAL
334: WHERE NOT EXISTS (SELECT 1
335: FROM ZX_DETERMINING_FACTORS_B

Line 364: fnd_global.user_id ,--CREATED_BY

360: B.DETERMINING_FACTOR_CODE,--DETERMINING_FACTOR_DESC
361: SYSDATE ,--CREATION_DATE
362: SYSDATE ,--LAST_UPDATE_DATE
363: B.DETERMINING_FACTOR_ID ,--DETERMINING_FACTOR_ID
364: fnd_global.user_id ,--CREATED_BY
365: fnd_global.user_id ,--LAST_UPDATED_BY
366: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
367: FROM
368: FND_LANGUAGES L,

Line 365: fnd_global.user_id ,--LAST_UPDATED_BY

361: SYSDATE ,--CREATION_DATE
362: SYSDATE ,--LAST_UPDATE_DATE
363: B.DETERMINING_FACTOR_ID ,--DETERMINING_FACTOR_ID
364: fnd_global.user_id ,--CREATED_BY
365: fnd_global.user_id ,--LAST_UPDATED_BY
366: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
367: FROM
368: FND_LANGUAGES L,
369: ZX_DETERMINING_FACTORS_B B

Line 366: fnd_global.conc_login_id --LAST_UPDATE_LOGIN

362: SYSDATE ,--LAST_UPDATE_DATE
363: B.DETERMINING_FACTOR_ID ,--DETERMINING_FACTOR_ID
364: fnd_global.user_id ,--CREATED_BY
365: fnd_global.user_id ,--LAST_UPDATED_BY
366: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
367: FROM
368: FND_LANGUAGES L,
369: ZX_DETERMINING_FACTORS_B B
370: WHERE

Line 597: fnd_global.user_id ,

593: ALPHANUMERIC_VALUE1 ,
594: 'MIGRATED' ,
595: zx_condition_groups_b_s.nextval ,
596: CONSTRAINT_ID ,
597: fnd_global.user_id ,
598: SYSDATE ,
599: fnd_global.user_id ,
600: SYSDATE ,
601: fnd_global.conc_login_id ,

Line 599: fnd_global.user_id ,

595: zx_condition_groups_b_s.nextval ,
596: CONSTRAINT_ID ,
597: fnd_global.user_id ,
598: SYSDATE ,
599: fnd_global.user_id ,
600: SYSDATE ,
601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,

Line 601: fnd_global.conc_login_id ,

597: fnd_global.user_id ,
598: SYSDATE ,
599: fnd_global.user_id ,
600: SYSDATE ,
601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,
604: fnd_global.conc_program_id ,
605: fnd_global.conc_login_id ,

Line 602: fnd_global.conc_request_id ,

598: SYSDATE ,
599: fnd_global.user_id ,
600: SYSDATE ,
601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,
604: fnd_global.conc_program_id ,
605: fnd_global.conc_login_id ,
606: 1

Line 603: fnd_global.prog_appl_id ,

599: fnd_global.user_id ,
600: SYSDATE ,
601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,
604: fnd_global.conc_program_id ,
605: fnd_global.conc_login_id ,
606: 1
607: )

Line 604: fnd_global.conc_program_id ,

600: SYSDATE ,
601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,
604: fnd_global.conc_program_id ,
605: fnd_global.conc_login_id ,
606: 1
607: )
608: WHEN (not exists

Line 605: fnd_global.conc_login_id ,

601: fnd_global.conc_login_id ,
602: fnd_global.conc_request_id ,
603: fnd_global.prog_appl_id ,
604: fnd_global.conc_program_id ,
605: fnd_global.conc_login_id ,
606: 1
607: )
608: WHEN (not exists
609: (select 1 from zx_conditions

Line 652: fnd_global.user_id ,

648: 'MIGRATED' ,
649: 'N' ,
650: ALPHANUMERIC_VALUE1 ,
651: zx_conditions_s.nextval ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: SYSDATE ,
656: fnd_global.conc_login_id ,

Line 654: fnd_global.user_id ,

650: ALPHANUMERIC_VALUE1 ,
651: zx_conditions_s.nextval ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: SYSDATE ,
656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,

Line 656: fnd_global.conc_login_id ,

652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: SYSDATE ,
656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,
659: fnd_global.conc_program_id ,
660: fnd_global.conc_login_id ,

Line 657: fnd_global.conc_request_id ,

653: SYSDATE ,
654: fnd_global.user_id ,
655: SYSDATE ,
656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,
659: fnd_global.conc_program_id ,
660: fnd_global.conc_login_id ,
661: 1

Line 658: fnd_global.prog_appl_id ,

654: fnd_global.user_id ,
655: SYSDATE ,
656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,
659: fnd_global.conc_program_id ,
660: fnd_global.conc_login_id ,
661: 1
662: )

Line 659: fnd_global.conc_program_id ,

655: SYSDATE ,
656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,
659: fnd_global.conc_program_id ,
660: fnd_global.conc_login_id ,
661: 1
662: )
663: SELECT distinct

Line 660: fnd_global.conc_login_id ,

656: fnd_global.conc_login_id ,
657: fnd_global.conc_request_id ,
658: fnd_global.prog_appl_id ,
659: fnd_global.conc_program_id ,
660: fnd_global.conc_login_id ,
661: 1
662: )
663: SELECT distinct
664: codes.name l_condition_group_code ,

Line 740: fnd_global.user_id ,

736: ALPHANUMERIC_VALUE1 ,
737: 'MIGRATED' ,
738: zx_condition_groups_b_s.nextval ,
739: CONSTRAINT_ID ,
740: fnd_global.user_id ,
741: SYSDATE ,
742: fnd_global.user_id ,
743: SYSDATE ,
744: fnd_global.conc_login_id ,

Line 742: fnd_global.user_id ,

738: zx_condition_groups_b_s.nextval ,
739: CONSTRAINT_ID ,
740: fnd_global.user_id ,
741: SYSDATE ,
742: fnd_global.user_id ,
743: SYSDATE ,
744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,

Line 744: fnd_global.conc_login_id ,

740: fnd_global.user_id ,
741: SYSDATE ,
742: fnd_global.user_id ,
743: SYSDATE ,
744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,
747: fnd_global.conc_program_id ,
748: fnd_global.conc_login_id ,

Line 745: fnd_global.conc_request_id ,

741: SYSDATE ,
742: fnd_global.user_id ,
743: SYSDATE ,
744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,
747: fnd_global.conc_program_id ,
748: fnd_global.conc_login_id ,
749: 1

Line 746: fnd_global.prog_appl_id ,

742: fnd_global.user_id ,
743: SYSDATE ,
744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,
747: fnd_global.conc_program_id ,
748: fnd_global.conc_login_id ,
749: 1
750: )

Line 747: fnd_global.conc_program_id ,

743: SYSDATE ,
744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,
747: fnd_global.conc_program_id ,
748: fnd_global.conc_login_id ,
749: 1
750: )
751: WHEN (not exists

Line 748: fnd_global.conc_login_id ,

744: fnd_global.conc_login_id ,
745: fnd_global.conc_request_id ,
746: fnd_global.prog_appl_id ,
747: fnd_global.conc_program_id ,
748: fnd_global.conc_login_id ,
749: 1
750: )
751: WHEN (not exists
752: (select 1 from zx_conditions

Line 795: fnd_global.user_id ,

791: 'MIGRATED' ,
792: 'N' ,
793: ALPHANUMERIC_VALUE1 ,
794: zx_conditions_s.nextval ,
795: fnd_global.user_id ,
796: SYSDATE ,
797: fnd_global.user_id ,
798: SYSDATE ,
799: fnd_global.conc_login_id ,

Line 797: fnd_global.user_id ,

793: ALPHANUMERIC_VALUE1 ,
794: zx_conditions_s.nextval ,
795: fnd_global.user_id ,
796: SYSDATE ,
797: fnd_global.user_id ,
798: SYSDATE ,
799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,

Line 799: fnd_global.conc_login_id ,

795: fnd_global.user_id ,
796: SYSDATE ,
797: fnd_global.user_id ,
798: SYSDATE ,
799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,
802: fnd_global.conc_program_id ,
803: fnd_global.conc_login_id ,

Line 800: fnd_global.conc_request_id ,

796: SYSDATE ,
797: fnd_global.user_id ,
798: SYSDATE ,
799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,
802: fnd_global.conc_program_id ,
803: fnd_global.conc_login_id ,
804: 1

Line 801: fnd_global.prog_appl_id ,

797: fnd_global.user_id ,
798: SYSDATE ,
799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,
802: fnd_global.conc_program_id ,
803: fnd_global.conc_login_id ,
804: 1
805: )

Line 802: fnd_global.conc_program_id ,

798: SYSDATE ,
799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,
802: fnd_global.conc_program_id ,
803: fnd_global.conc_login_id ,
804: 1
805: )
806: SELECT

Line 803: fnd_global.conc_login_id ,

799: fnd_global.conc_login_id ,
800: fnd_global.conc_request_id ,
801: fnd_global.prog_appl_id ,
802: fnd_global.conc_program_id ,
803: fnd_global.conc_login_id ,
804: 1
805: )
806: SELECT
807: DISTINCT

Line 1086: fnd_global.user_id ,

1082:
1083: 'MIGRATED' ,
1084: zx_condition_groups_b_s.nextval ,
1085: CONSTRAINT_ID ,
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.user_id ,
1089: SYSDATE ,
1090: fnd_global.conc_login_id ,

Line 1088: fnd_global.user_id ,

1084: zx_condition_groups_b_s.nextval ,
1085: CONSTRAINT_ID ,
1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.user_id ,
1089: SYSDATE ,
1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,

Line 1090: fnd_global.conc_login_id ,

1086: fnd_global.user_id ,
1087: SYSDATE ,
1088: fnd_global.user_id ,
1089: SYSDATE ,
1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,
1093: fnd_global.conc_program_id ,
1094: fnd_global.conc_login_id ,

Line 1091: fnd_global.conc_request_id ,

1087: SYSDATE ,
1088: fnd_global.user_id ,
1089: SYSDATE ,
1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,
1093: fnd_global.conc_program_id ,
1094: fnd_global.conc_login_id ,
1095: 1

Line 1092: fnd_global.prog_appl_id ,

1088: fnd_global.user_id ,
1089: SYSDATE ,
1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,
1093: fnd_global.conc_program_id ,
1094: fnd_global.conc_login_id ,
1095: 1
1096: )

Line 1093: fnd_global.conc_program_id ,

1089: SYSDATE ,
1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,
1093: fnd_global.conc_program_id ,
1094: fnd_global.conc_login_id ,
1095: 1
1096: )
1097: -- create conditions for tax_classification_code

Line 1094: fnd_global.conc_login_id ,

1090: fnd_global.conc_login_id ,
1091: fnd_global.conc_request_id ,
1092: fnd_global.prog_appl_id ,
1093: fnd_global.conc_program_id ,
1094: fnd_global.conc_login_id ,
1095: 1
1096: )
1097: -- create conditions for tax_classification_code
1098: WHEN (not exists

Line 1142: fnd_global.user_id ,

1138: 'MIGRATED' ,
1139: 'N' ,
1140: ALPHANUMERIC_VALUE1 ,
1141: zx_conditions_s.nextval ,
1142: fnd_global.user_id ,
1143: SYSDATE ,
1144: fnd_global.user_id ,
1145: SYSDATE ,
1146: fnd_global.conc_login_id ,

Line 1144: fnd_global.user_id ,

1140: ALPHANUMERIC_VALUE1 ,
1141: zx_conditions_s.nextval ,
1142: fnd_global.user_id ,
1143: SYSDATE ,
1144: fnd_global.user_id ,
1145: SYSDATE ,
1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,

Line 1146: fnd_global.conc_login_id ,

1142: fnd_global.user_id ,
1143: SYSDATE ,
1144: fnd_global.user_id ,
1145: SYSDATE ,
1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,
1149: fnd_global.conc_program_id ,
1150: fnd_global.conc_login_id ,

Line 1147: fnd_global.conc_request_id ,

1143: SYSDATE ,
1144: fnd_global.user_id ,
1145: SYSDATE ,
1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,
1149: fnd_global.conc_program_id ,
1150: fnd_global.conc_login_id ,
1151: 1

Line 1148: fnd_global.prog_appl_id ,

1144: fnd_global.user_id ,
1145: SYSDATE ,
1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,
1149: fnd_global.conc_program_id ,
1150: fnd_global.conc_login_id ,
1151: 1
1152: )

Line 1149: fnd_global.conc_program_id ,

1145: SYSDATE ,
1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,
1149: fnd_global.conc_program_id ,
1150: fnd_global.conc_login_id ,
1151: 1
1152: )
1153: -- create condition for product_fisc_classification

Line 1150: fnd_global.conc_login_id ,

1146: fnd_global.conc_login_id ,
1147: fnd_global.conc_request_id ,
1148: fnd_global.prog_appl_id ,
1149: fnd_global.conc_program_id ,
1150: fnd_global.conc_login_id ,
1151: 1
1152: )
1153: -- create condition for product_fisc_classification
1154: WHEN ALPHANUMERIC_VALUE2 IS NOT NULL

Line 1199: fnd_global.user_id ,

1195: 'MIGRATED' ,
1196: 'N' ,
1197: ALPHANUMERIC_VALUE2 ,
1198: zx_conditions_s.nextval ,
1199: fnd_global.user_id ,
1200: SYSDATE ,
1201: fnd_global.user_id ,
1202: SYSDATE ,
1203: fnd_global.conc_login_id ,

Line 1201: fnd_global.user_id ,

1197: ALPHANUMERIC_VALUE2 ,
1198: zx_conditions_s.nextval ,
1199: fnd_global.user_id ,
1200: SYSDATE ,
1201: fnd_global.user_id ,
1202: SYSDATE ,
1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,

Line 1203: fnd_global.conc_login_id ,

1199: fnd_global.user_id ,
1200: SYSDATE ,
1201: fnd_global.user_id ,
1202: SYSDATE ,
1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,
1206: fnd_global.conc_program_id ,
1207: fnd_global.conc_login_id ,

Line 1204: fnd_global.conc_request_id ,

1200: SYSDATE ,
1201: fnd_global.user_id ,
1202: SYSDATE ,
1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,
1206: fnd_global.conc_program_id ,
1207: fnd_global.conc_login_id ,
1208: 1

Line 1205: fnd_global.prog_appl_id ,

1201: fnd_global.user_id ,
1202: SYSDATE ,
1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,
1206: fnd_global.conc_program_id ,
1207: fnd_global.conc_login_id ,
1208: 1
1209: )

Line 1206: fnd_global.conc_program_id ,

1202: SYSDATE ,
1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,
1206: fnd_global.conc_program_id ,
1207: fnd_global.conc_login_id ,
1208: 1
1209: )
1210:

Line 1207: fnd_global.conc_login_id ,

1203: fnd_global.conc_login_id ,
1204: fnd_global.conc_request_id ,
1205: fnd_global.prog_appl_id ,
1206: fnd_global.conc_program_id ,
1207: fnd_global.conc_login_id ,
1208: 1
1209: )
1210:
1211: -- create condition for trx_business_category_code

Line 1257: fnd_global.user_id ,

1253: 'MIGRATED' ,
1254: 'N' ,
1255: ALPHANUMERIC_VALUE3 ,
1256: zx_conditions_s.nextval ,
1257: fnd_global.user_id ,
1258: SYSDATE ,
1259: fnd_global.user_id ,
1260: SYSDATE ,
1261: fnd_global.conc_login_id ,

Line 1259: fnd_global.user_id ,

1255: ALPHANUMERIC_VALUE3 ,
1256: zx_conditions_s.nextval ,
1257: fnd_global.user_id ,
1258: SYSDATE ,
1259: fnd_global.user_id ,
1260: SYSDATE ,
1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,

Line 1261: fnd_global.conc_login_id ,

1257: fnd_global.user_id ,
1258: SYSDATE ,
1259: fnd_global.user_id ,
1260: SYSDATE ,
1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,
1264: fnd_global.conc_program_id ,
1265: fnd_global.conc_login_id ,

Line 1262: fnd_global.conc_request_id ,

1258: SYSDATE ,
1259: fnd_global.user_id ,
1260: SYSDATE ,
1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,
1264: fnd_global.conc_program_id ,
1265: fnd_global.conc_login_id ,
1266: 1

Line 1263: fnd_global.prog_appl_id ,

1259: fnd_global.user_id ,
1260: SYSDATE ,
1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,
1264: fnd_global.conc_program_id ,
1265: fnd_global.conc_login_id ,
1266: 1
1267: )

Line 1264: fnd_global.conc_program_id ,

1260: SYSDATE ,
1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,
1264: fnd_global.conc_program_id ,
1265: fnd_global.conc_login_id ,
1266: 1
1267: )
1268:

Line 1265: fnd_global.conc_login_id ,

1261: fnd_global.conc_login_id ,
1262: fnd_global.conc_request_id ,
1263: fnd_global.prog_appl_id ,
1264: fnd_global.conc_program_id ,
1265: fnd_global.conc_login_id ,
1266: 1
1267: )
1268:
1269: -- create condition for party_fisc_classification

Line 1315: fnd_global.user_id ,

1311: 'MIGRATED' ,
1312: 'N' ,
1313: ALPHANUMERIC_VALUE4 ,
1314: zx_conditions_s.nextval ,
1315: fnd_global.user_id ,
1316: SYSDATE ,
1317: fnd_global.user_id ,
1318: SYSDATE ,
1319: fnd_global.conc_login_id ,

Line 1317: fnd_global.user_id ,

1313: ALPHANUMERIC_VALUE4 ,
1314: zx_conditions_s.nextval ,
1315: fnd_global.user_id ,
1316: SYSDATE ,
1317: fnd_global.user_id ,
1318: SYSDATE ,
1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,

Line 1319: fnd_global.conc_login_id ,

1315: fnd_global.user_id ,
1316: SYSDATE ,
1317: fnd_global.user_id ,
1318: SYSDATE ,
1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,
1322: fnd_global.conc_program_id ,
1323: fnd_global.conc_login_id ,

Line 1320: fnd_global.conc_request_id ,

1316: SYSDATE ,
1317: fnd_global.user_id ,
1318: SYSDATE ,
1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,
1322: fnd_global.conc_program_id ,
1323: fnd_global.conc_login_id ,
1324: 1

Line 1321: fnd_global.prog_appl_id ,

1317: fnd_global.user_id ,
1318: SYSDATE ,
1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,
1322: fnd_global.conc_program_id ,
1323: fnd_global.conc_login_id ,
1324: 1
1325: )

Line 1322: fnd_global.conc_program_id ,

1318: SYSDATE ,
1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,
1322: fnd_global.conc_program_id ,
1323: fnd_global.conc_login_id ,
1324: 1
1325: )
1326:

Line 1323: fnd_global.conc_login_id ,

1319: fnd_global.conc_login_id ,
1320: fnd_global.conc_request_id ,
1321: fnd_global.prog_appl_id ,
1322: fnd_global.conc_program_id ,
1323: fnd_global.conc_login_id ,
1324: 1
1325: )
1326:
1327: SELECT

Line 1407: fnd_global.user_id ,

1403: END
1404: ,
1405: B.CONDITION_GROUP_ID ,
1406: SYSDATE ,
1407: fnd_global.user_id ,
1408: SYSDATE ,
1409: fnd_global.user_id ,
1410: fnd_global.conc_login_id
1411: FROM

Line 1409: fnd_global.user_id ,

1405: B.CONDITION_GROUP_ID ,
1406: SYSDATE ,
1407: fnd_global.user_id ,
1408: SYSDATE ,
1409: fnd_global.user_id ,
1410: fnd_global.conc_login_id
1411: FROM
1412: FND_LANGUAGES L,
1413: ZX_CONDITION_GROUPS_B B

Line 1410: fnd_global.conc_login_id

1406: SYSDATE ,
1407: fnd_global.user_id ,
1408: SYSDATE ,
1409: fnd_global.user_id ,
1410: fnd_global.conc_login_id
1411: FROM
1412: FND_LANGUAGES L,
1413: ZX_CONDITION_GROUPS_B B
1414: WHERE

Line 1528: fnd_global.user_id ,

1524: 'Y' ,--ENABLED_FLAG
1525: 'MIGRATED' ,--RECORD_TYPE_CODE
1526: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1527: CONTENT_OWNER_ID ,
1528: fnd_global.user_id ,
1529: SYSDATE ,
1530: fnd_global.user_id ,
1531: SYSDATE ,
1532: fnd_global.conc_login_id ,

Line 1530: fnd_global.user_id ,

1526: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1527: CONTENT_OWNER_ID ,
1528: fnd_global.user_id ,
1529: SYSDATE ,
1530: fnd_global.user_id ,
1531: SYSDATE ,
1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID

Line 1532: fnd_global.conc_login_id ,

1528: fnd_global.user_id ,
1529: SYSDATE ,
1530: fnd_global.user_id ,
1531: SYSDATE ,
1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID
1535: fnd_global.conc_program_id ,--Program Id
1536: fnd_global.conc_login_id , --Program Login ID

Line 1533: fnd_global.conc_request_id ,--Request Id

1529: SYSDATE ,
1530: fnd_global.user_id ,
1531: SYSDATE ,
1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID
1535: fnd_global.conc_program_id ,--Program Id
1536: fnd_global.conc_login_id , --Program Login ID
1537: 1

Line 1534: fnd_global.prog_appl_id ,--Program Application ID

1530: fnd_global.user_id ,
1531: SYSDATE ,
1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID
1535: fnd_global.conc_program_id ,--Program Id
1536: fnd_global.conc_login_id , --Program Login ID
1537: 1
1538: )

Line 1535: fnd_global.conc_program_id ,--Program Id

1531: SYSDATE ,
1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID
1535: fnd_global.conc_program_id ,--Program Id
1536: fnd_global.conc_login_id , --Program Login ID
1537: 1
1538: )
1539: SELECT

Line 1536: fnd_global.conc_login_id , --Program Login ID

1532: fnd_global.conc_login_id ,
1533: fnd_global.conc_request_id ,--Request Id
1534: fnd_global.prog_appl_id ,--Program Application ID
1535: fnd_global.conc_program_id ,--Program Id
1536: fnd_global.conc_login_id , --Program Login ID
1537: 1
1538: )
1539: SELECT
1540: taxes.TAX L_TAX ,

Line 1611: fnd_global.user_id ,

1607: 'Y' ,--ENABLED_FLAG
1608: 'MIGRATED' ,--RECORD_TYPE_CODE
1609: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1610: CONTENT_OWNER_ID ,
1611: fnd_global.user_id ,
1612: SYSDATE ,
1613: fnd_global.user_id ,
1614: SYSDATE ,
1615: fnd_global.conc_login_id ,

Line 1613: fnd_global.user_id ,

1609: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1610: CONTENT_OWNER_ID ,
1611: fnd_global.user_id ,
1612: SYSDATE ,
1613: fnd_global.user_id ,
1614: SYSDATE ,
1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID

Line 1615: fnd_global.conc_login_id ,

1611: fnd_global.user_id ,
1612: SYSDATE ,
1613: fnd_global.user_id ,
1614: SYSDATE ,
1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID
1618: fnd_global.conc_program_id ,--Program Id
1619: fnd_global.conc_login_id , --Program Login ID

Line 1616: fnd_global.conc_request_id ,--Request Id

1612: SYSDATE ,
1613: fnd_global.user_id ,
1614: SYSDATE ,
1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID
1618: fnd_global.conc_program_id ,--Program Id
1619: fnd_global.conc_login_id , --Program Login ID
1620: 1

Line 1617: fnd_global.prog_appl_id ,--Program Application ID

1613: fnd_global.user_id ,
1614: SYSDATE ,
1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID
1618: fnd_global.conc_program_id ,--Program Id
1619: fnd_global.conc_login_id , --Program Login ID
1620: 1
1621: ) --Bug 5090631

Line 1618: fnd_global.conc_program_id ,--Program Id

1614: SYSDATE ,
1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID
1618: fnd_global.conc_program_id ,--Program Id
1619: fnd_global.conc_login_id , --Program Login ID
1620: 1
1621: ) --Bug 5090631
1622: --Bug 5572117

Line 1619: fnd_global.conc_login_id , --Program Login ID

1615: fnd_global.conc_login_id ,
1616: fnd_global.conc_request_id ,--Request Id
1617: fnd_global.prog_appl_id ,--Program Application ID
1618: fnd_global.conc_program_id ,--Program Id
1619: fnd_global.conc_login_id , --Program Login ID
1620: 1
1621: ) --Bug 5090631
1622: --Bug 5572117
1623: SELECT DISTINCT

Line 1748: fnd_global.user_id ,

1744: ENABLED_FLAG ,
1745: 'MIGRATED' ,--RECORD_TYPE_CODE
1746: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1747: CONTENT_OWNER_ID ,
1748: fnd_global.user_id ,
1749: SYSDATE ,
1750: fnd_global.user_id ,
1751: SYSDATE ,
1752: fnd_global.conc_login_id ,

Line 1750: fnd_global.user_id ,

1746: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1747: CONTENT_OWNER_ID ,
1748: fnd_global.user_id ,
1749: SYSDATE ,
1750: fnd_global.user_id ,
1751: SYSDATE ,
1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID

Line 1752: fnd_global.conc_login_id ,

1748: fnd_global.user_id ,
1749: SYSDATE ,
1750: fnd_global.user_id ,
1751: SYSDATE ,
1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID
1755: fnd_global.conc_program_id ,--Program Id
1756: fnd_global.conc_login_id ,--Program Login ID

Line 1753: fnd_global.conc_request_id ,--Request Id

1749: SYSDATE ,
1750: fnd_global.user_id ,
1751: SYSDATE ,
1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID
1755: fnd_global.conc_program_id ,--Program Id
1756: fnd_global.conc_login_id ,--Program Login ID
1757: 1

Line 1754: fnd_global.prog_appl_id ,--Program Application ID

1750: fnd_global.user_id ,
1751: SYSDATE ,
1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID
1755: fnd_global.conc_program_id ,--Program Id
1756: fnd_global.conc_login_id ,--Program Login ID
1757: 1
1758: )

Line 1755: fnd_global.conc_program_id ,--Program Id

1751: SYSDATE ,
1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID
1755: fnd_global.conc_program_id ,--Program Id
1756: fnd_global.conc_login_id ,--Program Login ID
1757: 1
1758: )
1759: SELECT

Line 1756: fnd_global.conc_login_id ,--Program Login ID

1752: fnd_global.conc_login_id ,
1753: fnd_global.conc_request_id ,--Request Id
1754: fnd_global.prog_appl_id ,--Program Application ID
1755: fnd_global.conc_program_id ,--Program Id
1756: fnd_global.conc_login_id ,--Program Login ID
1757: 1
1758: )
1759: SELECT
1760: taxes.TAX TAX ,

Line 1911: fnd_global.user_id ,

1907: 'Y' ,--ENABLED_FLAG
1908: 'MIGRATED' ,--RECORD_TYPE_CODE
1909: 'LEASE_MGT_RATE_DET_TEMPL' ,--DET_FACTOR_TEMPL_CODE
1910: CONTENT_OWNER_ID ,
1911: fnd_global.user_id ,
1912: SYSDATE ,
1913: fnd_global.user_id ,
1914: SYSDATE ,
1915: fnd_global.conc_login_id ,

Line 1913: fnd_global.user_id ,

1909: 'LEASE_MGT_RATE_DET_TEMPL' ,--DET_FACTOR_TEMPL_CODE
1910: CONTENT_OWNER_ID ,
1911: fnd_global.user_id ,
1912: SYSDATE ,
1913: fnd_global.user_id ,
1914: SYSDATE ,
1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID

Line 1915: fnd_global.conc_login_id ,

1911: fnd_global.user_id ,
1912: SYSDATE ,
1913: fnd_global.user_id ,
1914: SYSDATE ,
1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID
1918: fnd_global.conc_program_id ,--Program Id
1919: fnd_global.conc_login_id , --Program Login ID

Line 1916: fnd_global.conc_request_id ,--Request Id

1912: SYSDATE ,
1913: fnd_global.user_id ,
1914: SYSDATE ,
1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID
1918: fnd_global.conc_program_id ,--Program Id
1919: fnd_global.conc_login_id , --Program Login ID
1920: 1

Line 1917: fnd_global.prog_appl_id ,--Program Application ID

1913: fnd_global.user_id ,
1914: SYSDATE ,
1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID
1918: fnd_global.conc_program_id ,--Program Id
1919: fnd_global.conc_login_id , --Program Login ID
1920: 1
1921: ) --Bug 5090631

Line 1918: fnd_global.conc_program_id ,--Program Id

1914: SYSDATE ,
1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID
1918: fnd_global.conc_program_id ,--Program Id
1919: fnd_global.conc_login_id , --Program Login ID
1920: 1
1921: ) --Bug 5090631
1922: SELECT DISTINCT

Line 1919: fnd_global.conc_login_id , --Program Login ID

1915: fnd_global.conc_login_id ,
1916: fnd_global.conc_request_id ,--Request Id
1917: fnd_global.prog_appl_id ,--Program Application ID
1918: fnd_global.conc_program_id ,--Program Id
1919: fnd_global.conc_login_id , --Program Login ID
1920: 1
1921: ) --Bug 5090631
1922: SELECT DISTINCT
1923: taxes.TAX L_TAX ,

Line 2049: fnd_global.user_id ,

2045: B.TAX_RULE_CODE
2046: END ,
2047: B.TAX_RULE_ID ,
2048: SYSDATE ,
2049: fnd_global.user_id ,
2050: SYSDATE ,
2051: fnd_global.user_id ,
2052: fnd_global.conc_login_id
2053: FROM

Line 2051: fnd_global.user_id ,

2047: B.TAX_RULE_ID ,
2048: SYSDATE ,
2049: fnd_global.user_id ,
2050: SYSDATE ,
2051: fnd_global.user_id ,
2052: fnd_global.conc_login_id
2053: FROM
2054: FND_LANGUAGES L,
2055: ZX_RULES_B B

Line 2052: fnd_global.conc_login_id

2048: SYSDATE ,
2049: fnd_global.user_id ,
2050: SYSDATE ,
2051: fnd_global.user_id ,
2052: fnd_global.conc_login_id
2053: FROM
2054: FND_LANGUAGES L,
2055: ZX_RULES_B B
2056: WHERE

Line 2321: ,fnd_global.user_id --CREATED_BY

2317: ,tax.PARENT_GEOGRAPHY_TYPE
2318: ,tax.PARENT_GEOGRAPHY_ID
2319: ,tax.ALLOW_MASS_CREATE_FLAG
2320: ,tax.APPLIED_AMT_HANDLING_FLAG
2321: ,fnd_global.user_id --CREATED_BY
2322: ,SYSDATE --CREATION_DATE
2323: ,fnd_global.user_id --LAST_UPDATED_BY
2324: ,SYSDATE --LAST_UPDATE_DATE
2325: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN

Line 2323: ,fnd_global.user_id --LAST_UPDATED_BY

2319: ,tax.ALLOW_MASS_CREATE_FLAG
2320: ,tax.APPLIED_AMT_HANDLING_FLAG
2321: ,fnd_global.user_id --CREATED_BY
2322: ,SYSDATE --CREATION_DATE
2323: ,fnd_global.user_id --LAST_UPDATED_BY
2324: ,SYSDATE --LAST_UPDATE_DATE
2325: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN
2326: ,tax.REQUEST_ID
2327: ,tax.PROGRAM_APPLICATION_ID

Line 2325: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN

2321: ,fnd_global.user_id --CREATED_BY
2322: ,SYSDATE --CREATION_DATE
2323: ,fnd_global.user_id --LAST_UPDATED_BY
2324: ,SYSDATE --LAST_UPDATE_DATE
2325: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN
2326: ,tax.REQUEST_ID
2327: ,tax.PROGRAM_APPLICATION_ID
2328: ,tax.PROGRAM_ID
2329: ,tax.RECORD_TYPE_CODE

Line 2498: fnd_global.user_id ,

2494: zx_process_results_s.nextval ,--RESULT_ID
2495: CONTENT_OWNER_ID ,
2496: CONDITION_GROUP_ID ,
2497: TAX_RULE_ID ,
2498: fnd_global.user_id ,
2499: SYSDATE ,
2500: fnd_global.user_id ,
2501: SYSDATE ,
2502: fnd_global.conc_login_id ,

Line 2500: fnd_global.user_id ,

2496: CONDITION_GROUP_ID ,
2497: TAX_RULE_ID ,
2498: fnd_global.user_id ,
2499: SYSDATE ,
2500: fnd_global.user_id ,
2501: SYSDATE ,
2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID

Line 2502: fnd_global.conc_login_id ,

2498: fnd_global.user_id ,
2499: SYSDATE ,
2500: fnd_global.user_id ,
2501: SYSDATE ,
2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID
2505: fnd_global.conc_program_id ,--Program Id
2506: fnd_global.conc_login_id ,--Program Login ID

Line 2503: fnd_global.conc_request_id ,--Request Id

2499: SYSDATE ,
2500: fnd_global.user_id ,
2501: SYSDATE ,
2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID
2505: fnd_global.conc_program_id ,--Program Id
2506: fnd_global.conc_login_id ,--Program Login ID
2507: 1

Line 2504: fnd_global.prog_appl_id ,--Program Application ID

2500: fnd_global.user_id ,
2501: SYSDATE ,
2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID
2505: fnd_global.conc_program_id ,--Program Id
2506: fnd_global.conc_login_id ,--Program Login ID
2507: 1
2508: FROM

Line 2505: fnd_global.conc_program_id ,--Program Id

2501: SYSDATE ,
2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID
2505: fnd_global.conc_program_id ,--Program Id
2506: fnd_global.conc_login_id ,--Program Login ID
2507: 1
2508: FROM
2509: (

Line 2506: fnd_global.conc_login_id ,--Program Login ID

2502: fnd_global.conc_login_id ,
2503: fnd_global.conc_request_id ,--Request Id
2504: fnd_global.prog_appl_id ,--Program Application ID
2505: fnd_global.conc_program_id ,--Program Id
2506: fnd_global.conc_login_id ,--Program Login ID
2507: 1
2508: FROM
2509: (
2510: /* Bug 5061471 : Commenting this as we no longer require creation of process results for simple taxes

Line 2663: fnd_global.user_id ,

2659: CONDITION_GROUP_ID ,
2660: TAX_RULE_ID ,
2661: CONDITION_SET_ID ,
2662: EXCEPTION_SET_ID ,
2663: fnd_global.user_id ,
2664: SYSDATE ,
2665: fnd_global.user_id ,
2666: SYSDATE ,
2667: fnd_global.conc_login_id ,

Line 2665: fnd_global.user_id ,

2661: CONDITION_SET_ID ,
2662: EXCEPTION_SET_ID ,
2663: fnd_global.user_id ,
2664: SYSDATE ,
2665: fnd_global.user_id ,
2666: SYSDATE ,
2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID

Line 2667: fnd_global.conc_login_id ,

2663: fnd_global.user_id ,
2664: SYSDATE ,
2665: fnd_global.user_id ,
2666: SYSDATE ,
2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID
2670: fnd_global.conc_program_id ,--Program Id
2671: fnd_global.conc_login_id ,--Program Login ID

Line 2668: fnd_global.conc_request_id ,--Request Id

2664: SYSDATE ,
2665: fnd_global.user_id ,
2666: SYSDATE ,
2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID
2670: fnd_global.conc_program_id ,--Program Id
2671: fnd_global.conc_login_id ,--Program Login ID
2672: 1

Line 2669: fnd_global.prog_appl_id ,--Program Application ID

2665: fnd_global.user_id ,
2666: SYSDATE ,
2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID
2670: fnd_global.conc_program_id ,--Program Id
2671: fnd_global.conc_login_id ,--Program Login ID
2672: 1
2673: FROM

Line 2670: fnd_global.conc_program_id ,--Program Id

2666: SYSDATE ,
2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID
2670: fnd_global.conc_program_id ,--Program Id
2671: fnd_global.conc_login_id ,--Program Login ID
2672: 1
2673: FROM
2674: (

Line 2671: fnd_global.conc_login_id ,--Program Login ID

2667: fnd_global.conc_login_id ,
2668: fnd_global.conc_request_id ,--Request Id
2669: fnd_global.prog_appl_id ,--Program Application ID
2670: fnd_global.conc_program_id ,--Program Id
2671: fnd_global.conc_login_id ,--Program Login ID
2672: 1
2673: FROM
2674: (
2675: SELECT

Line 2841: fnd_global.conc_request_id, -- REQUEST_ID ,

2837: 'Y' , --ALLOW_EXCEPTIONS_FLAG ,
2838: 'MIGRATED' , --RECORD_TYPE_CODE ,
2839: sysdate , -- CREATION_DATE ,
2840: sysdate , -- LAST_UPDATE_DATE ,
2841: fnd_global.conc_request_id, -- REQUEST_ID ,
2842: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
2843: NULL, -- PROGRAM_ID ,
2844: CONDITION_SET_ID ,
2845: EXCEPTION_SET_ID ,

Line 2842: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

2838: 'MIGRATED' , --RECORD_TYPE_CODE ,
2839: sysdate , -- CREATION_DATE ,
2840: sysdate , -- LAST_UPDATE_DATE ,
2841: fnd_global.conc_request_id, -- REQUEST_ID ,
2842: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
2843: NULL, -- PROGRAM_ID ,
2844: CONDITION_SET_ID ,
2845: EXCEPTION_SET_ID ,
2846: NULL , -- PROGRAM_LOGIN_ID ,

Line 2851: fnd_global.user_id , --CREATED_BY ,

2847: zx_process_results_s.nextval,
2848: CONTENT_OWNER_ID ,
2849: condition_group_id,
2850: tax_rule_id,
2851: fnd_global.user_id , --CREATED_BY ,
2852: fnd_global.user_id , --LAST_UPDATED_BY ,
2853: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
2854: NULL , -- RESULT_API ,
2855: 1 --OBJECT_VERSION_NUMBER

Line 2852: fnd_global.user_id , --LAST_UPDATED_BY ,

2848: CONTENT_OWNER_ID ,
2849: condition_group_id,
2850: tax_rule_id,
2851: fnd_global.user_id , --CREATED_BY ,
2852: fnd_global.user_id , --LAST_UPDATED_BY ,
2853: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
2854: NULL , -- RESULT_API ,
2855: 1 --OBJECT_VERSION_NUMBER
2856: FROM

Line 2853: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

2849: condition_group_id,
2850: tax_rule_id,
2851: fnd_global.user_id , --CREATED_BY ,
2852: fnd_global.user_id , --LAST_UPDATED_BY ,
2853: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
2854: NULL , -- RESULT_API ,
2855: 1 --OBJECT_VERSION_NUMBER
2856: FROM
2857: (

Line 3029: fnd_global.conc_request_id, -- REQUEST_ID ,

3025: NULL , --ALLOW_EXCEPTIONS_FLAG ,
3026: 'MIGRATED' , --RECORD_TYPE_CODE ,
3027: sysdate , -- CREATION_DATE ,
3028: sysdate , -- LAST_UPDATE_DATE ,
3029: fnd_global.conc_request_id, -- REQUEST_ID ,
3030: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3031: NULL, -- PROGRAM_ID ,
3032: CONDITION_SET_ID ,
3033: EXCEPTION_SET_ID ,

Line 3030: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

3026: 'MIGRATED' , --RECORD_TYPE_CODE ,
3027: sysdate , -- CREATION_DATE ,
3028: sysdate , -- LAST_UPDATE_DATE ,
3029: fnd_global.conc_request_id, -- REQUEST_ID ,
3030: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3031: NULL, -- PROGRAM_ID ,
3032: CONDITION_SET_ID ,
3033: EXCEPTION_SET_ID ,
3034: NULL , -- PROGRAM_LOGIN_ID ,

Line 3039: fnd_global.user_id , --CREATED_BY ,

3035: zx_process_results_s.nextval,
3036: CONTENT_OWNER_ID ,
3037: condition_group_id,
3038: tax_rule_id,
3039: fnd_global.user_id , --CREATED_BY ,
3040: fnd_global.user_id , --LAST_UPDATED_BY ,
3041: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3042: NULL , -- RESULT_API ,
3043: 1 --OBJECT_VERSION_NUMBER

Line 3040: fnd_global.user_id , --LAST_UPDATED_BY ,

3036: CONTENT_OWNER_ID ,
3037: condition_group_id,
3038: tax_rule_id,
3039: fnd_global.user_id , --CREATED_BY ,
3040: fnd_global.user_id , --LAST_UPDATED_BY ,
3041: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3042: NULL , -- RESULT_API ,
3043: 1 --OBJECT_VERSION_NUMBER
3044: FROM

Line 3041: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

3037: condition_group_id,
3038: tax_rule_id,
3039: fnd_global.user_id , --CREATED_BY ,
3040: fnd_global.user_id , --LAST_UPDATED_BY ,
3041: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3042: NULL , -- RESULT_API ,
3043: 1 --OBJECT_VERSION_NUMBER
3044: FROM
3045: (

Line 3243: fnd_global.conc_request_id, -- REQUEST_ID ,

3239: NULL , --ALLOW_EXCEPTIONS_FLAG ,
3240: 'MIGRATED' , --RECORD_TYPE_CODE ,
3241: sysdate , -- CREATION_DATE ,
3242: sysdate , -- LAST_UPDATE_DATE ,
3243: fnd_global.conc_request_id, -- REQUEST_ID ,
3244: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3245: NULL, -- PROGRAM_ID ,
3246: CONDITION_SET_ID ,
3247: EXCEPTION_SET_ID ,

Line 3244: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

3240: 'MIGRATED' , --RECORD_TYPE_CODE ,
3241: sysdate , -- CREATION_DATE ,
3242: sysdate , -- LAST_UPDATE_DATE ,
3243: fnd_global.conc_request_id, -- REQUEST_ID ,
3244: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3245: NULL, -- PROGRAM_ID ,
3246: CONDITION_SET_ID ,
3247: EXCEPTION_SET_ID ,
3248: NULL , -- PROGRAM_LOGIN_ID ,

Line 3253: fnd_global.user_id , --CREATED_BY ,

3249: zx_process_results_s.nextval,
3250: CONTENT_OWNER_ID ,
3251: condition_group_id,
3252: tax_rule_id,
3253: fnd_global.user_id , --CREATED_BY ,
3254: fnd_global.user_id , --LAST_UPDATED_BY ,
3255: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3256: NULL , -- RESULT_API ,
3257: 1 --OBJECT_VERSION_NUMBER

Line 3254: fnd_global.user_id , --LAST_UPDATED_BY ,

3250: CONTENT_OWNER_ID ,
3251: condition_group_id,
3252: tax_rule_id,
3253: fnd_global.user_id , --CREATED_BY ,
3254: fnd_global.user_id , --LAST_UPDATED_BY ,
3255: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3256: NULL , -- RESULT_API ,
3257: 1 --OBJECT_VERSION_NUMBER
3258: FROM

Line 3255: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

3251: condition_group_id,
3252: tax_rule_id,
3253: fnd_global.user_id , --CREATED_BY ,
3254: fnd_global.user_id , --LAST_UPDATED_BY ,
3255: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3256: NULL , -- RESULT_API ,
3257: 1 --OBJECT_VERSION_NUMBER
3258: FROM
3259: (