APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on FND_GLOBAL

Line 118: fnd_global.user_id , --CREATED_BY

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

Line 120: fnd_global.user_id , --LAST_UPDATED_BY

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

Line 122: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

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

Line 123: fnd_global.conc_request_id , --Request Id

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

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

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

Line 125: fnd_global.conc_program_id , --Program Id

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

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

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

Line 163: fnd_global.user_id , --CREATED_BY

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

Line 165: fnd_global.user_id , --LAST_UPDATED_BY

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

Line 167: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

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

Line 168: fnd_global.conc_request_id , --Request Id

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

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

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

Line 170: fnd_global.conc_program_id , --Program Id

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

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

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

Line 199: fnd_global.user_id ,--CREATED_BY

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

Line 201: fnd_global.user_id ,--LAST_UPDATED_BY

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

Line 202: fnd_global.conc_login_id --LAST_UPDATE_LOGIN

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

Line 264: fnd_global.conc_request_id , --Request Id

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

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

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

Line 266: fnd_global.conc_program_id , --Program Id

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

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

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

Line 269: fnd_global.user_id , --CREATED_BY

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

Line 270: fnd_global.user_id , --LAST_UPDATED_BY

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

Line 271: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

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

Line 326: fnd_global.conc_request_id , --Request Id

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

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

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

Line 328: fnd_global.conc_program_id , --Program Id

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

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

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

Line 331: fnd_global.user_id , --CREATED_BY

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

Line 332: fnd_global.user_id , --LAST_UPDATED_BY

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

Line 333: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

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

Line 366: fnd_global.user_id ,--CREATED_BY

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

Line 367: fnd_global.user_id ,--LAST_UPDATED_BY

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

Line 368: fnd_global.conc_login_id --LAST_UPDATE_LOGIN

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

Line 600: fnd_global.user_id ,

596: ALPHANUMERIC_VALUE1 ,
597: 'MIGRATED' ,
598: zx_condition_groups_b_s.nextval ,
599: CONSTRAINT_ID ,
600: fnd_global.user_id ,
601: SYSDATE ,
602: fnd_global.user_id ,
603: SYSDATE ,
604: fnd_global.conc_login_id ,

Line 602: fnd_global.user_id ,

598: zx_condition_groups_b_s.nextval ,
599: CONSTRAINT_ID ,
600: fnd_global.user_id ,
601: SYSDATE ,
602: fnd_global.user_id ,
603: SYSDATE ,
604: fnd_global.conc_login_id ,
605: fnd_global.conc_request_id ,
606: fnd_global.prog_appl_id ,

Line 604: fnd_global.conc_login_id ,

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

Line 605: fnd_global.conc_request_id ,

601: SYSDATE ,
602: fnd_global.user_id ,
603: SYSDATE ,
604: fnd_global.conc_login_id ,
605: fnd_global.conc_request_id ,
606: fnd_global.prog_appl_id ,
607: fnd_global.conc_program_id ,
608: fnd_global.conc_login_id ,
609: 1

Line 606: fnd_global.prog_appl_id ,

602: fnd_global.user_id ,
603: SYSDATE ,
604: fnd_global.conc_login_id ,
605: fnd_global.conc_request_id ,
606: fnd_global.prog_appl_id ,
607: fnd_global.conc_program_id ,
608: fnd_global.conc_login_id ,
609: 1
610: )

Line 607: fnd_global.conc_program_id ,

603: SYSDATE ,
604: fnd_global.conc_login_id ,
605: fnd_global.conc_request_id ,
606: fnd_global.prog_appl_id ,
607: fnd_global.conc_program_id ,
608: fnd_global.conc_login_id ,
609: 1
610: )
611: WHEN (not exists

Line 608: fnd_global.conc_login_id ,

604: fnd_global.conc_login_id ,
605: fnd_global.conc_request_id ,
606: fnd_global.prog_appl_id ,
607: fnd_global.conc_program_id ,
608: fnd_global.conc_login_id ,
609: 1
610: )
611: WHEN (not exists
612: (select 1 from zx_conditions

Line 656: fnd_global.user_id ,

652: 'MIGRATED' ,
653: 'N' ,
654: ALPHANUMERIC_VALUE1 ,
655: zx_conditions_s.nextval ,
656: fnd_global.user_id ,
657: SYSDATE ,
658: fnd_global.user_id ,
659: SYSDATE ,
660: fnd_global.conc_login_id ,

Line 658: fnd_global.user_id ,

654: ALPHANUMERIC_VALUE1 ,
655: zx_conditions_s.nextval ,
656: fnd_global.user_id ,
657: SYSDATE ,
658: fnd_global.user_id ,
659: SYSDATE ,
660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,

Line 660: fnd_global.conc_login_id ,

656: fnd_global.user_id ,
657: SYSDATE ,
658: fnd_global.user_id ,
659: SYSDATE ,
660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,
663: fnd_global.conc_program_id ,
664: fnd_global.conc_login_id ,

Line 661: fnd_global.conc_request_id ,

657: SYSDATE ,
658: fnd_global.user_id ,
659: SYSDATE ,
660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,
663: fnd_global.conc_program_id ,
664: fnd_global.conc_login_id ,
665: 1

Line 662: fnd_global.prog_appl_id ,

658: fnd_global.user_id ,
659: SYSDATE ,
660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,
663: fnd_global.conc_program_id ,
664: fnd_global.conc_login_id ,
665: 1
666: )

Line 663: fnd_global.conc_program_id ,

659: SYSDATE ,
660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,
663: fnd_global.conc_program_id ,
664: fnd_global.conc_login_id ,
665: 1
666: )
667: SELECT distinct

Line 664: fnd_global.conc_login_id ,

660: fnd_global.conc_login_id ,
661: fnd_global.conc_request_id ,
662: fnd_global.prog_appl_id ,
663: fnd_global.conc_program_id ,
664: fnd_global.conc_login_id ,
665: 1
666: )
667: SELECT distinct
668: codes.name||'-'||'XIP' l_condition_group_code ,

