APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on FND_GLOBAL

Line 270: fnd_global.user_id ,

266: NULL ,--EXCEPTION_CODE
267: report_types.EFFECTIVE_FROM ,
268: NULL ,--EFFECTIVE_TO
269: 'MIGRATED' ,--RECORD_TYPE_CODE
270: fnd_global.user_id ,
271: SYSDATE ,
272: fnd_global.user_id ,
273: SYSDATE ,
274: fnd_global.conc_login_id ,

Line 272: fnd_global.user_id ,

268: NULL ,--EFFECTIVE_TO
269: 'MIGRATED' ,--RECORD_TYPE_CODE
270: fnd_global.user_id ,
271: SYSDATE ,
272: fnd_global.user_id ,
273: SYSDATE ,
274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID

Line 274: fnd_global.conc_login_id ,

270: fnd_global.user_id ,
271: SYSDATE ,
272: fnd_global.user_id ,
273: SYSDATE ,
274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID
277: fnd_global.conc_program_id , -- Program Id
278: fnd_global.conc_login_id , -- Program Login ID

Line 275: fnd_global.conc_request_id , -- Request Id

271: SYSDATE ,
272: fnd_global.user_id ,
273: SYSDATE ,
274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID
277: fnd_global.conc_program_id , -- Program Id
278: fnd_global.conc_login_id , -- Program Login ID
279: l_lookup_code,

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

272: fnd_global.user_id ,
273: SYSDATE ,
274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID
277: fnd_global.conc_program_id , -- Program Id
278: fnd_global.conc_login_id , -- Program Login ID
279: l_lookup_code,
280: NULL,

Line 277: fnd_global.conc_program_id , -- Program Id

273: SYSDATE ,
274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID
277: fnd_global.conc_program_id , -- Program Id
278: fnd_global.conc_login_id , -- Program Login ID
279: l_lookup_code,
280: NULL,
281: NULL,

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

274: fnd_global.conc_login_id ,
275: fnd_global.conc_request_id , -- Request Id
276: fnd_global.prog_appl_id , -- Program Application ID
277: fnd_global.conc_program_id , -- Program Id
278: fnd_global.conc_login_id , -- Program Login ID
279: l_lookup_code,
280: NULL,
281: NULL,
282: report_types.REPORTING_TYPE_ID,

Line 344: fnd_global.user_id ,

340: effective_from ,
341: NULL ,--EFFECTIVE_TO
342: 'MIGRATED' ,--RECORD_TYPE_CODE
343: 'N' ,--HAS_REPORTING_CODES_FLAG
344: fnd_global.user_id ,
345: SYSDATE ,
346: fnd_global.user_id ,
347: SYSDATE ,
348: fnd_global.conc_login_id ,

Line 346: fnd_global.user_id ,

342: 'MIGRATED' ,--RECORD_TYPE_CODE
343: 'N' ,--HAS_REPORTING_CODES_FLAG
344: fnd_global.user_id ,
345: SYSDATE ,
346: fnd_global.user_id ,
347: SYSDATE ,
348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID

Line 348: fnd_global.conc_login_id ,

344: fnd_global.user_id ,
345: SYSDATE ,
346: fnd_global.user_id ,
347: SYSDATE ,
348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID
351: fnd_global.conc_program_id , -- Program Id
352: fnd_global.conc_login_id , -- Program Login ID

Line 349: fnd_global.conc_request_id , -- Request Id

345: SYSDATE ,
346: fnd_global.user_id ,
347: SYSDATE ,
348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID
351: fnd_global.conc_program_id , -- Program Id
352: fnd_global.conc_login_id , -- Program Login ID
353: 1

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

346: fnd_global.user_id ,
347: SYSDATE ,
348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID
351: fnd_global.conc_program_id , -- Program Id
352: fnd_global.conc_login_id , -- Program Login ID
353: 1
354: )

Line 351: fnd_global.conc_program_id , -- Program Id

347: SYSDATE ,
348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID
351: fnd_global.conc_program_id , -- Program Id
352: fnd_global.conc_login_id , -- Program Login ID
353: 1
354: )
355: -- Creation of CAI NUMBER Reporting Type and Usage

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

348: fnd_global.conc_login_id ,
349: fnd_global.conc_request_id , -- Request Id
350: fnd_global.prog_appl_id , -- Program Application ID
351: fnd_global.conc_program_id , -- Program Id
352: fnd_global.conc_login_id , -- Program Login ID
353: 1
354: )
355: -- Creation of CAI NUMBER Reporting Type and Usage
356:

Line 402: fnd_global.user_id ,

398: effective_from ,
399: NULL ,--EFFECTIVE_TO
400: 'MIGRATED' ,--RECORD_TYPE_CODE
401: 'N' ,--HAS_REPORTING_CODES_FLAG
402: fnd_global.user_id ,
403: SYSDATE ,
404: fnd_global.user_id ,
405: SYSDATE ,
406: fnd_global.conc_login_id ,

Line 404: fnd_global.user_id ,

400: 'MIGRATED' ,--RECORD_TYPE_CODE
401: 'N' ,--HAS_REPORTING_CODES_FLAG
402: fnd_global.user_id ,
403: SYSDATE ,
404: fnd_global.user_id ,
405: SYSDATE ,
406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID

Line 406: fnd_global.conc_login_id ,

402: fnd_global.user_id ,
403: SYSDATE ,
404: fnd_global.user_id ,
405: SYSDATE ,
406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID
409: fnd_global.conc_program_id , -- Program Id
410: fnd_global.conc_login_id , -- Program Login ID

Line 407: fnd_global.conc_request_id , -- Request Id

403: SYSDATE ,
404: fnd_global.user_id ,
405: SYSDATE ,
406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID
409: fnd_global.conc_program_id , -- Program Id
410: fnd_global.conc_login_id , -- Program Login ID
411: 1

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

404: fnd_global.user_id ,
405: SYSDATE ,
406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID
409: fnd_global.conc_program_id , -- Program Id
410: fnd_global.conc_login_id , -- Program Login ID
411: 1
412: )

Line 409: fnd_global.conc_program_id , -- Program Id

405: SYSDATE ,
406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID
409: fnd_global.conc_program_id , -- Program Id
410: fnd_global.conc_login_id , -- Program Login ID
411: 1
412: )
413:

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

406: fnd_global.conc_login_id ,
407: fnd_global.conc_request_id , -- Request Id
408: fnd_global.prog_appl_id , -- Program Application ID
409: fnd_global.conc_program_id , -- Program Id
410: fnd_global.conc_login_id , -- Program Login ID
411: 1
412: )
413:
414: --Bug# 3587896

Line 445: fnd_global.user_id ,--CREATED_BY

441: decode(LOOKUP_CODE,
442: 'ZX_PARTY_TAX_PROFILE',
443: 'Y',
444: 'N') ,--ENABLED_FLAG
445: fnd_global.user_id ,--CREATED_BY
446: SYSDATE ,--CREATION_DATE
447: fnd_global.user_id ,--LAST_UPDATED_BY
448: SYSDATE ,--LAST_UPDATE_DATE
449: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 447: fnd_global.user_id ,--LAST_UPDATED_BY

443: 'Y',
444: 'N') ,--ENABLED_FLAG
445: fnd_global.user_id ,--CREATED_BY
446: SYSDATE ,--CREATION_DATE
447: fnd_global.user_id ,--LAST_UPDATED_BY
448: SYSDATE ,--LAST_UPDATE_DATE
449: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
450: reporting_type_id ,--REPORTING_TYPE_ID
451: 1

Line 449: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

445: fnd_global.user_id ,--CREATED_BY
446: SYSDATE ,--CREATION_DATE
447: fnd_global.user_id ,--LAST_UPDATED_BY
448: SYSDATE ,--LAST_UPDATE_DATE
449: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
450: reporting_type_id ,--REPORTING_TYPE_ID
451: 1
452:
453: FROM

Line 484: fnd_global.user_id ,--CREATED_BY

480: decode(LOOKUP_CODE,
481: 'ZX_PARTY_TAX_PROFILE',
482: 'Y',
483: 'N') ,--ENABLED_FLAG
484: fnd_global.user_id ,--CREATED_BY
485: SYSDATE ,--CREATION_DATE
486: fnd_global.user_id ,--LAST_UPDATED_BY
487: SYSDATE ,--LAST_UPDATE_DATE
488: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 486: fnd_global.user_id ,--LAST_UPDATED_BY

482: 'Y',
483: 'N') ,--ENABLED_FLAG
484: fnd_global.user_id ,--CREATED_BY
485: SYSDATE ,--CREATION_DATE
486: fnd_global.user_id ,--LAST_UPDATED_BY
487: SYSDATE ,--LAST_UPDATE_DATE
488: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
489: reporting_type_id ,--REPORTING_TYPE_ID
490: 1

Line 488: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

484: fnd_global.user_id ,--CREATED_BY
485: SYSDATE ,--CREATION_DATE
486: fnd_global.user_id ,--LAST_UPDATED_BY
487: SYSDATE ,--LAST_UPDATE_DATE
488: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
489: reporting_type_id ,--REPORTING_TYPE_ID
490: 1
491: FROM
492: zx_reporting_types_b rep_type,

Line 523: fnd_global.user_id ,

519: lookups.lookup_code ,--ENTITY_CODE
520: DECODE(lookups.lookup_code,
521: 'ZX_RATES','Y', --Bug 5528045
522: 'N') ,--ENABLED_FLAG
523: fnd_global.user_id ,
524: SYSDATE ,
525: fnd_global.user_id ,
526: SYSDATE ,
527: fnd_global.conc_login_id,

Line 525: fnd_global.user_id ,

521: 'ZX_RATES','Y', --Bug 5528045
522: 'N') ,--ENABLED_FLAG
523: fnd_global.user_id ,
524: SYSDATE ,
525: fnd_global.user_id ,
526: SYSDATE ,
527: fnd_global.conc_login_id,
528: 1
529: FROM

Line 527: fnd_global.conc_login_id,

523: fnd_global.user_id ,
524: SYSDATE ,
525: fnd_global.user_id ,
526: SYSDATE ,
527: fnd_global.conc_login_id,
528: 1
529: FROM
530: zx_reporting_types_b types,
531: fnd_lookups lookups

Line 586: fnd_global.user_id ,

582: NULL ,--EXCEPTION_CODE
583: EFFECTIVE_FROM ,
584: NULL ,--EFFECTIVE_TO
585: 'MIGRATED' ,--RECORD_TYPE_CODE
586: fnd_global.user_id ,
587: SYSDATE ,
588: fnd_global.user_id ,
589: SYSDATE ,
590: fnd_global.conc_login_id ,

Line 588: fnd_global.user_id ,

584: NULL ,--EFFECTIVE_TO
585: 'MIGRATED' ,--RECORD_TYPE_CODE
586: fnd_global.user_id ,
587: SYSDATE ,
588: fnd_global.user_id ,
589: SYSDATE ,
590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID

Line 590: fnd_global.conc_login_id ,

586: fnd_global.user_id ,
587: SYSDATE ,
588: fnd_global.user_id ,
589: SYSDATE ,
590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID
593: fnd_global.conc_program_id , -- Program Id
594: fnd_global.conc_login_id , -- Program Login ID

Line 591: fnd_global.conc_request_id , -- Request Id

587: SYSDATE ,
588: fnd_global.user_id ,
589: SYSDATE ,
590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID
593: fnd_global.conc_program_id , -- Program Id
594: fnd_global.conc_login_id , -- Program Login ID
595: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

588: fnd_global.user_id ,
589: SYSDATE ,
590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID
593: fnd_global.conc_program_id , -- Program Id
594: fnd_global.conc_login_id , -- Program Login ID
595: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
596: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 593: fnd_global.conc_program_id , -- Program Id

589: SYSDATE ,
590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID
593: fnd_global.conc_program_id , -- Program Id
594: fnd_global.conc_login_id , -- Program Login ID
595: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
596: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
597: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

590: fnd_global.conc_login_id ,
591: fnd_global.conc_request_id , -- Request Id
592: fnd_global.prog_appl_id , -- Program Application ID
593: fnd_global.conc_program_id , -- Program Id
594: fnd_global.conc_login_id , -- Program Login ID
595: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
596: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
597: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
598: REPORTING_TYPE_ID,

Line 644: fnd_global.user_id ,

640: THEN Initcap(lookups.meaning)
641: ELSE
642: lookups.meaning
643: END,
644: fnd_global.user_id ,
645: sysdate ,
646: fnd_global.user_id ,
647: sysdate ,
648: fnd_global.conc_login_id

Line 646: fnd_global.user_id ,

642: lookups.meaning
643: END,
644: fnd_global.user_id ,
645: sysdate ,
646: fnd_global.user_id ,
647: sysdate ,
648: fnd_global.conc_login_id
649: FROM
650: ZX_REPORTING_TYPES_B TYPES,

Line 648: fnd_global.conc_login_id

644: fnd_global.user_id ,
645: sysdate ,
646: fnd_global.user_id ,
647: sysdate ,
648: fnd_global.conc_login_id
649: FROM
650: ZX_REPORTING_TYPES_B TYPES,
651: ZX_REPORTING_CODES_B CODES,
652: FND_LOOKUP_VALUES lookups,

Line 688: fnd_global.user_id ,

684: REPORTING_TYPE_ID ,
685: LANGUAGE_CODE ,
686: userenv('LANG') ,
687: REPORTING_TYPE_NAME ,
688: fnd_global.user_id ,
689: SYSDATE ,
690: fnd_global.user_id ,
691: SYSDATE ,
692: fnd_global.conc_login_id

Line 690: fnd_global.user_id ,

686: userenv('LANG') ,
687: REPORTING_TYPE_NAME ,
688: fnd_global.user_id ,
689: SYSDATE ,
690: fnd_global.user_id ,
691: SYSDATE ,
692: fnd_global.conc_login_id
693:
694: FROM

Line 692: fnd_global.conc_login_id

688: fnd_global.user_id ,
689: SYSDATE ,
690: fnd_global.user_id ,
691: SYSDATE ,
692: fnd_global.conc_login_id
693:
694: FROM
695: (
696: SELECT

Line 768: fnd_global.user_id ,

764: codes.reporting_code_id ,
765: lookups.language ,
766: lookups.source_lang ,
767: lookups.meaning ,
768: fnd_global.user_id ,
769: sysdate ,
770: fnd_global.user_id ,
771: sysdate ,
772: fnd_global.conc_login_id

Line 770: fnd_global.user_id ,

766: lookups.source_lang ,
767: lookups.meaning ,
768: fnd_global.user_id ,
769: sysdate ,
770: fnd_global.user_id ,
771: sysdate ,
772: fnd_global.conc_login_id
773: FROM
774: ZX_REPORTING_TYPES_B TYPES,

Line 772: fnd_global.conc_login_id

768: fnd_global.user_id ,
769: sysdate ,
770: fnd_global.user_id ,
771: sysdate ,
772: fnd_global.conc_login_id
773: FROM
774: ZX_REPORTING_TYPES_B TYPES,
775: ZX_REPORTING_CODES_B CODES,
776: FND_LOOKUP_VALUES lookups,

Line 825: fnd_global.user_id ,

821: ELSE
822: CODES.REPORTING_CODE_CHAR_VALUE
823: END
824: END ,--REPORTING_CODE_NAME
825: fnd_global.user_id ,
826: SYSDATE ,
827: fnd_global.user_id ,
828: SYSDATE ,
829: fnd_global.conc_login_id

Line 827: fnd_global.user_id ,

823: END
824: END ,--REPORTING_CODE_NAME
825: fnd_global.user_id ,
826: SYSDATE ,
827: fnd_global.user_id ,
828: SYSDATE ,
829: fnd_global.conc_login_id
830: FROM
831: ZX_REPORTING_CODES_B CODES,

Line 829: fnd_global.conc_login_id

825: fnd_global.user_id ,
826: SYSDATE ,
827: fnd_global.user_id ,
828: SYSDATE ,
829: fnd_global.conc_login_id
830: FROM
831: ZX_REPORTING_CODES_B CODES,
832: FND_LANGUAGES L
833:

Line 919: fnd_global.user_id ,

915: effective_from ,
916: NULL ,--EFFECTIVE_TO
917: 'MIGRATED' ,--RECORD_TYPE_CODE
918: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
919: fnd_global.user_id ,
920: SYSDATE ,
921: fnd_global.user_id ,
922: SYSDATE ,
923: fnd_global.conc_login_id ,

Line 921: fnd_global.user_id ,

917: 'MIGRATED' ,--RECORD_TYPE_CODE
918: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
919: fnd_global.user_id ,
920: SYSDATE ,
921: fnd_global.user_id ,
922: SYSDATE ,
923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID

Line 923: fnd_global.conc_login_id ,

919: fnd_global.user_id ,
920: SYSDATE ,
921: fnd_global.user_id ,
922: SYSDATE ,
923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID
926: fnd_global.conc_program_id , -- Program Id
927: fnd_global.conc_login_id , -- Program Login ID

Line 924: fnd_global.conc_request_id , -- Request Id

920: SYSDATE ,
921: fnd_global.user_id ,
922: SYSDATE ,
923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID
926: fnd_global.conc_program_id , -- Program Id
927: fnd_global.conc_login_id , -- Program Login ID
928: 1

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

921: fnd_global.user_id ,
922: SYSDATE ,
923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID
926: fnd_global.conc_program_id , -- Program Id
927: fnd_global.conc_login_id , -- Program Login ID
928: 1
929: )

Line 926: fnd_global.conc_program_id , -- Program Id

922: SYSDATE ,
923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID
926: fnd_global.conc_program_id , -- Program Id
927: fnd_global.conc_login_id , -- Program Login ID
928: 1
929: )
930: SELECT

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

923: fnd_global.conc_login_id ,
924: fnd_global.conc_request_id , -- Request Id
925: fnd_global.prog_appl_id , -- Program Application ID
926: fnd_global.conc_program_id , -- Program Id
927: fnd_global.conc_login_id , -- Program Login ID
928: 1
929: )
930: SELECT
931: min(zx_rates.effective_from) effective_from,

Line 1008: fnd_global.user_id ,

1004: effective_from ,
1005: NULL ,--EFFECTIVE_TO
1006: 'MIGRATED' ,--RECORD_TYPE_CODE
1007: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
1008: fnd_global.user_id ,
1009: SYSDATE ,
1010: fnd_global.user_id ,
1011: SYSDATE ,
1012: fnd_global.conc_login_id ,

Line 1010: fnd_global.user_id ,