Line 746: fnd_global.user_id ,

742: ALPHANUMERIC_VALUE1 ,
743: 'MIGRATED' ,
744: zx_condition_groups_b_s.nextval ,
745: CONSTRAINT_ID ,
746: fnd_global.user_id ,
747: SYSDATE ,
748: fnd_global.user_id ,
749: SYSDATE ,
750: fnd_global.conc_login_id ,

Line 748: fnd_global.user_id ,

744: zx_condition_groups_b_s.nextval ,
745: CONSTRAINT_ID ,
746: fnd_global.user_id ,
747: SYSDATE ,
748: fnd_global.user_id ,
749: SYSDATE ,
750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,

Line 750: fnd_global.conc_login_id ,

746: fnd_global.user_id ,
747: SYSDATE ,
748: fnd_global.user_id ,
749: SYSDATE ,
750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,
753: fnd_global.conc_program_id ,
754: fnd_global.conc_login_id ,

Line 751: fnd_global.conc_request_id ,

747: SYSDATE ,
748: fnd_global.user_id ,
749: SYSDATE ,
750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,
753: fnd_global.conc_program_id ,
754: fnd_global.conc_login_id ,
755: 1

Line 752: fnd_global.prog_appl_id ,

748: fnd_global.user_id ,
749: SYSDATE ,
750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,
753: fnd_global.conc_program_id ,
754: fnd_global.conc_login_id ,
755: 1
756: )

Line 753: fnd_global.conc_program_id ,

749: SYSDATE ,
750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,
753: fnd_global.conc_program_id ,
754: fnd_global.conc_login_id ,
755: 1
756: )
757: WHEN (not exists

Line 754: fnd_global.conc_login_id ,

750: fnd_global.conc_login_id ,
751: fnd_global.conc_request_id ,
752: fnd_global.prog_appl_id ,
753: fnd_global.conc_program_id ,
754: fnd_global.conc_login_id ,
755: 1
756: )
757: WHEN (not exists
758: (select 1 from zx_conditions

Line 802: fnd_global.user_id ,

798: 'MIGRATED' ,
799: 'N' ,
800: ALPHANUMERIC_VALUE1 ,
801: zx_conditions_s.nextval ,
802: fnd_global.user_id ,
803: SYSDATE ,
804: fnd_global.user_id ,
805: SYSDATE ,
806: fnd_global.conc_login_id ,

Line 804: fnd_global.user_id ,

800: ALPHANUMERIC_VALUE1 ,
801: zx_conditions_s.nextval ,
802: fnd_global.user_id ,
803: SYSDATE ,
804: fnd_global.user_id ,
805: SYSDATE ,
806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,

Line 806: fnd_global.conc_login_id ,

802: fnd_global.user_id ,
803: SYSDATE ,
804: fnd_global.user_id ,
805: SYSDATE ,
806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,
809: fnd_global.conc_program_id ,
810: fnd_global.conc_login_id ,

Line 807: fnd_global.conc_request_id ,

803: SYSDATE ,
804: fnd_global.user_id ,
805: SYSDATE ,
806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,
809: fnd_global.conc_program_id ,
810: fnd_global.conc_login_id ,
811: 1

Line 808: fnd_global.prog_appl_id ,

804: fnd_global.user_id ,
805: SYSDATE ,
806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,
809: fnd_global.conc_program_id ,
810: fnd_global.conc_login_id ,
811: 1
812: )

Line 809: fnd_global.conc_program_id ,

805: SYSDATE ,
806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,
809: fnd_global.conc_program_id ,
810: fnd_global.conc_login_id ,
811: 1
812: )
813: SELECT

Line 810: fnd_global.conc_login_id ,

806: fnd_global.conc_login_id ,
807: fnd_global.conc_request_id ,
808: fnd_global.prog_appl_id ,
809: fnd_global.conc_program_id ,
810: fnd_global.conc_login_id ,
811: 1
812: )
813: SELECT
814: DISTINCT

Line 902: fnd_global.user_id ,

898: ALPHANUMERIC_VALUE1 ,
899: 'MIGRATED' ,
900: zx_condition_groups_b_s.nextval ,
901: CONSTRAINT_ID ,
902: fnd_global.user_id ,
903: SYSDATE ,
904: fnd_global.user_id ,
905: SYSDATE ,
906: fnd_global.conc_login_id ,

Line 904: fnd_global.user_id ,

900: zx_condition_groups_b_s.nextval ,
901: CONSTRAINT_ID ,
902: fnd_global.user_id ,
903: SYSDATE ,
904: fnd_global.user_id ,
905: SYSDATE ,
906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,

Line 906: fnd_global.conc_login_id ,

902: fnd_global.user_id ,
903: SYSDATE ,
904: fnd_global.user_id ,
905: SYSDATE ,
906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,
909: fnd_global.conc_program_id ,
910: fnd_global.conc_login_id ,

Line 907: fnd_global.conc_request_id ,

903: SYSDATE ,
904: fnd_global.user_id ,
905: SYSDATE ,
906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,
909: fnd_global.conc_program_id ,
910: fnd_global.conc_login_id ,
911: 1

Line 908: fnd_global.prog_appl_id ,

904: fnd_global.user_id ,
905: SYSDATE ,
906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,
909: fnd_global.conc_program_id ,
910: fnd_global.conc_login_id ,
911: 1
912: )

Line 909: fnd_global.conc_program_id ,