1006: 'MIGRATED' ,--RECORD_TYPE_CODE
1007: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
1008: fnd_global.user_id ,
1009: SYSDATE ,
1010: fnd_global.user_id ,
1011: SYSDATE ,
1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID

Line 1012: fnd_global.conc_login_id ,

1008: fnd_global.user_id ,
1009: SYSDATE ,
1010: fnd_global.user_id ,
1011: SYSDATE ,
1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID
1015: fnd_global.conc_program_id , -- Program Id
1016: fnd_global.conc_login_id , -- Program Login ID

Line 1013: fnd_global.conc_request_id , -- Request Id

1009: SYSDATE ,
1010: fnd_global.user_id ,
1011: SYSDATE ,
1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID
1015: fnd_global.conc_program_id , -- Program Id
1016: fnd_global.conc_login_id , -- Program Login ID
1017: 1

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

1010: fnd_global.user_id ,
1011: SYSDATE ,
1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID
1015: fnd_global.conc_program_id , -- Program Id
1016: fnd_global.conc_login_id , -- Program Login ID
1017: 1
1018: )

Line 1015: fnd_global.conc_program_id , -- Program Id

1011: SYSDATE ,
1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID
1015: fnd_global.conc_program_id , -- Program Id
1016: fnd_global.conc_login_id , -- Program Login ID
1017: 1
1018: )
1019: SELECT

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

1012: fnd_global.conc_login_id ,
1013: fnd_global.conc_request_id , -- Request Id
1014: fnd_global.prog_appl_id , -- Program Application ID
1015: fnd_global.conc_program_id , -- Program Id
1016: fnd_global.conc_login_id , -- Program Login ID
1017: 1
1018: )
1019: SELECT
1020: min(zx_rates.effective_from) effective_from,

Line 1078: fnd_global.user_id ,

1074: NULL ,--EXCEPTION_CODE
1075: EFFECTIVE_FROM ,
1076: NULL ,--EFFECTIVE_TO
1077: 'MIGRATED' ,--RECORD_TYPE_CODE
1078: fnd_global.user_id ,
1079: SYSDATE ,
1080: fnd_global.user_id ,
1081: SYSDATE ,
1082: fnd_global.conc_login_id ,

Line 1080: fnd_global.user_id ,

1076: NULL ,--EFFECTIVE_TO
1077: 'MIGRATED' ,--RECORD_TYPE_CODE
1078: fnd_global.user_id ,
1079: SYSDATE ,
1080: fnd_global.user_id ,
1081: SYSDATE ,
1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID

Line 1082: fnd_global.conc_login_id ,

1078: fnd_global.user_id ,
1079: SYSDATE ,
1080: fnd_global.user_id ,
1081: SYSDATE ,
1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID
1085: fnd_global.conc_program_id , -- Program Id
1086: fnd_global.conc_login_id , -- Program Login ID

Line 1083: fnd_global.conc_request_id , -- Request Id

1079: SYSDATE ,
1080: fnd_global.user_id ,
1081: SYSDATE ,
1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID
1085: fnd_global.conc_program_id , -- Program Id
1086: fnd_global.conc_login_id , -- Program Login ID
1087: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

1080: fnd_global.user_id ,
1081: SYSDATE ,
1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID
1085: fnd_global.conc_program_id , -- Program Id
1086: fnd_global.conc_login_id , -- Program Login ID
1087: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1088: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 1085: fnd_global.conc_program_id , -- Program Id

1081: SYSDATE ,
1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID
1085: fnd_global.conc_program_id , -- Program Id
1086: fnd_global.conc_login_id , -- Program Login ID
1087: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1088: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
1089: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

1082: fnd_global.conc_login_id ,
1083: fnd_global.conc_request_id , -- Request Id
1084: fnd_global.prog_appl_id , -- Program Application ID
1085: fnd_global.conc_program_id , -- Program Id
1086: fnd_global.conc_login_id , -- Program Login ID
1087: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1088: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
1089: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
1090: REPORTING_TYPE_ID,

Line 1136: fnd_global.user_id ,

1132: THEN Initcap(lookups.meaning)
1133: ELSE
1134: lookups.meaning
1135: END,
1136: fnd_global.user_id ,
1137: sysdate ,
1138: fnd_global.user_id ,
1139: sysdate ,
1140: fnd_global.conc_login_id

Line 1138: fnd_global.user_id ,

1134: lookups.meaning
1135: END,
1136: fnd_global.user_id ,
1137: sysdate ,
1138: fnd_global.user_id ,
1139: sysdate ,
1140: fnd_global.conc_login_id
1141: FROM
1142: ZX_REPORTING_TYPES_B TYPES,

Line 1140: fnd_global.conc_login_id

1136: fnd_global.user_id ,
1137: sysdate ,
1138: fnd_global.user_id ,
1139: sysdate ,
1140: fnd_global.conc_login_id
1141: FROM
1142: ZX_REPORTING_TYPES_B TYPES,
1143: ZX_REPORTING_CODES_B CODES,
1144: FND_LOOKUP_VALUES lookups,

Line 1226: fnd_global.user_id,

1222: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1223: null, --EXCEPTION_CODE
1224: sysdate, --EFFECTIVE_FROM
1225: null, --EFFECTIVE_TO
1226: fnd_global.user_id,
1227: sysdate,
1228: fnd_global.user_id,
1229: sysdate,
1230: fnd_global.conc_login_id,

Line 1228: fnd_global.user_id,

1224: sysdate, --EFFECTIVE_FROM
1225: null, --EFFECTIVE_TO
1226: fnd_global.user_id,
1227: sysdate,
1228: fnd_global.user_id,
1229: sysdate,
1230: fnd_global.conc_login_id,
1231: 1
1232: FROM

Line 1230: fnd_global.conc_login_id,

1226: fnd_global.user_id,
1227: sysdate,
1228: fnd_global.user_id,
1229: sysdate,
1230: fnd_global.conc_login_id,
1231: 1
1232: FROM
1233: zx_reporting_types_b types,
1234: ap_supplier_sites pvs,

Line 1276: fnd_global.user_id,

1272: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1273: null, --EXCEPTION_CODE
1274: sysdate, --EFFECTIVE_FROM
1275: to_date(pvs.GLOBAL_ATTRIBUTE20,'yyyy/mm/dd hh24:mi:ss'),--EFFECTIVE_TO
1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.user_id,
1279: sysdate,
1280: fnd_global.conc_login_id,

Line 1278: fnd_global.user_id,

1274: sysdate, --EFFECTIVE_FROM
1275: to_date(pvs.GLOBAL_ATTRIBUTE20,'yyyy/mm/dd hh24:mi:ss'),--EFFECTIVE_TO
1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.user_id,
1279: sysdate,
1280: fnd_global.conc_login_id,
1281: 1
1282: FROM

Line 1280: fnd_global.conc_login_id,

1276: fnd_global.user_id,
1277: sysdate,
1278: fnd_global.user_id,
1279: sysdate,
1280: fnd_global.conc_login_id,
1281: 1
1282: FROM
1283: zx_reporting_types_b types,
1284: ap_supplier_sites pvs ,

Line 1329: fnd_global.user_id ,

1325: report_codes.REPORTING_CODE_ID ,
1326: NULL ,--EXCEPTION_CODE
1327: rates.EFFECTIVE_FROM ,
1328: NULL ,--EFFECTIVE_TO
1329: fnd_global.user_id ,
1330: SYSDATE ,
1331: fnd_global.user_id ,
1332: SYSDATE ,
1333: fnd_global.conc_login_id ,

Line 1331: fnd_global.user_id ,

1327: rates.EFFECTIVE_FROM ,
1328: NULL ,--EFFECTIVE_TO
1329: fnd_global.user_id ,
1330: SYSDATE ,
1331: fnd_global.user_id ,
1332: SYSDATE ,
1333: fnd_global.conc_login_id ,
1334: report_codes.REPORTING_CODE_CHAR_VALUE ,
1335: report_codes.REPORTING_CODE_DATE_VALUE ,

Line 1333: fnd_global.conc_login_id ,

1329: fnd_global.user_id ,
1330: SYSDATE ,
1331: fnd_global.user_id ,
1332: SYSDATE ,
1333: fnd_global.conc_login_id ,
1334: report_codes.REPORTING_CODE_CHAR_VALUE ,
1335: report_codes.REPORTING_CODE_DATE_VALUE ,
1336: report_codes.REPORTING_CODE_NUM_VALUE ,
1337: 1

Line 1393: fnd_global.user_id ,

1389: REPORTING_CODE_ID ,
1390: NULL ,--EXCEPTION_CODE
1391: EFFECTIVE_FROM ,
1392: NULL ,--EFFECTIVE_TO
1393: fnd_global.user_id ,
1394: SYSDATE ,
1395: fnd_global.user_id ,
1396: SYSDATE ,
1397: fnd_global.conc_login_id ,

Line 1395: fnd_global.user_id ,

1391: EFFECTIVE_FROM ,
1392: NULL ,--EFFECTIVE_TO
1393: fnd_global.user_id ,
1394: SYSDATE ,
1395: fnd_global.user_id ,
1396: SYSDATE ,
1397: fnd_global.conc_login_id ,
1398: REPORTING_CODE_CHAR_VALUE,
1399: REPORTING_CODE_DATE_VALUE,

Line 1397: fnd_global.conc_login_id ,

1393: fnd_global.user_id ,
1394: SYSDATE ,
1395: fnd_global.user_id ,
1396: SYSDATE ,
1397: fnd_global.conc_login_id ,
1398: REPORTING_CODE_CHAR_VALUE,
1399: REPORTING_CODE_DATE_VALUE,
1400: REPORTING_CODE_NUM_VALUE,
1401: 1

Line 1809: fnd_global.user_id,

1805: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1806: null, --EXCEPTION_CODE
1807: codes.EFFECTIVE_FROM, --EFFECTIVE_FROM
1808: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1809: fnd_global.user_id,
1810: sysdate,
1811: fnd_global.user_id,
1812: sysdate,
1813: fnd_global.conc_login_id,

Line 1811: fnd_global.user_id,

1807: codes.EFFECTIVE_FROM, --EFFECTIVE_FROM
1808: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1809: fnd_global.user_id,
1810: sysdate,
1811: fnd_global.user_id,
1812: sysdate,
1813: fnd_global.conc_login_id,
1814: 1 -- Bug 5031787
1815: FROM

Line 1813: fnd_global.conc_login_id,

1809: fnd_global.user_id,
1810: sysdate,
1811: fnd_global.user_id,
1812: sysdate,
1813: fnd_global.conc_login_id,
1814: 1 -- Bug 5031787
1815: FROM
1816: financials_system_params_all fin_sys_param,
1817: zx_reporting_types_b types,

Line 1859: fnd_global.user_id,

1855: codes.REPORTING_CODE_ID, --REPORTING_CODE_ID
1856: null, --EXCEPTION_CODE
1857: codes.EFFECTIVE_FROM, --EFFECTIVE_FROM
1858: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1859: fnd_global.user_id,
1860: sysdate,
1861: fnd_global.user_id,
1862: sysdate,
1863: fnd_global.conc_login_id,

Line 1861: fnd_global.user_id,

1857: codes.EFFECTIVE_FROM, --EFFECTIVE_FROM
1858: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1859: fnd_global.user_id,
1860: sysdate,
1861: fnd_global.user_id,
1862: sysdate,
1863: fnd_global.conc_login_id,
1864: 1 -- Bug 5031787
1865: FROM

Line 1863: fnd_global.conc_login_id,

1859: fnd_global.user_id,
1860: sysdate,
1861: fnd_global.user_id,
1862: sysdate,
1863: fnd_global.conc_login_id,
1864: 1 -- Bug 5031787
1865: FROM
1866: financials_system_params_all fin_sys_param,
1867: zx_reporting_types_b types,

Line 1919: fnd_global.user_id ,

1915: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
1916: NULL ,--EXCEPTION_CODE
1917: rates.EFFECTIVE_FROM ,
1918: NULL ,--EFFECTIVE_TO
1919: fnd_global.user_id ,
1920: SYSDATE ,
1921: fnd_global.user_id ,
1922: SYSDATE ,
1923: fnd_global.conc_login_id ,

Line 1921: fnd_global.user_id ,

1917: rates.EFFECTIVE_FROM ,
1918: NULL ,--EFFECTIVE_TO
1919: fnd_global.user_id ,
1920: SYSDATE ,
1921: fnd_global.user_id ,
1922: SYSDATE ,
1923: fnd_global.conc_login_id ,
1924: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
1925: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 1923: fnd_global.conc_login_id ,

1919: fnd_global.user_id ,
1920: SYSDATE ,
1921: fnd_global.user_id ,
1922: SYSDATE ,
1923: fnd_global.conc_login_id ,
1924: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
1925: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
1926: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
1927: 1

Line 1998: fnd_global.user_id ,

1994: REPORTING_CODE_ID ,
1995: NULL ,--EXCEPTION_CODE
1996: EFFECTIVE_FROM ,
1997: NULL ,--EFFECTIVE_TO
1998: fnd_global.user_id ,
1999: SYSDATE ,
2000: fnd_global.user_id ,
2001: SYSDATE ,
2002: fnd_global.conc_login_id ,

Line 2000: fnd_global.user_id ,

1996: EFFECTIVE_FROM ,
1997: NULL ,--EFFECTIVE_TO
1998: fnd_global.user_id ,
1999: SYSDATE ,
2000: fnd_global.user_id ,
2001: SYSDATE ,
2002: fnd_global.conc_login_id ,
2003: REPORTING_CODE_CHAR_VALUE,
2004: REPORTING_CODE_DATE_VALUE,

Line 2002: fnd_global.conc_login_id ,

1998: fnd_global.user_id ,
1999: SYSDATE ,
2000: fnd_global.user_id ,
2001: SYSDATE ,
2002: fnd_global.conc_login_id ,
2003: REPORTING_CODE_CHAR_VALUE,
2004: REPORTING_CODE_DATE_VALUE,
2005: REPORTING_CODE_NUM_VALUE,
2006: 1

Line 2685: fnd_global.user_id ,

2681: NULL ,--REPORTING_CODE_ID
2682: NULL ,--EXCEPTION_CODE
2683: EFFECTIVE_FROM ,
2684: NULL ,--EFFECTIVE_TO
2685: fnd_global.user_id ,
2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.conc_login_id ,

Line 2687: fnd_global.user_id ,

2683: EFFECTIVE_FROM ,
2684: NULL ,--EFFECTIVE_TO
2685: fnd_global.user_id ,
2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.conc_login_id ,
2690: REPORTING_CODE_CHAR_VALUE ,
2691: NULL,

Line 2689: fnd_global.conc_login_id ,

2685: fnd_global.user_id ,
2686: SYSDATE ,
2687: fnd_global.user_id ,
2688: SYSDATE ,
2689: fnd_global.conc_login_id ,
2690: REPORTING_CODE_CHAR_VALUE ,
2691: NULL,
2692: NULL,
2693: 1

Line 2867: fnd_global.user_id ,

2863: NULL ,--REPORTING_CODE_NUM_VALUE
2864: NULL ,--EXCEPTION_CODE
2865: EFFECTIVE_FROM ,
2866: NULL ,--EFFECTIVE_TO
2867: fnd_global.user_id ,
2868: SYSDATE ,
2869: fnd_global.user_id ,
2870: SYSDATE ,
2871: fnd_global.conc_login_id ,

Line 2869: fnd_global.user_id ,

2865: EFFECTIVE_FROM ,
2866: NULL ,--EFFECTIVE_TO
2867: fnd_global.user_id ,
2868: SYSDATE ,
2869: fnd_global.user_id ,
2870: SYSDATE ,
2871: fnd_global.conc_login_id ,
2872: 1
2873: FROM

Line 2871: fnd_global.conc_login_id ,

2867: fnd_global.user_id ,
2868: SYSDATE ,
2869: fnd_global.user_id ,
2870: SYSDATE ,
2871: fnd_global.conc_login_id ,
2872: 1
2873: FROM
2874: (
2875: SELECT rates.TAX_RATE_ID TAX_RATE_ID,

Line 2960: fnd_global.user_id ,

2956: effective_from ,
2957: NULL ,--EFFECTIVE_TO
2958: 'MIGRATED' ,--RECORD_TYPE_CODE
2959: 'Y' ,
2960: fnd_global.user_id ,
2961: SYSDATE ,
2962: fnd_global.user_id ,
2963: SYSDATE ,
2964: fnd_global.conc_login_id ,

Line 2962: fnd_global.user_id ,

2958: 'MIGRATED' ,--RECORD_TYPE_CODE
2959: 'Y' ,
2960: fnd_global.user_id ,
2961: SYSDATE ,
2962: fnd_global.user_id ,
2963: SYSDATE ,
2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID

Line 2964: fnd_global.conc_login_id ,

2960: fnd_global.user_id ,
2961: SYSDATE ,
2962: fnd_global.user_id ,
2963: SYSDATE ,
2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID
2967: fnd_global.conc_program_id , -- Program Id
2968: fnd_global.conc_login_id , -- Program Login ID

Line 2965: fnd_global.conc_request_id , -- Request Id

2961: SYSDATE ,
2962: fnd_global.user_id ,
2963: SYSDATE ,
2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID
2967: fnd_global.conc_program_id , -- Program Id
2968: fnd_global.conc_login_id , -- Program Login ID
2969: 1

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

2962: fnd_global.user_id ,
2963: SYSDATE ,
2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID
2967: fnd_global.conc_program_id , -- Program Id
2968: fnd_global.conc_login_id , -- Program Login ID
2969: 1
2970: )

Line 2967: fnd_global.conc_program_id , -- Program Id

2963: SYSDATE ,
2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID
2967: fnd_global.conc_program_id , -- Program Id
2968: fnd_global.conc_login_id , -- Program Login ID
2969: 1
2970: )
2971: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

2964: fnd_global.conc_login_id ,
2965: fnd_global.conc_request_id , -- Request Id
2966: fnd_global.prog_appl_id , -- Program Application ID
2967: fnd_global.conc_program_id , -- Program Id
2968: fnd_global.conc_login_id , -- Program Login ID
2969: 1
2970: )
2971: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
2972: where reporting_type_code='PT_PRD_TAXABLE_BOX'

Line 3015: fnd_global.user_id ,

3011: effective_from ,
3012: NULL ,--EFFECTIVE_TO
3013: 'MIGRATED' ,--RECORD_TYPE_CODE
3014: 'N' ,
3015: fnd_global.user_id ,
3016: SYSDATE ,
3017: fnd_global.user_id ,
3018: SYSDATE ,
3019: fnd_global.conc_login_id ,