905: SYSDATE ,
906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,
909: fnd_global.conc_program_id ,
910: fnd_global.conc_login_id ,
911: 1
912: )
913: WHEN (not exists

Line 910: fnd_global.conc_login_id ,

906: fnd_global.conc_login_id ,
907: fnd_global.conc_request_id ,
908: fnd_global.prog_appl_id ,
909: fnd_global.conc_program_id ,
910: fnd_global.conc_login_id ,
911: 1
912: )
913: WHEN (not exists
914: (select 1 from zx_conditions

Line 956: fnd_global.user_id ,

952: 'MIGRATED' ,
953: 'N' ,
954: ALPHANUMERIC_VALUE1 ,
955: zx_conditions_s.nextval ,
956: fnd_global.user_id ,
957: SYSDATE ,
958: fnd_global.user_id ,
959: SYSDATE ,
960: fnd_global.conc_login_id ,

Line 958: fnd_global.user_id ,

954: ALPHANUMERIC_VALUE1 ,
955: zx_conditions_s.nextval ,
956: fnd_global.user_id ,
957: SYSDATE ,
958: fnd_global.user_id ,
959: SYSDATE ,
960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,

Line 960: fnd_global.conc_login_id ,

956: fnd_global.user_id ,
957: SYSDATE ,
958: fnd_global.user_id ,
959: SYSDATE ,
960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,
963: fnd_global.conc_program_id ,
964: fnd_global.conc_login_id ,

Line 961: fnd_global.conc_request_id ,

957: SYSDATE ,
958: fnd_global.user_id ,
959: SYSDATE ,
960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,
963: fnd_global.conc_program_id ,
964: fnd_global.conc_login_id ,
965: 1

Line 962: fnd_global.prog_appl_id ,

958: fnd_global.user_id ,
959: SYSDATE ,
960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,
963: fnd_global.conc_program_id ,
964: fnd_global.conc_login_id ,
965: 1
966: )

Line 963: fnd_global.conc_program_id ,

959: SYSDATE ,
960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,
963: fnd_global.conc_program_id ,
964: fnd_global.conc_login_id ,
965: 1
966: )
967: SELECT

Line 964: fnd_global.conc_login_id ,

960: fnd_global.conc_login_id ,
961: fnd_global.conc_request_id ,
962: fnd_global.prog_appl_id ,
963: fnd_global.conc_program_id ,
964: fnd_global.conc_login_id ,
965: 1
966: )
967: SELECT
968: DISTINCT ar_vat.tax_code l_condition_group_code ,

Line 1242: fnd_global.user_id ,

1238:
1239: 'MIGRATED' ,
1240: zx_condition_groups_b_s.nextval ,
1241: CONSTRAINT_ID ,
1242: fnd_global.user_id ,
1243: SYSDATE ,
1244: fnd_global.user_id ,
1245: SYSDATE ,
1246: fnd_global.conc_login_id ,

Line 1244: fnd_global.user_id ,

1240: zx_condition_groups_b_s.nextval ,
1241: CONSTRAINT_ID ,
1242: fnd_global.user_id ,
1243: SYSDATE ,
1244: fnd_global.user_id ,
1245: SYSDATE ,
1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,

Line 1246: fnd_global.conc_login_id ,

1242: fnd_global.user_id ,
1243: SYSDATE ,
1244: fnd_global.user_id ,
1245: SYSDATE ,
1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,
1249: fnd_global.conc_program_id ,
1250: fnd_global.conc_login_id ,

Line 1247: fnd_global.conc_request_id ,

1243: SYSDATE ,
1244: fnd_global.user_id ,
1245: SYSDATE ,
1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,
1249: fnd_global.conc_program_id ,
1250: fnd_global.conc_login_id ,
1251: 1

Line 1248: fnd_global.prog_appl_id ,

1244: fnd_global.user_id ,
1245: SYSDATE ,
1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,
1249: fnd_global.conc_program_id ,
1250: fnd_global.conc_login_id ,
1251: 1
1252: )

Line 1249: fnd_global.conc_program_id ,

1245: SYSDATE ,
1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,
1249: fnd_global.conc_program_id ,
1250: fnd_global.conc_login_id ,
1251: 1
1252: )
1253: -- create conditions for tax_classification_code

Line 1250: fnd_global.conc_login_id ,

1246: fnd_global.conc_login_id ,
1247: fnd_global.conc_request_id ,
1248: fnd_global.prog_appl_id ,
1249: fnd_global.conc_program_id ,
1250: fnd_global.conc_login_id ,
1251: 1
1252: )
1253: -- create conditions for tax_classification_code
1254: WHEN (not exists

Line 1298: fnd_global.user_id ,

1294: 'MIGRATED' ,
1295: 'N' ,
1296: ALPHANUMERIC_VALUE1 ,
1297: zx_conditions_s.nextval ,
1298: fnd_global.user_id ,
1299: SYSDATE ,
1300: fnd_global.user_id ,
1301: SYSDATE ,
1302: fnd_global.conc_login_id ,

Line 1300: fnd_global.user_id ,

1296: ALPHANUMERIC_VALUE1 ,
1297: zx_conditions_s.nextval ,
1298: fnd_global.user_id ,
1299: SYSDATE ,
1300: fnd_global.user_id ,
1301: SYSDATE ,
1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,

Line 1302: fnd_global.conc_login_id ,

1298: fnd_global.user_id ,
1299: SYSDATE ,
1300: fnd_global.user_id ,
1301: SYSDATE ,
1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,
1305: fnd_global.conc_program_id ,
1306: fnd_global.conc_login_id ,

Line 1303: fnd_global.conc_request_id ,

1299: SYSDATE ,
1300: fnd_global.user_id ,
1301: SYSDATE ,
1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,
1305: fnd_global.conc_program_id ,
1306: fnd_global.conc_login_id ,
1307: 1

Line 1304: fnd_global.prog_appl_id ,

1300: fnd_global.user_id ,
1301: SYSDATE ,
1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,
1305: fnd_global.conc_program_id ,
1306: fnd_global.conc_login_id ,
1307: 1
1308: )

Line 1305: fnd_global.conc_program_id ,

1301: SYSDATE ,
1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,
1305: fnd_global.conc_program_id ,
1306: fnd_global.conc_login_id ,
1307: 1
1308: )
1309: -- create condition for product_fisc_classification