Line 3017: fnd_global.user_id ,

3013: 'MIGRATED' ,--RECORD_TYPE_CODE
3014: 'N' ,
3015: fnd_global.user_id ,
3016: SYSDATE ,
3017: fnd_global.user_id ,
3018: SYSDATE ,
3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID

Line 3019: fnd_global.conc_login_id ,

3015: fnd_global.user_id ,
3016: SYSDATE ,
3017: fnd_global.user_id ,
3018: SYSDATE ,
3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID
3022: fnd_global.conc_program_id , -- Program Id
3023: fnd_global.conc_login_id ,-- Program Login ID

Line 3020: fnd_global.conc_request_id , -- Request Id

3016: SYSDATE ,
3017: fnd_global.user_id ,
3018: SYSDATE ,
3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID
3022: fnd_global.conc_program_id , -- Program Id
3023: fnd_global.conc_login_id ,-- Program Login ID
3024: 1

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

3017: fnd_global.user_id ,
3018: SYSDATE ,
3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID
3022: fnd_global.conc_program_id , -- Program Id
3023: fnd_global.conc_login_id ,-- Program Login ID
3024: 1
3025: )

Line 3022: fnd_global.conc_program_id , -- Program Id

3018: SYSDATE ,
3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID
3022: fnd_global.conc_program_id , -- Program Id
3023: fnd_global.conc_login_id ,-- Program Login ID
3024: 1
3025: )
3026: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3019: fnd_global.conc_login_id ,
3020: fnd_global.conc_request_id , -- Request Id
3021: fnd_global.prog_appl_id , -- Program Application ID
3022: fnd_global.conc_program_id , -- Program Id
3023: fnd_global.conc_login_id ,-- Program Login ID
3024: 1
3025: )
3026: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3027: where reporting_type_code='PT_PRD_REC_TAX_BOX'

Line 3070: fnd_global.user_id ,

3066: effective_from ,
3067: NULL ,--EFFECTIVE_TO
3068: 'MIGRATED' ,--RECORD_TYPE_CODE
3069: 'N' ,
3070: fnd_global.user_id ,
3071: SYSDATE ,
3072: fnd_global.user_id ,
3073: SYSDATE ,
3074: fnd_global.conc_login_id ,

Line 3072: fnd_global.user_id ,

3068: 'MIGRATED' ,--RECORD_TYPE_CODE
3069: 'N' ,
3070: fnd_global.user_id ,
3071: SYSDATE ,
3072: fnd_global.user_id ,
3073: SYSDATE ,
3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID

Line 3074: fnd_global.conc_login_id ,

3070: fnd_global.user_id ,
3071: SYSDATE ,
3072: fnd_global.user_id ,
3073: SYSDATE ,
3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID
3077: fnd_global.conc_program_id , -- Program Id
3078: fnd_global.conc_login_id , -- Program Login ID

Line 3075: fnd_global.conc_request_id , -- Request Id

3071: SYSDATE ,
3072: fnd_global.user_id ,
3073: SYSDATE ,
3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID
3077: fnd_global.conc_program_id , -- Program Id
3078: fnd_global.conc_login_id , -- Program Login ID
3079: 1

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

3072: fnd_global.user_id ,
3073: SYSDATE ,
3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID
3077: fnd_global.conc_program_id , -- Program Id
3078: fnd_global.conc_login_id , -- Program Login ID
3079: 1
3080: )

Line 3077: fnd_global.conc_program_id , -- Program Id

3073: SYSDATE ,
3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID
3077: fnd_global.conc_program_id , -- Program Id
3078: fnd_global.conc_login_id , -- Program Login ID
3079: 1
3080: )
3081: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3074: fnd_global.conc_login_id ,
3075: fnd_global.conc_request_id , -- Request Id
3076: fnd_global.prog_appl_id , -- Program Application ID
3077: fnd_global.conc_program_id , -- Program Id
3078: fnd_global.conc_login_id , -- Program Login ID
3079: 1
3080: )
3081: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3082: where reporting_type_code='PT_ANL_TTL_TAXABLE_BOX'

Line 3125: fnd_global.user_id ,

3121: effective_from ,
3122: NULL ,--EFFECTIVE_TO
3123: 'MIGRATED' ,--RECORD_TYPE_CODE
3124: 'N' ,
3125: fnd_global.user_id ,
3126: SYSDATE ,
3127: fnd_global.user_id ,
3128: SYSDATE ,
3129: fnd_global.conc_login_id ,

Line 3127: fnd_global.user_id ,

3123: 'MIGRATED' ,--RECORD_TYPE_CODE
3124: 'N' ,
3125: fnd_global.user_id ,
3126: SYSDATE ,
3127: fnd_global.user_id ,
3128: SYSDATE ,
3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID

Line 3129: fnd_global.conc_login_id ,

3125: fnd_global.user_id ,
3126: SYSDATE ,
3127: fnd_global.user_id ,
3128: SYSDATE ,
3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID
3132: fnd_global.conc_program_id , -- Program Id
3133: fnd_global.conc_login_id , -- Program Login ID

Line 3130: fnd_global.conc_request_id , -- Request Id

3126: SYSDATE ,
3127: fnd_global.user_id ,
3128: SYSDATE ,
3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID
3132: fnd_global.conc_program_id , -- Program Id
3133: fnd_global.conc_login_id , -- Program Login ID
3134: 1

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

3127: fnd_global.user_id ,
3128: SYSDATE ,
3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID
3132: fnd_global.conc_program_id , -- Program Id
3133: fnd_global.conc_login_id , -- Program Login ID
3134: 1
3135: )

Line 3132: fnd_global.conc_program_id , -- Program Id

3128: SYSDATE ,
3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID
3132: fnd_global.conc_program_id , -- Program Id
3133: fnd_global.conc_login_id , -- Program Login ID
3134: 1
3135: )
3136: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3129: fnd_global.conc_login_id ,
3130: fnd_global.conc_request_id , -- Request Id
3131: fnd_global.prog_appl_id , -- Program Application ID
3132: fnd_global.conc_program_id , -- Program Id
3133: fnd_global.conc_login_id , -- Program Login ID
3134: 1
3135: )
3136: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3137: where reporting_type_code='PT_ANL_REC_TAXABLE'

Line 3180: fnd_global.user_id ,

3176: effective_from ,
3177: NULL ,--EFFECTIVE_TO
3178: 'MIGRATED' ,--RECORD_TYPE_CODE
3179: 'N' ,
3180: fnd_global.user_id ,
3181: SYSDATE ,
3182: fnd_global.user_id ,
3183: SYSDATE ,
3184: fnd_global.conc_login_id ,

Line 3182: fnd_global.user_id ,

3178: 'MIGRATED' ,--RECORD_TYPE_CODE
3179: 'N' ,
3180: fnd_global.user_id ,
3181: SYSDATE ,
3182: fnd_global.user_id ,
3183: SYSDATE ,
3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID

Line 3184: fnd_global.conc_login_id ,

3180: fnd_global.user_id ,
3181: SYSDATE ,
3182: fnd_global.user_id ,
3183: SYSDATE ,
3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID
3187: fnd_global.conc_program_id , -- Program Id
3188: fnd_global.conc_login_id , -- Program Login ID

Line 3185: fnd_global.conc_request_id , -- Request Id

3181: SYSDATE ,
3182: fnd_global.user_id ,
3183: SYSDATE ,
3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID
3187: fnd_global.conc_program_id , -- Program Id
3188: fnd_global.conc_login_id , -- Program Login ID
3189: 1

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

3182: fnd_global.user_id ,
3183: SYSDATE ,
3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID
3187: fnd_global.conc_program_id , -- Program Id
3188: fnd_global.conc_login_id , -- Program Login ID
3189: 1
3190: )

Line 3187: fnd_global.conc_program_id , -- Program Id

3183: SYSDATE ,
3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID
3187: fnd_global.conc_program_id , -- Program Id
3188: fnd_global.conc_login_id , -- Program Login ID
3189: 1
3190: )
3191: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3184: fnd_global.conc_login_id ,
3185: fnd_global.conc_request_id , -- Request Id
3186: fnd_global.prog_appl_id , -- Program Application ID
3187: fnd_global.conc_program_id , -- Program Id
3188: fnd_global.conc_login_id , -- Program Login ID
3189: 1
3190: )
3191: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3192: where reporting_type_code='PT_ANL_NON_REC_TAXABLE'

Line 3235: fnd_global.user_id ,

3231: effective_from ,
3232: NULL ,--EFFECTIVE_TO
3233: 'MIGRATED' ,--RECORD_TYPE_CODE
3234: 'N' ,
3235: fnd_global.user_id ,
3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,

Line 3237: fnd_global.user_id ,

3233: 'MIGRATED' ,--RECORD_TYPE_CODE
3234: 'N' ,
3235: fnd_global.user_id ,
3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID

Line 3239: fnd_global.conc_login_id ,

3235: fnd_global.user_id ,
3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID

Line 3240: fnd_global.conc_request_id , -- Request Id

3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 1

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

3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 1
3245: )

Line 3242: fnd_global.conc_program_id , -- Program Id

3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 1
3245: )
3246: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 1
3245: )
3246: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3247: where reporting_type_code='PT_ANL_REC_TAX_BOX'

Line 3290: fnd_global.user_id ,

3286: effective_from ,
3287: NULL ,--EFFECTIVE_TO
3288: 'MIGRATED' ,--RECORD_TYPE_CODE
3289: 'N' ,
3290: fnd_global.user_id ,
3291: SYSDATE ,
3292: fnd_global.user_id ,
3293: SYSDATE ,
3294: fnd_global.conc_login_id ,

Line 3292: fnd_global.user_id ,

3288: 'MIGRATED' ,--RECORD_TYPE_CODE
3289: 'N' ,
3290: fnd_global.user_id ,
3291: SYSDATE ,
3292: fnd_global.user_id ,
3293: SYSDATE ,
3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID

Line 3294: fnd_global.conc_login_id ,

3290: fnd_global.user_id ,
3291: SYSDATE ,
3292: fnd_global.user_id ,
3293: SYSDATE ,
3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID
3297: fnd_global.conc_program_id , -- Program Id
3298: fnd_global.conc_login_id , -- Program Login ID

Line 3295: fnd_global.conc_request_id , -- Request Id

3291: SYSDATE ,
3292: fnd_global.user_id ,
3293: SYSDATE ,
3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID
3297: fnd_global.conc_program_id , -- Program Id
3298: fnd_global.conc_login_id , -- Program Login ID
3299: 1

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

3292: fnd_global.user_id ,
3293: SYSDATE ,
3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID
3297: fnd_global.conc_program_id , -- Program Id
3298: fnd_global.conc_login_id , -- Program Login ID
3299: 1
3300: )

Line 3297: fnd_global.conc_program_id , -- Program Id

3293: SYSDATE ,
3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID
3297: fnd_global.conc_program_id , -- Program Id
3298: fnd_global.conc_login_id , -- Program Login ID
3299: 1
3300: )
3301: SELECT

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

3294: fnd_global.conc_login_id ,
3295: fnd_global.conc_request_id , -- Request Id
3296: fnd_global.prog_appl_id , -- Program Application ID
3297: fnd_global.conc_program_id , -- Program Id
3298: fnd_global.conc_login_id , -- Program Login ID
3299: 1
3300: )
3301: SELECT
3302: min(zx_rates.effective_from) effective_from,

Line 3365: fnd_global.user_id ,

3361: effective_from ,
3362: NULL ,--EFFECTIVE_TO
3363: 'MIGRATED' ,--RECORD_TYPE_CODE
3364: 'Y' ,
3365: fnd_global.user_id ,
3366: SYSDATE ,
3367: fnd_global.user_id ,
3368: SYSDATE ,
3369: fnd_global.conc_login_id ,

Line 3367: fnd_global.user_id ,

3363: 'MIGRATED' ,--RECORD_TYPE_CODE
3364: 'Y' ,
3365: fnd_global.user_id ,
3366: SYSDATE ,
3367: fnd_global.user_id ,
3368: SYSDATE ,
3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID

Line 3369: fnd_global.conc_login_id ,

3365: fnd_global.user_id ,
3366: SYSDATE ,
3367: fnd_global.user_id ,
3368: SYSDATE ,
3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID
3372: fnd_global.conc_program_id , -- Program Id
3373: fnd_global.conc_login_id , -- Program Login ID

Line 3370: fnd_global.conc_request_id , -- Request Id

3366: SYSDATE ,
3367: fnd_global.user_id ,
3368: SYSDATE ,
3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID
3372: fnd_global.conc_program_id , -- Program Id
3373: fnd_global.conc_login_id , -- Program Login ID
3374: 1

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

3367: fnd_global.user_id ,
3368: SYSDATE ,
3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID
3372: fnd_global.conc_program_id , -- Program Id
3373: fnd_global.conc_login_id , -- Program Login ID
3374: 1
3375: )

Line 3372: fnd_global.conc_program_id , -- Program Id

3368: SYSDATE ,
3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID
3372: fnd_global.conc_program_id , -- Program Id
3373: fnd_global.conc_login_id , -- Program Login ID
3374: 1
3375: )
3376: SELECT

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

3369: fnd_global.conc_login_id ,
3370: fnd_global.conc_request_id , -- Request Id
3371: fnd_global.prog_appl_id , -- Program Application ID
3372: fnd_global.conc_program_id , -- Program Id
3373: fnd_global.conc_login_id , -- Program Login ID
3374: 1
3375: )
3376: SELECT
3377: min(zx_rates.effective_from) effective_from,

Line 3440: fnd_global.user_id ,

3436: effective_from ,
3437: NULL ,--EFFECTIVE_TO
3438: 'MIGRATED' ,--RECORD_TYPE_CODE
3439: 'Y' ,
3440: fnd_global.user_id ,
3441: SYSDATE ,
3442: fnd_global.user_id ,
3443: SYSDATE ,
3444: fnd_global.conc_login_id ,

Line 3442: fnd_global.user_id ,

3438: 'MIGRATED' ,--RECORD_TYPE_CODE
3439: 'Y' ,
3440: fnd_global.user_id ,
3441: SYSDATE ,
3442: fnd_global.user_id ,
3443: SYSDATE ,
3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID

Line 3444: fnd_global.conc_login_id ,

3440: fnd_global.user_id ,
3441: SYSDATE ,
3442: fnd_global.user_id ,
3443: SYSDATE ,
3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID
3447: fnd_global.conc_program_id , -- Program Id
3448: fnd_global.conc_login_id , -- Program Login ID

Line 3445: fnd_global.conc_request_id , -- Request Id

3441: SYSDATE ,
3442: fnd_global.user_id ,
3443: SYSDATE ,
3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID
3447: fnd_global.conc_program_id , -- Program Id
3448: fnd_global.conc_login_id , -- Program Login ID
3449: 1

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

3442: fnd_global.user_id ,
3443: SYSDATE ,
3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID
3447: fnd_global.conc_program_id , -- Program Id
3448: fnd_global.conc_login_id , -- Program Login ID
3449: 1
3450: )

Line 3447: fnd_global.conc_program_id , -- Program Id

3443: SYSDATE ,
3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID
3447: fnd_global.conc_program_id , -- Program Id
3448: fnd_global.conc_login_id , -- Program Login ID
3449: 1
3450: )
3451: SELECT

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

3444: fnd_global.conc_login_id ,
3445: fnd_global.conc_request_id , -- Request Id
3446: fnd_global.prog_appl_id , -- Program Application ID
3447: fnd_global.conc_program_id , -- Program Id
3448: fnd_global.conc_login_id , -- Program Login ID
3449: 1
3450: )
3451: SELECT
3452: min(zx_rates.effective_from) effective_from,

Line 3512: fnd_global.user_id ,

3508: NULL ,--EXCEPTION_CODE
3509: EFFECTIVE_FROM ,
3510: NULL ,--EFFECTIVE_TO
3511: 'MIGRATED' ,--RECORD_TYPE_CODE
3512: fnd_global.user_id ,
3513: SYSDATE ,
3514: fnd_global.user_id ,
3515: SYSDATE ,
3516: fnd_global.conc_login_id ,

Line 3514: fnd_global.user_id ,

3510: NULL ,--EFFECTIVE_TO
3511: 'MIGRATED' ,--RECORD_TYPE_CODE
3512: fnd_global.user_id ,
3513: SYSDATE ,
3514: fnd_global.user_id ,
3515: SYSDATE ,
3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID

Line 3516: fnd_global.conc_login_id ,

3512: fnd_global.user_id ,
3513: SYSDATE ,
3514: fnd_global.user_id ,
3515: SYSDATE ,
3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID
3519: fnd_global.conc_program_id , -- Program Id
3520: fnd_global.conc_login_id , -- Program Login ID

Line 3517: fnd_global.conc_request_id , -- Request Id

3513: SYSDATE ,
3514: fnd_global.user_id ,
3515: SYSDATE ,
3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID
3519: fnd_global.conc_program_id , -- Program Id
3520: fnd_global.conc_login_id , -- Program Login ID
3521: REPORTING_CODE,

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

3514: fnd_global.user_id ,
3515: SYSDATE ,
3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID
3519: fnd_global.conc_program_id , -- Program Id
3520: fnd_global.conc_login_id , -- Program Login ID
3521: REPORTING_CODE,
3522: REPORTING_TYPE_ID,

Line 3519: fnd_global.conc_program_id , -- Program Id

3515: SYSDATE ,
3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID
3519: fnd_global.conc_program_id , -- Program Id
3520: fnd_global.conc_login_id , -- Program Login ID
3521: REPORTING_CODE,
3522: REPORTING_TYPE_ID,
3523: 1

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

3516: fnd_global.conc_login_id ,
3517: fnd_global.conc_request_id , -- Request Id
3518: fnd_global.prog_appl_id , -- Program Application ID
3519: fnd_global.conc_program_id , -- Program Id
3520: fnd_global.conc_login_id , -- Program Login ID
3521: REPORTING_CODE,
3522: REPORTING_TYPE_ID,
3523: 1
3524:

Line 3584: fnd_global.user_id ,

3580: NULL ,--EXCEPTION_CODE
3581: EFFECTIVE_FROM ,
3582: NULL ,--EFFECTIVE_TO
3583: 'MIGRATED' ,--RECORD_TYPE_CODE
3584: fnd_global.user_id ,
3585: SYSDATE ,
3586: fnd_global.user_id ,
3587: SYSDATE ,
3588: fnd_global.conc_login_id ,