Line 1306: fnd_global.conc_login_id ,

1302: fnd_global.conc_login_id ,
1303: fnd_global.conc_request_id ,
1304: fnd_global.prog_appl_id ,
1305: fnd_global.conc_program_id ,
1306: fnd_global.conc_login_id ,
1307: 1
1308: )
1309: -- create condition for product_fisc_classification
1310: WHEN ALPHANUMERIC_VALUE2 IS NOT NULL

Line 1355: fnd_global.user_id ,

1351: 'MIGRATED' ,
1352: 'N' ,
1353: ALPHANUMERIC_VALUE2 ,
1354: zx_conditions_s.nextval ,
1355: fnd_global.user_id ,
1356: SYSDATE ,
1357: fnd_global.user_id ,
1358: SYSDATE ,
1359: fnd_global.conc_login_id ,

Line 1357: fnd_global.user_id ,

1353: ALPHANUMERIC_VALUE2 ,
1354: zx_conditions_s.nextval ,
1355: fnd_global.user_id ,
1356: SYSDATE ,
1357: fnd_global.user_id ,
1358: SYSDATE ,
1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,

Line 1359: fnd_global.conc_login_id ,

1355: fnd_global.user_id ,
1356: SYSDATE ,
1357: fnd_global.user_id ,
1358: SYSDATE ,
1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,
1362: fnd_global.conc_program_id ,
1363: fnd_global.conc_login_id ,

Line 1360: fnd_global.conc_request_id ,

1356: SYSDATE ,
1357: fnd_global.user_id ,
1358: SYSDATE ,
1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,
1362: fnd_global.conc_program_id ,
1363: fnd_global.conc_login_id ,
1364: 1

Line 1361: fnd_global.prog_appl_id ,

1357: fnd_global.user_id ,
1358: SYSDATE ,
1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,
1362: fnd_global.conc_program_id ,
1363: fnd_global.conc_login_id ,
1364: 1
1365: )

Line 1362: fnd_global.conc_program_id ,

1358: SYSDATE ,
1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,
1362: fnd_global.conc_program_id ,
1363: fnd_global.conc_login_id ,
1364: 1
1365: )
1366:

Line 1363: fnd_global.conc_login_id ,

1359: fnd_global.conc_login_id ,
1360: fnd_global.conc_request_id ,
1361: fnd_global.prog_appl_id ,
1362: fnd_global.conc_program_id ,
1363: fnd_global.conc_login_id ,
1364: 1
1365: )
1366:
1367: -- create condition for trx_business_category_code

Line 1413: fnd_global.user_id ,

1409: 'MIGRATED' ,
1410: 'N' ,
1411: ALPHANUMERIC_VALUE3 ,
1412: zx_conditions_s.nextval ,
1413: fnd_global.user_id ,
1414: SYSDATE ,
1415: fnd_global.user_id ,
1416: SYSDATE ,
1417: fnd_global.conc_login_id ,

Line 1415: fnd_global.user_id ,

1411: ALPHANUMERIC_VALUE3 ,
1412: zx_conditions_s.nextval ,
1413: fnd_global.user_id ,
1414: SYSDATE ,
1415: fnd_global.user_id ,
1416: SYSDATE ,
1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,

Line 1417: fnd_global.conc_login_id ,

1413: fnd_global.user_id ,
1414: SYSDATE ,
1415: fnd_global.user_id ,
1416: SYSDATE ,
1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,
1420: fnd_global.conc_program_id ,
1421: fnd_global.conc_login_id ,

Line 1418: fnd_global.conc_request_id ,

1414: SYSDATE ,
1415: fnd_global.user_id ,
1416: SYSDATE ,
1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,
1420: fnd_global.conc_program_id ,
1421: fnd_global.conc_login_id ,
1422: 1

Line 1419: fnd_global.prog_appl_id ,

1415: fnd_global.user_id ,
1416: SYSDATE ,
1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,
1420: fnd_global.conc_program_id ,
1421: fnd_global.conc_login_id ,
1422: 1
1423: )

Line 1420: fnd_global.conc_program_id ,

1416: SYSDATE ,
1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,
1420: fnd_global.conc_program_id ,
1421: fnd_global.conc_login_id ,
1422: 1
1423: )
1424:

Line 1421: fnd_global.conc_login_id ,

1417: fnd_global.conc_login_id ,
1418: fnd_global.conc_request_id ,
1419: fnd_global.prog_appl_id ,
1420: fnd_global.conc_program_id ,
1421: fnd_global.conc_login_id ,
1422: 1
1423: )
1424:
1425: -- create condition for party_fisc_classification

Line 1471: fnd_global.user_id ,

1467: 'MIGRATED' ,
1468: 'N' ,
1469: ALPHANUMERIC_VALUE4 ,
1470: zx_conditions_s.nextval ,
1471: fnd_global.user_id ,
1472: SYSDATE ,
1473: fnd_global.user_id ,
1474: SYSDATE ,
1475: fnd_global.conc_login_id ,

Line 1473: fnd_global.user_id ,

1469: ALPHANUMERIC_VALUE4 ,
1470: zx_conditions_s.nextval ,
1471: fnd_global.user_id ,
1472: SYSDATE ,
1473: fnd_global.user_id ,
1474: SYSDATE ,
1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,

Line 1475: fnd_global.conc_login_id ,

1471: fnd_global.user_id ,
1472: SYSDATE ,
1473: fnd_global.user_id ,
1474: SYSDATE ,
1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,
1478: fnd_global.conc_program_id ,
1479: fnd_global.conc_login_id ,

Line 1476: fnd_global.conc_request_id ,

1472: SYSDATE ,
1473: fnd_global.user_id ,
1474: SYSDATE ,
1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,
1478: fnd_global.conc_program_id ,
1479: fnd_global.conc_login_id ,
1480: 1

Line 1477: fnd_global.prog_appl_id ,

1473: fnd_global.user_id ,
1474: SYSDATE ,
1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,
1478: fnd_global.conc_program_id ,
1479: fnd_global.conc_login_id ,
1480: 1
1481: )

Line 1478: fnd_global.conc_program_id ,

1474: SYSDATE ,
1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,
1478: fnd_global.conc_program_id ,
1479: fnd_global.conc_login_id ,
1480: 1
1481: )
1482:

Line 1479: fnd_global.conc_login_id ,

1475: fnd_global.conc_login_id ,
1476: fnd_global.conc_request_id ,
1477: fnd_global.prog_appl_id ,
1478: fnd_global.conc_program_id ,
1479: fnd_global.conc_login_id ,
1480: 1
1481: )
1482:
1483: SELECT

Line 1563: fnd_global.user_id ,

1559: END
1560: ,
1561: B.CONDITION_GROUP_ID ,
1562: SYSDATE ,
1563: fnd_global.user_id ,
1564: SYSDATE ,
1565: fnd_global.user_id ,
1566: fnd_global.conc_login_id
1567: FROM

Line 1565: fnd_global.user_id ,

1561: B.CONDITION_GROUP_ID ,
1562: SYSDATE ,
1563: fnd_global.user_id ,
1564: SYSDATE ,
1565: fnd_global.user_id ,
1566: fnd_global.conc_login_id
1567: FROM
1568: FND_LANGUAGES L,
1569: ZX_CONDITION_GROUPS_B B

Line 1566: fnd_global.conc_login_id

1562: SYSDATE ,
1563: fnd_global.user_id ,
1564: SYSDATE ,
1565: fnd_global.user_id ,
1566: fnd_global.conc_login_id
1567: FROM
1568: FND_LANGUAGES L,
1569: ZX_CONDITION_GROUPS_B B
1570: WHERE

Line 1684: fnd_global.user_id ,

1680: 'Y' ,--ENABLED_FLAG
1681: 'MIGRATED' ,--RECORD_TYPE_CODE
1682: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1683: CONTENT_OWNER_ID ,
1684: fnd_global.user_id ,
1685: SYSDATE ,
1686: fnd_global.user_id ,
1687: SYSDATE ,
1688: fnd_global.conc_login_id ,

Line 1686: fnd_global.user_id ,

1682: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1683: CONTENT_OWNER_ID ,
1684: fnd_global.user_id ,
1685: SYSDATE ,
1686: fnd_global.user_id ,
1687: SYSDATE ,
1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID

Line 1688: fnd_global.conc_login_id ,

1684: fnd_global.user_id ,
1685: SYSDATE ,
1686: fnd_global.user_id ,
1687: SYSDATE ,
1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID
1691: fnd_global.conc_program_id ,--Program Id
1692: fnd_global.conc_login_id , --Program Login ID

Line 1689: fnd_global.conc_request_id ,--Request Id

1685: SYSDATE ,
1686: fnd_global.user_id ,
1687: SYSDATE ,
1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID
1691: fnd_global.conc_program_id ,--Program Id
1692: fnd_global.conc_login_id , --Program Login ID
1693: 1

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

1686: fnd_global.user_id ,
1687: SYSDATE ,
1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID
1691: fnd_global.conc_program_id ,--Program Id
1692: fnd_global.conc_login_id , --Program Login ID
1693: 1
1694: )

Line 1691: fnd_global.conc_program_id ,--Program Id

1687: SYSDATE ,
1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID
1691: fnd_global.conc_program_id ,--Program Id
1692: fnd_global.conc_login_id , --Program Login ID
1693: 1
1694: )
1695: SELECT

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

1688: fnd_global.conc_login_id ,
1689: fnd_global.conc_request_id ,--Request Id
1690: fnd_global.prog_appl_id ,--Program Application ID
1691: fnd_global.conc_program_id ,--Program Id
1692: fnd_global.conc_login_id , --Program Login ID
1693: 1
1694: )
1695: SELECT
1696: taxes.TAX L_TAX ,

Line 1767: fnd_global.user_id ,

1763: 'Y' ,--ENABLED_FLAG
1764: 'MIGRATED' ,--RECORD_TYPE_CODE
1765: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1766: CONTENT_OWNER_ID ,
1767: fnd_global.user_id ,
1768: SYSDATE ,
1769: fnd_global.user_id ,
1770: SYSDATE ,
1771: fnd_global.conc_login_id ,

Line 1769: fnd_global.user_id ,

1765: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1766: CONTENT_OWNER_ID ,
1767: fnd_global.user_id ,
1768: SYSDATE ,
1769: fnd_global.user_id ,
1770: SYSDATE ,
1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID

Line 1771: fnd_global.conc_login_id ,

1767: fnd_global.user_id ,
1768: SYSDATE ,
1769: fnd_global.user_id ,
1770: SYSDATE ,
1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID
1774: fnd_global.conc_program_id ,--Program Id
1775: fnd_global.conc_login_id , --Program Login ID

Line 1772: fnd_global.conc_request_id ,--Request Id

1768: SYSDATE ,
1769: fnd_global.user_id ,
1770: SYSDATE ,
1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID
1774: fnd_global.conc_program_id ,--Program Id
1775: fnd_global.conc_login_id , --Program Login ID
1776: 1

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

1769: fnd_global.user_id ,
1770: SYSDATE ,
1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID
1774: fnd_global.conc_program_id ,--Program Id
1775: fnd_global.conc_login_id , --Program Login ID
1776: 1
1777: ) --Bug 5090631

Line 1774: fnd_global.conc_program_id ,--Program Id

1770: SYSDATE ,
1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID
1774: fnd_global.conc_program_id ,--Program Id
1775: fnd_global.conc_login_id , --Program Login ID
1776: 1
1777: ) --Bug 5090631
1778: --Bug 5572117

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