Line 3586: fnd_global.user_id ,

3582: NULL ,--EFFECTIVE_TO
3583: 'MIGRATED' ,--RECORD_TYPE_CODE
3584: fnd_global.user_id ,
3585: SYSDATE ,
3586: fnd_global.user_id ,
3587: SYSDATE ,
3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID

Line 3588: fnd_global.conc_login_id ,

3584: fnd_global.user_id ,
3585: SYSDATE ,
3586: fnd_global.user_id ,
3587: SYSDATE ,
3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID
3591: fnd_global.conc_program_id , -- Program Id
3592: fnd_global.conc_login_id , -- Program Login ID

Line 3589: fnd_global.conc_request_id , -- Request Id

3585: SYSDATE ,
3586: fnd_global.user_id ,
3587: SYSDATE ,
3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID
3591: fnd_global.conc_program_id , -- Program Id
3592: fnd_global.conc_login_id , -- Program Login ID
3593: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

3586: fnd_global.user_id ,
3587: SYSDATE ,
3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID
3591: fnd_global.conc_program_id , -- Program Id
3592: fnd_global.conc_login_id , -- Program Login ID
3593: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3594: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 3591: fnd_global.conc_program_id , -- Program Id

3587: SYSDATE ,
3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID
3591: fnd_global.conc_program_id , -- Program Id
3592: fnd_global.conc_login_id , -- Program Login ID
3593: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3594: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
3595: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

3588: fnd_global.conc_login_id ,
3589: fnd_global.conc_request_id , -- Request Id
3590: fnd_global.prog_appl_id , -- Program Application ID
3591: fnd_global.conc_program_id , -- Program Id
3592: fnd_global.conc_login_id , -- Program Login ID
3593: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3594: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
3595: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
3596: REPORTING_TYPE_ID,

Line 3657: fnd_global.user_id ,

3653: NULL ,--EXCEPTION_CODE
3654: effective_from ,
3655: NULL ,--EFFECTIVE_TO
3656: 'MIGRATED' ,--RECORD_TYPE_CODE
3657: fnd_global.user_id ,
3658: SYSDATE ,
3659: fnd_global.user_id ,
3660: SYSDATE ,
3661: fnd_global.conc_login_id ,

Line 3659: fnd_global.user_id ,

3655: NULL ,--EFFECTIVE_TO
3656: 'MIGRATED' ,--RECORD_TYPE_CODE
3657: fnd_global.user_id ,
3658: SYSDATE ,
3659: fnd_global.user_id ,
3660: SYSDATE ,
3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID

Line 3661: fnd_global.conc_login_id ,

3657: fnd_global.user_id ,
3658: SYSDATE ,
3659: fnd_global.user_id ,
3660: SYSDATE ,
3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID
3664: fnd_global.conc_program_id , -- Program Id
3665: fnd_global.conc_login_id , -- Program Login ID

Line 3662: fnd_global.conc_request_id , -- Request

3658: SYSDATE ,
3659: fnd_global.user_id ,
3660: SYSDATE ,
3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID
3664: fnd_global.conc_program_id , -- Program Id
3665: fnd_global.conc_login_id , -- Program Login ID
3666: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),

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

3659: fnd_global.user_id ,
3660: SYSDATE ,
3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID
3664: fnd_global.conc_program_id , -- Program Id
3665: fnd_global.conc_login_id , -- Program Login ID
3666: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3667: decode(DATATYPE,'DATE',global_attribute,NULL),

Line 3664: fnd_global.conc_program_id , -- Program Id

3660: SYSDATE ,
3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID
3664: fnd_global.conc_program_id , -- Program Id
3665: fnd_global.conc_login_id , -- Program Login ID
3666: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3667: decode(DATATYPE,'DATE',global_attribute,NULL),
3668: decode(DATATYPE,'NUMERIC_VALUE',global_attribute,NULL),

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

3661: fnd_global.conc_login_id ,
3662: fnd_global.conc_request_id , -- Request
3663: fnd_global.prog_appl_id , -- Program Application ID
3664: fnd_global.conc_program_id , -- Program Id
3665: fnd_global.conc_login_id , -- Program Login ID
3666: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3667: decode(DATATYPE,'DATE',global_attribute,NULL),
3668: decode(DATATYPE,'NUMERIC_VALUE',global_attribute,NULL),
3669: reporting_type_id,

Line 3879: fnd_global.user_id ,--CREATED_BY

3875: effective_from ,--EFFECTIVE_FROM
3876: NULL ,--EFFECTIVE_TO
3877: 'MIGRATED' ,--RECORD_TYPE_CODE
3878: 'Y' ,--HAS_REPORTING_CODES_FLAG
3879: fnd_global.user_id ,--CREATED_BY
3880: SYSDATE ,--CREATION_DATE
3881: fnd_global.user_id ,--LAST_UPDATED_BY
3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 3881: fnd_global.user_id ,--LAST_UPDATED_BY

3877: 'MIGRATED' ,--RECORD_TYPE_CODE
3878: 'Y' ,--HAS_REPORTING_CODES_FLAG
3879: fnd_global.user_id ,--CREATED_BY
3880: SYSDATE ,--CREATION_DATE
3881: fnd_global.user_id ,--LAST_UPDATED_BY
3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID

Line 3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

3879: fnd_global.user_id ,--CREATED_BY
3880: SYSDATE ,--CREATION_DATE
3881: fnd_global.user_id ,--LAST_UPDATED_BY
3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID
3886: fnd_global.conc_program_id , -- Program Id
3887: fnd_global.conc_login_id , -- Program Login ID

Line 3884: fnd_global.conc_request_id , -- Request Id

3880: SYSDATE ,--CREATION_DATE
3881: fnd_global.user_id ,--LAST_UPDATED_BY
3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID
3886: fnd_global.conc_program_id , -- Program Id
3887: fnd_global.conc_login_id , -- Program Login ID
3888: 1

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

3881: fnd_global.user_id ,--LAST_UPDATED_BY
3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID
3886: fnd_global.conc_program_id , -- Program Id
3887: fnd_global.conc_login_id , -- Program Login ID
3888: 1
3889: )

Line 3886: fnd_global.conc_program_id , -- Program Id

3882: SYSDATE ,--LAST_UPDATE_DATE
3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID
3886: fnd_global.conc_program_id , -- Program Id
3887: fnd_global.conc_login_id , -- Program Login ID
3888: 1
3889: )
3890: SELECT

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

3883: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3884: fnd_global.conc_request_id , -- Request Id
3885: fnd_global.prog_appl_id , -- Program Application ID
3886: fnd_global.conc_program_id , -- Program Id
3887: fnd_global.conc_login_id , -- Program Login ID
3888: 1
3889: )
3890: SELECT
3891: min(zx_rates.effective_from) effective_from,

Line 3938: FND_GLOBAL.USER_ID,

3934: NULL,
3935: l_start_date,
3936: NULL,
3937: 'MIGRATED',
3938: FND_GLOBAL.USER_ID,
3939: SYSDATE,
3940: FND_GLOBAL.USER_ID,
3941: SYSDATE,
3942: fnd_global.conc_login_id ,

Line 3940: FND_GLOBAL.USER_ID,

3936: NULL,
3937: 'MIGRATED',
3938: FND_GLOBAL.USER_ID,
3939: SYSDATE,
3940: FND_GLOBAL.USER_ID,
3941: SYSDATE,
3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID

Line 3942: fnd_global.conc_login_id ,

3938: FND_GLOBAL.USER_ID,
3939: SYSDATE,
3940: FND_GLOBAL.USER_ID,
3941: SYSDATE,
3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID
3945: fnd_global.conc_program_id , -- Program Id
3946: fnd_global.conc_login_id , -- Program Login ID

Line 3943: fnd_global.conc_request_id , -- Request Id

3939: SYSDATE,
3940: FND_GLOBAL.USER_ID,
3941: SYSDATE,
3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID
3945: fnd_global.conc_program_id , -- Program Id
3946: fnd_global.conc_login_id , -- Program Login ID
3947: l_location_code,

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

3940: FND_GLOBAL.USER_ID,
3941: SYSDATE,
3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID
3945: fnd_global.conc_program_id , -- Program Id
3946: fnd_global.conc_login_id , -- Program Login ID
3947: l_location_code,
3948: NULL,

Line 3945: fnd_global.conc_program_id , -- Program Id

3941: SYSDATE,
3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID
3945: fnd_global.conc_program_id , -- Program Id
3946: fnd_global.conc_login_id , -- Program Login ID
3947: l_location_code,
3948: NULL,
3949: NULL,

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

3942: fnd_global.conc_login_id ,
3943: fnd_global.conc_request_id , -- Request Id
3944: fnd_global.prog_appl_id , -- Program Application ID
3945: fnd_global.conc_program_id , -- Program Id
3946: fnd_global.conc_login_id , -- Program Login ID
3947: l_location_code,
3948: NULL,
3949: NULL,
3950: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 4011: fnd_global.user_id ,

4007: REPORTING_CODE_ID ,
4008: NULL ,--EXCEPTION_CODE
4009: EFFECTIVE_FROM ,
4010: NULL ,--EFFECTIVE_TO
4011: fnd_global.user_id ,
4012: SYSDATE ,
4013: fnd_global.user_id ,
4014: SYSDATE ,
4015: fnd_global.conc_login_id ,

Line 4013: fnd_global.user_id ,

4009: EFFECTIVE_FROM ,
4010: NULL ,--EFFECTIVE_TO
4011: fnd_global.user_id ,
4012: SYSDATE ,
4013: fnd_global.user_id ,
4014: SYSDATE ,
4015: fnd_global.conc_login_id ,
4016: REPORTING_CODE_CHAR_VALUE,
4017: REPORTING_CODE_DATE_VALUE,

Line 4015: fnd_global.conc_login_id ,

4011: fnd_global.user_id ,
4012: SYSDATE ,
4013: fnd_global.user_id ,
4014: SYSDATE ,
4015: fnd_global.conc_login_id ,
4016: REPORTING_CODE_CHAR_VALUE,
4017: REPORTING_CODE_DATE_VALUE,
4018: REPORTING_CODE_NUM_VALUE,
4019: 1

Line 4147: fnd_global.user_id ,

4143: effective_from ,
4144: NULL ,--EFFECTIVE_TO
4145: 'MIGRATED' ,--RECORD_TYPE_CODE
4146: 'Y' ,
4147: fnd_global.user_id ,
4148: SYSDATE ,
4149: fnd_global.user_id ,
4150: SYSDATE ,
4151: fnd_global.conc_login_id ,

Line 4149: fnd_global.user_id ,

4145: 'MIGRATED' ,--RECORD_TYPE_CODE
4146: 'Y' ,
4147: fnd_global.user_id ,
4148: SYSDATE ,
4149: fnd_global.user_id ,
4150: SYSDATE ,
4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID

Line 4151: fnd_global.conc_login_id ,

4147: fnd_global.user_id ,
4148: SYSDATE ,
4149: fnd_global.user_id ,
4150: SYSDATE ,
4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID
4154: fnd_global.conc_program_id , -- Program Id
4155: fnd_global.conc_login_id , -- Program Login ID

Line 4152: fnd_global.conc_request_id , -- Request Id

4148: SYSDATE ,
4149: fnd_global.user_id ,
4150: SYSDATE ,
4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID
4154: fnd_global.conc_program_id , -- Program Id
4155: fnd_global.conc_login_id , -- Program Login ID
4156: 1

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

4149: fnd_global.user_id ,
4150: SYSDATE ,
4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID
4154: fnd_global.conc_program_id , -- Program Id
4155: fnd_global.conc_login_id , -- Program Login ID
4156: 1
4157: )

Line 4154: fnd_global.conc_program_id , -- Program Id

4150: SYSDATE ,
4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID
4154: fnd_global.conc_program_id , -- Program Id
4155: fnd_global.conc_login_id , -- Program Login ID
4156: 1
4157: )
4158: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4151: fnd_global.conc_login_id ,
4152: fnd_global.conc_request_id , -- Request Id
4153: fnd_global.prog_appl_id , -- Program Application ID
4154: fnd_global.conc_program_id , -- Program Id
4155: fnd_global.conc_login_id , -- Program Login ID
4156: 1
4157: )
4158: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4159: where reporting_type_code='PT_PRD_TAXABLE_BOX'

Line 4202: fnd_global.user_id ,

4198: effective_from ,
4199: NULL ,--EFFECTIVE_TO
4200: 'MIGRATED' ,--RECORD_TYPE_CODE
4201: 'N' ,
4202: fnd_global.user_id ,
4203: SYSDATE ,
4204: fnd_global.user_id ,
4205: SYSDATE ,
4206: fnd_global.conc_login_id ,

Line 4204: fnd_global.user_id ,

4200: 'MIGRATED' ,--RECORD_TYPE_CODE
4201: 'N' ,
4202: fnd_global.user_id ,
4203: SYSDATE ,
4204: fnd_global.user_id ,
4205: SYSDATE ,
4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID

Line 4206: fnd_global.conc_login_id ,

4202: fnd_global.user_id ,
4203: SYSDATE ,
4204: fnd_global.user_id ,
4205: SYSDATE ,
4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID
4209: fnd_global.conc_program_id , -- Program Id
4210: fnd_global.conc_login_id , -- Program Login ID

Line 4207: fnd_global.conc_request_id , -- Request Id

4203: SYSDATE ,
4204: fnd_global.user_id ,
4205: SYSDATE ,
4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID
4209: fnd_global.conc_program_id , -- Program Id
4210: fnd_global.conc_login_id , -- Program Login ID
4211: 1

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

4204: fnd_global.user_id ,
4205: SYSDATE ,
4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID
4209: fnd_global.conc_program_id , -- Program Id
4210: fnd_global.conc_login_id , -- Program Login ID
4211: 1
4212: )

Line 4209: fnd_global.conc_program_id , -- Program Id

4205: SYSDATE ,
4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID
4209: fnd_global.conc_program_id , -- Program Id
4210: fnd_global.conc_login_id , -- Program Login ID
4211: 1
4212: )
4213: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4206: fnd_global.conc_login_id ,
4207: fnd_global.conc_request_id , -- Request Id
4208: fnd_global.prog_appl_id , -- Program Application ID
4209: fnd_global.conc_program_id , -- Program Id
4210: fnd_global.conc_login_id , -- Program Login ID
4211: 1
4212: )
4213: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4214: where reporting_type_code='PT_PRD_REC_TAX_BOX'

Line 4257: fnd_global.user_id ,

4253: effective_from ,
4254: NULL ,--EFFECTIVE_TO
4255: 'MIGRATED' ,--RECORD_TYPE_CODE
4256: 'N' ,
4257: fnd_global.user_id ,
4258: SYSDATE ,
4259: fnd_global.user_id ,
4260: SYSDATE ,
4261: fnd_global.conc_login_id ,

Line 4259: fnd_global.user_id ,

4255: 'MIGRATED' ,--RECORD_TYPE_CODE
4256: 'N' ,
4257: fnd_global.user_id ,
4258: SYSDATE ,
4259: fnd_global.user_id ,
4260: SYSDATE ,
4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID

Line 4261: fnd_global.conc_login_id ,

4257: fnd_global.user_id ,
4258: SYSDATE ,
4259: fnd_global.user_id ,
4260: SYSDATE ,
4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID
4264: fnd_global.conc_program_id , -- Program Id
4265: fnd_global.conc_login_id , -- Program Login ID

Line 4262: fnd_global.conc_request_id , -- Request Id

4258: SYSDATE ,
4259: fnd_global.user_id ,
4260: SYSDATE ,
4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID
4264: fnd_global.conc_program_id , -- Program Id
4265: fnd_global.conc_login_id , -- Program Login ID
4266: 1

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

4259: fnd_global.user_id ,
4260: SYSDATE ,
4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID
4264: fnd_global.conc_program_id , -- Program Id
4265: fnd_global.conc_login_id , -- Program Login ID
4266: 1
4267: )

Line 4264: fnd_global.conc_program_id , -- Program Id

4260: SYSDATE ,
4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID
4264: fnd_global.conc_program_id , -- Program Id
4265: fnd_global.conc_login_id , -- Program Login ID
4266: 1
4267: )
4268: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4261: fnd_global.conc_login_id ,
4262: fnd_global.conc_request_id , -- Request Id
4263: fnd_global.prog_appl_id , -- Program Application ID
4264: fnd_global.conc_program_id , -- Program Id
4265: fnd_global.conc_login_id , -- Program Login ID
4266: 1
4267: )
4268: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4269: where reporting_type_code='PT_ANL_TTL_TAXABLE_BOX'

Line 4312: fnd_global.user_id ,

4308: effective_from ,
4309: NULL ,--EFFECTIVE_TO
4310: 'MIGRATED' ,--RECORD_TYPE_CODE
4311: 'N' ,
4312: fnd_global.user_id ,
4313: SYSDATE ,
4314: fnd_global.user_id ,
4315: SYSDATE ,
4316: fnd_global.conc_login_id ,

Line 4314: fnd_global.user_id ,

4310: 'MIGRATED' ,--RECORD_TYPE_CODE
4311: 'N' ,
4312: fnd_global.user_id ,
4313: SYSDATE ,
4314: fnd_global.user_id ,
4315: SYSDATE ,
4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID

Line 4316: fnd_global.conc_login_id ,

4312: fnd_global.user_id ,
4313: SYSDATE ,
4314: fnd_global.user_id ,
4315: SYSDATE ,
4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID
4319: fnd_global.conc_program_id , -- Program Id
4320: fnd_global.conc_login_id , -- Program Login ID

Line 4317: fnd_global.conc_request_id , -- Request Id

4313: SYSDATE ,
4314: fnd_global.user_id ,
4315: SYSDATE ,
4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID
4319: fnd_global.conc_program_id , -- Program Id
4320: fnd_global.conc_login_id , -- Program Login ID
4321: 1

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

4314: fnd_global.user_id ,
4315: SYSDATE ,
4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID
4319: fnd_global.conc_program_id , -- Program Id
4320: fnd_global.conc_login_id , -- Program Login ID
4321: 1
4322: )

Line 4319: fnd_global.conc_program_id , -- Program Id

4315: SYSDATE ,
4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID
4319: fnd_global.conc_program_id , -- Program Id
4320: fnd_global.conc_login_id , -- Program Login ID
4321: 1
4322: )
4323: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4316: fnd_global.conc_login_id ,
4317: fnd_global.conc_request_id , -- Request Id
4318: fnd_global.prog_appl_id , -- Program Application ID
4319: fnd_global.conc_program_id , -- Program Id
4320: fnd_global.conc_login_id , -- Program Login ID
4321: 1
4322: )
4323: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4324: where reporting_type_code='PT_ANL_REC_TAXABLE' -- Bug 5031787

Line 4367: fnd_global.user_id ,

4363: effective_from ,
4364: NULL ,--EFFECTIVE_TO
4365: 'MIGRATED' ,--RECORD_TYPE_CODE
4366: 'N' ,
4367: fnd_global.user_id ,
4368: SYSDATE ,
4369: fnd_global.user_id ,
4370: SYSDATE ,
4371: fnd_global.conc_login_id ,

Line 4369: fnd_global.user_id ,

4365: 'MIGRATED' ,--RECORD_TYPE_CODE
4366: 'N' ,
4367: fnd_global.user_id ,
4368: SYSDATE ,
4369: fnd_global.user_id ,
4370: SYSDATE ,
4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID

Line 4371: fnd_global.conc_login_id ,

4367: fnd_global.user_id ,
4368: SYSDATE ,
4369: fnd_global.user_id ,
4370: SYSDATE ,
4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID
4374: fnd_global.conc_program_id , -- Program Id
4375: fnd_global.conc_login_id , -- Program Login ID

Line 4372: fnd_global.conc_request_id , -- Request Id

4368: SYSDATE ,
4369: fnd_global.user_id ,
4370: SYSDATE ,
4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID
4374: fnd_global.conc_program_id , -- Program Id
4375: fnd_global.conc_login_id , -- Program Login ID
4376: 1

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

4369: fnd_global.user_id ,
4370: SYSDATE ,
4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID
4374: fnd_global.conc_program_id , -- Program Id
4375: fnd_global.conc_login_id , -- Program Login ID
4376: 1
4377: )

Line 4374: fnd_global.conc_program_id , -- Program Id

4370: SYSDATE ,
4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID
4374: fnd_global.conc_program_id , -- Program Id
4375: fnd_global.conc_login_id , -- Program Login ID
4376: 1
4377: )
4378: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4371: fnd_global.conc_login_id ,
4372: fnd_global.conc_request_id , -- Request Id
4373: fnd_global.prog_appl_id , -- Program Application ID
4374: fnd_global.conc_program_id , -- Program Id
4375: fnd_global.conc_login_id , -- Program Login ID
4376: 1
4377: )
4378: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4379: where reporting_type_code='PT_ANL_NON_REC_TAXABLE'

Line 4422: fnd_global.user_id ,

4418: effective_from ,
4419: NULL ,--EFFECTIVE_TO
4420: 'MIGRATED' ,--RECORD_TYPE_CODE
4421: 'N' ,
4422: fnd_global.user_id ,
4423: SYSDATE ,
4424: fnd_global.user_id ,
4425: SYSDATE ,
4426: fnd_global.conc_login_id ,

Line 4424: fnd_global.user_id ,

4420: 'MIGRATED' ,--RECORD_TYPE_CODE
4421: 'N' ,
4422: fnd_global.user_id ,
4423: SYSDATE ,
4424: fnd_global.user_id ,
4425: SYSDATE ,
4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID

Line 4426: fnd_global.conc_login_id ,

4422: fnd_global.user_id ,
4423: SYSDATE ,
4424: fnd_global.user_id ,
4425: SYSDATE ,
4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID
4429: fnd_global.conc_program_id , -- Program Id
4430: fnd_global.conc_login_id , -- Program Login ID

Line 4427: fnd_global.conc_request_id , -- Request Id

4423: SYSDATE ,
4424: fnd_global.user_id ,
4425: SYSDATE ,
4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID
4429: fnd_global.conc_program_id , -- Program Id
4430: fnd_global.conc_login_id , -- Program Login ID
4431: 1

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

4424: fnd_global.user_id ,
4425: SYSDATE ,
4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID
4429: fnd_global.conc_program_id , -- Program Id
4430: fnd_global.conc_login_id , -- Program Login ID
4431: 1
4432: )

Line 4429: fnd_global.conc_program_id , -- Program Id

4425: SYSDATE ,
4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID
4429: fnd_global.conc_program_id , -- Program Id
4430: fnd_global.conc_login_id , -- Program Login ID
4431: 1
4432: )
4433: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4426: fnd_global.conc_login_id ,
4427: fnd_global.conc_request_id , -- Request Id
4428: fnd_global.prog_appl_id , -- Program Application ID
4429: fnd_global.conc_program_id , -- Program Id
4430: fnd_global.conc_login_id , -- Program Login ID
4431: 1
4432: )
4433: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4434: where reporting_type_code='PT_ANL_REC_TAX_BOX' -- Bug 5031787

Line 4477: fnd_global.user_id ,

4473: effective_from ,
4474: NULL ,--EFFECTIVE_TO
4475: 'MIGRATED' ,--RECORD_TYPE_CODE
4476: 'N' ,
4477: fnd_global.user_id ,
4478: SYSDATE ,
4479: fnd_global.user_id ,
4480: SYSDATE ,
4481: fnd_global.conc_login_id ,

Line 4479: fnd_global.user_id ,

4475: 'MIGRATED' ,--RECORD_TYPE_CODE
4476: 'N' ,
4477: fnd_global.user_id ,
4478: SYSDATE ,
4479: fnd_global.user_id ,
4480: SYSDATE ,
4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID

Line 4481: fnd_global.conc_login_id ,

4477: fnd_global.user_id ,
4478: SYSDATE ,
4479: fnd_global.user_id ,
4480: SYSDATE ,
4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID
4484: fnd_global.conc_program_id , -- Program Id
4485: fnd_global.conc_login_id , -- Program Login ID

Line 4482: fnd_global.conc_request_id , -- Request Id

4478: SYSDATE ,
4479: fnd_global.user_id ,
4480: SYSDATE ,
4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID
4484: fnd_global.conc_program_id , -- Program Id
4485: fnd_global.conc_login_id , -- Program Login ID
4486: 1

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

4479: fnd_global.user_id ,
4480: SYSDATE ,
4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID
4484: fnd_global.conc_program_id , -- Program Id
4485: fnd_global.conc_login_id , -- Program Login ID
4486: 1
4487: )

Line 4484: fnd_global.conc_program_id , -- Program Id

4480: SYSDATE ,
4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID
4484: fnd_global.conc_program_id , -- Program Id
4485: fnd_global.conc_login_id , -- Program Login ID
4486: 1
4487: )
4488:

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

4481: fnd_global.conc_login_id ,
4482: fnd_global.conc_request_id , -- Request Id
4483: fnd_global.prog_appl_id , -- Program Application ID
4484: fnd_global.conc_program_id , -- Program Id
4485: fnd_global.conc_login_id , -- Program Login ID
4486: 1
4487: )
4488:
4489: SELECT

Line 4549: fnd_global.user_id ,

4545: effective_from ,
4546: NULL ,--EFFECTIVE_TO
4547: 'MIGRATED' ,--RECORD_TYPE_CODE
4548: 'Y' ,
4549: fnd_global.user_id ,
4550: SYSDATE ,
4551: fnd_global.user_id ,
4552: SYSDATE ,
4553: fnd_global.conc_login_id ,

Line 4551: fnd_global.user_id ,

4547: 'MIGRATED' ,--RECORD_TYPE_CODE
4548: 'Y' ,
4549: fnd_global.user_id ,
4550: SYSDATE ,
4551: fnd_global.user_id ,
4552: SYSDATE ,
4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID

Line 4553: fnd_global.conc_login_id ,

4549: fnd_global.user_id ,
4550: SYSDATE ,
4551: fnd_global.user_id ,
4552: SYSDATE ,
4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID
4556: fnd_global.conc_program_id , -- Program Id
4557: fnd_global.conc_login_id , -- Program Login ID

Line 4554: fnd_global.conc_request_id , -- Request Id

4550: SYSDATE ,
4551: fnd_global.user_id ,
4552: SYSDATE ,
4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID
4556: fnd_global.conc_program_id , -- Program Id
4557: fnd_global.conc_login_id , -- Program Login ID
4558: 1

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

4551: fnd_global.user_id ,
4552: SYSDATE ,
4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID
4556: fnd_global.conc_program_id , -- Program Id
4557: fnd_global.conc_login_id , -- Program Login ID
4558: 1
4559: )

Line 4556: fnd_global.conc_program_id , -- Program Id

4552: SYSDATE ,
4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID
4556: fnd_global.conc_program_id , -- Program Id
4557: fnd_global.conc_login_id , -- Program Login ID
4558: 1
4559: )
4560:

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

4553: fnd_global.conc_login_id ,
4554: fnd_global.conc_request_id , -- Request Id
4555: fnd_global.prog_appl_id , -- Program Application ID
4556: fnd_global.conc_program_id , -- Program Id
4557: fnd_global.conc_login_id , -- Program Login ID
4558: 1
4559: )
4560:
4561: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4604: fnd_global.user_id ,

4600: effective_from ,
4601: NULL ,--EFFECTIVE_TO
4602: 'MIGRATED' ,--RECORD_TYPE_CODE
4603: 'N' ,
4604: fnd_global.user_id ,
4605: SYSDATE ,
4606: fnd_global.user_id ,
4607: SYSDATE ,
4608: fnd_global.conc_login_id ,

Line 4606: fnd_global.user_id ,

4602: 'MIGRATED' ,--RECORD_TYPE_CODE
4603: 'N' ,
4604: fnd_global.user_id ,
4605: SYSDATE ,
4606: fnd_global.user_id ,
4607: SYSDATE ,
4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID

Line 4608: fnd_global.conc_login_id ,

4604: fnd_global.user_id ,
4605: SYSDATE ,
4606: fnd_global.user_id ,
4607: SYSDATE ,
4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID
4611: fnd_global.conc_program_id , -- Program Id
4612: fnd_global.conc_login_id , -- Program Login ID

Line 4609: fnd_global.conc_request_id , -- Request Id

4605: SYSDATE ,
4606: fnd_global.user_id ,
4607: SYSDATE ,
4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID
4611: fnd_global.conc_program_id , -- Program Id
4612: fnd_global.conc_login_id , -- Program Login ID
4613: 1

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

4606: fnd_global.user_id ,
4607: SYSDATE ,
4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID
4611: fnd_global.conc_program_id , -- Program Id
4612: fnd_global.conc_login_id , -- Program Login ID
4613: 1
4614: )

Line 4611: fnd_global.conc_program_id , -- Program Id

4607: SYSDATE ,
4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID
4611: fnd_global.conc_program_id , -- Program Id
4612: fnd_global.conc_login_id , -- Program Login ID
4613: 1
4614: )
4615:

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

4608: fnd_global.conc_login_id ,
4609: fnd_global.conc_request_id , -- Request Id
4610: fnd_global.prog_appl_id , -- Program Application ID
4611: fnd_global.conc_program_id , -- Program Id
4612: fnd_global.conc_login_id , -- Program Login ID
4613: 1
4614: )
4615:
4616: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4659: fnd_global.user_id ,

4655: effective_from ,
4656: NULL ,--EFFECTIVE_TO
4657: 'MIGRATED' ,--RECORD_TYPE_CODE
4658: 'Y' ,
4659: fnd_global.user_id ,
4660: SYSDATE ,
4661: fnd_global.user_id ,
4662: SYSDATE ,
4663: fnd_global.conc_login_id ,

Line 4661: fnd_global.user_id ,

4657: 'MIGRATED' ,--RECORD_TYPE_CODE
4658: 'Y' ,
4659: fnd_global.user_id ,
4660: SYSDATE ,
4661: fnd_global.user_id ,
4662: SYSDATE ,
4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID

Line 4663: fnd_global.conc_login_id ,

4659: fnd_global.user_id ,
4660: SYSDATE ,
4661: fnd_global.user_id ,
4662: SYSDATE ,
4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID
4666: fnd_global.conc_program_id , -- Program Id
4667: fnd_global.conc_login_id , -- Program Login ID

Line 4664: fnd_global.conc_request_id , -- Request Id

4660: SYSDATE ,
4661: fnd_global.user_id ,
4662: SYSDATE ,
4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID
4666: fnd_global.conc_program_id , -- Program Id
4667: fnd_global.conc_login_id , -- Program Login ID
4668: 1

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

4661: fnd_global.user_id ,
4662: SYSDATE ,
4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID
4666: fnd_global.conc_program_id , -- Program Id
4667: fnd_global.conc_login_id , -- Program Login ID
4668: 1
4669: )

Line 4666: fnd_global.conc_program_id , -- Program Id

4662: SYSDATE ,
4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID
4666: fnd_global.conc_program_id , -- Program Id
4667: fnd_global.conc_login_id , -- Program Login ID
4668: 1
4669: )
4670:

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

4663: fnd_global.conc_login_id ,
4664: fnd_global.conc_request_id , -- Request Id
4665: fnd_global.prog_appl_id , -- Program Application ID
4666: fnd_global.conc_program_id , -- Program Id
4667: fnd_global.conc_login_id , -- Program Login ID
4668: 1
4669: )
4670:
4671: SELECT

Line 4736: fnd_global.user_id ,

4732: effective_from ,
4733: NULL ,--EFFECTIVE_TO
4734: 'MIGRATED' ,--RECORD_TYPE_CODE
4735: 'Y' ,--HAS_REPORTING_CODES_FLAG
4736: fnd_global.user_id ,
4737: SYSDATE ,
4738: fnd_global.user_id ,
4739: SYSDATE ,
4740: fnd_global.conc_login_id ,

Line 4738: fnd_global.user_id ,

4734: 'MIGRATED' ,--RECORD_TYPE_CODE
4735: 'Y' ,--HAS_REPORTING_CODES_FLAG
4736: fnd_global.user_id ,
4737: SYSDATE ,
4738: fnd_global.user_id ,
4739: SYSDATE ,
4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID

Line 4740: fnd_global.conc_login_id ,

4736: fnd_global.user_id ,
4737: SYSDATE ,
4738: fnd_global.user_id ,
4739: SYSDATE ,
4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID
4743: fnd_global.conc_program_id , -- Program Id
4744: fnd_global.conc_login_id , -- Program Login ID

Line 4741: fnd_global.conc_request_id , -- Request Id

4737: SYSDATE ,
4738: fnd_global.user_id ,
4739: SYSDATE ,
4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID
4743: fnd_global.conc_program_id , -- Program Id
4744: fnd_global.conc_login_id , -- Program Login ID
4745: 1

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

4738: fnd_global.user_id ,
4739: SYSDATE ,
4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID
4743: fnd_global.conc_program_id , -- Program Id
4744: fnd_global.conc_login_id , -- Program Login ID
4745: 1
4746: )

Line 4743: fnd_global.conc_program_id , -- Program Id

4739: SYSDATE ,
4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID
4743: fnd_global.conc_program_id , -- Program Id
4744: fnd_global.conc_login_id , -- Program Login ID
4745: 1
4746: )
4747: SELECT

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

4740: fnd_global.conc_login_id ,
4741: fnd_global.conc_request_id , -- Request Id
4742: fnd_global.prog_appl_id , -- Program Application ID
4743: fnd_global.conc_program_id , -- Program Id
4744: fnd_global.conc_login_id , -- Program Login ID
4745: 1
4746: )
4747: SELECT
4748: min(zx_rates.effective_from) effective_from,

Line 4807: FND_GLOBAL.USER_ID,

4803: NULL,
4804: l_start_date,
4805: NULL,
4806: 'MIGRATED',
4807: FND_GLOBAL.USER_ID,
4808: SYSDATE,
4809: FND_GLOBAL.USER_ID,
4810: SYSDATE,
4811: fnd_global.conc_login_id ,

Line 4809: FND_GLOBAL.USER_ID,

4805: NULL,
4806: 'MIGRATED',
4807: FND_GLOBAL.USER_ID,
4808: SYSDATE,
4809: FND_GLOBAL.USER_ID,
4810: SYSDATE,
4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID

Line 4811: fnd_global.conc_login_id ,

4807: FND_GLOBAL.USER_ID,
4808: SYSDATE,
4809: FND_GLOBAL.USER_ID,
4810: SYSDATE,
4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID
4814: fnd_global.conc_program_id , -- Program Id
4815: fnd_global.conc_login_id , -- Program Login ID

Line 4812: fnd_global.conc_request_id , -- Request Id

4808: SYSDATE,
4809: FND_GLOBAL.USER_ID,
4810: SYSDATE,
4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID
4814: fnd_global.conc_program_id , -- Program Id
4815: fnd_global.conc_login_id , -- Program Login ID
4816: printed_tax_name,

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

4809: FND_GLOBAL.USER_ID,
4810: SYSDATE,
4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID
4814: fnd_global.conc_program_id , -- Program Id
4815: fnd_global.conc_login_id , -- Program Login ID
4816: printed_tax_name,
4817: NULL,

Line 4814: fnd_global.conc_program_id , -- Program Id

4810: SYSDATE,
4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID
4814: fnd_global.conc_program_id , -- Program Id
4815: fnd_global.conc_login_id , -- Program Login ID
4816: printed_tax_name,
4817: NULL,
4818: NULL,

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

4811: fnd_global.conc_login_id ,
4812: fnd_global.conc_request_id , -- Request Id
4813: fnd_global.prog_appl_id , -- Program Application ID
4814: fnd_global.conc_program_id , -- Program Id
4815: fnd_global.conc_login_id , -- Program Login ID
4816: printed_tax_name,
4817: NULL,
4818: NULL,
4819: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 4866: fnd_global.user_id,

4862: THEN Initcap(l_printed_tax_name)
4863: ELSE
4864: l_printed_tax_name
4865: END,
4866: fnd_global.user_id,
4867: sysdate,
4868: fnd_global.user_id,
4869: sysdate,
4870: fnd_global.conc_login_id

Line 4868: fnd_global.user_id,

4864: l_printed_tax_name
4865: END,
4866: fnd_global.user_id,
4867: sysdate,
4868: fnd_global.user_id,
4869: sysdate,
4870: fnd_global.conc_login_id
4871: )
4872: SELECT

Line 4870: fnd_global.conc_login_id

4866: fnd_global.user_id,
4867: sysdate,
4868: fnd_global.user_id,
4869: sysdate,
4870: fnd_global.conc_login_id
4871: )
4872: SELECT
4873: avtl.language l_language,
4874: avtl.source_lang l_source_lang,