1771: fnd_global.conc_login_id ,
1772: fnd_global.conc_request_id ,--Request Id
1773: fnd_global.prog_appl_id ,--Program Application ID
1774: fnd_global.conc_program_id ,--Program Id
1775: fnd_global.conc_login_id , --Program Login ID
1776: 1
1777: ) --Bug 5090631
1778: --Bug 5572117
1779: SELECT DISTINCT

Line 1909: fnd_global.user_id ,

1905: ENABLED_FLAG ,
1906: 'MIGRATED' ,--RECORD_TYPE_CODE
1907: 'STCC' ,--DET_FACTOR_TEMPL_CODE
1908: CONTENT_OWNER_ID ,
1909: fnd_global.user_id ,
1910: SYSDATE ,
1911: fnd_global.user_id ,
1912: SYSDATE ,
1913: fnd_global.conc_login_id ,

Line 1911: fnd_global.user_id ,

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

Line 1913: fnd_global.conc_login_id ,

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

Line 1914: fnd_global.conc_request_id ,--Request Id

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

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

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

Line 1916: fnd_global.conc_program_id ,--Program Id

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

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

1913: fnd_global.conc_login_id ,
1914: fnd_global.conc_request_id ,--Request Id
1915: fnd_global.prog_appl_id ,--Program Application ID
1916: fnd_global.conc_program_id ,--Program Id
1917: fnd_global.conc_login_id ,--Program Login ID
1918: 1
1919: )
1920: SELECT
1921: taxes.TAX TAX ,

Line 2077: fnd_global.user_id ,

2073: 'Y' ,--ENABLED_FLAG
2074: 'MIGRATED' ,--RECORD_TYPE_CODE
2075: 'LEASE_MGT_RATE_DET_TEMPL' ,--DET_FACTOR_TEMPL_CODE
2076: CONTENT_OWNER_ID ,
2077: fnd_global.user_id ,
2078: SYSDATE ,
2079: fnd_global.user_id ,
2080: SYSDATE ,
2081: fnd_global.conc_login_id ,

Line 2079: fnd_global.user_id ,

2075: 'LEASE_MGT_RATE_DET_TEMPL' ,--DET_FACTOR_TEMPL_CODE
2076: CONTENT_OWNER_ID ,
2077: fnd_global.user_id ,
2078: SYSDATE ,
2079: fnd_global.user_id ,
2080: SYSDATE ,
2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID

Line 2081: fnd_global.conc_login_id ,

2077: fnd_global.user_id ,
2078: SYSDATE ,
2079: fnd_global.user_id ,
2080: SYSDATE ,
2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID
2084: fnd_global.conc_program_id ,--Program Id
2085: fnd_global.conc_login_id , --Program Login ID

Line 2082: fnd_global.conc_request_id ,--Request Id

2078: SYSDATE ,
2079: fnd_global.user_id ,
2080: SYSDATE ,
2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID
2084: fnd_global.conc_program_id ,--Program Id
2085: fnd_global.conc_login_id , --Program Login ID
2086: 1

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

2079: fnd_global.user_id ,
2080: SYSDATE ,
2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID
2084: fnd_global.conc_program_id ,--Program Id
2085: fnd_global.conc_login_id , --Program Login ID
2086: 1
2087: ) --Bug 5090631

Line 2084: fnd_global.conc_program_id ,--Program Id

2080: SYSDATE ,
2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID
2084: fnd_global.conc_program_id ,--Program Id
2085: fnd_global.conc_login_id , --Program Login ID
2086: 1
2087: ) --Bug 5090631
2088: SELECT DISTINCT

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

2081: fnd_global.conc_login_id ,
2082: fnd_global.conc_request_id ,--Request Id
2083: fnd_global.prog_appl_id ,--Program Application ID
2084: fnd_global.conc_program_id ,--Program Id
2085: fnd_global.conc_login_id , --Program Login ID
2086: 1
2087: ) --Bug 5090631
2088: SELECT DISTINCT
2089: taxes.TAX L_TAX ,

Line 2215: fnd_global.user_id ,

2211: B.TAX_RULE_CODE
2212: END ,
2213: B.TAX_RULE_ID ,
2214: SYSDATE ,
2215: fnd_global.user_id ,
2216: SYSDATE ,
2217: fnd_global.user_id ,
2218: fnd_global.conc_login_id
2219: FROM

Line 2217: fnd_global.user_id ,

2213: B.TAX_RULE_ID ,
2214: SYSDATE ,
2215: fnd_global.user_id ,
2216: SYSDATE ,
2217: fnd_global.user_id ,
2218: fnd_global.conc_login_id
2219: FROM
2220: FND_LANGUAGES L,
2221: ZX_RULES_B B

Line 2218: fnd_global.conc_login_id

2214: SYSDATE ,
2215: fnd_global.user_id ,
2216: SYSDATE ,
2217: fnd_global.user_id ,
2218: fnd_global.conc_login_id
2219: FROM
2220: FND_LANGUAGES L,
2221: ZX_RULES_B B
2222: WHERE

Line 2487: ,fnd_global.user_id --CREATED_BY

2483: ,tax.PARENT_GEOGRAPHY_TYPE
2484: ,tax.PARENT_GEOGRAPHY_ID
2485: ,tax.ALLOW_MASS_CREATE_FLAG
2486: ,tax.APPLIED_AMT_HANDLING_FLAG
2487: ,fnd_global.user_id --CREATED_BY
2488: ,SYSDATE --CREATION_DATE
2489: ,fnd_global.user_id --LAST_UPDATED_BY
2490: ,SYSDATE --LAST_UPDATE_DATE
2491: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN

Line 2489: ,fnd_global.user_id --LAST_UPDATED_BY

2485: ,tax.ALLOW_MASS_CREATE_FLAG
2486: ,tax.APPLIED_AMT_HANDLING_FLAG
2487: ,fnd_global.user_id --CREATED_BY
2488: ,SYSDATE --CREATION_DATE
2489: ,fnd_global.user_id --LAST_UPDATED_BY
2490: ,SYSDATE --LAST_UPDATE_DATE
2491: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN
2492: ,tax.REQUEST_ID
2493: ,tax.PROGRAM_APPLICATION_ID

Line 2491: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN

2487: ,fnd_global.user_id --CREATED_BY
2488: ,SYSDATE --CREATION_DATE
2489: ,fnd_global.user_id --LAST_UPDATED_BY
2490: ,SYSDATE --LAST_UPDATE_DATE
2491: ,fnd_global.conc_login_id --LAST_UPDATE_LOGIN
2492: ,tax.REQUEST_ID
2493: ,tax.PROGRAM_APPLICATION_ID
2494: ,tax.PROGRAM_ID
2495: ,tax.RECORD_TYPE_CODE

Line 2664: fnd_global.user_id ,

2660: zx_process_results_s.nextval ,--RESULT_ID
2661: CONTENT_OWNER_ID ,
2662: CONDITION_GROUP_ID ,
2663: TAX_RULE_ID ,
2664: fnd_global.user_id ,
2665: SYSDATE ,
2666: fnd_global.user_id ,
2667: SYSDATE ,
2668: fnd_global.conc_login_id ,

Line 2666: fnd_global.user_id ,

2662: CONDITION_GROUP_ID ,
2663: TAX_RULE_ID ,
2664: fnd_global.user_id ,
2665: SYSDATE ,
2666: fnd_global.user_id ,
2667: SYSDATE ,
2668: fnd_global.conc_login_id ,
2669: fnd_global.conc_request_id ,--Request Id
2670: fnd_global.prog_appl_id ,--Program Application ID

Line 2668: fnd_global.conc_login_id ,

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

Line 2669: fnd_global.conc_request_id ,--Request Id

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

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

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

Line 2671: fnd_global.conc_program_id ,--Program Id

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

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