Line 4963: fnd_global.user_id ,--CREATED_BY

4959: effective_from ,--EFFECTIVE_FROM
4960: NULL ,--EFFECTIVE_TO
4961: 'MIGRATED' ,--RECORD_TYPE_CODE
4962: 'Y' ,--HAS_REPORTING_CODES_FLAG
4963: fnd_global.user_id ,--CREATED_BY
4964: SYSDATE ,--CREATION_DATE
4965: fnd_global.user_id ,--LAST_UPDATED_BY
4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 4965: fnd_global.user_id ,--LAST_UPDATED_BY

4961: 'MIGRATED' ,--RECORD_TYPE_CODE
4962: 'Y' ,--HAS_REPORTING_CODES_FLAG
4963: fnd_global.user_id ,--CREATED_BY
4964: SYSDATE ,--CREATION_DATE
4965: fnd_global.user_id ,--LAST_UPDATED_BY
4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID

Line 4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

4963: fnd_global.user_id ,--CREATED_BY
4964: SYSDATE ,--CREATION_DATE
4965: fnd_global.user_id ,--LAST_UPDATED_BY
4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID
4970: fnd_global.conc_program_id , -- Program Id
4971: fnd_global.conc_login_id , -- Program Login ID

Line 4968: fnd_global.conc_request_id , -- Request Id

4964: SYSDATE ,--CREATION_DATE
4965: fnd_global.user_id ,--LAST_UPDATED_BY
4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID
4970: fnd_global.conc_program_id , -- Program Id
4971: fnd_global.conc_login_id , -- Program Login ID
4972: 1

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

4965: fnd_global.user_id ,--LAST_UPDATED_BY
4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID
4970: fnd_global.conc_program_id , -- Program Id
4971: fnd_global.conc_login_id , -- Program Login ID
4972: 1
4973: )

Line 4970: fnd_global.conc_program_id , -- Program Id

4966: SYSDATE ,--LAST_UPDATE_DATE
4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID
4970: fnd_global.conc_program_id , -- Program Id
4971: fnd_global.conc_login_id , -- Program Login ID
4972: 1
4973: )
4974: SELECT

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

4967: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4968: fnd_global.conc_request_id , -- Request Id
4969: fnd_global.prog_appl_id , -- Program Application ID
4970: fnd_global.conc_program_id , -- Program Id
4971: fnd_global.conc_login_id , -- Program Login ID
4972: 1
4973: )
4974: SELECT
4975: min(zx_rates.effective_from) effective_from,

Line 5023: FND_GLOBAL.USER_ID,

5019: NULL,
5020: l_start_date,
5021: NULL,
5022: 'MIGRATED',
5023: FND_GLOBAL.USER_ID,
5024: SYSDATE,
5025: FND_GLOBAL.USER_ID,
5026: SYSDATE,
5027: fnd_global.conc_login_id ,

Line 5025: FND_GLOBAL.USER_ID,

5021: NULL,
5022: 'MIGRATED',
5023: FND_GLOBAL.USER_ID,
5024: SYSDATE,
5025: FND_GLOBAL.USER_ID,
5026: SYSDATE,
5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID

Line 5027: fnd_global.conc_login_id ,

5023: FND_GLOBAL.USER_ID,
5024: SYSDATE,
5025: FND_GLOBAL.USER_ID,
5026: SYSDATE,
5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID
5030: fnd_global.conc_program_id , -- Program Id
5031: fnd_global.conc_login_id , -- Program Login ID

Line 5028: fnd_global.conc_request_id , -- Request Id

5024: SYSDATE,
5025: FND_GLOBAL.USER_ID,
5026: SYSDATE,
5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID
5030: fnd_global.conc_program_id , -- Program Id
5031: fnd_global.conc_login_id , -- Program Login ID
5032: adjustment_tax_code,

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

5025: FND_GLOBAL.USER_ID,
5026: SYSDATE,
5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID
5030: fnd_global.conc_program_id , -- Program Id
5031: fnd_global.conc_login_id , -- Program Login ID
5032: adjustment_tax_code,
5033: NULL,

Line 5030: fnd_global.conc_program_id , -- Program Id

5026: SYSDATE,
5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID
5030: fnd_global.conc_program_id , -- Program Id
5031: fnd_global.conc_login_id , -- Program Login ID
5032: adjustment_tax_code,
5033: NULL,
5034: NULL,

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

5027: fnd_global.conc_login_id ,
5028: fnd_global.conc_request_id , -- Request Id
5029: fnd_global.prog_appl_id , -- Program Application ID
5030: fnd_global.conc_program_id , -- Program Id
5031: fnd_global.conc_login_id , -- Program Login ID
5032: adjustment_tax_code,
5033: NULL,
5034: NULL,
5035: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5087: FND_GLOBAL.USER_ID,

5083: NULL,
5084: l_start_date,
5085: NULL,
5086: 'MIGRATED',
5087: FND_GLOBAL.USER_ID,
5088: SYSDATE,
5089: FND_GLOBAL.USER_ID,
5090: SYSDATE,
5091: fnd_global.conc_login_id ,

Line 5089: FND_GLOBAL.USER_ID,

5085: NULL,
5086: 'MIGRATED',
5087: FND_GLOBAL.USER_ID,
5088: SYSDATE,
5089: FND_GLOBAL.USER_ID,
5090: SYSDATE,
5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID

Line 5091: fnd_global.conc_login_id ,

5087: FND_GLOBAL.USER_ID,
5088: SYSDATE,
5089: FND_GLOBAL.USER_ID,
5090: SYSDATE,
5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID
5094: fnd_global.conc_program_id , -- Program Id
5095: fnd_global.conc_login_id , -- Program Login ID

Line 5092: fnd_global.conc_request_id , -- Request Id

5088: SYSDATE,
5089: FND_GLOBAL.USER_ID,
5090: SYSDATE,
5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID
5094: fnd_global.conc_program_id , -- Program Id
5095: fnd_global.conc_login_id , -- Program Login ID
5096: global_attribute5,

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

5089: FND_GLOBAL.USER_ID,
5090: SYSDATE,
5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID
5094: fnd_global.conc_program_id , -- Program Id
5095: fnd_global.conc_login_id , -- Program Login ID
5096: global_attribute5,
5097: NULL,

Line 5094: fnd_global.conc_program_id , -- Program Id

5090: SYSDATE,
5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID
5094: fnd_global.conc_program_id , -- Program Id
5095: fnd_global.conc_login_id , -- Program Login ID
5096: global_attribute5,
5097: NULL,
5098: NULL,

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

5091: fnd_global.conc_login_id ,
5092: fnd_global.conc_request_id , -- Request Id
5093: fnd_global.prog_appl_id , -- Program Application ID
5094: fnd_global.conc_program_id , -- Program Id
5095: fnd_global.conc_login_id , -- Program Login ID
5096: global_attribute5,
5097: NULL,
5098: NULL,
5099: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5143: fnd_global.user_id ,--CREATED_BY

5139: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5140: DECODE(lookups.lookup_code,
5141: 'ZX_RATES','Y',
5142: 'N') ,--ENABLED_FLAG --Bug 5528045
5143: fnd_global.user_id ,--CREATED_BY
5144: SYSDATE ,--CREATION_DATE
5145: fnd_global.user_id ,--LAST_UPDATED_BY
5146: SYSDATE ,--LAST_UPDATE_DATE
5147: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 5145: fnd_global.user_id ,--LAST_UPDATED_BY

5141: 'ZX_RATES','Y',
5142: 'N') ,--ENABLED_FLAG --Bug 5528045
5143: fnd_global.user_id ,--CREATED_BY
5144: SYSDATE ,--CREATION_DATE
5145: fnd_global.user_id ,--LAST_UPDATED_BY
5146: SYSDATE ,--LAST_UPDATE_DATE
5147: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5148: reporting_type_id ,--REPORTING_TYPE_ID
5149: 1

Line 5147: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

5143: fnd_global.user_id ,--CREATED_BY
5144: SYSDATE ,--CREATION_DATE
5145: fnd_global.user_id ,--LAST_UPDATED_BY
5146: SYSDATE ,--LAST_UPDATE_DATE
5147: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5148: reporting_type_id ,--REPORTING_TYPE_ID
5149: 1
5150: FROM
5151: zx_reporting_types_b rep_type,

Line 5188: fnd_global.user_id ,

5184: THEN Initcap(REPORTING_TYPE_NAME)
5185: ELSE
5186: REPORTING_TYPE_NAME
5187: END,
5188: fnd_global.user_id ,
5189: SYSDATE ,
5190: fnd_global.user_id ,
5191: SYSDATE ,
5192: fnd_global.conc_login_id

Line 5190: fnd_global.user_id ,

5186: REPORTING_TYPE_NAME
5187: END,
5188: fnd_global.user_id ,
5189: SYSDATE ,
5190: fnd_global.user_id ,
5191: SYSDATE ,
5192: fnd_global.conc_login_id
5193:
5194: FROM

Line 5192: fnd_global.conc_login_id

5188: fnd_global.user_id ,
5189: SYSDATE ,
5190: fnd_global.user_id ,
5191: SYSDATE ,
5192: fnd_global.conc_login_id
5193:
5194: FROM
5195: (
5196: SELECT

Line 5260: fnd_global.user_id ,

5256: lookups.lookup_code ,--ENTITY_CODE
5257: DECODE(lookups.lookup_code,
5258: 'ZX_RATES','Y', --Bug 5528045
5259: 'N') ,--ENABLED_FLAG
5260: fnd_global.user_id ,
5261: SYSDATE ,
5262: fnd_global.user_id ,
5263: SYSDATE ,
5264: fnd_global.conc_login_id,

Line 5262: fnd_global.user_id ,

5258: 'ZX_RATES','Y', --Bug 5528045
5259: 'N') ,--ENABLED_FLAG
5260: fnd_global.user_id ,
5261: SYSDATE ,
5262: fnd_global.user_id ,
5263: SYSDATE ,
5264: fnd_global.conc_login_id,
5265: 1
5266: FROM

Line 5264: fnd_global.conc_login_id,

5260: fnd_global.user_id ,
5261: SYSDATE ,
5262: fnd_global.user_id ,
5263: SYSDATE ,
5264: fnd_global.conc_login_id,
5265: 1
5266: FROM
5267: zx_reporting_types_b types,
5268: fnd_lookups lookups

Line 5323: fnd_global.user_id ,

5319: NULL ,--EXCEPTION_CODE
5320: report_types.EFFECTIVE_FROM ,
5321: NULL ,--EFFECTIVE_TO
5322: 'MIGRATED' ,--RECORD_TYPE_CODE
5323: fnd_global.user_id ,
5324: SYSDATE ,
5325: fnd_global.user_id ,
5326: SYSDATE ,
5327: fnd_global.conc_login_id ,

Line 5325: fnd_global.user_id ,

5321: NULL ,--EFFECTIVE_TO
5322: 'MIGRATED' ,--RECORD_TYPE_CODE
5323: fnd_global.user_id ,
5324: SYSDATE ,
5325: fnd_global.user_id ,
5326: SYSDATE ,
5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID

Line 5327: fnd_global.conc_login_id ,

5323: fnd_global.user_id ,
5324: SYSDATE ,
5325: fnd_global.user_id ,
5326: SYSDATE ,
5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID
5330: fnd_global.conc_program_id , -- Program Id
5331: fnd_global.conc_login_id , -- Program Login ID

Line 5328: fnd_global.conc_request_id , -- Request Id

5324: SYSDATE ,
5325: fnd_global.user_id ,
5326: SYSDATE ,
5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID
5330: fnd_global.conc_program_id , -- Program Id
5331: fnd_global.conc_login_id , -- Program Login ID
5332: l_lookup_code,

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

5325: fnd_global.user_id ,
5326: SYSDATE ,
5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID
5330: fnd_global.conc_program_id , -- Program Id
5331: fnd_global.conc_login_id , -- Program Login ID
5332: l_lookup_code,
5333: NULL,

Line 5330: fnd_global.conc_program_id , -- Program Id

5326: SYSDATE ,
5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID
5330: fnd_global.conc_program_id , -- Program Id
5331: fnd_global.conc_login_id , -- Program Login ID
5332: l_lookup_code,
5333: NULL,
5334: NULL,

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

5327: fnd_global.conc_login_id ,
5328: fnd_global.conc_request_id , -- Request Id
5329: fnd_global.prog_appl_id , -- Program Application ID
5330: fnd_global.conc_program_id , -- Program Id
5331: fnd_global.conc_login_id , -- Program Login ID
5332: l_lookup_code,
5333: NULL,
5334: NULL,
5335: report_types.REPORTING_TYPE_ID,

Line 5372: fnd_global.user_id ,

5368: codes.reporting_code_id ,
5369: lookups.language ,
5370: lookups.source_lang ,
5371: lookups.meaning ,
5372: fnd_global.user_id ,
5373: sysdate ,
5374: fnd_global.user_id ,
5375: sysdate ,
5376: fnd_global.conc_login_id

Line 5374: fnd_global.user_id ,

5370: lookups.source_lang ,
5371: lookups.meaning ,
5372: fnd_global.user_id ,
5373: sysdate ,
5374: fnd_global.user_id ,
5375: sysdate ,
5376: fnd_global.conc_login_id
5377: FROM
5378: ZX_REPORTING_TYPES_B TYPES,

Line 5376: fnd_global.conc_login_id

5372: fnd_global.user_id ,
5373: sysdate ,
5374: fnd_global.user_id ,
5375: sysdate ,
5376: fnd_global.conc_login_id
5377: FROM
5378: ZX_REPORTING_TYPES_B TYPES,
5379: ZX_REPORTING_CODES_B CODES,
5380: FND_LOOKUP_VALUES lookups,

Line 5420: fnd_global.user_id ,

5416: codes.reporting_code_id ,
5417: lookups.language ,
5418: lookups.source_lang ,
5419: lookups.meaning ,
5420: fnd_global.user_id ,
5421: sysdate ,
5422: fnd_global.user_id ,
5423: sysdate ,
5424: fnd_global.conc_login_id

Line 5422: fnd_global.user_id ,

5418: lookups.source_lang ,
5419: lookups.meaning ,
5420: fnd_global.user_id ,
5421: sysdate ,
5422: fnd_global.user_id ,
5423: sysdate ,
5424: fnd_global.conc_login_id
5425: FROM
5426: ZX_REPORTING_TYPES_B TYPES,

Line 5424: fnd_global.conc_login_id

5420: fnd_global.user_id ,
5421: sysdate ,
5422: fnd_global.user_id ,
5423: sysdate ,
5424: fnd_global.conc_login_id
5425: FROM
5426: ZX_REPORTING_TYPES_B TYPES,
5427: ZX_REPORTING_CODES_B CODES,
5428: FND_LOOKUP_VALUES lookups,

Line 5480: fnd_global.user_id ,

5476: NULL ,--EXCEPTION_CODE
5477: effective_from ,
5478: NULL ,--EFFECTIVE_TO
5479: 'MIGRATED' ,--RECORD_TYPE_CODE
5480: fnd_global.user_id ,
5481: SYSDATE ,
5482: fnd_global.user_id ,
5483: SYSDATE ,
5484: fnd_global.conc_login_id ,

Line 5482: fnd_global.user_id ,

5478: NULL ,--EFFECTIVE_TO
5479: 'MIGRATED' ,--RECORD_TYPE_CODE
5480: fnd_global.user_id ,
5481: SYSDATE ,
5482: fnd_global.user_id ,
5483: SYSDATE ,
5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID

Line 5484: fnd_global.conc_login_id ,

5480: fnd_global.user_id ,
5481: SYSDATE ,
5482: fnd_global.user_id ,
5483: SYSDATE ,
5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID
5487: fnd_global.conc_program_id , -- Program Id
5488: fnd_global.conc_login_id , -- Program Login ID

Line 5485: fnd_global.conc_request_id , -- Request

5481: SYSDATE ,
5482: fnd_global.user_id ,
5483: SYSDATE ,
5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID
5487: fnd_global.conc_program_id , -- Program Id
5488: fnd_global.conc_login_id , -- Program Login ID
5489: 1

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

5482: fnd_global.user_id ,
5483: SYSDATE ,
5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID
5487: fnd_global.conc_program_id , -- Program Id
5488: fnd_global.conc_login_id , -- Program Login ID
5489: 1
5490: FROM

Line 5487: fnd_global.conc_program_id , -- Program Id

5483: SYSDATE ,
5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID
5487: fnd_global.conc_program_id , -- Program Id
5488: fnd_global.conc_login_id , -- Program Login ID
5489: 1
5490: FROM
5491: (

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

5484: fnd_global.conc_login_id ,
5485: fnd_global.conc_request_id , -- Request
5486: fnd_global.prog_appl_id , -- Program Application ID
5487: fnd_global.conc_program_id , -- Program Id
5488: fnd_global.conc_login_id , -- Program Login ID
5489: 1
5490: FROM
5491: (
5492: SELECT

Line 5534: fnd_global.user_id ,

5530: codes.reporting_code_id ,
5531: lookups.language ,
5532: lookups.source_lang ,
5533: lookups.meaning ,
5534: fnd_global.user_id ,
5535: sysdate ,
5536: fnd_global.user_id ,
5537: sysdate ,
5538: fnd_global.conc_login_id

Line 5536: fnd_global.user_id ,

5532: lookups.source_lang ,
5533: lookups.meaning ,
5534: fnd_global.user_id ,
5535: sysdate ,
5536: fnd_global.user_id ,
5537: sysdate ,
5538: fnd_global.conc_login_id
5539: FROM
5540: ZX_REPORTING_TYPES_B TYPES,

Line 5538: fnd_global.conc_login_id

5534: fnd_global.user_id ,
5535: sysdate ,
5536: fnd_global.user_id ,
5537: sysdate ,
5538: fnd_global.conc_login_id
5539: FROM
5540: ZX_REPORTING_TYPES_B TYPES,
5541: ZX_REPORTING_CODES_B CODES,
5542: FND_LOOKUP_VALUES lookups,

Line 5612: fnd_global.user_id ,--CREATED_BY

5608: effective_from ,--EFFECTIVE_FROM
5609: NULL ,--EFFECTIVE_TO
5610: 'MIGRATED' ,--RECORD_TYPE_CODE
5611: 'Y' ,--HAS_REPORTING_CODES_FLAG
5612: fnd_global.user_id ,--CREATED_BY
5613: SYSDATE ,--CREATION_DATE
5614: fnd_global.user_id ,--LAST_UPDATED_BY
5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 5614: fnd_global.user_id ,--LAST_UPDATED_BY

5610: 'MIGRATED' ,--RECORD_TYPE_CODE
5611: 'Y' ,--HAS_REPORTING_CODES_FLAG
5612: fnd_global.user_id ,--CREATED_BY
5613: SYSDATE ,--CREATION_DATE
5614: fnd_global.user_id ,--LAST_UPDATED_BY
5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID

Line 5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

5612: fnd_global.user_id ,--CREATED_BY
5613: SYSDATE ,--CREATION_DATE
5614: fnd_global.user_id ,--LAST_UPDATED_BY
5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID
5619: fnd_global.conc_program_id , -- Program Id
5620: fnd_global.conc_login_id , -- Program Login ID

Line 5617: fnd_global.conc_request_id , -- Request Id

5613: SYSDATE ,--CREATION_DATE
5614: fnd_global.user_id ,--LAST_UPDATED_BY
5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID
5619: fnd_global.conc_program_id , -- Program Id
5620: fnd_global.conc_login_id , -- Program Login ID
5621: 1

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

5614: fnd_global.user_id ,--LAST_UPDATED_BY
5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID
5619: fnd_global.conc_program_id , -- Program Id
5620: fnd_global.conc_login_id , -- Program Login ID
5621: 1
5622: )

Line 5619: fnd_global.conc_program_id , -- Program Id

5615: SYSDATE ,--LAST_UPDATE_DATE
5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID
5619: fnd_global.conc_program_id , -- Program Id
5620: fnd_global.conc_login_id , -- Program Login ID
5621: 1
5622: )
5623: SELECT

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