2668: fnd_global.conc_login_id ,
2669: fnd_global.conc_request_id ,--Request Id
2670: fnd_global.prog_appl_id ,--Program Application ID
2671: fnd_global.conc_program_id ,--Program Id
2672: fnd_global.conc_login_id ,--Program Login ID
2673: 1
2674: FROM
2675: (
2676: /* Bug 5061471 : Commenting this as we no longer require creation of process results for simple taxes

Line 2830: fnd_global.user_id ,

2826: CONDITION_GROUP_ID ,
2827: TAX_RULE_ID ,
2828: CONDITION_SET_ID ,
2829: EXCEPTION_SET_ID ,
2830: fnd_global.user_id ,
2831: SYSDATE ,
2832: fnd_global.user_id ,
2833: SYSDATE ,
2834: fnd_global.conc_login_id ,

Line 2832: fnd_global.user_id ,

2828: CONDITION_SET_ID ,
2829: EXCEPTION_SET_ID ,
2830: fnd_global.user_id ,
2831: SYSDATE ,
2832: fnd_global.user_id ,
2833: SYSDATE ,
2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID

Line 2834: fnd_global.conc_login_id ,

2830: fnd_global.user_id ,
2831: SYSDATE ,
2832: fnd_global.user_id ,
2833: SYSDATE ,
2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID
2837: fnd_global.conc_program_id ,--Program Id
2838: fnd_global.conc_login_id ,--Program Login ID

Line 2835: fnd_global.conc_request_id ,--Request Id

2831: SYSDATE ,
2832: fnd_global.user_id ,
2833: SYSDATE ,
2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID
2837: fnd_global.conc_program_id ,--Program Id
2838: fnd_global.conc_login_id ,--Program Login ID
2839: 1

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

2832: fnd_global.user_id ,
2833: SYSDATE ,
2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID
2837: fnd_global.conc_program_id ,--Program Id
2838: fnd_global.conc_login_id ,--Program Login ID
2839: 1
2840: FROM

Line 2837: fnd_global.conc_program_id ,--Program Id

2833: SYSDATE ,
2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID
2837: fnd_global.conc_program_id ,--Program Id
2838: fnd_global.conc_login_id ,--Program Login ID
2839: 1
2840: FROM
2841: (

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

2834: fnd_global.conc_login_id ,
2835: fnd_global.conc_request_id ,--Request Id
2836: fnd_global.prog_appl_id ,--Program Application ID
2837: fnd_global.conc_program_id ,--Program Id
2838: fnd_global.conc_login_id ,--Program Login ID
2839: 1
2840: FROM
2841: (
2842: SELECT

Line 3016: fnd_global.conc_request_id, -- REQUEST_ID ,

3012: 'Y' , --ALLOW_EXCEPTIONS_FLAG ,
3013: 'MIGRATED' , --RECORD_TYPE_CODE ,
3014: sysdate , -- CREATION_DATE ,
3015: sysdate , -- LAST_UPDATE_DATE ,
3016: fnd_global.conc_request_id, -- REQUEST_ID ,
3017: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3018: NULL, -- PROGRAM_ID ,
3019: CONDITION_SET_ID ,
3020: EXCEPTION_SET_ID ,

Line 3017: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

3013: 'MIGRATED' , --RECORD_TYPE_CODE ,
3014: sysdate , -- CREATION_DATE ,
3015: sysdate , -- LAST_UPDATE_DATE ,
3016: fnd_global.conc_request_id, -- REQUEST_ID ,
3017: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3018: NULL, -- PROGRAM_ID ,
3019: CONDITION_SET_ID ,
3020: EXCEPTION_SET_ID ,
3021: NULL , -- PROGRAM_LOGIN_ID ,

Line 3026: fnd_global.user_id , --CREATED_BY ,

3022: zx_process_results_s.nextval,
3023: CONTENT_OWNER_ID ,
3024: condition_group_id,
3025: tax_rule_id,
3026: fnd_global.user_id , --CREATED_BY ,
3027: fnd_global.user_id , --LAST_UPDATED_BY ,
3028: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3029: NULL , -- RESULT_API ,
3030: 1 --OBJECT_VERSION_NUMBER

Line 3027: fnd_global.user_id , --LAST_UPDATED_BY ,

3023: CONTENT_OWNER_ID ,
3024: condition_group_id,
3025: tax_rule_id,
3026: fnd_global.user_id , --CREATED_BY ,
3027: fnd_global.user_id , --LAST_UPDATED_BY ,
3028: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3029: NULL , -- RESULT_API ,
3030: 1 --OBJECT_VERSION_NUMBER
3031: FROM

Line 3028: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

3024: condition_group_id,
3025: tax_rule_id,
3026: fnd_global.user_id , --CREATED_BY ,
3027: fnd_global.user_id , --LAST_UPDATED_BY ,
3028: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3029: NULL , -- RESULT_API ,
3030: 1 --OBJECT_VERSION_NUMBER
3031: FROM
3032: (

Line 3212: fnd_global.conc_request_id, -- REQUEST_ID ,

3208: NULL , --ALLOW_EXCEPTIONS_FLAG ,
3209: 'MIGRATED' , --RECORD_TYPE_CODE ,
3210: sysdate , -- CREATION_DATE ,
3211: sysdate , -- LAST_UPDATE_DATE ,
3212: fnd_global.conc_request_id, -- REQUEST_ID ,
3213: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3214: NULL, -- PROGRAM_ID ,
3215: CONDITION_SET_ID ,
3216: EXCEPTION_SET_ID ,

Line 3213: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

3209: 'MIGRATED' , --RECORD_TYPE_CODE ,
3210: sysdate , -- CREATION_DATE ,
3211: sysdate , -- LAST_UPDATE_DATE ,
3212: fnd_global.conc_request_id, -- REQUEST_ID ,
3213: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3214: NULL, -- PROGRAM_ID ,
3215: CONDITION_SET_ID ,
3216: EXCEPTION_SET_ID ,
3217: NULL , -- PROGRAM_LOGIN_ID ,

Line 3222: fnd_global.user_id , --CREATED_BY ,

3218: zx_process_results_s.nextval,
3219: CONTENT_OWNER_ID ,
3220: condition_group_id,
3221: tax_rule_id,
3222: fnd_global.user_id , --CREATED_BY ,
3223: fnd_global.user_id , --LAST_UPDATED_BY ,
3224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3225: NULL , -- RESULT_API ,
3226: 1 --OBJECT_VERSION_NUMBER

Line 3223: fnd_global.user_id , --LAST_UPDATED_BY ,

3219: CONTENT_OWNER_ID ,
3220: condition_group_id,
3221: tax_rule_id,
3222: fnd_global.user_id , --CREATED_BY ,
3223: fnd_global.user_id , --LAST_UPDATED_BY ,
3224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3225: NULL , -- RESULT_API ,
3226: 1 --OBJECT_VERSION_NUMBER
3227: FROM

Line 3224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

3220: condition_group_id,
3221: tax_rule_id,
3222: fnd_global.user_id , --CREATED_BY ,
3223: fnd_global.user_id , --LAST_UPDATED_BY ,
3224: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3225: NULL , -- RESULT_API ,
3226: 1 --OBJECT_VERSION_NUMBER
3227: FROM
3228: (

Line 3426: fnd_global.conc_request_id, -- REQUEST_ID ,

3422: NULL , --ALLOW_EXCEPTIONS_FLAG ,
3423: 'MIGRATED' , --RECORD_TYPE_CODE ,
3424: sysdate , -- CREATION_DATE ,
3425: sysdate , -- LAST_UPDATE_DATE ,
3426: fnd_global.conc_request_id, -- REQUEST_ID ,
3427: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3428: NULL, -- PROGRAM_ID ,
3429: CONDITION_SET_ID ,
3430: EXCEPTION_SET_ID ,

Line 3427: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,

3423: 'MIGRATED' , --RECORD_TYPE_CODE ,
3424: sysdate , -- CREATION_DATE ,
3425: sysdate , -- LAST_UPDATE_DATE ,
3426: fnd_global.conc_request_id, -- REQUEST_ID ,
3427: fnd_global.prog_appl_id, --PROGRAM_APPLICATION_ID,
3428: NULL, -- PROGRAM_ID ,
3429: CONDITION_SET_ID ,
3430: EXCEPTION_SET_ID ,
3431: NULL , -- PROGRAM_LOGIN_ID ,

Line 3436: fnd_global.user_id , --CREATED_BY ,

3432: zx_process_results_s.nextval,
3433: CONTENT_OWNER_ID ,
3434: condition_group_id,
3435: tax_rule_id,
3436: fnd_global.user_id , --CREATED_BY ,
3437: fnd_global.user_id , --LAST_UPDATED_BY ,
3438: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3439: NULL , -- RESULT_API ,
3440: 1 --OBJECT_VERSION_NUMBER

Line 3437: fnd_global.user_id , --LAST_UPDATED_BY ,

3433: CONTENT_OWNER_ID ,
3434: condition_group_id,
3435: tax_rule_id,
3436: fnd_global.user_id , --CREATED_BY ,
3437: fnd_global.user_id , --LAST_UPDATED_BY ,
3438: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3439: NULL , -- RESULT_API ,
3440: 1 --OBJECT_VERSION_NUMBER
3441: FROM

Line 3438: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN

3434: condition_group_id,
3435: tax_rule_id,
3436: fnd_global.user_id , --CREATED_BY ,
3437: fnd_global.user_id , --LAST_UPDATED_BY ,
3438: fnd_global.conc_login_id, --LAST_UPDATE_LOGIN
3439: NULL , -- RESULT_API ,
3440: 1 --OBJECT_VERSION_NUMBER
3441: FROM
3442: (