5616: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5617: fnd_global.conc_request_id , -- Request Id
5618: fnd_global.prog_appl_id , -- Program Application ID
5619: fnd_global.conc_program_id , -- Program Id
5620: fnd_global.conc_login_id , -- Program Login ID
5621: 1
5622: )
5623: SELECT
5624: min(zx_rates.effective_from) effective_from,

Line 5672: FND_GLOBAL.USER_ID,

5668: NULL,
5669: l_start_date,
5670: NULL,
5671: 'MIGRATED',
5672: FND_GLOBAL.USER_ID,
5673: SYSDATE,
5674: FND_GLOBAL.USER_ID,
5675: SYSDATE,
5676: fnd_global.conc_login_id ,

Line 5674: FND_GLOBAL.USER_ID,

5670: NULL,
5671: 'MIGRATED',
5672: FND_GLOBAL.USER_ID,
5673: SYSDATE,
5674: FND_GLOBAL.USER_ID,
5675: SYSDATE,
5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID

Line 5676: fnd_global.conc_login_id ,

5672: FND_GLOBAL.USER_ID,
5673: SYSDATE,
5674: FND_GLOBAL.USER_ID,
5675: SYSDATE,
5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID
5679: fnd_global.conc_program_id , -- Program Id
5680: fnd_global.conc_login_id , -- Program Login ID

Line 5677: fnd_global.conc_request_id , -- Request Id

5673: SYSDATE,
5674: FND_GLOBAL.USER_ID,
5675: SYSDATE,
5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID
5679: fnd_global.conc_program_id , -- Program Id
5680: fnd_global.conc_login_id , -- Program Login ID
5681: l_location_code,

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

5674: FND_GLOBAL.USER_ID,
5675: SYSDATE,
5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID
5679: fnd_global.conc_program_id , -- Program Id
5680: fnd_global.conc_login_id , -- Program Login ID
5681: l_location_code,
5682: NULL,

Line 5679: fnd_global.conc_program_id , -- Program Id

5675: SYSDATE,
5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID
5679: fnd_global.conc_program_id , -- Program Id
5680: fnd_global.conc_login_id , -- Program Login ID
5681: l_location_code,
5682: NULL,
5683: NULL,

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

5676: fnd_global.conc_login_id ,
5677: fnd_global.conc_request_id , -- Request Id
5678: fnd_global.prog_appl_id , -- Program Application ID
5679: fnd_global.conc_program_id , -- Program Id
5680: fnd_global.conc_login_id , -- Program Login ID
5681: l_location_code,
5682: NULL,
5683: NULL,
5684: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5744: fnd_global.user_id ,

5740: REPORTING_CODE_ID ,
5741: NULL ,--EXCEPTION_CODE
5742: EFFECTIVE_FROM ,
5743: NULL ,--EFFECTIVE_TO
5744: fnd_global.user_id ,
5745: SYSDATE ,
5746: fnd_global.user_id ,
5747: SYSDATE ,
5748: fnd_global.conc_login_id ,

Line 5746: fnd_global.user_id ,

5742: EFFECTIVE_FROM ,
5743: NULL ,--EFFECTIVE_TO
5744: fnd_global.user_id ,
5745: SYSDATE ,
5746: fnd_global.user_id ,
5747: SYSDATE ,
5748: fnd_global.conc_login_id ,
5749: REPORTING_CODE_CHAR_VALUE,
5750: REPORTING_CODE_DATE_VALUE,

Line 5748: fnd_global.conc_login_id ,

5744: fnd_global.user_id ,
5745: SYSDATE ,
5746: fnd_global.user_id ,
5747: SYSDATE ,
5748: fnd_global.conc_login_id ,
5749: REPORTING_CODE_CHAR_VALUE,
5750: REPORTING_CODE_DATE_VALUE,
5751: REPORTING_CODE_NUM_VALUE,
5752: 1

Line 5810: fnd_global.user_id ,--CREATED_BY

5806: )
5807: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5808: 'ZX_RATES_B' ,--ENTITY_CODE
5809: 'Y' ,--ENABLED_FLAG
5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE
5812: fnd_global.user_id ,--LAST_UPDATED_BY
5813: SYSDATE ,--LAST_UPDATE_DATE
5814: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 5812: fnd_global.user_id ,--LAST_UPDATED_BY

5808: 'ZX_RATES_B' ,--ENTITY_CODE
5809: 'Y' ,--ENABLED_FLAG
5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE
5812: fnd_global.user_id ,--LAST_UPDATED_BY
5813: SYSDATE ,--LAST_UPDATE_DATE
5814: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5815: reporting_type_id ,--REPORTING_TYPE_ID
5816: 1

Line 5814: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

5810: fnd_global.user_id ,--CREATED_BY
5811: SYSDATE ,--CREATION_DATE
5812: fnd_global.user_id ,--LAST_UPDATED_BY
5813: SYSDATE ,--LAST_UPDATE_DATE
5814: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5815: reporting_type_id ,--REPORTING_TYPE_ID
5816: 1
5817:
5818: FROM

Line 5903: fnd_global.user_id,

5899: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5900: null, --EXCEPTION_CODE
5901: sysdate, --EFFECTIVE_FROM
5902: null, --EFFECTIVE_TO
5903: fnd_global.user_id,
5904: sysdate,
5905: fnd_global.user_id,
5906: sysdate,
5907: fnd_global.conc_login_id,

Line 5905: fnd_global.user_id,

5901: sysdate, --EFFECTIVE_FROM
5902: null, --EFFECTIVE_TO
5903: fnd_global.user_id,
5904: sysdate,
5905: fnd_global.user_id,
5906: sysdate,
5907: fnd_global.conc_login_id,
5908: 1
5909:

Line 5907: fnd_global.conc_login_id,

5903: fnd_global.user_id,
5904: sysdate,
5905: fnd_global.user_id,
5906: sysdate,
5907: fnd_global.conc_login_id,
5908: 1
5909:
5910: FROM ZX_REPORTING_TYPES_B
5911: WHERE REPORTING_TYPE_CODE=p_reporting_type_code

Line 6005: fnd_global.user_id ,

6001: SYSDATE, --EFFECTIVE_FROM
6002: NULL, --EFFECTIVE_TO
6003: 'MIGRATED', --RECORD_TYPE_CODE
6004: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
6005: fnd_global.user_id ,
6006: SYSDATE ,
6007: fnd_global.user_id ,
6008: SYSDATE ,
6009: fnd_global.conc_login_id ,

Line 6007: fnd_global.user_id ,

6003: 'MIGRATED', --RECORD_TYPE_CODE
6004: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
6005: fnd_global.user_id ,
6006: SYSDATE ,
6007: fnd_global.user_id ,
6008: SYSDATE ,
6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID

Line 6009: fnd_global.conc_login_id ,

6005: fnd_global.user_id ,
6006: SYSDATE ,
6007: fnd_global.user_id ,
6008: SYSDATE ,
6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID

Line 6010: fnd_global.conc_request_id , -- Request Id

6006: SYSDATE ,
6007: fnd_global.user_id ,
6008: SYSDATE ,
6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID
6014: 1

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

6007: fnd_global.user_id ,
6008: SYSDATE ,
6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID
6014: 1
6015:

Line 6012: fnd_global.conc_program_id , -- Program Id

6008: SYSDATE ,
6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID
6014: 1
6015:
6016: FROM DUAL

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

6009: fnd_global.conc_login_id ,
6010: fnd_global.conc_request_id , -- Request Id
6011: fnd_global.prog_appl_id , -- Program Application ID
6012: fnd_global.conc_program_id , -- Program Id
6013: fnd_global.conc_login_id , -- Program Login ID
6014: 1
6015:
6016: FROM DUAL
6017:

Line 6108: fnd_global.conc_request_id , -- Request Id

6104: SYSDATE ,
6105: 120 ,
6106: SYSDATE ,
6107: 0 ,
6108: fnd_global.conc_request_id , -- Request Id
6109: fnd_global.prog_appl_id , -- Program Application ID
6110: fnd_global.conc_program_id , -- Program Id
6111: fnd_global.conc_login_id , -- Program Login ID
6112: 1

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

6105: 120 ,
6106: SYSDATE ,
6107: 0 ,
6108: fnd_global.conc_request_id , -- Request Id
6109: fnd_global.prog_appl_id , -- Program Application ID
6110: fnd_global.conc_program_id , -- Program Id
6111: fnd_global.conc_login_id , -- Program Login ID
6112: 1
6113: FROM DUAL

Line 6110: fnd_global.conc_program_id , -- Program Id

6106: SYSDATE ,
6107: 0 ,
6108: fnd_global.conc_request_id , -- Request Id
6109: fnd_global.prog_appl_id , -- Program Application ID
6110: fnd_global.conc_program_id , -- Program Id
6111: fnd_global.conc_login_id , -- Program Login ID
6112: 1
6113: FROM DUAL
6114: WHERE NOT EXISTS (select 1 from zx_reporting_types_b

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

6107: 0 ,
6108: fnd_global.conc_request_id , -- Request Id
6109: fnd_global.prog_appl_id , -- Program Application ID
6110: fnd_global.conc_program_id , -- Program Id
6111: fnd_global.conc_login_id , -- Program Login ID
6112: 1
6113: FROM DUAL
6114: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6115: where reporting_type_code= p_reporting_type_code

Line 6281: fnd_global.conc_request_id , -- Request Id

6277: SYSDATE ,
6278: 120 ,
6279: SYSDATE ,
6280: 0 ,
6281: fnd_global.conc_request_id , -- Request Id
6282: fnd_global.prog_appl_id , -- Program Application ID
6283: fnd_global.conc_program_id , -- Program Id
6284: fnd_global.conc_login_id , -- Program Login ID
6285: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

6278: 120 ,
6279: SYSDATE ,
6280: 0 ,
6281: fnd_global.conc_request_id , -- Request Id
6282: fnd_global.prog_appl_id , -- Program Application ID
6283: fnd_global.conc_program_id , -- Program Id
6284: fnd_global.conc_login_id , -- Program Login ID
6285: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6286: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 6283: fnd_global.conc_program_id , -- Program Id

6279: SYSDATE ,
6280: 0 ,
6281: fnd_global.conc_request_id , -- Request Id
6282: fnd_global.prog_appl_id , -- Program Application ID
6283: fnd_global.conc_program_id , -- Program Id
6284: fnd_global.conc_login_id , -- Program Login ID
6285: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6286: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6287: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

6280: 0 ,
6281: fnd_global.conc_request_id , -- Request Id
6282: fnd_global.prog_appl_id , -- Program Application ID
6283: fnd_global.conc_program_id , -- Program Id
6284: fnd_global.conc_login_id , -- Program Login ID
6285: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6286: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6287: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
6288: REPORTING_TYPE_ID,

Line 6548: fnd_global.conc_request_id , -- Request Id

6544: SYSDATE ,
6545: 120 ,
6546: SYSDATE ,
6547: 0 ,
6548: fnd_global.conc_request_id , -- Request Id
6549: fnd_global.prog_appl_id , -- Program Application ID
6550: fnd_global.conc_program_id , -- Program Id
6551: fnd_global.conc_login_id , -- Program Login ID
6552: l_lookup_code,

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

6545: 120 ,
6546: SYSDATE ,
6547: 0 ,
6548: fnd_global.conc_request_id , -- Request Id
6549: fnd_global.prog_appl_id , -- Program Application ID
6550: fnd_global.conc_program_id , -- Program Id
6551: fnd_global.conc_login_id , -- Program Login ID
6552: l_lookup_code,
6553: NULL,

Line 6550: fnd_global.conc_program_id , -- Program Id

6546: SYSDATE ,
6547: 0 ,
6548: fnd_global.conc_request_id , -- Request Id
6549: fnd_global.prog_appl_id , -- Program Application ID
6550: fnd_global.conc_program_id , -- Program Id
6551: fnd_global.conc_login_id , -- Program Login ID
6552: l_lookup_code,
6553: NULL,
6554: NULL,

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

6547: 0 ,
6548: fnd_global.conc_request_id , -- Request Id
6549: fnd_global.prog_appl_id , -- Program Application ID
6550: fnd_global.conc_program_id , -- Program Id
6551: fnd_global.conc_login_id , -- Program Login ID
6552: l_lookup_code,
6553: NULL,
6554: NULL,
6555: report_types.REPORTING_TYPE_ID,

Line 6701: fnd_global.conc_request_id , -- Request Id

6697: SYSDATE ,
6698: 120 ,
6699: SYSDATE ,
6700: 0 ,
6701: fnd_global.conc_request_id , -- Request Id
6702: fnd_global.prog_appl_id , -- Program Application ID
6703: fnd_global.conc_program_id , -- Program Id
6704: fnd_global.conc_login_id , -- Program Login ID
6705: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

6698: 120 ,
6699: SYSDATE ,
6700: 0 ,
6701: fnd_global.conc_request_id , -- Request Id
6702: fnd_global.prog_appl_id , -- Program Application ID
6703: fnd_global.conc_program_id , -- Program Id
6704: fnd_global.conc_login_id , -- Program Login ID
6705: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6706: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 6703: fnd_global.conc_program_id , -- Program Id

6699: SYSDATE ,
6700: 0 ,
6701: fnd_global.conc_request_id , -- Request Id
6702: fnd_global.prog_appl_id , -- Program Application ID
6703: fnd_global.conc_program_id , -- Program Id
6704: fnd_global.conc_login_id , -- Program Login ID
6705: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6706: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6707: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

6700: 0 ,
6701: fnd_global.conc_request_id , -- Request Id
6702: fnd_global.prog_appl_id , -- Program Application ID
6703: fnd_global.conc_program_id , -- Program Id
6704: fnd_global.conc_login_id , -- Program Login ID
6705: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6706: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6707: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
6708: REPORTING_TYPE_ID,

Line 6849: fnd_global.user_id ,

6845: lookups.lookup_code ,--ENTITY_CODE
6846: DECODE(lookups.lookup_code,
6847: 'ZX_RATES','Y',
6848: 'N') ,--ENABLED_FLAG
6849: fnd_global.user_id ,
6850: SYSDATE ,
6851: fnd_global.user_id ,
6852: SYSDATE ,
6853: fnd_global.conc_login_id,

Line 6851: fnd_global.user_id ,

6847: 'ZX_RATES','Y',
6848: 'N') ,--ENABLED_FLAG
6849: fnd_global.user_id ,
6850: SYSDATE ,
6851: fnd_global.user_id ,
6852: SYSDATE ,
6853: fnd_global.conc_login_id,
6854: 1
6855: FROM

Line 6853: fnd_global.conc_login_id,

6849: fnd_global.user_id ,
6850: SYSDATE ,
6851: fnd_global.user_id ,
6852: SYSDATE ,
6853: fnd_global.conc_login_id,
6854: 1
6855: FROM
6856: zx_reporting_types_b types,
6857: fnd_lookups lookups

Line 6894: fnd_global.user_id ,

6890: lookups.lookup_code ,--ENTITY_CODE
6891: DECODE(lookups.lookup_code,
6892: 'ZX_PARTY_TAX_PROFILE','Y',
6893: 'N') ,--ENABLED_FLAG
6894: fnd_global.user_id ,
6895: SYSDATE ,
6896: fnd_global.user_id ,
6897: SYSDATE ,
6898: fnd_global.conc_login_id,

Line 6896: fnd_global.user_id ,

6892: 'ZX_PARTY_TAX_PROFILE','Y',
6893: 'N') ,--ENABLED_FLAG
6894: fnd_global.user_id ,
6895: SYSDATE ,
6896: fnd_global.user_id ,
6897: SYSDATE ,
6898: fnd_global.conc_login_id,
6899: 1
6900: FROM

Line 6898: fnd_global.conc_login_id,

6894: fnd_global.user_id ,
6895: SYSDATE ,
6896: fnd_global.user_id ,
6897: SYSDATE ,
6898: fnd_global.conc_login_id,
6899: 1
6900: FROM
6901: zx_reporting_types_b types,
6902: fnd_lookups lookups

Line 6995: fnd_global.user_id ,--CREATED_BY

6991: effective_from ,--EFFECTIVE_FROM
6992: NULL ,--EFFECTIVE_TO
6993: 'MIGRATED' ,--RECORD_TYPE_CODE
6994: 'Y' ,--HAS_REPORTING_CODES_FLAG
6995: fnd_global.user_id ,--CREATED_BY
6996: SYSDATE ,--CREATION_DATE
6997: fnd_global.user_id ,--LAST_UPDATED_BY
6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 6997: fnd_global.user_id ,--LAST_UPDATED_BY

6993: 'MIGRATED' ,--RECORD_TYPE_CODE
6994: 'Y' ,--HAS_REPORTING_CODES_FLAG
6995: fnd_global.user_id ,--CREATED_BY
6996: SYSDATE ,--CREATION_DATE
6997: fnd_global.user_id ,--LAST_UPDATED_BY
6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

6995: fnd_global.user_id ,--CREATED_BY
6996: SYSDATE ,--CREATION_DATE
6997: fnd_global.user_id ,--LAST_UPDATED_BY
6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7002: fnd_global.conc_program_id ,--PROGRAM_ID
7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7000: fnd_global.conc_request_id ,--REQUEST_ID

6996: SYSDATE ,--CREATION_DATE
6997: fnd_global.user_id ,--LAST_UPDATED_BY
6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7002: fnd_global.conc_program_id ,--PROGRAM_ID
7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7004: 1 --OBJECT_VERSION_NUMBER

Line 7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

6997: fnd_global.user_id ,--LAST_UPDATED_BY
6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7002: fnd_global.conc_program_id ,--PROGRAM_ID
7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7004: 1 --OBJECT_VERSION_NUMBER
7005: )

Line 7002: fnd_global.conc_program_id ,--PROGRAM_ID

6998: SYSDATE ,--LAST_UPDATE_DATE
6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7002: fnd_global.conc_program_id ,--PROGRAM_ID
7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7004: 1 --OBJECT_VERSION_NUMBER
7005: )
7006: SELECT min(zx_rates.effective_from) effective_from

Line 7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

6999: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7000: fnd_global.conc_request_id ,--REQUEST_ID
7001: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7002: fnd_global.conc_program_id ,--PROGRAM_ID
7003: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7004: 1 --OBJECT_VERSION_NUMBER
7005: )
7006: SELECT min(zx_rates.effective_from) effective_from
7007: FROM zx_rates_b zx_rates,

Line 7032: fnd_global.user_id ,

7028: REPORTING_TYPE_ID ,
7029: LANGUAGE_CODE ,
7030: userenv('LANG') ,
7031: 'EMEA VAT Reporting Type' ,
7032: fnd_global.user_id ,
7033: SYSDATE ,
7034: fnd_global.user_id ,
7035: SYSDATE ,
7036: fnd_global.conc_login_id

Line 7034: fnd_global.user_id ,

7030: userenv('LANG') ,
7031: 'EMEA VAT Reporting Type' ,
7032: fnd_global.user_id ,
7033: SYSDATE ,
7034: fnd_global.user_id ,
7035: SYSDATE ,
7036: fnd_global.conc_login_id
7037: FROM
7038: (

Line 7036: fnd_global.conc_login_id

7032: fnd_global.user_id ,
7033: SYSDATE ,
7034: fnd_global.user_id ,
7035: SYSDATE ,
7036: fnd_global.conc_login_id
7037: FROM
7038: (
7039: SELECT
7040: TYPES.REPORTING_TYPE_ID ,

Line 7096: fnd_global.user_id ,--CREATED_BY

7092: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7093: types.reporting_type_id ,--REPORTING_TYPE_ID
7094: 'ZX_RATES' ,--ENTITY_CODE
7095: 'Y' ,--ENABLED_FLAG
7096: fnd_global.user_id ,--CREATED_BY
7097: SYSDATE ,--CREATION_DATE
7098: fnd_global.user_id ,--LAST_UPDATED_BY
7099: SYSDATE ,--LAST_UPDATE_DATE
7100: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7098: fnd_global.user_id ,--LAST_UPDATED_BY

7094: 'ZX_RATES' ,--ENTITY_CODE
7095: 'Y' ,--ENABLED_FLAG
7096: fnd_global.user_id ,--CREATED_BY
7097: SYSDATE ,--CREATION_DATE
7098: fnd_global.user_id ,--LAST_UPDATED_BY
7099: SYSDATE ,--LAST_UPDATE_DATE
7100: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7101: 1 --OBJECT_VERSION_NUMBER
7102: FROM

Line 7100: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7096: fnd_global.user_id ,--CREATED_BY
7097: SYSDATE ,--CREATION_DATE
7098: fnd_global.user_id ,--LAST_UPDATED_BY
7099: SYSDATE ,--LAST_UPDATE_DATE
7100: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7101: 1 --OBJECT_VERSION_NUMBER
7102: FROM
7103: zx_reporting_types_b types
7104: WHERE types.reporting_type_code IN('EMEA_VAT_REPORTING_TYPE')

Line 7163: fnd_global.user_id ,--CREATED_BY

7159: NULL ,--EXCEPTION_CODE
7160: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7161: NULL ,--EFFECTIVE_TO
7162: 'MIGRATED' ,--RECORD_TYPE_CODE
7163: fnd_global.user_id ,--CREATED_BY
7164: SYSDATE ,--CREATION_DATE
7165: fnd_global.user_id ,--LAST_UPDATED_BY
7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7165: fnd_global.user_id ,--LAST_UPDATED_BY

7161: NULL ,--EFFECTIVE_TO
7162: 'MIGRATED' ,--RECORD_TYPE_CODE
7163: fnd_global.user_id ,--CREATED_BY
7164: SYSDATE ,--CREATION_DATE
7165: fnd_global.user_id ,--LAST_UPDATED_BY
7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7163: fnd_global.user_id ,--CREATED_BY
7164: SYSDATE ,--CREATION_DATE
7165: fnd_global.user_id ,--LAST_UPDATED_BY
7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7170: fnd_global.conc_program_id ,--PROGRAM_ID
7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7168: fnd_global.conc_request_id ,--REQUEST_ID

7164: SYSDATE ,--CREATION_DATE
7165: fnd_global.user_id ,--LAST_UPDATED_BY
7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7170: fnd_global.conc_program_id ,--PROGRAM_ID
7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7172: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621

Line 7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7165: fnd_global.user_id ,--LAST_UPDATED_BY
7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7170: fnd_global.conc_program_id ,--PROGRAM_ID
7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7172: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7173: NULL ,--REPORTING_CODE_DATE_VALUE

Line 7170: fnd_global.conc_program_id ,--PROGRAM_ID

7166: SYSDATE ,--LAST_UPDATE_DATE
7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7170: fnd_global.conc_program_id ,--PROGRAM_ID
7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7172: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7173: NULL ,--REPORTING_CODE_DATE_VALUE
7174: NULL ,--REPORTING_CODE_NUM_VALUE

Line 7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7167: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7168: fnd_global.conc_request_id ,--REQUEST_ID
7169: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7170: fnd_global.conc_program_id ,--PROGRAM_ID
7171: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7172: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7173: NULL ,--REPORTING_CODE_DATE_VALUE
7174: NULL ,--REPORTING_CODE_NUM_VALUE
7175: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID

Line 7236: fnd_global.user_id ,

7232: THEN Initcap(lookups.meaning)
7233: ELSE
7234: lookups.meaning
7235: END,
7236: fnd_global.user_id ,
7237: sysdate ,
7238: fnd_global.user_id ,
7239: sysdate ,
7240: fnd_global.conc_login_id

Line 7238: fnd_global.user_id ,

7234: lookups.meaning
7235: END,
7236: fnd_global.user_id ,
7237: sysdate ,
7238: fnd_global.user_id ,
7239: sysdate ,
7240: fnd_global.conc_login_id
7241: FROM
7242: ZX_REPORTING_TYPES_B TYPES,

Line 7240: fnd_global.conc_login_id

7236: fnd_global.user_id ,
7237: sysdate ,
7238: fnd_global.user_id ,
7239: sysdate ,
7240: fnd_global.conc_login_id
7241: FROM
7242: ZX_REPORTING_TYPES_B TYPES,
7243: ZX_REPORTING_CODES_B CODES,
7244: FND_LOOKUP_VALUES lookups,

Line 7325: fnd_global.user_id ,

7321: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7322: NULL ,--EXCEPTION_CODE
7323: rates.EFFECTIVE_FROM ,
7324: NULL ,--EFFECTIVE_TO
7325: fnd_global.user_id ,
7326: SYSDATE ,
7327: fnd_global.user_id ,
7328: SYSDATE ,
7329: fnd_global.conc_login_id ,

Line 7327: fnd_global.user_id ,

7323: rates.EFFECTIVE_FROM ,
7324: NULL ,--EFFECTIVE_TO
7325: fnd_global.user_id ,
7326: SYSDATE ,
7327: fnd_global.user_id ,
7328: SYSDATE ,
7329: fnd_global.conc_login_id ,
7330: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7331: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7329: fnd_global.conc_login_id ,

7325: fnd_global.user_id ,
7326: SYSDATE ,
7327: fnd_global.user_id ,
7328: SYSDATE ,
7329: fnd_global.conc_login_id ,
7330: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7331: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7332: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7333: 1

Line 7397: fnd_global.user_id ,

7393: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7394: NULL ,--EXCEPTION_CODE
7395: rates.EFFECTIVE_FROM ,
7396: NULL ,--EFFECTIVE_TO
7397: fnd_global.user_id ,
7398: SYSDATE ,
7399: fnd_global.user_id ,
7400: SYSDATE ,
7401: fnd_global.conc_login_id ,

Line 7399: fnd_global.user_id ,

7395: rates.EFFECTIVE_FROM ,
7396: NULL ,--EFFECTIVE_TO
7397: fnd_global.user_id ,
7398: SYSDATE ,
7399: fnd_global.user_id ,
7400: SYSDATE ,
7401: fnd_global.conc_login_id ,
7402: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7403: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7401: fnd_global.conc_login_id ,

7397: fnd_global.user_id ,
7398: SYSDATE ,
7399: fnd_global.user_id ,
7400: SYSDATE ,
7401: fnd_global.conc_login_id ,
7402: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7403: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7404: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7405: 1

Line 7504: fnd_global.user_id ,--CREATED_BY

7500: l_effective_from ,--EFFECTIVE_FROM
7501: NULL ,--EFFECTIVE_TO
7502: 'MIGRATED' ,--RECORD_TYPE_CODE
7503: 'N' ,--HAS_REPORTING_CODES_FLAG
7504: fnd_global.user_id ,--CREATED_BY
7505: SYSDATE ,--CREATION_DATE
7506: fnd_global.user_id ,--LAST_UPDATED_BY
7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7506: fnd_global.user_id ,--LAST_UPDATED_BY

7502: 'MIGRATED' ,--RECORD_TYPE_CODE
7503: 'N' ,--HAS_REPORTING_CODES_FLAG
7504: fnd_global.user_id ,--CREATED_BY
7505: SYSDATE ,--CREATION_DATE
7506: fnd_global.user_id ,--LAST_UPDATED_BY
7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7504: fnd_global.user_id ,--CREATED_BY
7505: SYSDATE ,--CREATION_DATE
7506: fnd_global.user_id ,--LAST_UPDATED_BY
7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7511: fnd_global.conc_program_id ,--PROGRAM_ID
7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7509: fnd_global.conc_request_id ,--REQUEST_ID

7505: SYSDATE ,--CREATION_DATE
7506: fnd_global.user_id ,--LAST_UPDATED_BY
7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7511: fnd_global.conc_program_id ,--PROGRAM_ID
7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7513: 1 --OBJECT_VERSION_NUMBER

Line 7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7506: fnd_global.user_id ,--LAST_UPDATED_BY
7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7511: fnd_global.conc_program_id ,--PROGRAM_ID
7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7513: 1 --OBJECT_VERSION_NUMBER
7514: )

Line 7511: fnd_global.conc_program_id ,--PROGRAM_ID

7507: SYSDATE ,--LAST_UPDATE_DATE
7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7511: fnd_global.conc_program_id ,--PROGRAM_ID
7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7513: 1 --OBJECT_VERSION_NUMBER
7514: )
7515: SELECT

Line 7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7508: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7509: fnd_global.conc_request_id ,--REQUEST_ID
7510: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7511: fnd_global.conc_program_id ,--PROGRAM_ID
7512: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7513: 1 --OBJECT_VERSION_NUMBER
7514: )
7515: SELECT
7516: 'REVERSE_CHARGE_VAT' l_reporting_type_code,

Line 7545: fnd_global.user_id ,

7541: REPORTING_TYPE_ID ,
7542: LANGUAGE_CODE ,
7543: userenv('LANG') ,
7544: 'Reverse Charge VAT' ,
7545: fnd_global.user_id ,
7546: SYSDATE ,
7547: fnd_global.user_id ,
7548: SYSDATE ,
7549: fnd_global.conc_login_id

Line 7547: fnd_global.user_id ,

7543: userenv('LANG') ,
7544: 'Reverse Charge VAT' ,
7545: fnd_global.user_id ,
7546: SYSDATE ,
7547: fnd_global.user_id ,
7548: SYSDATE ,
7549: fnd_global.conc_login_id
7550: FROM
7551: (

Line 7549: fnd_global.conc_login_id

7545: fnd_global.user_id ,
7546: SYSDATE ,
7547: fnd_global.user_id ,
7548: SYSDATE ,
7549: fnd_global.conc_login_id
7550: FROM
7551: (
7552: SELECT
7553: TYPES.REPORTING_TYPE_ID ,

Line 7587: fnd_global.user_id ,--CREATED_BY

7583: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7584: types.reporting_type_id ,--REPORTING_TYPE_ID
7585: 'ZX_RATES' ,--ENTITY_CODE
7586: 'Y' ,--ENABLED_FLAG
7587: fnd_global.user_id ,--CREATED_BY
7588: SYSDATE ,--CREATION_DATE
7589: fnd_global.user_id ,--LAST_UPDATED_BY
7590: SYSDATE ,--LAST_UPDATE_DATE
7591: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7589: fnd_global.user_id ,--LAST_UPDATED_BY

7585: 'ZX_RATES' ,--ENTITY_CODE
7586: 'Y' ,--ENABLED_FLAG
7587: fnd_global.user_id ,--CREATED_BY
7588: SYSDATE ,--CREATION_DATE
7589: fnd_global.user_id ,--LAST_UPDATED_BY
7590: SYSDATE ,--LAST_UPDATE_DATE
7591: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7592: 1 --OBJECT_VERSION_NUMBER
7593: FROM

Line 7591: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7587: fnd_global.user_id ,--CREATED_BY
7588: SYSDATE ,--CREATION_DATE
7589: fnd_global.user_id ,--LAST_UPDATED_BY
7590: SYSDATE ,--LAST_UPDATE_DATE
7591: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7592: 1 --OBJECT_VERSION_NUMBER
7593: FROM
7594: zx_reporting_types_b types
7595: WHERE types.reporting_type_code = 'REVERSE_CHARGE_VAT'

Line 7631: fnd_global.user_id ,--CREATED_BY

7627: NULL ,--EXCEPTION_CODE
7628: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7629: NULL ,--EFFECTIVE_TO
7630: 'MIGRATED' ,--RECORD_TYPE_CODE
7631: fnd_global.user_id ,--CREATED_BY
7632: SYSDATE ,--CREATION_DATE
7633: fnd_global.user_id ,--LAST_UPDATED_BY
7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7633: fnd_global.user_id ,--LAST_UPDATED_BY

7629: NULL ,--EFFECTIVE_TO
7630: 'MIGRATED' ,--RECORD_TYPE_CODE
7631: fnd_global.user_id ,--CREATED_BY
7632: SYSDATE ,--CREATION_DATE
7633: fnd_global.user_id ,--LAST_UPDATED_BY
7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7631: fnd_global.user_id ,--CREATED_BY
7632: SYSDATE ,--CREATION_DATE
7633: fnd_global.user_id ,--LAST_UPDATED_BY
7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7638: fnd_global.conc_program_id ,--PROGRAM_ID
7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7636: fnd_global.conc_request_id ,--REQUEST_ID

7632: SYSDATE ,--CREATION_DATE
7633: fnd_global.user_id ,--LAST_UPDATED_BY
7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7638: fnd_global.conc_program_id ,--PROGRAM_ID
7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7640: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE

Line 7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7633: fnd_global.user_id ,--LAST_UPDATED_BY
7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7638: fnd_global.conc_program_id ,--PROGRAM_ID
7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7640: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7641: NULL ,--REPORTING_CODE_DATE_VALUE

Line 7638: fnd_global.conc_program_id ,--PROGRAM_ID

7634: SYSDATE ,--LAST_UPDATE_DATE
7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7638: fnd_global.conc_program_id ,--PROGRAM_ID
7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7640: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7641: NULL ,--REPORTING_CODE_DATE_VALUE
7642: NULL ,--REPORTING_CODE_NUM_VALUE

Line 7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7635: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7636: fnd_global.conc_request_id ,--REQUEST_ID
7637: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7638: fnd_global.conc_program_id ,--PROGRAM_ID
7639: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7640: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7641: NULL ,--REPORTING_CODE_DATE_VALUE
7642: NULL ,--REPORTING_CODE_NUM_VALUE
7643: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID

Line 7692: fnd_global.user_id ,

7688: THEN Initcap(lookups.meaning)
7689: ELSE
7690: lookups.meaning
7691: END,
7692: fnd_global.user_id ,
7693: sysdate ,
7694: fnd_global.user_id ,
7695: sysdate ,
7696: fnd_global.conc_login_id

Line 7694: fnd_global.user_id ,

7690: lookups.meaning
7691: END,
7692: fnd_global.user_id ,
7693: sysdate ,
7694: fnd_global.user_id ,
7695: sysdate ,
7696: fnd_global.conc_login_id
7697: FROM
7698: ZX_REPORTING_TYPES_B TYPES,

Line 7696: fnd_global.conc_login_id

7692: fnd_global.user_id ,
7693: sysdate ,
7694: fnd_global.user_id ,
7695: sysdate ,
7696: fnd_global.conc_login_id
7697: FROM
7698: ZX_REPORTING_TYPES_B TYPES,
7699: ZX_REPORTING_CODES_B CODES,
7700: FND_LOOKUP_VALUES lookups,

Line 7750: fnd_global.user_id ,

7746: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7747: NULL ,--EXCEPTION_CODE
7748: rates.EFFECTIVE_FROM ,
7749: NULL ,--EFFECTIVE_TO
7750: fnd_global.user_id ,
7751: SYSDATE ,
7752: fnd_global.user_id ,
7753: SYSDATE ,
7754: fnd_global.conc_login_id ,

Line 7752: fnd_global.user_id ,

7748: rates.EFFECTIVE_FROM ,
7749: NULL ,--EFFECTIVE_TO
7750: fnd_global.user_id ,
7751: SYSDATE ,
7752: fnd_global.user_id ,
7753: SYSDATE ,
7754: fnd_global.conc_login_id ,
7755: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7756: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7754: fnd_global.conc_login_id ,

7750: fnd_global.user_id ,
7751: SYSDATE ,
7752: fnd_global.user_id ,
7753: SYSDATE ,
7754: fnd_global.conc_login_id ,
7755: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7756: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7757: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7758: 1