APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on FND_GLOBAL

Line 285: fnd_global.user_id ,

281: NULL ,--EXCEPTION_CODE
282: report_types.EFFECTIVE_FROM ,
283: NULL ,--EFFECTIVE_TO
284: 'MIGRATED' ,--RECORD_TYPE_CODE
285: fnd_global.user_id ,
286: SYSDATE ,
287: fnd_global.user_id ,
288: SYSDATE ,
289: fnd_global.conc_login_id ,

Line 287: fnd_global.user_id ,

283: NULL ,--EFFECTIVE_TO
284: 'MIGRATED' ,--RECORD_TYPE_CODE
285: fnd_global.user_id ,
286: SYSDATE ,
287: fnd_global.user_id ,
288: SYSDATE ,
289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID

Line 289: fnd_global.conc_login_id ,

285: fnd_global.user_id ,
286: SYSDATE ,
287: fnd_global.user_id ,
288: SYSDATE ,
289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID
292: fnd_global.conc_program_id , -- Program Id
293: fnd_global.conc_login_id , -- Program Login ID

Line 290: fnd_global.conc_request_id , -- Request Id

286: SYSDATE ,
287: fnd_global.user_id ,
288: SYSDATE ,
289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID
292: fnd_global.conc_program_id , -- Program Id
293: fnd_global.conc_login_id , -- Program Login ID
294: l_lookup_code,

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

287: fnd_global.user_id ,
288: SYSDATE ,
289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID
292: fnd_global.conc_program_id , -- Program Id
293: fnd_global.conc_login_id , -- Program Login ID
294: l_lookup_code,
295: NULL,

Line 292: fnd_global.conc_program_id , -- Program Id

288: SYSDATE ,
289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID
292: fnd_global.conc_program_id , -- Program Id
293: fnd_global.conc_login_id , -- Program Login ID
294: l_lookup_code,
295: NULL,
296: NULL,

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

289: fnd_global.conc_login_id ,
290: fnd_global.conc_request_id , -- Request Id
291: fnd_global.prog_appl_id , -- Program Application ID
292: fnd_global.conc_program_id , -- Program Id
293: fnd_global.conc_login_id , -- Program Login ID
294: l_lookup_code,
295: NULL,
296: NULL,
297: report_types.REPORTING_TYPE_ID,

Line 359: fnd_global.user_id ,

355: effective_from ,
356: NULL ,--EFFECTIVE_TO
357: 'MIGRATED' ,--RECORD_TYPE_CODE
358: 'N' ,--HAS_REPORTING_CODES_FLAG
359: fnd_global.user_id ,
360: SYSDATE ,
361: fnd_global.user_id ,
362: SYSDATE ,
363: fnd_global.conc_login_id ,

Line 361: fnd_global.user_id ,

357: 'MIGRATED' ,--RECORD_TYPE_CODE
358: 'N' ,--HAS_REPORTING_CODES_FLAG
359: fnd_global.user_id ,
360: SYSDATE ,
361: fnd_global.user_id ,
362: SYSDATE ,
363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID

Line 363: fnd_global.conc_login_id ,

359: fnd_global.user_id ,
360: SYSDATE ,
361: fnd_global.user_id ,
362: SYSDATE ,
363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID
366: fnd_global.conc_program_id , -- Program Id
367: fnd_global.conc_login_id , -- Program Login ID

Line 364: fnd_global.conc_request_id , -- Request Id

360: SYSDATE ,
361: fnd_global.user_id ,
362: SYSDATE ,
363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID
366: fnd_global.conc_program_id , -- Program Id
367: fnd_global.conc_login_id , -- Program Login ID
368: 1

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

361: fnd_global.user_id ,
362: SYSDATE ,
363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID
366: fnd_global.conc_program_id , -- Program Id
367: fnd_global.conc_login_id , -- Program Login ID
368: 1
369: )

Line 366: fnd_global.conc_program_id , -- Program Id

362: SYSDATE ,
363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID
366: fnd_global.conc_program_id , -- Program Id
367: fnd_global.conc_login_id , -- Program Login ID
368: 1
369: )
370: -- Creation of CAI NUMBER Reporting Type and Usage

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

363: fnd_global.conc_login_id ,
364: fnd_global.conc_request_id , -- Request Id
365: fnd_global.prog_appl_id , -- Program Application ID
366: fnd_global.conc_program_id , -- Program Id
367: fnd_global.conc_login_id , -- Program Login ID
368: 1
369: )
370: -- Creation of CAI NUMBER Reporting Type and Usage
371:

Line 417: fnd_global.user_id ,

413: effective_from ,
414: NULL ,--EFFECTIVE_TO
415: 'MIGRATED' ,--RECORD_TYPE_CODE
416: 'N' ,--HAS_REPORTING_CODES_FLAG
417: fnd_global.user_id ,
418: SYSDATE ,
419: fnd_global.user_id ,
420: SYSDATE ,
421: fnd_global.conc_login_id ,

Line 419: fnd_global.user_id ,

415: 'MIGRATED' ,--RECORD_TYPE_CODE
416: 'N' ,--HAS_REPORTING_CODES_FLAG
417: fnd_global.user_id ,
418: SYSDATE ,
419: fnd_global.user_id ,
420: SYSDATE ,
421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID

Line 421: fnd_global.conc_login_id ,

417: fnd_global.user_id ,
418: SYSDATE ,
419: fnd_global.user_id ,
420: SYSDATE ,
421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID
424: fnd_global.conc_program_id , -- Program Id
425: fnd_global.conc_login_id , -- Program Login ID

Line 422: fnd_global.conc_request_id , -- Request Id

418: SYSDATE ,
419: fnd_global.user_id ,
420: SYSDATE ,
421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID
424: fnd_global.conc_program_id , -- Program Id
425: fnd_global.conc_login_id , -- Program Login ID
426: 1

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

419: fnd_global.user_id ,
420: SYSDATE ,
421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID
424: fnd_global.conc_program_id , -- Program Id
425: fnd_global.conc_login_id , -- Program Login ID
426: 1
427: )

Line 424: fnd_global.conc_program_id , -- Program Id

420: SYSDATE ,
421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID
424: fnd_global.conc_program_id , -- Program Id
425: fnd_global.conc_login_id , -- Program Login ID
426: 1
427: )
428:

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

421: fnd_global.conc_login_id ,
422: fnd_global.conc_request_id , -- Request Id
423: fnd_global.prog_appl_id , -- Program Application ID
424: fnd_global.conc_program_id , -- Program Id
425: fnd_global.conc_login_id , -- Program Login ID
426: 1
427: )
428:
429: --Bug# 3587896

Line 460: fnd_global.user_id ,--CREATED_BY

456: decode(LOOKUP_CODE,
457: 'ZX_PARTY_TAX_PROFILE',
458: 'Y',
459: 'N') ,--ENABLED_FLAG
460: fnd_global.user_id ,--CREATED_BY
461: SYSDATE ,--CREATION_DATE
462: fnd_global.user_id ,--LAST_UPDATED_BY
463: SYSDATE ,--LAST_UPDATE_DATE
464: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 462: fnd_global.user_id ,--LAST_UPDATED_BY

458: 'Y',
459: 'N') ,--ENABLED_FLAG
460: fnd_global.user_id ,--CREATED_BY
461: SYSDATE ,--CREATION_DATE
462: fnd_global.user_id ,--LAST_UPDATED_BY
463: SYSDATE ,--LAST_UPDATE_DATE
464: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
465: reporting_type_id ,--REPORTING_TYPE_ID
466: 1

Line 464: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

460: fnd_global.user_id ,--CREATED_BY
461: SYSDATE ,--CREATION_DATE
462: fnd_global.user_id ,--LAST_UPDATED_BY
463: SYSDATE ,--LAST_UPDATE_DATE
464: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
465: reporting_type_id ,--REPORTING_TYPE_ID
466: 1
467:
468: FROM

Line 499: fnd_global.user_id ,--CREATED_BY

495: decode(LOOKUP_CODE,
496: 'ZX_PARTY_TAX_PROFILE',
497: 'Y',
498: 'N') ,--ENABLED_FLAG
499: fnd_global.user_id ,--CREATED_BY
500: SYSDATE ,--CREATION_DATE
501: fnd_global.user_id ,--LAST_UPDATED_BY
502: SYSDATE ,--LAST_UPDATE_DATE
503: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 501: fnd_global.user_id ,--LAST_UPDATED_BY

497: 'Y',
498: 'N') ,--ENABLED_FLAG
499: fnd_global.user_id ,--CREATED_BY
500: SYSDATE ,--CREATION_DATE
501: fnd_global.user_id ,--LAST_UPDATED_BY
502: SYSDATE ,--LAST_UPDATE_DATE
503: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
504: reporting_type_id ,--REPORTING_TYPE_ID
505: 1

Line 503: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

499: fnd_global.user_id ,--CREATED_BY
500: SYSDATE ,--CREATION_DATE
501: fnd_global.user_id ,--LAST_UPDATED_BY
502: SYSDATE ,--LAST_UPDATE_DATE
503: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
504: reporting_type_id ,--REPORTING_TYPE_ID
505: 1
506: FROM
507: zx_reporting_types_b rep_type,

Line 538: fnd_global.user_id ,

534: lookups.lookup_code ,--ENTITY_CODE
535: DECODE(lookups.lookup_code,
536: 'ZX_RATES','Y', --Bug 5528045
537: 'N') ,--ENABLED_FLAG
538: fnd_global.user_id ,
539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.conc_login_id,

Line 540: fnd_global.user_id ,

536: 'ZX_RATES','Y', --Bug 5528045
537: 'N') ,--ENABLED_FLAG
538: fnd_global.user_id ,
539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.conc_login_id,
543: 1
544: FROM

Line 542: fnd_global.conc_login_id,

538: fnd_global.user_id ,
539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.conc_login_id,
543: 1
544: FROM
545: zx_reporting_types_b types,
546: fnd_lookups lookups

Line 601: fnd_global.user_id ,

597: NULL ,--EXCEPTION_CODE
598: EFFECTIVE_FROM ,
599: NULL ,--EFFECTIVE_TO
600: 'MIGRATED' ,--RECORD_TYPE_CODE
601: fnd_global.user_id ,
602: SYSDATE ,
603: fnd_global.user_id ,
604: SYSDATE ,
605: fnd_global.conc_login_id ,

Line 603: fnd_global.user_id ,

599: NULL ,--EFFECTIVE_TO
600: 'MIGRATED' ,--RECORD_TYPE_CODE
601: fnd_global.user_id ,
602: SYSDATE ,
603: fnd_global.user_id ,
604: SYSDATE ,
605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID

Line 605: fnd_global.conc_login_id ,

601: fnd_global.user_id ,
602: SYSDATE ,
603: fnd_global.user_id ,
604: SYSDATE ,
605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID
608: fnd_global.conc_program_id , -- Program Id
609: fnd_global.conc_login_id , -- Program Login ID

Line 606: fnd_global.conc_request_id , -- Request Id

602: SYSDATE ,
603: fnd_global.user_id ,
604: SYSDATE ,
605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID
608: fnd_global.conc_program_id , -- Program Id
609: fnd_global.conc_login_id , -- Program Login ID
610: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

603: fnd_global.user_id ,
604: SYSDATE ,
605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID
608: fnd_global.conc_program_id , -- Program Id
609: fnd_global.conc_login_id , -- Program Login ID
610: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
611: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 608: fnd_global.conc_program_id , -- Program Id

604: SYSDATE ,
605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID
608: fnd_global.conc_program_id , -- Program Id
609: fnd_global.conc_login_id , -- Program Login ID
610: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
611: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
612: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

605: fnd_global.conc_login_id ,
606: fnd_global.conc_request_id , -- Request Id
607: fnd_global.prog_appl_id , -- Program Application ID
608: fnd_global.conc_program_id , -- Program Id
609: fnd_global.conc_login_id , -- Program Login ID
610: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
611: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
612: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
613: REPORTING_TYPE_ID,

Line 659: fnd_global.user_id ,

655: THEN Initcap(lookups.meaning)
656: ELSE
657: lookups.meaning
658: END,
659: fnd_global.user_id ,
660: sysdate ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.conc_login_id

Line 661: fnd_global.user_id ,

657: lookups.meaning
658: END,
659: fnd_global.user_id ,
660: sysdate ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.conc_login_id
664: FROM
665: ZX_REPORTING_TYPES_B TYPES,

Line 663: fnd_global.conc_login_id

659: fnd_global.user_id ,
660: sysdate ,
661: fnd_global.user_id ,
662: sysdate ,
663: fnd_global.conc_login_id
664: FROM
665: ZX_REPORTING_TYPES_B TYPES,
666: ZX_REPORTING_CODES_B CODES,
667: FND_LOOKUP_VALUES lookups,

Line 703: fnd_global.user_id ,

699: REPORTING_TYPE_ID ,
700: LANGUAGE_CODE ,
701: userenv('LANG') ,
702: REPORTING_TYPE_NAME ,
703: fnd_global.user_id ,
704: SYSDATE ,
705: fnd_global.user_id ,
706: SYSDATE ,
707: fnd_global.conc_login_id

Line 705: fnd_global.user_id ,

701: userenv('LANG') ,
702: REPORTING_TYPE_NAME ,
703: fnd_global.user_id ,
704: SYSDATE ,
705: fnd_global.user_id ,
706: SYSDATE ,
707: fnd_global.conc_login_id
708:
709: FROM

Line 707: fnd_global.conc_login_id

703: fnd_global.user_id ,
704: SYSDATE ,
705: fnd_global.user_id ,
706: SYSDATE ,
707: fnd_global.conc_login_id
708:
709: FROM
710: (
711: SELECT

Line 783: fnd_global.user_id ,

779: codes.reporting_code_id ,
780: lookups.language ,
781: lookups.source_lang ,
782: lookups.meaning ,
783: fnd_global.user_id ,
784: sysdate ,
785: fnd_global.user_id ,
786: sysdate ,
787: fnd_global.conc_login_id

Line 785: fnd_global.user_id ,

781: lookups.source_lang ,
782: lookups.meaning ,
783: fnd_global.user_id ,
784: sysdate ,
785: fnd_global.user_id ,
786: sysdate ,
787: fnd_global.conc_login_id
788: FROM
789: ZX_REPORTING_TYPES_B TYPES,

Line 787: fnd_global.conc_login_id

783: fnd_global.user_id ,
784: sysdate ,
785: fnd_global.user_id ,
786: sysdate ,
787: fnd_global.conc_login_id
788: FROM
789: ZX_REPORTING_TYPES_B TYPES,
790: ZX_REPORTING_CODES_B CODES,
791: FND_LOOKUP_VALUES lookups,

Line 840: fnd_global.user_id ,

836: ELSE
837: CODES.REPORTING_CODE_CHAR_VALUE
838: END
839: END ,--REPORTING_CODE_NAME
840: fnd_global.user_id ,
841: SYSDATE ,
842: fnd_global.user_id ,
843: SYSDATE ,
844: fnd_global.conc_login_id

Line 842: fnd_global.user_id ,

838: END
839: END ,--REPORTING_CODE_NAME
840: fnd_global.user_id ,
841: SYSDATE ,
842: fnd_global.user_id ,
843: SYSDATE ,
844: fnd_global.conc_login_id
845: FROM
846: ZX_REPORTING_CODES_B CODES,

Line 844: fnd_global.conc_login_id

840: fnd_global.user_id ,
841: SYSDATE ,
842: fnd_global.user_id ,
843: SYSDATE ,
844: fnd_global.conc_login_id
845: FROM
846: ZX_REPORTING_CODES_B CODES,
847: FND_LANGUAGES L
848:

Line 934: fnd_global.user_id ,

930: effective_from ,
931: NULL ,--EFFECTIVE_TO
932: 'MIGRATED' ,--RECORD_TYPE_CODE
933: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
934: fnd_global.user_id ,
935: SYSDATE ,
936: fnd_global.user_id ,
937: SYSDATE ,
938: fnd_global.conc_login_id ,

Line 936: fnd_global.user_id ,

932: 'MIGRATED' ,--RECORD_TYPE_CODE
933: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
934: fnd_global.user_id ,
935: SYSDATE ,
936: fnd_global.user_id ,
937: SYSDATE ,
938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID

Line 938: fnd_global.conc_login_id ,

934: fnd_global.user_id ,
935: SYSDATE ,
936: fnd_global.user_id ,
937: SYSDATE ,
938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID
941: fnd_global.conc_program_id , -- Program Id
942: fnd_global.conc_login_id , -- Program Login ID

Line 939: fnd_global.conc_request_id , -- Request Id

935: SYSDATE ,
936: fnd_global.user_id ,
937: SYSDATE ,
938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID
941: fnd_global.conc_program_id , -- Program Id
942: fnd_global.conc_login_id , -- Program Login ID
943: 1

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

936: fnd_global.user_id ,
937: SYSDATE ,
938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID
941: fnd_global.conc_program_id , -- Program Id
942: fnd_global.conc_login_id , -- Program Login ID
943: 1
944: )

Line 941: fnd_global.conc_program_id , -- Program Id

937: SYSDATE ,
938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID
941: fnd_global.conc_program_id , -- Program Id
942: fnd_global.conc_login_id , -- Program Login ID
943: 1
944: )
945: SELECT

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

938: fnd_global.conc_login_id ,
939: fnd_global.conc_request_id , -- Request Id
940: fnd_global.prog_appl_id , -- Program Application ID
941: fnd_global.conc_program_id , -- Program Id
942: fnd_global.conc_login_id , -- Program Login ID
943: 1
944: )
945: SELECT
946: min(zx_rates.effective_from) effective_from,

Line 1023: fnd_global.user_id ,

1019: effective_from ,
1020: NULL ,--EFFECTIVE_TO
1021: 'MIGRATED' ,--RECORD_TYPE_CODE
1022: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
1023: fnd_global.user_id ,
1024: SYSDATE ,
1025: fnd_global.user_id ,
1026: SYSDATE ,
1027: fnd_global.conc_login_id ,

Line 1025: fnd_global.user_id ,

1021: 'MIGRATED' ,--RECORD_TYPE_CODE
1022: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
1023: fnd_global.user_id ,
1024: SYSDATE ,
1025: fnd_global.user_id ,
1026: SYSDATE ,
1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID

Line 1027: fnd_global.conc_login_id ,

1023: fnd_global.user_id ,
1024: SYSDATE ,
1025: fnd_global.user_id ,
1026: SYSDATE ,
1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID
1030: fnd_global.conc_program_id , -- Program Id
1031: fnd_global.conc_login_id , -- Program Login ID

Line 1028: fnd_global.conc_request_id , -- Request Id

1024: SYSDATE ,
1025: fnd_global.user_id ,
1026: SYSDATE ,
1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID
1030: fnd_global.conc_program_id , -- Program Id
1031: fnd_global.conc_login_id , -- Program Login ID
1032: 1

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

1025: fnd_global.user_id ,
1026: SYSDATE ,
1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID
1030: fnd_global.conc_program_id , -- Program Id
1031: fnd_global.conc_login_id , -- Program Login ID
1032: 1
1033: )

Line 1030: fnd_global.conc_program_id , -- Program Id

1026: SYSDATE ,
1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID
1030: fnd_global.conc_program_id , -- Program Id
1031: fnd_global.conc_login_id , -- Program Login ID
1032: 1
1033: )
1034: SELECT

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

1027: fnd_global.conc_login_id ,
1028: fnd_global.conc_request_id , -- Request Id
1029: fnd_global.prog_appl_id , -- Program Application ID
1030: fnd_global.conc_program_id , -- Program Id
1031: fnd_global.conc_login_id , -- Program Login ID
1032: 1
1033: )
1034: SELECT
1035: min(zx_rates.effective_from) effective_from,

Line 1093: fnd_global.user_id ,

1089: NULL ,--EXCEPTION_CODE
1090: EFFECTIVE_FROM ,
1091: NULL ,--EFFECTIVE_TO
1092: 'MIGRATED' ,--RECORD_TYPE_CODE
1093: fnd_global.user_id ,
1094: SYSDATE ,
1095: fnd_global.user_id ,
1096: SYSDATE ,
1097: fnd_global.conc_login_id ,

Line 1095: fnd_global.user_id ,

1091: NULL ,--EFFECTIVE_TO
1092: 'MIGRATED' ,--RECORD_TYPE_CODE
1093: fnd_global.user_id ,
1094: SYSDATE ,
1095: fnd_global.user_id ,
1096: SYSDATE ,
1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID

Line 1097: fnd_global.conc_login_id ,

1093: fnd_global.user_id ,
1094: SYSDATE ,
1095: fnd_global.user_id ,
1096: SYSDATE ,
1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID
1100: fnd_global.conc_program_id , -- Program Id
1101: fnd_global.conc_login_id , -- Program Login ID

Line 1098: fnd_global.conc_request_id , -- Request Id

1094: SYSDATE ,
1095: fnd_global.user_id ,
1096: SYSDATE ,
1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID
1100: fnd_global.conc_program_id , -- Program Id
1101: fnd_global.conc_login_id , -- Program Login ID
1102: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

1095: fnd_global.user_id ,
1096: SYSDATE ,
1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID
1100: fnd_global.conc_program_id , -- Program Id
1101: fnd_global.conc_login_id , -- Program Login ID
1102: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1103: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 1100: fnd_global.conc_program_id , -- Program Id

1096: SYSDATE ,
1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID
1100: fnd_global.conc_program_id , -- Program Id
1101: fnd_global.conc_login_id , -- Program Login ID
1102: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1103: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
1104: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

1097: fnd_global.conc_login_id ,
1098: fnd_global.conc_request_id , -- Request Id
1099: fnd_global.prog_appl_id , -- Program Application ID
1100: fnd_global.conc_program_id , -- Program Id
1101: fnd_global.conc_login_id , -- Program Login ID
1102: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
1103: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
1104: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
1105: REPORTING_TYPE_ID,

Line 1151: fnd_global.user_id ,

1147: THEN Initcap(lookups.meaning)
1148: ELSE
1149: lookups.meaning
1150: END,
1151: fnd_global.user_id ,
1152: sysdate ,
1153: fnd_global.user_id ,
1154: sysdate ,
1155: fnd_global.conc_login_id

Line 1153: fnd_global.user_id ,

1149: lookups.meaning
1150: END,
1151: fnd_global.user_id ,
1152: sysdate ,
1153: fnd_global.user_id ,
1154: sysdate ,
1155: fnd_global.conc_login_id
1156: FROM
1157: ZX_REPORTING_TYPES_B TYPES,

Line 1155: fnd_global.conc_login_id

1151: fnd_global.user_id ,
1152: sysdate ,
1153: fnd_global.user_id ,
1154: sysdate ,
1155: fnd_global.conc_login_id
1156: FROM
1157: ZX_REPORTING_TYPES_B TYPES,
1158: ZX_REPORTING_CODES_B CODES,
1159: FND_LOOKUP_VALUES lookups,

Line 1241: fnd_global.user_id,

1237: pvs.GLOBAL_ATTRIBUTE18, --REPORTING_CODE_CHAR_VALUE
1238: null, --EXCEPTION_CODE
1239: sysdate, --EFFECTIVE_FROM
1240: null, --EFFECTIVE_TO
1241: fnd_global.user_id,
1242: sysdate,
1243: fnd_global.user_id,
1244: sysdate,
1245: fnd_global.conc_login_id,

Line 1243: fnd_global.user_id,

1239: sysdate, --EFFECTIVE_FROM
1240: null, --EFFECTIVE_TO
1241: fnd_global.user_id,
1242: sysdate,
1243: fnd_global.user_id,
1244: sysdate,
1245: fnd_global.conc_login_id,
1246: 1
1247: FROM

Line 1245: fnd_global.conc_login_id,

1241: fnd_global.user_id,
1242: sysdate,
1243: fnd_global.user_id,
1244: sysdate,
1245: fnd_global.conc_login_id,
1246: 1
1247: FROM
1248: zx_reporting_types_b types,
1249: ap_supplier_sites pvs,

Line 1291: fnd_global.user_id,

1287: pvs.GLOBAL_ATTRIBUTE19, --REPORTING_CODE_NUM_VALUE
1288: null, --EXCEPTION_CODE
1289: sysdate, --EFFECTIVE_FROM
1290: to_date(pvs.GLOBAL_ATTRIBUTE20,'yyyy/mm/dd hh24:mi:ss'),--EFFECTIVE_TO
1291: fnd_global.user_id,
1292: sysdate,
1293: fnd_global.user_id,
1294: sysdate,
1295: fnd_global.conc_login_id,

Line 1293: fnd_global.user_id,

1289: sysdate, --EFFECTIVE_FROM
1290: to_date(pvs.GLOBAL_ATTRIBUTE20,'yyyy/mm/dd hh24:mi:ss'),--EFFECTIVE_TO
1291: fnd_global.user_id,
1292: sysdate,
1293: fnd_global.user_id,
1294: sysdate,
1295: fnd_global.conc_login_id,
1296: 1
1297: FROM

Line 1295: fnd_global.conc_login_id,

1291: fnd_global.user_id,
1292: sysdate,
1293: fnd_global.user_id,
1294: sysdate,
1295: fnd_global.conc_login_id,
1296: 1
1297: FROM
1298: zx_reporting_types_b types,
1299: ap_supplier_sites pvs ,

Line 1344: fnd_global.user_id ,

1340: report_codes.REPORTING_CODE_ID ,
1341: NULL ,--EXCEPTION_CODE
1342: rates.EFFECTIVE_FROM ,
1343: NULL ,--EFFECTIVE_TO
1344: fnd_global.user_id ,
1345: SYSDATE ,
1346: fnd_global.user_id ,
1347: SYSDATE ,
1348: fnd_global.conc_login_id ,

Line 1346: fnd_global.user_id ,

1342: rates.EFFECTIVE_FROM ,
1343: NULL ,--EFFECTIVE_TO
1344: fnd_global.user_id ,
1345: SYSDATE ,
1346: fnd_global.user_id ,
1347: SYSDATE ,
1348: fnd_global.conc_login_id ,
1349: report_codes.REPORTING_CODE_CHAR_VALUE ,
1350: report_codes.REPORTING_CODE_DATE_VALUE ,

Line 1348: fnd_global.conc_login_id ,

1344: fnd_global.user_id ,
1345: SYSDATE ,
1346: fnd_global.user_id ,
1347: SYSDATE ,
1348: fnd_global.conc_login_id ,
1349: report_codes.REPORTING_CODE_CHAR_VALUE ,
1350: report_codes.REPORTING_CODE_DATE_VALUE ,
1351: report_codes.REPORTING_CODE_NUM_VALUE ,
1352: 1

Line 1408: fnd_global.user_id ,

1404: REPORTING_CODE_ID ,
1405: NULL ,--EXCEPTION_CODE
1406: EFFECTIVE_FROM ,
1407: NULL ,--EFFECTIVE_TO
1408: fnd_global.user_id ,
1409: SYSDATE ,
1410: fnd_global.user_id ,
1411: SYSDATE ,
1412: fnd_global.conc_login_id ,

Line 1410: fnd_global.user_id ,

1406: EFFECTIVE_FROM ,
1407: NULL ,--EFFECTIVE_TO
1408: fnd_global.user_id ,
1409: SYSDATE ,
1410: fnd_global.user_id ,
1411: SYSDATE ,
1412: fnd_global.conc_login_id ,
1413: REPORTING_CODE_CHAR_VALUE,
1414: REPORTING_CODE_DATE_VALUE,

Line 1412: fnd_global.conc_login_id ,

1408: fnd_global.user_id ,
1409: SYSDATE ,
1410: fnd_global.user_id ,
1411: SYSDATE ,
1412: fnd_global.conc_login_id ,
1413: REPORTING_CODE_CHAR_VALUE,
1414: REPORTING_CODE_DATE_VALUE,
1415: REPORTING_CODE_NUM_VALUE,
1416: 1

Line 1830: fnd_global.user_id,

1826: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1827: codes.REPORTING_CODE_CHAR_VALUE, -- Bug 14528148
1828: codes.REPORTING_CODE_DATE_VALUE, -- Bug 14528148
1829: codes.REPORTING_CODE_NUM_VALUE, -- Bug 14528148
1830: fnd_global.user_id,
1831: sysdate,
1832: fnd_global.user_id,
1833: sysdate,
1834: fnd_global.conc_login_id,

Line 1832: fnd_global.user_id,

1828: codes.REPORTING_CODE_DATE_VALUE, -- Bug 14528148
1829: codes.REPORTING_CODE_NUM_VALUE, -- Bug 14528148
1830: fnd_global.user_id,
1831: sysdate,
1832: fnd_global.user_id,
1833: sysdate,
1834: fnd_global.conc_login_id,
1835: 1 -- Bug 5031787
1836: FROM

Line 1834: fnd_global.conc_login_id,

1830: fnd_global.user_id,
1831: sysdate,
1832: fnd_global.user_id,
1833: sysdate,
1834: fnd_global.conc_login_id,
1835: 1 -- Bug 5031787
1836: FROM
1837: financials_system_params_all fin_sys_param,
1838: zx_reporting_types_b types,

Line 1886: fnd_global.user_id,

1882: codes.EFFECTIVE_TO, --EFFECTIVE_TO
1883: codes.REPORTING_CODE_CHAR_VALUE, -- Bug 14528148
1884: codes.REPORTING_CODE_DATE_VALUE, -- Bug 14528148
1885: codes.REPORTING_CODE_NUM_VALUE, -- Bug 14528148
1886: fnd_global.user_id,
1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.conc_login_id,

Line 1888: fnd_global.user_id,

1884: codes.REPORTING_CODE_DATE_VALUE, -- Bug 14528148
1885: codes.REPORTING_CODE_NUM_VALUE, -- Bug 14528148
1886: fnd_global.user_id,
1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.conc_login_id,
1891: 1 -- Bug 5031787
1892: FROM

Line 1890: fnd_global.conc_login_id,

1886: fnd_global.user_id,
1887: sysdate,
1888: fnd_global.user_id,
1889: sysdate,
1890: fnd_global.conc_login_id,
1891: 1 -- Bug 5031787
1892: FROM
1893: financials_system_params_all fin_sys_param,
1894: zx_reporting_types_b types,

Line 1946: fnd_global.user_id ,

1942: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
1943: NULL ,--EXCEPTION_CODE
1944: rates.EFFECTIVE_FROM ,
1945: NULL ,--EFFECTIVE_TO
1946: fnd_global.user_id ,
1947: SYSDATE ,
1948: fnd_global.user_id ,
1949: SYSDATE ,
1950: fnd_global.conc_login_id ,

Line 1948: fnd_global.user_id ,

1944: rates.EFFECTIVE_FROM ,
1945: NULL ,--EFFECTIVE_TO
1946: fnd_global.user_id ,
1947: SYSDATE ,
1948: fnd_global.user_id ,
1949: SYSDATE ,
1950: fnd_global.conc_login_id ,
1951: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
1952: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 1950: fnd_global.conc_login_id ,

1946: fnd_global.user_id ,
1947: SYSDATE ,
1948: fnd_global.user_id ,
1949: SYSDATE ,
1950: fnd_global.conc_login_id ,
1951: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
1952: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
1953: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
1954: 1

Line 2025: fnd_global.user_id ,

2021: REPORTING_CODE_ID ,
2022: NULL ,--EXCEPTION_CODE
2023: EFFECTIVE_FROM ,
2024: NULL ,--EFFECTIVE_TO
2025: fnd_global.user_id ,
2026: SYSDATE ,
2027: fnd_global.user_id ,
2028: SYSDATE ,
2029: fnd_global.conc_login_id ,

Line 2027: fnd_global.user_id ,

2023: EFFECTIVE_FROM ,
2024: NULL ,--EFFECTIVE_TO
2025: fnd_global.user_id ,
2026: SYSDATE ,
2027: fnd_global.user_id ,
2028: SYSDATE ,
2029: fnd_global.conc_login_id ,
2030: REPORTING_CODE_CHAR_VALUE,
2031: REPORTING_CODE_DATE_VALUE,

Line 2029: fnd_global.conc_login_id ,

2025: fnd_global.user_id ,
2026: SYSDATE ,
2027: fnd_global.user_id ,
2028: SYSDATE ,
2029: fnd_global.conc_login_id ,
2030: REPORTING_CODE_CHAR_VALUE,
2031: REPORTING_CODE_DATE_VALUE,
2032: REPORTING_CODE_NUM_VALUE,
2033: 1

Line 2712: fnd_global.user_id ,

2708: NULL ,--REPORTING_CODE_ID
2709: NULL ,--EXCEPTION_CODE
2710: EFFECTIVE_FROM ,
2711: NULL ,--EFFECTIVE_TO
2712: fnd_global.user_id ,
2713: SYSDATE ,
2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.conc_login_id ,

Line 2714: fnd_global.user_id ,

2710: EFFECTIVE_FROM ,
2711: NULL ,--EFFECTIVE_TO
2712: fnd_global.user_id ,
2713: SYSDATE ,
2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.conc_login_id ,
2717: REPORTING_CODE_CHAR_VALUE ,
2718: NULL,

Line 2716: fnd_global.conc_login_id ,

2712: fnd_global.user_id ,
2713: SYSDATE ,
2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.conc_login_id ,
2717: REPORTING_CODE_CHAR_VALUE ,
2718: NULL,
2719: NULL,
2720: 1

Line 2894: fnd_global.user_id ,

2890: NULL ,--REPORTING_CODE_NUM_VALUE
2891: NULL ,--EXCEPTION_CODE
2892: EFFECTIVE_FROM ,
2893: NULL ,--EFFECTIVE_TO
2894: fnd_global.user_id ,
2895: SYSDATE ,
2896: fnd_global.user_id ,
2897: SYSDATE ,
2898: fnd_global.conc_login_id ,

Line 2896: fnd_global.user_id ,

2892: EFFECTIVE_FROM ,
2893: NULL ,--EFFECTIVE_TO
2894: fnd_global.user_id ,
2895: SYSDATE ,
2896: fnd_global.user_id ,
2897: SYSDATE ,
2898: fnd_global.conc_login_id ,
2899: 1
2900: FROM

Line 2898: fnd_global.conc_login_id ,

2894: fnd_global.user_id ,
2895: SYSDATE ,
2896: fnd_global.user_id ,
2897: SYSDATE ,
2898: fnd_global.conc_login_id ,
2899: 1
2900: FROM
2901: (
2902: SELECT rates.TAX_RATE_ID TAX_RATE_ID,

Line 2987: fnd_global.user_id ,

2983: effective_from ,
2984: NULL ,--EFFECTIVE_TO
2985: 'MIGRATED' ,--RECORD_TYPE_CODE
2986: 'Y' ,
2987: fnd_global.user_id ,
2988: SYSDATE ,
2989: fnd_global.user_id ,
2990: SYSDATE ,
2991: fnd_global.conc_login_id ,

Line 2989: fnd_global.user_id ,

2985: 'MIGRATED' ,--RECORD_TYPE_CODE
2986: 'Y' ,
2987: fnd_global.user_id ,
2988: SYSDATE ,
2989: fnd_global.user_id ,
2990: SYSDATE ,
2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID

Line 2991: fnd_global.conc_login_id ,

2987: fnd_global.user_id ,
2988: SYSDATE ,
2989: fnd_global.user_id ,
2990: SYSDATE ,
2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID
2994: fnd_global.conc_program_id , -- Program Id
2995: fnd_global.conc_login_id , -- Program Login ID

Line 2992: fnd_global.conc_request_id , -- Request Id

2988: SYSDATE ,
2989: fnd_global.user_id ,
2990: SYSDATE ,
2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID
2994: fnd_global.conc_program_id , -- Program Id
2995: fnd_global.conc_login_id , -- Program Login ID
2996: 1

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

2989: fnd_global.user_id ,
2990: SYSDATE ,
2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID
2994: fnd_global.conc_program_id , -- Program Id
2995: fnd_global.conc_login_id , -- Program Login ID
2996: 1
2997: )

Line 2994: fnd_global.conc_program_id , -- Program Id

2990: SYSDATE ,
2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID
2994: fnd_global.conc_program_id , -- Program Id
2995: fnd_global.conc_login_id , -- Program Login ID
2996: 1
2997: )
2998: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

2991: fnd_global.conc_login_id ,
2992: fnd_global.conc_request_id , -- Request Id
2993: fnd_global.prog_appl_id , -- Program Application ID
2994: fnd_global.conc_program_id , -- Program Id
2995: fnd_global.conc_login_id , -- Program Login ID
2996: 1
2997: )
2998: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
2999: where reporting_type_code='PT_PRD_TAXABLE_BOX'

Line 3042: fnd_global.user_id ,

3038: effective_from ,
3039: NULL ,--EFFECTIVE_TO
3040: 'MIGRATED' ,--RECORD_TYPE_CODE
3041: 'N' ,
3042: fnd_global.user_id ,
3043: SYSDATE ,
3044: fnd_global.user_id ,
3045: SYSDATE ,
3046: fnd_global.conc_login_id ,

Line 3044: fnd_global.user_id ,

3040: 'MIGRATED' ,--RECORD_TYPE_CODE
3041: 'N' ,
3042: fnd_global.user_id ,
3043: SYSDATE ,
3044: fnd_global.user_id ,
3045: SYSDATE ,
3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID

Line 3046: fnd_global.conc_login_id ,

3042: fnd_global.user_id ,
3043: SYSDATE ,
3044: fnd_global.user_id ,
3045: SYSDATE ,
3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID
3049: fnd_global.conc_program_id , -- Program Id
3050: fnd_global.conc_login_id ,-- Program Login ID

Line 3047: fnd_global.conc_request_id , -- Request Id

3043: SYSDATE ,
3044: fnd_global.user_id ,
3045: SYSDATE ,
3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID
3049: fnd_global.conc_program_id , -- Program Id
3050: fnd_global.conc_login_id ,-- Program Login ID
3051: 1

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

3044: fnd_global.user_id ,
3045: SYSDATE ,
3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID
3049: fnd_global.conc_program_id , -- Program Id
3050: fnd_global.conc_login_id ,-- Program Login ID
3051: 1
3052: )

Line 3049: fnd_global.conc_program_id , -- Program Id

3045: SYSDATE ,
3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID
3049: fnd_global.conc_program_id , -- Program Id
3050: fnd_global.conc_login_id ,-- Program Login ID
3051: 1
3052: )
3053: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3046: fnd_global.conc_login_id ,
3047: fnd_global.conc_request_id , -- Request Id
3048: fnd_global.prog_appl_id , -- Program Application ID
3049: fnd_global.conc_program_id , -- Program Id
3050: fnd_global.conc_login_id ,-- Program Login ID
3051: 1
3052: )
3053: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3054: where reporting_type_code='PT_PRD_REC_TAX_BOX'

Line 3097: fnd_global.user_id ,

3093: effective_from ,
3094: NULL ,--EFFECTIVE_TO
3095: 'MIGRATED' ,--RECORD_TYPE_CODE
3096: 'N' ,
3097: fnd_global.user_id ,
3098: SYSDATE ,
3099: fnd_global.user_id ,
3100: SYSDATE ,
3101: fnd_global.conc_login_id ,

Line 3099: fnd_global.user_id ,

3095: 'MIGRATED' ,--RECORD_TYPE_CODE
3096: 'N' ,
3097: fnd_global.user_id ,
3098: SYSDATE ,
3099: fnd_global.user_id ,
3100: SYSDATE ,
3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID

Line 3101: fnd_global.conc_login_id ,

3097: fnd_global.user_id ,
3098: SYSDATE ,
3099: fnd_global.user_id ,
3100: SYSDATE ,
3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID
3104: fnd_global.conc_program_id , -- Program Id
3105: fnd_global.conc_login_id , -- Program Login ID

Line 3102: fnd_global.conc_request_id , -- Request Id

3098: SYSDATE ,
3099: fnd_global.user_id ,
3100: SYSDATE ,
3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID
3104: fnd_global.conc_program_id , -- Program Id
3105: fnd_global.conc_login_id , -- Program Login ID
3106: 1

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

3099: fnd_global.user_id ,
3100: SYSDATE ,
3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID
3104: fnd_global.conc_program_id , -- Program Id
3105: fnd_global.conc_login_id , -- Program Login ID
3106: 1
3107: )

Line 3104: fnd_global.conc_program_id , -- Program Id

3100: SYSDATE ,
3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID
3104: fnd_global.conc_program_id , -- Program Id
3105: fnd_global.conc_login_id , -- Program Login ID
3106: 1
3107: )
3108: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3101: fnd_global.conc_login_id ,
3102: fnd_global.conc_request_id , -- Request Id
3103: fnd_global.prog_appl_id , -- Program Application ID
3104: fnd_global.conc_program_id , -- Program Id
3105: fnd_global.conc_login_id , -- Program Login ID
3106: 1
3107: )
3108: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3109: where reporting_type_code='PT_ANL_TTL_TAXABLE_BOX'

Line 3152: fnd_global.user_id ,

3148: effective_from ,
3149: NULL ,--EFFECTIVE_TO
3150: 'MIGRATED' ,--RECORD_TYPE_CODE
3151: 'N' ,
3152: fnd_global.user_id ,
3153: SYSDATE ,
3154: fnd_global.user_id ,
3155: SYSDATE ,
3156: fnd_global.conc_login_id ,

Line 3154: fnd_global.user_id ,

3150: 'MIGRATED' ,--RECORD_TYPE_CODE
3151: 'N' ,
3152: fnd_global.user_id ,
3153: SYSDATE ,
3154: fnd_global.user_id ,
3155: SYSDATE ,
3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID

Line 3156: fnd_global.conc_login_id ,

3152: fnd_global.user_id ,
3153: SYSDATE ,
3154: fnd_global.user_id ,
3155: SYSDATE ,
3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID
3159: fnd_global.conc_program_id , -- Program Id
3160: fnd_global.conc_login_id , -- Program Login ID

Line 3157: fnd_global.conc_request_id , -- Request Id

3153: SYSDATE ,
3154: fnd_global.user_id ,
3155: SYSDATE ,
3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID
3159: fnd_global.conc_program_id , -- Program Id
3160: fnd_global.conc_login_id , -- Program Login ID
3161: 1

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

3154: fnd_global.user_id ,
3155: SYSDATE ,
3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID
3159: fnd_global.conc_program_id , -- Program Id
3160: fnd_global.conc_login_id , -- Program Login ID
3161: 1
3162: )

Line 3159: fnd_global.conc_program_id , -- Program Id

3155: SYSDATE ,
3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID
3159: fnd_global.conc_program_id , -- Program Id
3160: fnd_global.conc_login_id , -- Program Login ID
3161: 1
3162: )
3163: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3156: fnd_global.conc_login_id ,
3157: fnd_global.conc_request_id , -- Request Id
3158: fnd_global.prog_appl_id , -- Program Application ID
3159: fnd_global.conc_program_id , -- Program Id
3160: fnd_global.conc_login_id , -- Program Login ID
3161: 1
3162: )
3163: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3164: where reporting_type_code='PT_ANL_REC_TAXABLE'

Line 3207: fnd_global.user_id ,

3203: effective_from ,
3204: NULL ,--EFFECTIVE_TO
3205: 'MIGRATED' ,--RECORD_TYPE_CODE
3206: 'N' ,
3207: fnd_global.user_id ,
3208: SYSDATE ,
3209: fnd_global.user_id ,
3210: SYSDATE ,
3211: fnd_global.conc_login_id ,

Line 3209: fnd_global.user_id ,

3205: 'MIGRATED' ,--RECORD_TYPE_CODE
3206: 'N' ,
3207: fnd_global.user_id ,
3208: SYSDATE ,
3209: fnd_global.user_id ,
3210: SYSDATE ,
3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID

Line 3211: fnd_global.conc_login_id ,

3207: fnd_global.user_id ,
3208: SYSDATE ,
3209: fnd_global.user_id ,
3210: SYSDATE ,
3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID
3214: fnd_global.conc_program_id , -- Program Id
3215: fnd_global.conc_login_id , -- Program Login ID

Line 3212: fnd_global.conc_request_id , -- Request Id

3208: SYSDATE ,
3209: fnd_global.user_id ,
3210: SYSDATE ,
3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID
3214: fnd_global.conc_program_id , -- Program Id
3215: fnd_global.conc_login_id , -- Program Login ID
3216: 1

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

3209: fnd_global.user_id ,
3210: SYSDATE ,
3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID
3214: fnd_global.conc_program_id , -- Program Id
3215: fnd_global.conc_login_id , -- Program Login ID
3216: 1
3217: )

Line 3214: fnd_global.conc_program_id , -- Program Id

3210: SYSDATE ,
3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID
3214: fnd_global.conc_program_id , -- Program Id
3215: fnd_global.conc_login_id , -- Program Login ID
3216: 1
3217: )
3218: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3211: fnd_global.conc_login_id ,
3212: fnd_global.conc_request_id , -- Request Id
3213: fnd_global.prog_appl_id , -- Program Application ID
3214: fnd_global.conc_program_id , -- Program Id
3215: fnd_global.conc_login_id , -- Program Login ID
3216: 1
3217: )
3218: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3219: where reporting_type_code='PT_ANL_NON_REC_TAXABLE'

Line 3262: fnd_global.user_id ,

3258: effective_from ,
3259: NULL ,--EFFECTIVE_TO
3260: 'MIGRATED' ,--RECORD_TYPE_CODE
3261: 'N' ,
3262: fnd_global.user_id ,
3263: SYSDATE ,
3264: fnd_global.user_id ,
3265: SYSDATE ,
3266: fnd_global.conc_login_id ,

Line 3264: fnd_global.user_id ,

3260: 'MIGRATED' ,--RECORD_TYPE_CODE
3261: 'N' ,
3262: fnd_global.user_id ,
3263: SYSDATE ,
3264: fnd_global.user_id ,
3265: SYSDATE ,
3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID

Line 3266: fnd_global.conc_login_id ,

3262: fnd_global.user_id ,
3263: SYSDATE ,
3264: fnd_global.user_id ,
3265: SYSDATE ,
3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID
3269: fnd_global.conc_program_id , -- Program Id
3270: fnd_global.conc_login_id , -- Program Login ID

Line 3267: fnd_global.conc_request_id , -- Request Id

3263: SYSDATE ,
3264: fnd_global.user_id ,
3265: SYSDATE ,
3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID
3269: fnd_global.conc_program_id , -- Program Id
3270: fnd_global.conc_login_id , -- Program Login ID
3271: 1

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

3264: fnd_global.user_id ,
3265: SYSDATE ,
3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID
3269: fnd_global.conc_program_id , -- Program Id
3270: fnd_global.conc_login_id , -- Program Login ID
3271: 1
3272: )

Line 3269: fnd_global.conc_program_id , -- Program Id

3265: SYSDATE ,
3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID
3269: fnd_global.conc_program_id , -- Program Id
3270: fnd_global.conc_login_id , -- Program Login ID
3271: 1
3272: )
3273: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

3266: fnd_global.conc_login_id ,
3267: fnd_global.conc_request_id , -- Request Id
3268: fnd_global.prog_appl_id , -- Program Application ID
3269: fnd_global.conc_program_id , -- Program Id
3270: fnd_global.conc_login_id , -- Program Login ID
3271: 1
3272: )
3273: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
3274: where reporting_type_code='PT_ANL_REC_TAX_BOX'

Line 3317: fnd_global.user_id ,

3313: effective_from ,
3314: NULL ,--EFFECTIVE_TO
3315: 'MIGRATED' ,--RECORD_TYPE_CODE
3316: 'N' ,
3317: fnd_global.user_id ,
3318: SYSDATE ,
3319: fnd_global.user_id ,
3320: SYSDATE ,
3321: fnd_global.conc_login_id ,

Line 3319: fnd_global.user_id ,

3315: 'MIGRATED' ,--RECORD_TYPE_CODE
3316: 'N' ,
3317: fnd_global.user_id ,
3318: SYSDATE ,
3319: fnd_global.user_id ,
3320: SYSDATE ,
3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID

Line 3321: fnd_global.conc_login_id ,

3317: fnd_global.user_id ,
3318: SYSDATE ,
3319: fnd_global.user_id ,
3320: SYSDATE ,
3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID
3324: fnd_global.conc_program_id , -- Program Id
3325: fnd_global.conc_login_id , -- Program Login ID

Line 3322: fnd_global.conc_request_id , -- Request Id

3318: SYSDATE ,
3319: fnd_global.user_id ,
3320: SYSDATE ,
3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID
3324: fnd_global.conc_program_id , -- Program Id
3325: fnd_global.conc_login_id , -- Program Login ID
3326: 1

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

3319: fnd_global.user_id ,
3320: SYSDATE ,
3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID
3324: fnd_global.conc_program_id , -- Program Id
3325: fnd_global.conc_login_id , -- Program Login ID
3326: 1
3327: )

Line 3324: fnd_global.conc_program_id , -- Program Id

3320: SYSDATE ,
3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID
3324: fnd_global.conc_program_id , -- Program Id
3325: fnd_global.conc_login_id , -- Program Login ID
3326: 1
3327: )
3328: SELECT

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

3321: fnd_global.conc_login_id ,
3322: fnd_global.conc_request_id , -- Request Id
3323: fnd_global.prog_appl_id , -- Program Application ID
3324: fnd_global.conc_program_id , -- Program Id
3325: fnd_global.conc_login_id , -- Program Login ID
3326: 1
3327: )
3328: SELECT
3329: min(zx_rates.effective_from) effective_from,

Line 3392: fnd_global.user_id ,

3388: effective_from ,
3389: NULL ,--EFFECTIVE_TO
3390: 'MIGRATED' ,--RECORD_TYPE_CODE
3391: 'Y' ,
3392: fnd_global.user_id ,
3393: SYSDATE ,
3394: fnd_global.user_id ,
3395: SYSDATE ,
3396: fnd_global.conc_login_id ,

Line 3394: fnd_global.user_id ,

3390: 'MIGRATED' ,--RECORD_TYPE_CODE
3391: 'Y' ,
3392: fnd_global.user_id ,
3393: SYSDATE ,
3394: fnd_global.user_id ,
3395: SYSDATE ,
3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID

Line 3396: fnd_global.conc_login_id ,

3392: fnd_global.user_id ,
3393: SYSDATE ,
3394: fnd_global.user_id ,
3395: SYSDATE ,
3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID
3399: fnd_global.conc_program_id , -- Program Id
3400: fnd_global.conc_login_id , -- Program Login ID

Line 3397: fnd_global.conc_request_id , -- Request Id

3393: SYSDATE ,
3394: fnd_global.user_id ,
3395: SYSDATE ,
3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID
3399: fnd_global.conc_program_id , -- Program Id
3400: fnd_global.conc_login_id , -- Program Login ID
3401: 1

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

3394: fnd_global.user_id ,
3395: SYSDATE ,
3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID
3399: fnd_global.conc_program_id , -- Program Id
3400: fnd_global.conc_login_id , -- Program Login ID
3401: 1
3402: )

Line 3399: fnd_global.conc_program_id , -- Program Id

3395: SYSDATE ,
3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID
3399: fnd_global.conc_program_id , -- Program Id
3400: fnd_global.conc_login_id , -- Program Login ID
3401: 1
3402: )
3403: SELECT

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

3396: fnd_global.conc_login_id ,
3397: fnd_global.conc_request_id , -- Request Id
3398: fnd_global.prog_appl_id , -- Program Application ID
3399: fnd_global.conc_program_id , -- Program Id
3400: fnd_global.conc_login_id , -- Program Login ID
3401: 1
3402: )
3403: SELECT
3404: min(zx_rates.effective_from) effective_from,

Line 3467: fnd_global.user_id ,

3463: effective_from ,
3464: NULL ,--EFFECTIVE_TO
3465: 'MIGRATED' ,--RECORD_TYPE_CODE
3466: 'Y' ,
3467: fnd_global.user_id ,
3468: SYSDATE ,
3469: fnd_global.user_id ,
3470: SYSDATE ,
3471: fnd_global.conc_login_id ,

Line 3469: fnd_global.user_id ,

3465: 'MIGRATED' ,--RECORD_TYPE_CODE
3466: 'Y' ,
3467: fnd_global.user_id ,
3468: SYSDATE ,
3469: fnd_global.user_id ,
3470: SYSDATE ,
3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID

Line 3471: fnd_global.conc_login_id ,

3467: fnd_global.user_id ,
3468: SYSDATE ,
3469: fnd_global.user_id ,
3470: SYSDATE ,
3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID
3474: fnd_global.conc_program_id , -- Program Id
3475: fnd_global.conc_login_id , -- Program Login ID

Line 3472: fnd_global.conc_request_id , -- Request Id

3468: SYSDATE ,
3469: fnd_global.user_id ,
3470: SYSDATE ,
3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID
3474: fnd_global.conc_program_id , -- Program Id
3475: fnd_global.conc_login_id , -- Program Login ID
3476: 1

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

3469: fnd_global.user_id ,
3470: SYSDATE ,
3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID
3474: fnd_global.conc_program_id , -- Program Id
3475: fnd_global.conc_login_id , -- Program Login ID
3476: 1
3477: )

Line 3474: fnd_global.conc_program_id , -- Program Id

3470: SYSDATE ,
3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID
3474: fnd_global.conc_program_id , -- Program Id
3475: fnd_global.conc_login_id , -- Program Login ID
3476: 1
3477: )
3478: SELECT

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

3471: fnd_global.conc_login_id ,
3472: fnd_global.conc_request_id , -- Request Id
3473: fnd_global.prog_appl_id , -- Program Application ID
3474: fnd_global.conc_program_id , -- Program Id
3475: fnd_global.conc_login_id , -- Program Login ID
3476: 1
3477: )
3478: SELECT
3479: min(zx_rates.effective_from) effective_from,

Line 3539: fnd_global.user_id ,

3535: NULL ,--EXCEPTION_CODE
3536: EFFECTIVE_FROM ,
3537: NULL ,--EFFECTIVE_TO
3538: 'MIGRATED' ,--RECORD_TYPE_CODE
3539: fnd_global.user_id ,
3540: SYSDATE ,
3541: fnd_global.user_id ,
3542: SYSDATE ,
3543: fnd_global.conc_login_id ,

Line 3541: fnd_global.user_id ,

3537: NULL ,--EFFECTIVE_TO
3538: 'MIGRATED' ,--RECORD_TYPE_CODE
3539: fnd_global.user_id ,
3540: SYSDATE ,
3541: fnd_global.user_id ,
3542: SYSDATE ,
3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID

Line 3543: fnd_global.conc_login_id ,

3539: fnd_global.user_id ,
3540: SYSDATE ,
3541: fnd_global.user_id ,
3542: SYSDATE ,
3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID
3546: fnd_global.conc_program_id , -- Program Id
3547: fnd_global.conc_login_id , -- Program Login ID

Line 3544: fnd_global.conc_request_id , -- Request Id

3540: SYSDATE ,
3541: fnd_global.user_id ,
3542: SYSDATE ,
3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID
3546: fnd_global.conc_program_id , -- Program Id
3547: fnd_global.conc_login_id , -- Program Login ID
3548: REPORTING_CODE,

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

3541: fnd_global.user_id ,
3542: SYSDATE ,
3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID
3546: fnd_global.conc_program_id , -- Program Id
3547: fnd_global.conc_login_id , -- Program Login ID
3548: REPORTING_CODE,
3549: REPORTING_TYPE_ID,

Line 3546: fnd_global.conc_program_id , -- Program Id

3542: SYSDATE ,
3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID
3546: fnd_global.conc_program_id , -- Program Id
3547: fnd_global.conc_login_id , -- Program Login ID
3548: REPORTING_CODE,
3549: REPORTING_TYPE_ID,
3550: 1

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

3543: fnd_global.conc_login_id ,
3544: fnd_global.conc_request_id , -- Request Id
3545: fnd_global.prog_appl_id , -- Program Application ID
3546: fnd_global.conc_program_id , -- Program Id
3547: fnd_global.conc_login_id , -- Program Login ID
3548: REPORTING_CODE,
3549: REPORTING_TYPE_ID,
3550: 1
3551:

Line 3611: fnd_global.user_id ,

3607: NULL ,--EXCEPTION_CODE
3608: EFFECTIVE_FROM ,
3609: NULL ,--EFFECTIVE_TO
3610: 'MIGRATED' ,--RECORD_TYPE_CODE
3611: fnd_global.user_id ,
3612: SYSDATE ,
3613: fnd_global.user_id ,
3614: SYSDATE ,
3615: fnd_global.conc_login_id ,

Line 3613: fnd_global.user_id ,

3609: NULL ,--EFFECTIVE_TO
3610: 'MIGRATED' ,--RECORD_TYPE_CODE
3611: fnd_global.user_id ,
3612: SYSDATE ,
3613: fnd_global.user_id ,
3614: SYSDATE ,
3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID

Line 3615: fnd_global.conc_login_id ,

3611: fnd_global.user_id ,
3612: SYSDATE ,
3613: fnd_global.user_id ,
3614: SYSDATE ,
3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID
3618: fnd_global.conc_program_id , -- Program Id
3619: fnd_global.conc_login_id , -- Program Login ID

Line 3616: fnd_global.conc_request_id , -- Request Id

3612: SYSDATE ,
3613: fnd_global.user_id ,
3614: SYSDATE ,
3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID
3618: fnd_global.conc_program_id , -- Program Id
3619: fnd_global.conc_login_id , -- Program Login ID
3620: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

3613: fnd_global.user_id ,
3614: SYSDATE ,
3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID
3618: fnd_global.conc_program_id , -- Program Id
3619: fnd_global.conc_login_id , -- Program Login ID
3620: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3621: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 3618: fnd_global.conc_program_id , -- Program Id

3614: SYSDATE ,
3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID
3618: fnd_global.conc_program_id , -- Program Id
3619: fnd_global.conc_login_id , -- Program Login ID
3620: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3621: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
3622: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

3615: fnd_global.conc_login_id ,
3616: fnd_global.conc_request_id , -- Request Id
3617: fnd_global.prog_appl_id , -- Program Application ID
3618: fnd_global.conc_program_id , -- Program Id
3619: fnd_global.conc_login_id , -- Program Login ID
3620: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
3621: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
3622: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
3623: REPORTING_TYPE_ID,

Line 3684: fnd_global.user_id ,

3680: NULL ,--EXCEPTION_CODE
3681: effective_from ,
3682: NULL ,--EFFECTIVE_TO
3683: 'MIGRATED' ,--RECORD_TYPE_CODE
3684: fnd_global.user_id ,
3685: SYSDATE ,
3686: fnd_global.user_id ,
3687: SYSDATE ,
3688: fnd_global.conc_login_id ,

Line 3686: fnd_global.user_id ,

3682: NULL ,--EFFECTIVE_TO
3683: 'MIGRATED' ,--RECORD_TYPE_CODE
3684: fnd_global.user_id ,
3685: SYSDATE ,
3686: fnd_global.user_id ,
3687: SYSDATE ,
3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID

Line 3688: fnd_global.conc_login_id ,

3684: fnd_global.user_id ,
3685: SYSDATE ,
3686: fnd_global.user_id ,
3687: SYSDATE ,
3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID
3691: fnd_global.conc_program_id , -- Program Id
3692: fnd_global.conc_login_id , -- Program Login ID

Line 3689: fnd_global.conc_request_id , -- Request

3685: SYSDATE ,
3686: fnd_global.user_id ,
3687: SYSDATE ,
3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID
3691: fnd_global.conc_program_id , -- Program Id
3692: fnd_global.conc_login_id , -- Program Login ID
3693: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),

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

3686: fnd_global.user_id ,
3687: SYSDATE ,
3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID
3691: fnd_global.conc_program_id , -- Program Id
3692: fnd_global.conc_login_id , -- Program Login ID
3693: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3694: decode(DATATYPE,'DATE',global_attribute,NULL),

Line 3691: fnd_global.conc_program_id , -- Program Id

3687: SYSDATE ,
3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID
3691: fnd_global.conc_program_id , -- Program Id
3692: fnd_global.conc_login_id , -- Program Login ID
3693: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3694: decode(DATATYPE,'DATE',global_attribute,NULL),
3695: decode(DATATYPE,'NUMERIC_VALUE',global_attribute,NULL),

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

3688: fnd_global.conc_login_id ,
3689: fnd_global.conc_request_id , -- Request
3690: fnd_global.prog_appl_id , -- Program Application ID
3691: fnd_global.conc_program_id , -- Program Id
3692: fnd_global.conc_login_id , -- Program Login ID
3693: decode(DATATYPE,'TEXT',global_attribute,'YES_NO',global_attribute,NULL),
3694: decode(DATATYPE,'DATE',global_attribute,NULL),
3695: decode(DATATYPE,'NUMERIC_VALUE',global_attribute,NULL),
3696: reporting_type_id,

Line 3906: fnd_global.user_id ,--CREATED_BY

3902: effective_from ,--EFFECTIVE_FROM
3903: NULL ,--EFFECTIVE_TO
3904: 'MIGRATED' ,--RECORD_TYPE_CODE
3905: 'Y' ,--HAS_REPORTING_CODES_FLAG
3906: fnd_global.user_id ,--CREATED_BY
3907: SYSDATE ,--CREATION_DATE
3908: fnd_global.user_id ,--LAST_UPDATED_BY
3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 3908: fnd_global.user_id ,--LAST_UPDATED_BY

3904: 'MIGRATED' ,--RECORD_TYPE_CODE
3905: 'Y' ,--HAS_REPORTING_CODES_FLAG
3906: fnd_global.user_id ,--CREATED_BY
3907: SYSDATE ,--CREATION_DATE
3908: fnd_global.user_id ,--LAST_UPDATED_BY
3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID

Line 3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

3906: fnd_global.user_id ,--CREATED_BY
3907: SYSDATE ,--CREATION_DATE
3908: fnd_global.user_id ,--LAST_UPDATED_BY
3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID
3913: fnd_global.conc_program_id , -- Program Id
3914: fnd_global.conc_login_id , -- Program Login ID

Line 3911: fnd_global.conc_request_id , -- Request Id

3907: SYSDATE ,--CREATION_DATE
3908: fnd_global.user_id ,--LAST_UPDATED_BY
3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID
3913: fnd_global.conc_program_id , -- Program Id
3914: fnd_global.conc_login_id , -- Program Login ID
3915: 1

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

3908: fnd_global.user_id ,--LAST_UPDATED_BY
3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID
3913: fnd_global.conc_program_id , -- Program Id
3914: fnd_global.conc_login_id , -- Program Login ID
3915: 1
3916: )

Line 3913: fnd_global.conc_program_id , -- Program Id

3909: SYSDATE ,--LAST_UPDATE_DATE
3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID
3913: fnd_global.conc_program_id , -- Program Id
3914: fnd_global.conc_login_id , -- Program Login ID
3915: 1
3916: )
3917: SELECT

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

3910: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
3911: fnd_global.conc_request_id , -- Request Id
3912: fnd_global.prog_appl_id , -- Program Application ID
3913: fnd_global.conc_program_id , -- Program Id
3914: fnd_global.conc_login_id , -- Program Login ID
3915: 1
3916: )
3917: SELECT
3918: min(zx_rates.effective_from) effective_from,

Line 3965: FND_GLOBAL.USER_ID,

3961: NULL,
3962: l_start_date,
3963: NULL,
3964: 'MIGRATED',
3965: FND_GLOBAL.USER_ID,
3966: SYSDATE,
3967: FND_GLOBAL.USER_ID,
3968: SYSDATE,
3969: fnd_global.conc_login_id ,

Line 3967: FND_GLOBAL.USER_ID,

3963: NULL,
3964: 'MIGRATED',
3965: FND_GLOBAL.USER_ID,
3966: SYSDATE,
3967: FND_GLOBAL.USER_ID,
3968: SYSDATE,
3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID

Line 3969: fnd_global.conc_login_id ,

3965: FND_GLOBAL.USER_ID,
3966: SYSDATE,
3967: FND_GLOBAL.USER_ID,
3968: SYSDATE,
3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID
3972: fnd_global.conc_program_id , -- Program Id
3973: fnd_global.conc_login_id , -- Program Login ID

Line 3970: fnd_global.conc_request_id , -- Request Id

3966: SYSDATE,
3967: FND_GLOBAL.USER_ID,
3968: SYSDATE,
3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID
3972: fnd_global.conc_program_id , -- Program Id
3973: fnd_global.conc_login_id , -- Program Login ID
3974: l_location_code,

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

3967: FND_GLOBAL.USER_ID,
3968: SYSDATE,
3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID
3972: fnd_global.conc_program_id , -- Program Id
3973: fnd_global.conc_login_id , -- Program Login ID
3974: l_location_code,
3975: NULL,

Line 3972: fnd_global.conc_program_id , -- Program Id

3968: SYSDATE,
3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID
3972: fnd_global.conc_program_id , -- Program Id
3973: fnd_global.conc_login_id , -- Program Login ID
3974: l_location_code,
3975: NULL,
3976: NULL,

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

3969: fnd_global.conc_login_id ,
3970: fnd_global.conc_request_id , -- Request Id
3971: fnd_global.prog_appl_id , -- Program Application ID
3972: fnd_global.conc_program_id , -- Program Id
3973: fnd_global.conc_login_id , -- Program Login ID
3974: l_location_code,
3975: NULL,
3976: NULL,
3977: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 4038: fnd_global.user_id ,

4034: REPORTING_CODE_ID ,
4035: NULL ,--EXCEPTION_CODE
4036: EFFECTIVE_FROM ,
4037: NULL ,--EFFECTIVE_TO
4038: fnd_global.user_id ,
4039: SYSDATE ,
4040: fnd_global.user_id ,
4041: SYSDATE ,
4042: fnd_global.conc_login_id ,

Line 4040: fnd_global.user_id ,

4036: EFFECTIVE_FROM ,
4037: NULL ,--EFFECTIVE_TO
4038: fnd_global.user_id ,
4039: SYSDATE ,
4040: fnd_global.user_id ,
4041: SYSDATE ,
4042: fnd_global.conc_login_id ,
4043: REPORTING_CODE_CHAR_VALUE,
4044: REPORTING_CODE_DATE_VALUE,

Line 4042: fnd_global.conc_login_id ,

4038: fnd_global.user_id ,
4039: SYSDATE ,
4040: fnd_global.user_id ,
4041: SYSDATE ,
4042: fnd_global.conc_login_id ,
4043: REPORTING_CODE_CHAR_VALUE,
4044: REPORTING_CODE_DATE_VALUE,
4045: REPORTING_CODE_NUM_VALUE,
4046: 1

Line 4174: fnd_global.user_id ,

4170: effective_from ,
4171: NULL ,--EFFECTIVE_TO
4172: 'MIGRATED' ,--RECORD_TYPE_CODE
4173: 'Y' ,
4174: fnd_global.user_id ,
4175: SYSDATE ,
4176: fnd_global.user_id ,
4177: SYSDATE ,
4178: fnd_global.conc_login_id ,

Line 4176: fnd_global.user_id ,

4172: 'MIGRATED' ,--RECORD_TYPE_CODE
4173: 'Y' ,
4174: fnd_global.user_id ,
4175: SYSDATE ,
4176: fnd_global.user_id ,
4177: SYSDATE ,
4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID

Line 4178: fnd_global.conc_login_id ,

4174: fnd_global.user_id ,
4175: SYSDATE ,
4176: fnd_global.user_id ,
4177: SYSDATE ,
4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID
4181: fnd_global.conc_program_id , -- Program Id
4182: fnd_global.conc_login_id , -- Program Login ID

Line 4179: fnd_global.conc_request_id , -- Request Id

4175: SYSDATE ,
4176: fnd_global.user_id ,
4177: SYSDATE ,
4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID
4181: fnd_global.conc_program_id , -- Program Id
4182: fnd_global.conc_login_id , -- Program Login ID
4183: 1

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

4176: fnd_global.user_id ,
4177: SYSDATE ,
4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID
4181: fnd_global.conc_program_id , -- Program Id
4182: fnd_global.conc_login_id , -- Program Login ID
4183: 1
4184: )

Line 4181: fnd_global.conc_program_id , -- Program Id

4177: SYSDATE ,
4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID
4181: fnd_global.conc_program_id , -- Program Id
4182: fnd_global.conc_login_id , -- Program Login ID
4183: 1
4184: )
4185: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4178: fnd_global.conc_login_id ,
4179: fnd_global.conc_request_id , -- Request Id
4180: fnd_global.prog_appl_id , -- Program Application ID
4181: fnd_global.conc_program_id , -- Program Id
4182: fnd_global.conc_login_id , -- Program Login ID
4183: 1
4184: )
4185: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4186: where reporting_type_code='PT_PRD_TAXABLE_BOX'

Line 4229: fnd_global.user_id ,

4225: effective_from ,
4226: NULL ,--EFFECTIVE_TO
4227: 'MIGRATED' ,--RECORD_TYPE_CODE
4228: 'N' ,
4229: fnd_global.user_id ,
4230: SYSDATE ,
4231: fnd_global.user_id ,
4232: SYSDATE ,
4233: fnd_global.conc_login_id ,

Line 4231: fnd_global.user_id ,

4227: 'MIGRATED' ,--RECORD_TYPE_CODE
4228: 'N' ,
4229: fnd_global.user_id ,
4230: SYSDATE ,
4231: fnd_global.user_id ,
4232: SYSDATE ,
4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID

Line 4233: fnd_global.conc_login_id ,

4229: fnd_global.user_id ,
4230: SYSDATE ,
4231: fnd_global.user_id ,
4232: SYSDATE ,
4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID
4236: fnd_global.conc_program_id , -- Program Id
4237: fnd_global.conc_login_id , -- Program Login ID

Line 4234: fnd_global.conc_request_id , -- Request Id

4230: SYSDATE ,
4231: fnd_global.user_id ,
4232: SYSDATE ,
4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID
4236: fnd_global.conc_program_id , -- Program Id
4237: fnd_global.conc_login_id , -- Program Login ID
4238: 1

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

4231: fnd_global.user_id ,
4232: SYSDATE ,
4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID
4236: fnd_global.conc_program_id , -- Program Id
4237: fnd_global.conc_login_id , -- Program Login ID
4238: 1
4239: )

Line 4236: fnd_global.conc_program_id , -- Program Id

4232: SYSDATE ,
4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID
4236: fnd_global.conc_program_id , -- Program Id
4237: fnd_global.conc_login_id , -- Program Login ID
4238: 1
4239: )
4240: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4233: fnd_global.conc_login_id ,
4234: fnd_global.conc_request_id , -- Request Id
4235: fnd_global.prog_appl_id , -- Program Application ID
4236: fnd_global.conc_program_id , -- Program Id
4237: fnd_global.conc_login_id , -- Program Login ID
4238: 1
4239: )
4240: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4241: where reporting_type_code='PT_PRD_REC_TAX_BOX'

Line 4284: fnd_global.user_id ,

4280: effective_from ,
4281: NULL ,--EFFECTIVE_TO
4282: 'MIGRATED' ,--RECORD_TYPE_CODE
4283: 'N' ,
4284: fnd_global.user_id ,
4285: SYSDATE ,
4286: fnd_global.user_id ,
4287: SYSDATE ,
4288: fnd_global.conc_login_id ,

Line 4286: fnd_global.user_id ,

4282: 'MIGRATED' ,--RECORD_TYPE_CODE
4283: 'N' ,
4284: fnd_global.user_id ,
4285: SYSDATE ,
4286: fnd_global.user_id ,
4287: SYSDATE ,
4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID

Line 4288: fnd_global.conc_login_id ,

4284: fnd_global.user_id ,
4285: SYSDATE ,
4286: fnd_global.user_id ,
4287: SYSDATE ,
4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID
4291: fnd_global.conc_program_id , -- Program Id
4292: fnd_global.conc_login_id , -- Program Login ID

Line 4289: fnd_global.conc_request_id , -- Request Id

4285: SYSDATE ,
4286: fnd_global.user_id ,
4287: SYSDATE ,
4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID
4291: fnd_global.conc_program_id , -- Program Id
4292: fnd_global.conc_login_id , -- Program Login ID
4293: 1

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

4286: fnd_global.user_id ,
4287: SYSDATE ,
4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID
4291: fnd_global.conc_program_id , -- Program Id
4292: fnd_global.conc_login_id , -- Program Login ID
4293: 1
4294: )

Line 4291: fnd_global.conc_program_id , -- Program Id

4287: SYSDATE ,
4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID
4291: fnd_global.conc_program_id , -- Program Id
4292: fnd_global.conc_login_id , -- Program Login ID
4293: 1
4294: )
4295: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4288: fnd_global.conc_login_id ,
4289: fnd_global.conc_request_id , -- Request Id
4290: fnd_global.prog_appl_id , -- Program Application ID
4291: fnd_global.conc_program_id , -- Program Id
4292: fnd_global.conc_login_id , -- Program Login ID
4293: 1
4294: )
4295: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4296: where reporting_type_code='PT_ANL_TTL_TAXABLE_BOX'

Line 4339: fnd_global.user_id ,

4335: effective_from ,
4336: NULL ,--EFFECTIVE_TO
4337: 'MIGRATED' ,--RECORD_TYPE_CODE
4338: 'N' ,
4339: fnd_global.user_id ,
4340: SYSDATE ,
4341: fnd_global.user_id ,
4342: SYSDATE ,
4343: fnd_global.conc_login_id ,

Line 4341: fnd_global.user_id ,

4337: 'MIGRATED' ,--RECORD_TYPE_CODE
4338: 'N' ,
4339: fnd_global.user_id ,
4340: SYSDATE ,
4341: fnd_global.user_id ,
4342: SYSDATE ,
4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID

Line 4343: fnd_global.conc_login_id ,

4339: fnd_global.user_id ,
4340: SYSDATE ,
4341: fnd_global.user_id ,
4342: SYSDATE ,
4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID
4346: fnd_global.conc_program_id , -- Program Id
4347: fnd_global.conc_login_id , -- Program Login ID

Line 4344: fnd_global.conc_request_id , -- Request Id

4340: SYSDATE ,
4341: fnd_global.user_id ,
4342: SYSDATE ,
4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID
4346: fnd_global.conc_program_id , -- Program Id
4347: fnd_global.conc_login_id , -- Program Login ID
4348: 1

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

4341: fnd_global.user_id ,
4342: SYSDATE ,
4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID
4346: fnd_global.conc_program_id , -- Program Id
4347: fnd_global.conc_login_id , -- Program Login ID
4348: 1
4349: )

Line 4346: fnd_global.conc_program_id , -- Program Id

4342: SYSDATE ,
4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID
4346: fnd_global.conc_program_id , -- Program Id
4347: fnd_global.conc_login_id , -- Program Login ID
4348: 1
4349: )
4350: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4343: fnd_global.conc_login_id ,
4344: fnd_global.conc_request_id , -- Request Id
4345: fnd_global.prog_appl_id , -- Program Application ID
4346: fnd_global.conc_program_id , -- Program Id
4347: fnd_global.conc_login_id , -- Program Login ID
4348: 1
4349: )
4350: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4351: where reporting_type_code='PT_ANL_REC_TAXABLE' -- Bug 5031787

Line 4394: fnd_global.user_id ,

4390: effective_from ,
4391: NULL ,--EFFECTIVE_TO
4392: 'MIGRATED' ,--RECORD_TYPE_CODE
4393: 'N' ,
4394: fnd_global.user_id ,
4395: SYSDATE ,
4396: fnd_global.user_id ,
4397: SYSDATE ,
4398: fnd_global.conc_login_id ,

Line 4396: fnd_global.user_id ,

4392: 'MIGRATED' ,--RECORD_TYPE_CODE
4393: 'N' ,
4394: fnd_global.user_id ,
4395: SYSDATE ,
4396: fnd_global.user_id ,
4397: SYSDATE ,
4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID

Line 4398: fnd_global.conc_login_id ,

4394: fnd_global.user_id ,
4395: SYSDATE ,
4396: fnd_global.user_id ,
4397: SYSDATE ,
4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID
4401: fnd_global.conc_program_id , -- Program Id
4402: fnd_global.conc_login_id , -- Program Login ID

Line 4399: fnd_global.conc_request_id , -- Request Id

4395: SYSDATE ,
4396: fnd_global.user_id ,
4397: SYSDATE ,
4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID
4401: fnd_global.conc_program_id , -- Program Id
4402: fnd_global.conc_login_id , -- Program Login ID
4403: 1

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

4396: fnd_global.user_id ,
4397: SYSDATE ,
4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID
4401: fnd_global.conc_program_id , -- Program Id
4402: fnd_global.conc_login_id , -- Program Login ID
4403: 1
4404: )

Line 4401: fnd_global.conc_program_id , -- Program Id

4397: SYSDATE ,
4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID
4401: fnd_global.conc_program_id , -- Program Id
4402: fnd_global.conc_login_id , -- Program Login ID
4403: 1
4404: )
4405: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4398: fnd_global.conc_login_id ,
4399: fnd_global.conc_request_id , -- Request Id
4400: fnd_global.prog_appl_id , -- Program Application ID
4401: fnd_global.conc_program_id , -- Program Id
4402: fnd_global.conc_login_id , -- Program Login ID
4403: 1
4404: )
4405: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4406: where reporting_type_code='PT_ANL_NON_REC_TAXABLE'

Line 4449: fnd_global.user_id ,

4445: effective_from ,
4446: NULL ,--EFFECTIVE_TO
4447: 'MIGRATED' ,--RECORD_TYPE_CODE
4448: 'N' ,
4449: fnd_global.user_id ,
4450: SYSDATE ,
4451: fnd_global.user_id ,
4452: SYSDATE ,
4453: fnd_global.conc_login_id ,

Line 4451: fnd_global.user_id ,

4447: 'MIGRATED' ,--RECORD_TYPE_CODE
4448: 'N' ,
4449: fnd_global.user_id ,
4450: SYSDATE ,
4451: fnd_global.user_id ,
4452: SYSDATE ,
4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID

Line 4453: fnd_global.conc_login_id ,

4449: fnd_global.user_id ,
4450: SYSDATE ,
4451: fnd_global.user_id ,
4452: SYSDATE ,
4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID
4456: fnd_global.conc_program_id , -- Program Id
4457: fnd_global.conc_login_id , -- Program Login ID

Line 4454: fnd_global.conc_request_id , -- Request Id

4450: SYSDATE ,
4451: fnd_global.user_id ,
4452: SYSDATE ,
4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID
4456: fnd_global.conc_program_id , -- Program Id
4457: fnd_global.conc_login_id , -- Program Login ID
4458: 1

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

4451: fnd_global.user_id ,
4452: SYSDATE ,
4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID
4456: fnd_global.conc_program_id , -- Program Id
4457: fnd_global.conc_login_id , -- Program Login ID
4458: 1
4459: )

Line 4456: fnd_global.conc_program_id , -- Program Id

4452: SYSDATE ,
4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID
4456: fnd_global.conc_program_id , -- Program Id
4457: fnd_global.conc_login_id , -- Program Login ID
4458: 1
4459: )
4460: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

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

4453: fnd_global.conc_login_id ,
4454: fnd_global.conc_request_id , -- Request Id
4455: fnd_global.prog_appl_id , -- Program Application ID
4456: fnd_global.conc_program_id , -- Program Id
4457: fnd_global.conc_login_id , -- Program Login ID
4458: 1
4459: )
4460: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b
4461: where reporting_type_code='PT_ANL_REC_TAX_BOX' -- Bug 5031787

Line 4504: fnd_global.user_id ,

4500: effective_from ,
4501: NULL ,--EFFECTIVE_TO
4502: 'MIGRATED' ,--RECORD_TYPE_CODE
4503: 'N' ,
4504: fnd_global.user_id ,
4505: SYSDATE ,
4506: fnd_global.user_id ,
4507: SYSDATE ,
4508: fnd_global.conc_login_id ,

Line 4506: fnd_global.user_id ,

4502: 'MIGRATED' ,--RECORD_TYPE_CODE
4503: 'N' ,
4504: fnd_global.user_id ,
4505: SYSDATE ,
4506: fnd_global.user_id ,
4507: SYSDATE ,
4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID

Line 4508: fnd_global.conc_login_id ,

4504: fnd_global.user_id ,
4505: SYSDATE ,
4506: fnd_global.user_id ,
4507: SYSDATE ,
4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID
4511: fnd_global.conc_program_id , -- Program Id
4512: fnd_global.conc_login_id , -- Program Login ID

Line 4509: fnd_global.conc_request_id , -- Request Id

4505: SYSDATE ,
4506: fnd_global.user_id ,
4507: SYSDATE ,
4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID
4511: fnd_global.conc_program_id , -- Program Id
4512: fnd_global.conc_login_id , -- Program Login ID
4513: 1

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

4506: fnd_global.user_id ,
4507: SYSDATE ,
4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID
4511: fnd_global.conc_program_id , -- Program Id
4512: fnd_global.conc_login_id , -- Program Login ID
4513: 1
4514: )

Line 4511: fnd_global.conc_program_id , -- Program Id

4507: SYSDATE ,
4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID
4511: fnd_global.conc_program_id , -- Program Id
4512: fnd_global.conc_login_id , -- Program Login ID
4513: 1
4514: )
4515:

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

4508: fnd_global.conc_login_id ,
4509: fnd_global.conc_request_id , -- Request Id
4510: fnd_global.prog_appl_id , -- Program Application ID
4511: fnd_global.conc_program_id , -- Program Id
4512: fnd_global.conc_login_id , -- Program Login ID
4513: 1
4514: )
4515:
4516: SELECT

Line 4576: fnd_global.user_id ,

4572: effective_from ,
4573: NULL ,--EFFECTIVE_TO
4574: 'MIGRATED' ,--RECORD_TYPE_CODE
4575: 'Y' ,
4576: fnd_global.user_id ,
4577: SYSDATE ,
4578: fnd_global.user_id ,
4579: SYSDATE ,
4580: fnd_global.conc_login_id ,

Line 4578: fnd_global.user_id ,

4574: 'MIGRATED' ,--RECORD_TYPE_CODE
4575: 'Y' ,
4576: fnd_global.user_id ,
4577: SYSDATE ,
4578: fnd_global.user_id ,
4579: SYSDATE ,
4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID

Line 4580: fnd_global.conc_login_id ,

4576: fnd_global.user_id ,
4577: SYSDATE ,
4578: fnd_global.user_id ,
4579: SYSDATE ,
4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID
4583: fnd_global.conc_program_id , -- Program Id
4584: fnd_global.conc_login_id , -- Program Login ID

Line 4581: fnd_global.conc_request_id , -- Request Id

4577: SYSDATE ,
4578: fnd_global.user_id ,
4579: SYSDATE ,
4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID
4583: fnd_global.conc_program_id , -- Program Id
4584: fnd_global.conc_login_id , -- Program Login ID
4585: 1

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

4578: fnd_global.user_id ,
4579: SYSDATE ,
4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID
4583: fnd_global.conc_program_id , -- Program Id
4584: fnd_global.conc_login_id , -- Program Login ID
4585: 1
4586: )

Line 4583: fnd_global.conc_program_id , -- Program Id

4579: SYSDATE ,
4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID
4583: fnd_global.conc_program_id , -- Program Id
4584: fnd_global.conc_login_id , -- Program Login ID
4585: 1
4586: )
4587:

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

4580: fnd_global.conc_login_id ,
4581: fnd_global.conc_request_id , -- Request Id
4582: fnd_global.prog_appl_id , -- Program Application ID
4583: fnd_global.conc_program_id , -- Program Id
4584: fnd_global.conc_login_id , -- Program Login ID
4585: 1
4586: )
4587:
4588: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4631: fnd_global.user_id ,

4627: effective_from ,
4628: NULL ,--EFFECTIVE_TO
4629: 'MIGRATED' ,--RECORD_TYPE_CODE
4630: 'N' ,
4631: fnd_global.user_id ,
4632: SYSDATE ,
4633: fnd_global.user_id ,
4634: SYSDATE ,
4635: fnd_global.conc_login_id ,

Line 4633: fnd_global.user_id ,

4629: 'MIGRATED' ,--RECORD_TYPE_CODE
4630: 'N' ,
4631: fnd_global.user_id ,
4632: SYSDATE ,
4633: fnd_global.user_id ,
4634: SYSDATE ,
4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID

Line 4635: fnd_global.conc_login_id ,

4631: fnd_global.user_id ,
4632: SYSDATE ,
4633: fnd_global.user_id ,
4634: SYSDATE ,
4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID
4638: fnd_global.conc_program_id , -- Program Id
4639: fnd_global.conc_login_id , -- Program Login ID

Line 4636: fnd_global.conc_request_id , -- Request Id

4632: SYSDATE ,
4633: fnd_global.user_id ,
4634: SYSDATE ,
4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID
4638: fnd_global.conc_program_id , -- Program Id
4639: fnd_global.conc_login_id , -- Program Login ID
4640: 1

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

4633: fnd_global.user_id ,
4634: SYSDATE ,
4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID
4638: fnd_global.conc_program_id , -- Program Id
4639: fnd_global.conc_login_id , -- Program Login ID
4640: 1
4641: )

Line 4638: fnd_global.conc_program_id , -- Program Id

4634: SYSDATE ,
4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID
4638: fnd_global.conc_program_id , -- Program Id
4639: fnd_global.conc_login_id , -- Program Login ID
4640: 1
4641: )
4642:

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

4635: fnd_global.conc_login_id ,
4636: fnd_global.conc_request_id , -- Request Id
4637: fnd_global.prog_appl_id , -- Program Application ID
4638: fnd_global.conc_program_id , -- Program Id
4639: fnd_global.conc_login_id , -- Program Login ID
4640: 1
4641: )
4642:
4643: WHEN (NOT EXISTS (select 1 from zx_reporting_types_b

Line 4686: fnd_global.user_id ,

4682: effective_from ,
4683: NULL ,--EFFECTIVE_TO
4684: 'MIGRATED' ,--RECORD_TYPE_CODE
4685: 'Y' ,
4686: fnd_global.user_id ,
4687: SYSDATE ,
4688: fnd_global.user_id ,
4689: SYSDATE ,
4690: fnd_global.conc_login_id ,

Line 4688: fnd_global.user_id ,

4684: 'MIGRATED' ,--RECORD_TYPE_CODE
4685: 'Y' ,
4686: fnd_global.user_id ,
4687: SYSDATE ,
4688: fnd_global.user_id ,
4689: SYSDATE ,
4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID

Line 4690: fnd_global.conc_login_id ,

4686: fnd_global.user_id ,
4687: SYSDATE ,
4688: fnd_global.user_id ,
4689: SYSDATE ,
4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID
4693: fnd_global.conc_program_id , -- Program Id
4694: fnd_global.conc_login_id , -- Program Login ID

Line 4691: fnd_global.conc_request_id , -- Request Id

4687: SYSDATE ,
4688: fnd_global.user_id ,
4689: SYSDATE ,
4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID
4693: fnd_global.conc_program_id , -- Program Id
4694: fnd_global.conc_login_id , -- Program Login ID
4695: 1

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

4688: fnd_global.user_id ,
4689: SYSDATE ,
4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID
4693: fnd_global.conc_program_id , -- Program Id
4694: fnd_global.conc_login_id , -- Program Login ID
4695: 1
4696: )

Line 4693: fnd_global.conc_program_id , -- Program Id

4689: SYSDATE ,
4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID
4693: fnd_global.conc_program_id , -- Program Id
4694: fnd_global.conc_login_id , -- Program Login ID
4695: 1
4696: )
4697:

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

4690: fnd_global.conc_login_id ,
4691: fnd_global.conc_request_id , -- Request Id
4692: fnd_global.prog_appl_id , -- Program Application ID
4693: fnd_global.conc_program_id , -- Program Id
4694: fnd_global.conc_login_id , -- Program Login ID
4695: 1
4696: )
4697:
4698: SELECT

Line 4763: fnd_global.user_id ,

4759: effective_from ,
4760: NULL ,--EFFECTIVE_TO
4761: 'MIGRATED' ,--RECORD_TYPE_CODE
4762: 'Y' ,--HAS_REPORTING_CODES_FLAG
4763: fnd_global.user_id ,
4764: SYSDATE ,
4765: fnd_global.user_id ,
4766: SYSDATE ,
4767: fnd_global.conc_login_id ,

Line 4765: fnd_global.user_id ,

4761: 'MIGRATED' ,--RECORD_TYPE_CODE
4762: 'Y' ,--HAS_REPORTING_CODES_FLAG
4763: fnd_global.user_id ,
4764: SYSDATE ,
4765: fnd_global.user_id ,
4766: SYSDATE ,
4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID

Line 4767: fnd_global.conc_login_id ,

4763: fnd_global.user_id ,
4764: SYSDATE ,
4765: fnd_global.user_id ,
4766: SYSDATE ,
4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID
4770: fnd_global.conc_program_id , -- Program Id
4771: fnd_global.conc_login_id , -- Program Login ID

Line 4768: fnd_global.conc_request_id , -- Request Id

4764: SYSDATE ,
4765: fnd_global.user_id ,
4766: SYSDATE ,
4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID
4770: fnd_global.conc_program_id , -- Program Id
4771: fnd_global.conc_login_id , -- Program Login ID
4772: 1

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

4765: fnd_global.user_id ,
4766: SYSDATE ,
4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID
4770: fnd_global.conc_program_id , -- Program Id
4771: fnd_global.conc_login_id , -- Program Login ID
4772: 1
4773: )

Line 4770: fnd_global.conc_program_id , -- Program Id

4766: SYSDATE ,
4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID
4770: fnd_global.conc_program_id , -- Program Id
4771: fnd_global.conc_login_id , -- Program Login ID
4772: 1
4773: )
4774: SELECT

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

4767: fnd_global.conc_login_id ,
4768: fnd_global.conc_request_id , -- Request Id
4769: fnd_global.prog_appl_id , -- Program Application ID
4770: fnd_global.conc_program_id , -- Program Id
4771: fnd_global.conc_login_id , -- Program Login ID
4772: 1
4773: )
4774: SELECT
4775: min(zx_rates.effective_from) effective_from,

Line 4834: FND_GLOBAL.USER_ID,

4830: NULL,
4831: l_start_date,
4832: NULL,
4833: 'MIGRATED',
4834: FND_GLOBAL.USER_ID,
4835: SYSDATE,
4836: FND_GLOBAL.USER_ID,
4837: SYSDATE,
4838: fnd_global.conc_login_id ,

Line 4836: FND_GLOBAL.USER_ID,

4832: NULL,
4833: 'MIGRATED',
4834: FND_GLOBAL.USER_ID,
4835: SYSDATE,
4836: FND_GLOBAL.USER_ID,
4837: SYSDATE,
4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID

Line 4838: fnd_global.conc_login_id ,

4834: FND_GLOBAL.USER_ID,
4835: SYSDATE,
4836: FND_GLOBAL.USER_ID,
4837: SYSDATE,
4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID
4841: fnd_global.conc_program_id , -- Program Id
4842: fnd_global.conc_login_id , -- Program Login ID

Line 4839: fnd_global.conc_request_id , -- Request Id

4835: SYSDATE,
4836: FND_GLOBAL.USER_ID,
4837: SYSDATE,
4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID
4841: fnd_global.conc_program_id , -- Program Id
4842: fnd_global.conc_login_id , -- Program Login ID
4843: printed_tax_name,

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

4836: FND_GLOBAL.USER_ID,
4837: SYSDATE,
4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID
4841: fnd_global.conc_program_id , -- Program Id
4842: fnd_global.conc_login_id , -- Program Login ID
4843: printed_tax_name,
4844: NULL,

Line 4841: fnd_global.conc_program_id , -- Program Id

4837: SYSDATE,
4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID
4841: fnd_global.conc_program_id , -- Program Id
4842: fnd_global.conc_login_id , -- Program Login ID
4843: printed_tax_name,
4844: NULL,
4845: NULL,

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

4838: fnd_global.conc_login_id ,
4839: fnd_global.conc_request_id , -- Request Id
4840: fnd_global.prog_appl_id , -- Program Application ID
4841: fnd_global.conc_program_id , -- Program Id
4842: fnd_global.conc_login_id , -- Program Login ID
4843: printed_tax_name,
4844: NULL,
4845: NULL,
4846: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 4893: fnd_global.user_id,

4889: THEN Initcap(l_printed_tax_name)
4890: ELSE
4891: l_printed_tax_name
4892: END,
4893: fnd_global.user_id,
4894: sysdate,
4895: fnd_global.user_id,
4896: sysdate,
4897: fnd_global.conc_login_id

Line 4895: fnd_global.user_id,

4891: l_printed_tax_name
4892: END,
4893: fnd_global.user_id,
4894: sysdate,
4895: fnd_global.user_id,
4896: sysdate,
4897: fnd_global.conc_login_id
4898: )
4899: SELECT

Line 4897: fnd_global.conc_login_id

4893: fnd_global.user_id,
4894: sysdate,
4895: fnd_global.user_id,
4896: sysdate,
4897: fnd_global.conc_login_id
4898: )
4899: SELECT
4900: avtl.language l_language,
4901: avtl.source_lang l_source_lang,

Line 4990: fnd_global.user_id ,--CREATED_BY

4986: effective_from ,--EFFECTIVE_FROM
4987: NULL ,--EFFECTIVE_TO
4988: 'MIGRATED' ,--RECORD_TYPE_CODE
4989: 'Y' ,--HAS_REPORTING_CODES_FLAG
4990: fnd_global.user_id ,--CREATED_BY
4991: SYSDATE ,--CREATION_DATE
4992: fnd_global.user_id ,--LAST_UPDATED_BY
4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 4992: fnd_global.user_id ,--LAST_UPDATED_BY

4988: 'MIGRATED' ,--RECORD_TYPE_CODE
4989: 'Y' ,--HAS_REPORTING_CODES_FLAG
4990: fnd_global.user_id ,--CREATED_BY
4991: SYSDATE ,--CREATION_DATE
4992: fnd_global.user_id ,--LAST_UPDATED_BY
4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID

Line 4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

4990: fnd_global.user_id ,--CREATED_BY
4991: SYSDATE ,--CREATION_DATE
4992: fnd_global.user_id ,--LAST_UPDATED_BY
4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID
4997: fnd_global.conc_program_id , -- Program Id
4998: fnd_global.conc_login_id , -- Program Login ID

Line 4995: fnd_global.conc_request_id , -- Request Id

4991: SYSDATE ,--CREATION_DATE
4992: fnd_global.user_id ,--LAST_UPDATED_BY
4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID
4997: fnd_global.conc_program_id , -- Program Id
4998: fnd_global.conc_login_id , -- Program Login ID
4999: 1

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

4992: fnd_global.user_id ,--LAST_UPDATED_BY
4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID
4997: fnd_global.conc_program_id , -- Program Id
4998: fnd_global.conc_login_id , -- Program Login ID
4999: 1
5000: )

Line 4997: fnd_global.conc_program_id , -- Program Id

4993: SYSDATE ,--LAST_UPDATE_DATE
4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID
4997: fnd_global.conc_program_id , -- Program Id
4998: fnd_global.conc_login_id , -- Program Login ID
4999: 1
5000: )
5001: SELECT

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

4994: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
4995: fnd_global.conc_request_id , -- Request Id
4996: fnd_global.prog_appl_id , -- Program Application ID
4997: fnd_global.conc_program_id , -- Program Id
4998: fnd_global.conc_login_id , -- Program Login ID
4999: 1
5000: )
5001: SELECT
5002: min(zx_rates.effective_from) effective_from,

Line 5050: FND_GLOBAL.USER_ID,

5046: NULL,
5047: l_start_date,
5048: NULL,
5049: 'MIGRATED',
5050: FND_GLOBAL.USER_ID,
5051: SYSDATE,
5052: FND_GLOBAL.USER_ID,
5053: SYSDATE,
5054: fnd_global.conc_login_id ,

Line 5052: FND_GLOBAL.USER_ID,

5048: NULL,
5049: 'MIGRATED',
5050: FND_GLOBAL.USER_ID,
5051: SYSDATE,
5052: FND_GLOBAL.USER_ID,
5053: SYSDATE,
5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID

Line 5054: fnd_global.conc_login_id ,

5050: FND_GLOBAL.USER_ID,
5051: SYSDATE,
5052: FND_GLOBAL.USER_ID,
5053: SYSDATE,
5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID
5057: fnd_global.conc_program_id , -- Program Id
5058: fnd_global.conc_login_id , -- Program Login ID

Line 5055: fnd_global.conc_request_id , -- Request Id

5051: SYSDATE,
5052: FND_GLOBAL.USER_ID,
5053: SYSDATE,
5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID
5057: fnd_global.conc_program_id , -- Program Id
5058: fnd_global.conc_login_id , -- Program Login ID
5059: adjustment_tax_code,

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

5052: FND_GLOBAL.USER_ID,
5053: SYSDATE,
5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID
5057: fnd_global.conc_program_id , -- Program Id
5058: fnd_global.conc_login_id , -- Program Login ID
5059: adjustment_tax_code,
5060: NULL,

Line 5057: fnd_global.conc_program_id , -- Program Id

5053: SYSDATE,
5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID
5057: fnd_global.conc_program_id , -- Program Id
5058: fnd_global.conc_login_id , -- Program Login ID
5059: adjustment_tax_code,
5060: NULL,
5061: NULL,

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

5054: fnd_global.conc_login_id ,
5055: fnd_global.conc_request_id , -- Request Id
5056: fnd_global.prog_appl_id , -- Program Application ID
5057: fnd_global.conc_program_id , -- Program Id
5058: fnd_global.conc_login_id , -- Program Login ID
5059: adjustment_tax_code,
5060: NULL,
5061: NULL,
5062: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5116: FND_GLOBAL.USER_ID,

5112: NULL,
5113: l_start_date,
5114: NULL,
5115: 'MIGRATED',
5116: FND_GLOBAL.USER_ID,
5117: SYSDATE,
5118: FND_GLOBAL.USER_ID,
5119: SYSDATE,
5120: fnd_global.conc_login_id ,

Line 5118: FND_GLOBAL.USER_ID,

5114: NULL,
5115: 'MIGRATED',
5116: FND_GLOBAL.USER_ID,
5117: SYSDATE,
5118: FND_GLOBAL.USER_ID,
5119: SYSDATE,
5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID

Line 5120: fnd_global.conc_login_id ,

5116: FND_GLOBAL.USER_ID,
5117: SYSDATE,
5118: FND_GLOBAL.USER_ID,
5119: SYSDATE,
5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID
5123: fnd_global.conc_program_id , -- Program Id
5124: fnd_global.conc_login_id , -- Program Login ID

Line 5121: fnd_global.conc_request_id , -- Request Id

5117: SYSDATE,
5118: FND_GLOBAL.USER_ID,
5119: SYSDATE,
5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID
5123: fnd_global.conc_program_id , -- Program Id
5124: fnd_global.conc_login_id , -- Program Login ID
5125: global_attribute5,

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

5118: FND_GLOBAL.USER_ID,
5119: SYSDATE,
5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID
5123: fnd_global.conc_program_id , -- Program Id
5124: fnd_global.conc_login_id , -- Program Login ID
5125: global_attribute5,
5126: NULL,

Line 5123: fnd_global.conc_program_id , -- Program Id

5119: SYSDATE,
5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID
5123: fnd_global.conc_program_id , -- Program Id
5124: fnd_global.conc_login_id , -- Program Login ID
5125: global_attribute5,
5126: NULL,
5127: NULL,

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

5120: fnd_global.conc_login_id ,
5121: fnd_global.conc_request_id , -- Request Id
5122: fnd_global.prog_appl_id , -- Program Application ID
5123: fnd_global.conc_program_id , -- Program Id
5124: fnd_global.conc_login_id , -- Program Login ID
5125: global_attribute5,
5126: NULL,
5127: NULL,
5128: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5172: fnd_global.user_id ,--CREATED_BY

5168: lookups.lookup_code , --ENTITY_CODE --Bug 5528045
5169: DECODE(lookups.lookup_code,
5170: 'ZX_RATES','Y',
5171: 'N') ,--ENABLED_FLAG --Bug 5528045
5172: fnd_global.user_id ,--CREATED_BY
5173: SYSDATE ,--CREATION_DATE
5174: fnd_global.user_id ,--LAST_UPDATED_BY
5175: SYSDATE ,--LAST_UPDATE_DATE
5176: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 5174: fnd_global.user_id ,--LAST_UPDATED_BY

5170: 'ZX_RATES','Y',
5171: 'N') ,--ENABLED_FLAG --Bug 5528045
5172: fnd_global.user_id ,--CREATED_BY
5173: SYSDATE ,--CREATION_DATE
5174: fnd_global.user_id ,--LAST_UPDATED_BY
5175: SYSDATE ,--LAST_UPDATE_DATE
5176: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5177: reporting_type_id ,--REPORTING_TYPE_ID
5178: 1

Line 5176: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

5172: fnd_global.user_id ,--CREATED_BY
5173: SYSDATE ,--CREATION_DATE
5174: fnd_global.user_id ,--LAST_UPDATED_BY
5175: SYSDATE ,--LAST_UPDATE_DATE
5176: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5177: reporting_type_id ,--REPORTING_TYPE_ID
5178: 1
5179: FROM
5180: zx_reporting_types_b rep_type,

Line 5217: fnd_global.user_id ,

5213: THEN Initcap(REPORTING_TYPE_NAME)
5214: ELSE
5215: REPORTING_TYPE_NAME
5216: END,
5217: fnd_global.user_id ,
5218: SYSDATE ,
5219: fnd_global.user_id ,
5220: SYSDATE ,
5221: fnd_global.conc_login_id

Line 5219: fnd_global.user_id ,

5215: REPORTING_TYPE_NAME
5216: END,
5217: fnd_global.user_id ,
5218: SYSDATE ,
5219: fnd_global.user_id ,
5220: SYSDATE ,
5221: fnd_global.conc_login_id
5222:
5223: FROM

Line 5221: fnd_global.conc_login_id

5217: fnd_global.user_id ,
5218: SYSDATE ,
5219: fnd_global.user_id ,
5220: SYSDATE ,
5221: fnd_global.conc_login_id
5222:
5223: FROM
5224: (
5225: SELECT

Line 5289: fnd_global.user_id ,

5285: lookups.lookup_code ,--ENTITY_CODE
5286: DECODE(lookups.lookup_code,
5287: 'ZX_RATES','Y', --Bug 5528045
5288: 'N') ,--ENABLED_FLAG
5289: fnd_global.user_id ,
5290: SYSDATE ,
5291: fnd_global.user_id ,
5292: SYSDATE ,
5293: fnd_global.conc_login_id,

Line 5291: fnd_global.user_id ,

5287: 'ZX_RATES','Y', --Bug 5528045
5288: 'N') ,--ENABLED_FLAG
5289: fnd_global.user_id ,
5290: SYSDATE ,
5291: fnd_global.user_id ,
5292: SYSDATE ,
5293: fnd_global.conc_login_id,
5294: 1
5295: FROM

Line 5293: fnd_global.conc_login_id,

5289: fnd_global.user_id ,
5290: SYSDATE ,
5291: fnd_global.user_id ,
5292: SYSDATE ,
5293: fnd_global.conc_login_id,
5294: 1
5295: FROM
5296: zx_reporting_types_b types,
5297: fnd_lookups lookups

Line 5352: fnd_global.user_id ,

5348: NULL ,--EXCEPTION_CODE
5349: report_types.EFFECTIVE_FROM ,
5350: NULL ,--EFFECTIVE_TO
5351: 'MIGRATED' ,--RECORD_TYPE_CODE
5352: fnd_global.user_id ,
5353: SYSDATE ,
5354: fnd_global.user_id ,
5355: SYSDATE ,
5356: fnd_global.conc_login_id ,

Line 5354: fnd_global.user_id ,

5350: NULL ,--EFFECTIVE_TO
5351: 'MIGRATED' ,--RECORD_TYPE_CODE
5352: fnd_global.user_id ,
5353: SYSDATE ,
5354: fnd_global.user_id ,
5355: SYSDATE ,
5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID

Line 5356: fnd_global.conc_login_id ,

5352: fnd_global.user_id ,
5353: SYSDATE ,
5354: fnd_global.user_id ,
5355: SYSDATE ,
5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID
5359: fnd_global.conc_program_id , -- Program Id
5360: fnd_global.conc_login_id , -- Program Login ID

Line 5357: fnd_global.conc_request_id , -- Request Id

5353: SYSDATE ,
5354: fnd_global.user_id ,
5355: SYSDATE ,
5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID
5359: fnd_global.conc_program_id , -- Program Id
5360: fnd_global.conc_login_id , -- Program Login ID
5361: l_lookup_code,

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

5354: fnd_global.user_id ,
5355: SYSDATE ,
5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID
5359: fnd_global.conc_program_id , -- Program Id
5360: fnd_global.conc_login_id , -- Program Login ID
5361: l_lookup_code,
5362: NULL,

Line 5359: fnd_global.conc_program_id , -- Program Id

5355: SYSDATE ,
5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID
5359: fnd_global.conc_program_id , -- Program Id
5360: fnd_global.conc_login_id , -- Program Login ID
5361: l_lookup_code,
5362: NULL,
5363: NULL,

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

5356: fnd_global.conc_login_id ,
5357: fnd_global.conc_request_id , -- Request Id
5358: fnd_global.prog_appl_id , -- Program Application ID
5359: fnd_global.conc_program_id , -- Program Id
5360: fnd_global.conc_login_id , -- Program Login ID
5361: l_lookup_code,
5362: NULL,
5363: NULL,
5364: report_types.REPORTING_TYPE_ID,

Line 5401: fnd_global.user_id ,

5397: codes.reporting_code_id ,
5398: lookups.language ,
5399: lookups.source_lang ,
5400: lookups.meaning ,
5401: fnd_global.user_id ,
5402: sysdate ,
5403: fnd_global.user_id ,
5404: sysdate ,
5405: fnd_global.conc_login_id

Line 5403: fnd_global.user_id ,

5399: lookups.source_lang ,
5400: lookups.meaning ,
5401: fnd_global.user_id ,
5402: sysdate ,
5403: fnd_global.user_id ,
5404: sysdate ,
5405: fnd_global.conc_login_id
5406: FROM
5407: ZX_REPORTING_TYPES_B TYPES,

Line 5405: fnd_global.conc_login_id

5401: fnd_global.user_id ,
5402: sysdate ,
5403: fnd_global.user_id ,
5404: sysdate ,
5405: fnd_global.conc_login_id
5406: FROM
5407: ZX_REPORTING_TYPES_B TYPES,
5408: ZX_REPORTING_CODES_B CODES,
5409: FND_LOOKUP_VALUES lookups,

Line 5449: fnd_global.user_id ,

5445: codes.reporting_code_id ,
5446: lookups.language ,
5447: lookups.source_lang ,
5448: lookups.meaning ,
5449: fnd_global.user_id ,
5450: sysdate ,
5451: fnd_global.user_id ,
5452: sysdate ,
5453: fnd_global.conc_login_id

Line 5451: fnd_global.user_id ,

5447: lookups.source_lang ,
5448: lookups.meaning ,
5449: fnd_global.user_id ,
5450: sysdate ,
5451: fnd_global.user_id ,
5452: sysdate ,
5453: fnd_global.conc_login_id
5454: FROM
5455: ZX_REPORTING_TYPES_B TYPES,

Line 5453: fnd_global.conc_login_id

5449: fnd_global.user_id ,
5450: sysdate ,
5451: fnd_global.user_id ,
5452: sysdate ,
5453: fnd_global.conc_login_id
5454: FROM
5455: ZX_REPORTING_TYPES_B TYPES,
5456: ZX_REPORTING_CODES_B CODES,
5457: FND_LOOKUP_VALUES lookups,

Line 5509: fnd_global.user_id ,

5505: NULL ,--EXCEPTION_CODE
5506: effective_from ,
5507: NULL ,--EFFECTIVE_TO
5508: 'MIGRATED' ,--RECORD_TYPE_CODE
5509: fnd_global.user_id ,
5510: SYSDATE ,
5511: fnd_global.user_id ,
5512: SYSDATE ,
5513: fnd_global.conc_login_id ,

Line 5511: fnd_global.user_id ,

5507: NULL ,--EFFECTIVE_TO
5508: 'MIGRATED' ,--RECORD_TYPE_CODE
5509: fnd_global.user_id ,
5510: SYSDATE ,
5511: fnd_global.user_id ,
5512: SYSDATE ,
5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID

Line 5513: fnd_global.conc_login_id ,

5509: fnd_global.user_id ,
5510: SYSDATE ,
5511: fnd_global.user_id ,
5512: SYSDATE ,
5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID
5516: fnd_global.conc_program_id , -- Program Id
5517: fnd_global.conc_login_id , -- Program Login ID

Line 5514: fnd_global.conc_request_id , -- Request

5510: SYSDATE ,
5511: fnd_global.user_id ,
5512: SYSDATE ,
5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID
5516: fnd_global.conc_program_id , -- Program Id
5517: fnd_global.conc_login_id , -- Program Login ID
5518: 1

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

5511: fnd_global.user_id ,
5512: SYSDATE ,
5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID
5516: fnd_global.conc_program_id , -- Program Id
5517: fnd_global.conc_login_id , -- Program Login ID
5518: 1
5519: FROM

Line 5516: fnd_global.conc_program_id , -- Program Id

5512: SYSDATE ,
5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID
5516: fnd_global.conc_program_id , -- Program Id
5517: fnd_global.conc_login_id , -- Program Login ID
5518: 1
5519: FROM
5520: (

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

5513: fnd_global.conc_login_id ,
5514: fnd_global.conc_request_id , -- Request
5515: fnd_global.prog_appl_id , -- Program Application ID
5516: fnd_global.conc_program_id , -- Program Id
5517: fnd_global.conc_login_id , -- Program Login ID
5518: 1
5519: FROM
5520: (
5521: SELECT

Line 5563: fnd_global.user_id ,

5559: codes.reporting_code_id ,
5560: lookups.language ,
5561: lookups.source_lang ,
5562: lookups.meaning ,
5563: fnd_global.user_id ,
5564: sysdate ,
5565: fnd_global.user_id ,
5566: sysdate ,
5567: fnd_global.conc_login_id

Line 5565: fnd_global.user_id ,

5561: lookups.source_lang ,
5562: lookups.meaning ,
5563: fnd_global.user_id ,
5564: sysdate ,
5565: fnd_global.user_id ,
5566: sysdate ,
5567: fnd_global.conc_login_id
5568: FROM
5569: ZX_REPORTING_TYPES_B TYPES,

Line 5567: fnd_global.conc_login_id

5563: fnd_global.user_id ,
5564: sysdate ,
5565: fnd_global.user_id ,
5566: sysdate ,
5567: fnd_global.conc_login_id
5568: FROM
5569: ZX_REPORTING_TYPES_B TYPES,
5570: ZX_REPORTING_CODES_B CODES,
5571: FND_LOOKUP_VALUES lookups,

Line 5641: fnd_global.user_id ,--CREATED_BY

5637: effective_from ,--EFFECTIVE_FROM
5638: NULL ,--EFFECTIVE_TO
5639: 'MIGRATED' ,--RECORD_TYPE_CODE
5640: 'Y' ,--HAS_REPORTING_CODES_FLAG
5641: fnd_global.user_id ,--CREATED_BY
5642: SYSDATE ,--CREATION_DATE
5643: fnd_global.user_id ,--LAST_UPDATED_BY
5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 5643: fnd_global.user_id ,--LAST_UPDATED_BY

5639: 'MIGRATED' ,--RECORD_TYPE_CODE
5640: 'Y' ,--HAS_REPORTING_CODES_FLAG
5641: fnd_global.user_id ,--CREATED_BY
5642: SYSDATE ,--CREATION_DATE
5643: fnd_global.user_id ,--LAST_UPDATED_BY
5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID

Line 5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

5641: fnd_global.user_id ,--CREATED_BY
5642: SYSDATE ,--CREATION_DATE
5643: fnd_global.user_id ,--LAST_UPDATED_BY
5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID
5648: fnd_global.conc_program_id , -- Program Id
5649: fnd_global.conc_login_id , -- Program Login ID

Line 5646: fnd_global.conc_request_id , -- Request Id

5642: SYSDATE ,--CREATION_DATE
5643: fnd_global.user_id ,--LAST_UPDATED_BY
5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID
5648: fnd_global.conc_program_id , -- Program Id
5649: fnd_global.conc_login_id , -- Program Login ID
5650: 1

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

5643: fnd_global.user_id ,--LAST_UPDATED_BY
5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID
5648: fnd_global.conc_program_id , -- Program Id
5649: fnd_global.conc_login_id , -- Program Login ID
5650: 1
5651: )

Line 5648: fnd_global.conc_program_id , -- Program Id

5644: SYSDATE ,--LAST_UPDATE_DATE
5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID
5648: fnd_global.conc_program_id , -- Program Id
5649: fnd_global.conc_login_id , -- Program Login ID
5650: 1
5651: )
5652: SELECT

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

5645: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
5646: fnd_global.conc_request_id , -- Request Id
5647: fnd_global.prog_appl_id , -- Program Application ID
5648: fnd_global.conc_program_id , -- Program Id
5649: fnd_global.conc_login_id , -- Program Login ID
5650: 1
5651: )
5652: SELECT
5653: min(zx_rates.effective_from) effective_from,

Line 5701: FND_GLOBAL.USER_ID,

5697: NULL,
5698: l_start_date,
5699: NULL,
5700: 'MIGRATED',
5701: FND_GLOBAL.USER_ID,
5702: SYSDATE,
5703: FND_GLOBAL.USER_ID,
5704: SYSDATE,
5705: fnd_global.conc_login_id ,

Line 5703: FND_GLOBAL.USER_ID,

5699: NULL,
5700: 'MIGRATED',
5701: FND_GLOBAL.USER_ID,
5702: SYSDATE,
5703: FND_GLOBAL.USER_ID,
5704: SYSDATE,
5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID

Line 5705: fnd_global.conc_login_id ,

5701: FND_GLOBAL.USER_ID,
5702: SYSDATE,
5703: FND_GLOBAL.USER_ID,
5704: SYSDATE,
5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID
5708: fnd_global.conc_program_id , -- Program Id
5709: fnd_global.conc_login_id , -- Program Login ID

Line 5706: fnd_global.conc_request_id , -- Request Id

5702: SYSDATE,
5703: FND_GLOBAL.USER_ID,
5704: SYSDATE,
5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID
5708: fnd_global.conc_program_id , -- Program Id
5709: fnd_global.conc_login_id , -- Program Login ID
5710: l_location_code,

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

5703: FND_GLOBAL.USER_ID,
5704: SYSDATE,
5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID
5708: fnd_global.conc_program_id , -- Program Id
5709: fnd_global.conc_login_id , -- Program Login ID
5710: l_location_code,
5711: NULL,

Line 5708: fnd_global.conc_program_id , -- Program Id

5704: SYSDATE,
5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID
5708: fnd_global.conc_program_id , -- Program Id
5709: fnd_global.conc_login_id , -- Program Login ID
5710: l_location_code,
5711: NULL,
5712: NULL,

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

5705: fnd_global.conc_login_id ,
5706: fnd_global.conc_request_id , -- Request Id
5707: fnd_global.prog_appl_id , -- Program Application ID
5708: fnd_global.conc_program_id , -- Program Id
5709: fnd_global.conc_login_id , -- Program Login ID
5710: l_location_code,
5711: NULL,
5712: NULL,
5713: (select reporting_type_id FROM zx_reporting_types_b where tax_regime_code = l_tax_regime_code

Line 5773: fnd_global.user_id ,

5769: REPORTING_CODE_ID ,
5770: NULL ,--EXCEPTION_CODE
5771: EFFECTIVE_FROM ,
5772: NULL ,--EFFECTIVE_TO
5773: fnd_global.user_id ,
5774: SYSDATE ,
5775: fnd_global.user_id ,
5776: SYSDATE ,
5777: fnd_global.conc_login_id ,

Line 5775: fnd_global.user_id ,

5771: EFFECTIVE_FROM ,
5772: NULL ,--EFFECTIVE_TO
5773: fnd_global.user_id ,
5774: SYSDATE ,
5775: fnd_global.user_id ,
5776: SYSDATE ,
5777: fnd_global.conc_login_id ,
5778: REPORTING_CODE_CHAR_VALUE,
5779: REPORTING_CODE_DATE_VALUE,

Line 5777: fnd_global.conc_login_id ,

5773: fnd_global.user_id ,
5774: SYSDATE ,
5775: fnd_global.user_id ,
5776: SYSDATE ,
5777: fnd_global.conc_login_id ,
5778: REPORTING_CODE_CHAR_VALUE,
5779: REPORTING_CODE_DATE_VALUE,
5780: REPORTING_CODE_NUM_VALUE,
5781: 1

Line 5839: fnd_global.user_id ,--CREATED_BY

5835: )
5836: SELECT zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
5837: 'ZX_RATES_B' ,--ENTITY_CODE
5838: 'Y' ,--ENABLED_FLAG
5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE
5841: fnd_global.user_id ,--LAST_UPDATED_BY
5842: SYSDATE ,--LAST_UPDATE_DATE
5843: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

Line 5841: fnd_global.user_id ,--LAST_UPDATED_BY

5837: 'ZX_RATES_B' ,--ENTITY_CODE
5838: 'Y' ,--ENABLED_FLAG
5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE
5841: fnd_global.user_id ,--LAST_UPDATED_BY
5842: SYSDATE ,--LAST_UPDATE_DATE
5843: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5844: reporting_type_id ,--REPORTING_TYPE_ID
5845: 1

Line 5843: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN

5839: fnd_global.user_id ,--CREATED_BY
5840: SYSDATE ,--CREATION_DATE
5841: fnd_global.user_id ,--LAST_UPDATED_BY
5842: SYSDATE ,--LAST_UPDATE_DATE
5843: fnd_global.conc_login_id,--LAST_UPDATE_LOGIN
5844: reporting_type_id ,--REPORTING_TYPE_ID
5845: 1
5846:
5847: FROM

Line 5932: fnd_global.user_id,

5928: p_rep_type_info, --REPORTING_CODE_CHAR_VALUE
5929: null, --EXCEPTION_CODE
5930: sysdate, --EFFECTIVE_FROM
5931: null, --EFFECTIVE_TO
5932: fnd_global.user_id,
5933: sysdate,
5934: fnd_global.user_id,
5935: sysdate,
5936: fnd_global.conc_login_id,

Line 5934: fnd_global.user_id,

5930: sysdate, --EFFECTIVE_FROM
5931: null, --EFFECTIVE_TO
5932: fnd_global.user_id,
5933: sysdate,
5934: fnd_global.user_id,
5935: sysdate,
5936: fnd_global.conc_login_id,
5937: 1
5938:

Line 5936: fnd_global.conc_login_id,

5932: fnd_global.user_id,
5933: sysdate,
5934: fnd_global.user_id,
5935: sysdate,
5936: fnd_global.conc_login_id,
5937: 1
5938:
5939: FROM ZX_REPORTING_TYPES_B
5940: WHERE REPORTING_TYPE_CODE=p_reporting_type_code

Line 6034: fnd_global.user_id ,

6030: SYSDATE, --EFFECTIVE_FROM
6031: NULL, --EFFECTIVE_TO
6032: 'MIGRATED', --RECORD_TYPE_CODE
6033: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
6034: fnd_global.user_id ,
6035: SYSDATE ,
6036: fnd_global.user_id ,
6037: SYSDATE ,
6038: fnd_global.conc_login_id ,

Line 6036: fnd_global.user_id ,

6032: 'MIGRATED', --RECORD_TYPE_CODE
6033: p_has_rep_code , --HAS_REPORTING_CODES_FLAG
6034: fnd_global.user_id ,
6035: SYSDATE ,
6036: fnd_global.user_id ,
6037: SYSDATE ,
6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID

Line 6038: fnd_global.conc_login_id ,

6034: fnd_global.user_id ,
6035: SYSDATE ,
6036: fnd_global.user_id ,
6037: SYSDATE ,
6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID
6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID

Line 6039: fnd_global.conc_request_id , -- Request Id

6035: SYSDATE ,
6036: fnd_global.user_id ,
6037: SYSDATE ,
6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID
6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID
6043: 1

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

6036: fnd_global.user_id ,
6037: SYSDATE ,
6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID
6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID
6043: 1
6044:

Line 6041: fnd_global.conc_program_id , -- Program Id

6037: SYSDATE ,
6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID
6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID
6043: 1
6044:
6045: FROM DUAL

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

6038: fnd_global.conc_login_id ,
6039: fnd_global.conc_request_id , -- Request Id
6040: fnd_global.prog_appl_id , -- Program Application ID
6041: fnd_global.conc_program_id , -- Program Id
6042: fnd_global.conc_login_id , -- Program Login ID
6043: 1
6044:
6045: FROM DUAL
6046:

Line 6137: fnd_global.conc_request_id , -- Request Id

6133: SYSDATE ,
6134: 120 ,
6135: SYSDATE ,
6136: 0 ,
6137: fnd_global.conc_request_id , -- Request Id
6138: fnd_global.prog_appl_id , -- Program Application ID
6139: fnd_global.conc_program_id , -- Program Id
6140: fnd_global.conc_login_id , -- Program Login ID
6141: 1

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

6134: 120 ,
6135: SYSDATE ,
6136: 0 ,
6137: fnd_global.conc_request_id , -- Request Id
6138: fnd_global.prog_appl_id , -- Program Application ID
6139: fnd_global.conc_program_id , -- Program Id
6140: fnd_global.conc_login_id , -- Program Login ID
6141: 1
6142: FROM DUAL

Line 6139: fnd_global.conc_program_id , -- Program Id

6135: SYSDATE ,
6136: 0 ,
6137: fnd_global.conc_request_id , -- Request Id
6138: fnd_global.prog_appl_id , -- Program Application ID
6139: fnd_global.conc_program_id , -- Program Id
6140: fnd_global.conc_login_id , -- Program Login ID
6141: 1
6142: FROM DUAL
6143: WHERE NOT EXISTS (select 1 from zx_reporting_types_b

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

6136: 0 ,
6137: fnd_global.conc_request_id , -- Request Id
6138: fnd_global.prog_appl_id , -- Program Application ID
6139: fnd_global.conc_program_id , -- Program Id
6140: fnd_global.conc_login_id , -- Program Login ID
6141: 1
6142: FROM DUAL
6143: WHERE NOT EXISTS (select 1 from zx_reporting_types_b
6144: where reporting_type_code= p_reporting_type_code

Line 6310: fnd_global.conc_request_id , -- Request Id

6306: SYSDATE ,
6307: 120 ,
6308: SYSDATE ,
6309: 0 ,
6310: fnd_global.conc_request_id , -- Request Id
6311: fnd_global.prog_appl_id , -- Program Application ID
6312: fnd_global.conc_program_id , -- Program Id
6313: fnd_global.conc_login_id , -- Program Login ID
6314: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

6307: 120 ,
6308: SYSDATE ,
6309: 0 ,
6310: fnd_global.conc_request_id , -- Request Id
6311: fnd_global.prog_appl_id , -- Program Application ID
6312: fnd_global.conc_program_id , -- Program Id
6313: fnd_global.conc_login_id , -- Program Login ID
6314: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6315: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 6312: fnd_global.conc_program_id , -- Program Id

6308: SYSDATE ,
6309: 0 ,
6310: fnd_global.conc_request_id , -- Request Id
6311: fnd_global.prog_appl_id , -- Program Application ID
6312: fnd_global.conc_program_id , -- Program Id
6313: fnd_global.conc_login_id , -- Program Login ID
6314: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6315: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6316: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

6309: 0 ,
6310: fnd_global.conc_request_id , -- Request Id
6311: fnd_global.prog_appl_id , -- Program Application ID
6312: fnd_global.conc_program_id , -- Program Id
6313: fnd_global.conc_login_id , -- Program Login ID
6314: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6315: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6316: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
6317: REPORTING_TYPE_ID,

Line 6577: fnd_global.conc_request_id , -- Request Id

6573: SYSDATE ,
6574: 120 ,
6575: SYSDATE ,
6576: 0 ,
6577: fnd_global.conc_request_id , -- Request Id
6578: fnd_global.prog_appl_id , -- Program Application ID
6579: fnd_global.conc_program_id , -- Program Id
6580: fnd_global.conc_login_id , -- Program Login ID
6581: l_lookup_code,

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

6574: 120 ,
6575: SYSDATE ,
6576: 0 ,
6577: fnd_global.conc_request_id , -- Request Id
6578: fnd_global.prog_appl_id , -- Program Application ID
6579: fnd_global.conc_program_id , -- Program Id
6580: fnd_global.conc_login_id , -- Program Login ID
6581: l_lookup_code,
6582: NULL,

Line 6579: fnd_global.conc_program_id , -- Program Id

6575: SYSDATE ,
6576: 0 ,
6577: fnd_global.conc_request_id , -- Request Id
6578: fnd_global.prog_appl_id , -- Program Application ID
6579: fnd_global.conc_program_id , -- Program Id
6580: fnd_global.conc_login_id , -- Program Login ID
6581: l_lookup_code,
6582: NULL,
6583: NULL,

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

6576: 0 ,
6577: fnd_global.conc_request_id , -- Request Id
6578: fnd_global.prog_appl_id , -- Program Application ID
6579: fnd_global.conc_program_id , -- Program Id
6580: fnd_global.conc_login_id , -- Program Login ID
6581: l_lookup_code,
6582: NULL,
6583: NULL,
6584: report_types.REPORTING_TYPE_ID,

Line 6730: fnd_global.conc_request_id , -- Request Id

6726: SYSDATE ,
6727: 120 ,
6728: SYSDATE ,
6729: 0 ,
6730: fnd_global.conc_request_id , -- Request Id
6731: fnd_global.prog_appl_id , -- Program Application ID
6732: fnd_global.conc_program_id , -- Program Id
6733: fnd_global.conc_login_id , -- Program Login ID
6734: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),

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

6727: 120 ,
6728: SYSDATE ,
6729: 0 ,
6730: fnd_global.conc_request_id , -- Request Id
6731: fnd_global.prog_appl_id , -- Program Application ID
6732: fnd_global.conc_program_id , -- Program Id
6733: fnd_global.conc_login_id , -- Program Login ID
6734: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6735: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),

Line 6732: fnd_global.conc_program_id , -- Program Id

6728: SYSDATE ,
6729: 0 ,
6730: fnd_global.conc_request_id , -- Request Id
6731: fnd_global.prog_appl_id , -- Program Application ID
6732: fnd_global.conc_program_id , -- Program Id
6733: fnd_global.conc_login_id , -- Program Login ID
6734: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6735: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6736: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),

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

6729: 0 ,
6730: fnd_global.conc_request_id , -- Request Id
6731: fnd_global.prog_appl_id , -- Program Application ID
6732: fnd_global.conc_program_id , -- Program Id
6733: fnd_global.conc_login_id , -- Program Login ID
6734: decode(DATATYPE,'TEXT',LOOKUP_CODE,'YES_NO',LOOKUP_CODE,NULL),
6735: decode(DATATYPE,'DATE',LOOKUP_CODE,NULL),
6736: decode(DATATYPE,'NUMERIC_VALUE',LOOKUP_CODE,NULL),
6737: REPORTING_TYPE_ID,

Line 6878: fnd_global.user_id ,

6874: lookups.lookup_code ,--ENTITY_CODE
6875: DECODE(lookups.lookup_code,
6876: 'ZX_RATES','Y',
6877: 'N') ,--ENABLED_FLAG
6878: fnd_global.user_id ,
6879: SYSDATE ,
6880: fnd_global.user_id ,
6881: SYSDATE ,
6882: fnd_global.conc_login_id,

Line 6880: fnd_global.user_id ,

6876: 'ZX_RATES','Y',
6877: 'N') ,--ENABLED_FLAG
6878: fnd_global.user_id ,
6879: SYSDATE ,
6880: fnd_global.user_id ,
6881: SYSDATE ,
6882: fnd_global.conc_login_id,
6883: 1
6884: FROM

Line 6882: fnd_global.conc_login_id,

6878: fnd_global.user_id ,
6879: SYSDATE ,
6880: fnd_global.user_id ,
6881: SYSDATE ,
6882: fnd_global.conc_login_id,
6883: 1
6884: FROM
6885: zx_reporting_types_b types,
6886: fnd_lookups lookups

Line 6923: fnd_global.user_id ,

6919: lookups.lookup_code ,--ENTITY_CODE
6920: DECODE(lookups.lookup_code,
6921: 'ZX_PARTY_TAX_PROFILE','Y',
6922: 'N') ,--ENABLED_FLAG
6923: fnd_global.user_id ,
6924: SYSDATE ,
6925: fnd_global.user_id ,
6926: SYSDATE ,
6927: fnd_global.conc_login_id,

Line 6925: fnd_global.user_id ,

6921: 'ZX_PARTY_TAX_PROFILE','Y',
6922: 'N') ,--ENABLED_FLAG
6923: fnd_global.user_id ,
6924: SYSDATE ,
6925: fnd_global.user_id ,
6926: SYSDATE ,
6927: fnd_global.conc_login_id,
6928: 1
6929: FROM

Line 6927: fnd_global.conc_login_id,

6923: fnd_global.user_id ,
6924: SYSDATE ,
6925: fnd_global.user_id ,
6926: SYSDATE ,
6927: fnd_global.conc_login_id,
6928: 1
6929: FROM
6930: zx_reporting_types_b types,
6931: fnd_lookups lookups

Line 7024: fnd_global.user_id ,--CREATED_BY

7020: effective_from ,--EFFECTIVE_FROM
7021: NULL ,--EFFECTIVE_TO
7022: 'MIGRATED' ,--RECORD_TYPE_CODE
7023: 'Y' ,--HAS_REPORTING_CODES_FLAG
7024: fnd_global.user_id ,--CREATED_BY
7025: SYSDATE ,--CREATION_DATE
7026: fnd_global.user_id ,--LAST_UPDATED_BY
7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7026: fnd_global.user_id ,--LAST_UPDATED_BY

7022: 'MIGRATED' ,--RECORD_TYPE_CODE
7023: 'Y' ,--HAS_REPORTING_CODES_FLAG
7024: fnd_global.user_id ,--CREATED_BY
7025: SYSDATE ,--CREATION_DATE
7026: fnd_global.user_id ,--LAST_UPDATED_BY
7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7024: fnd_global.user_id ,--CREATED_BY
7025: SYSDATE ,--CREATION_DATE
7026: fnd_global.user_id ,--LAST_UPDATED_BY
7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7031: fnd_global.conc_program_id ,--PROGRAM_ID
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7029: fnd_global.conc_request_id ,--REQUEST_ID

7025: SYSDATE ,--CREATION_DATE
7026: fnd_global.user_id ,--LAST_UPDATED_BY
7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7031: fnd_global.conc_program_id ,--PROGRAM_ID
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7033: 1 --OBJECT_VERSION_NUMBER

Line 7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7026: fnd_global.user_id ,--LAST_UPDATED_BY
7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7031: fnd_global.conc_program_id ,--PROGRAM_ID
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7033: 1 --OBJECT_VERSION_NUMBER
7034: )

Line 7031: fnd_global.conc_program_id ,--PROGRAM_ID

7027: SYSDATE ,--LAST_UPDATE_DATE
7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7031: fnd_global.conc_program_id ,--PROGRAM_ID
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7033: 1 --OBJECT_VERSION_NUMBER
7034: )
7035: SELECT min(zx_rates.effective_from) effective_from

Line 7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7028: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7029: fnd_global.conc_request_id ,--REQUEST_ID
7030: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7031: fnd_global.conc_program_id ,--PROGRAM_ID
7032: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7033: 1 --OBJECT_VERSION_NUMBER
7034: )
7035: SELECT min(zx_rates.effective_from) effective_from
7036: FROM zx_rates_b zx_rates,

Line 7061: fnd_global.user_id ,

7057: REPORTING_TYPE_ID ,
7058: LANGUAGE_CODE ,
7059: userenv('LANG') ,
7060: 'EMEA VAT Reporting Type' ,
7061: fnd_global.user_id ,
7062: SYSDATE ,
7063: fnd_global.user_id ,
7064: SYSDATE ,
7065: fnd_global.conc_login_id

Line 7063: fnd_global.user_id ,

7059: userenv('LANG') ,
7060: 'EMEA VAT Reporting Type' ,
7061: fnd_global.user_id ,
7062: SYSDATE ,
7063: fnd_global.user_id ,
7064: SYSDATE ,
7065: fnd_global.conc_login_id
7066: FROM
7067: (

Line 7065: fnd_global.conc_login_id

7061: fnd_global.user_id ,
7062: SYSDATE ,
7063: fnd_global.user_id ,
7064: SYSDATE ,
7065: fnd_global.conc_login_id
7066: FROM
7067: (
7068: SELECT
7069: TYPES.REPORTING_TYPE_ID ,

Line 7125: fnd_global.user_id ,--CREATED_BY

7121: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7122: types.reporting_type_id ,--REPORTING_TYPE_ID
7123: 'ZX_RATES' ,--ENTITY_CODE
7124: 'Y' ,--ENABLED_FLAG
7125: fnd_global.user_id ,--CREATED_BY
7126: SYSDATE ,--CREATION_DATE
7127: fnd_global.user_id ,--LAST_UPDATED_BY
7128: SYSDATE ,--LAST_UPDATE_DATE
7129: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7127: fnd_global.user_id ,--LAST_UPDATED_BY

7123: 'ZX_RATES' ,--ENTITY_CODE
7124: 'Y' ,--ENABLED_FLAG
7125: fnd_global.user_id ,--CREATED_BY
7126: SYSDATE ,--CREATION_DATE
7127: fnd_global.user_id ,--LAST_UPDATED_BY
7128: SYSDATE ,--LAST_UPDATE_DATE
7129: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7130: 1 --OBJECT_VERSION_NUMBER
7131: FROM

Line 7129: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7125: fnd_global.user_id ,--CREATED_BY
7126: SYSDATE ,--CREATION_DATE
7127: fnd_global.user_id ,--LAST_UPDATED_BY
7128: SYSDATE ,--LAST_UPDATE_DATE
7129: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7130: 1 --OBJECT_VERSION_NUMBER
7131: FROM
7132: zx_reporting_types_b types
7133: WHERE types.reporting_type_code IN('EMEA_VAT_REPORTING_TYPE')

Line 7192: fnd_global.user_id ,--CREATED_BY

7188: NULL ,--EXCEPTION_CODE
7189: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7190: NULL ,--EFFECTIVE_TO
7191: 'MIGRATED' ,--RECORD_TYPE_CODE
7192: fnd_global.user_id ,--CREATED_BY
7193: SYSDATE ,--CREATION_DATE
7194: fnd_global.user_id ,--LAST_UPDATED_BY
7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7194: fnd_global.user_id ,--LAST_UPDATED_BY

7190: NULL ,--EFFECTIVE_TO
7191: 'MIGRATED' ,--RECORD_TYPE_CODE
7192: fnd_global.user_id ,--CREATED_BY
7193: SYSDATE ,--CREATION_DATE
7194: fnd_global.user_id ,--LAST_UPDATED_BY
7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7192: fnd_global.user_id ,--CREATED_BY
7193: SYSDATE ,--CREATION_DATE
7194: fnd_global.user_id ,--LAST_UPDATED_BY
7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7199: fnd_global.conc_program_id ,--PROGRAM_ID
7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7197: fnd_global.conc_request_id ,--REQUEST_ID

7193: SYSDATE ,--CREATION_DATE
7194: fnd_global.user_id ,--LAST_UPDATED_BY
7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7199: fnd_global.conc_program_id ,--PROGRAM_ID
7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7201: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621

Line 7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7194: fnd_global.user_id ,--LAST_UPDATED_BY
7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7199: fnd_global.conc_program_id ,--PROGRAM_ID
7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7201: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7202: NULL ,--REPORTING_CODE_DATE_VALUE

Line 7199: fnd_global.conc_program_id ,--PROGRAM_ID

7195: SYSDATE ,--LAST_UPDATE_DATE
7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7199: fnd_global.conc_program_id ,--PROGRAM_ID
7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7201: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7202: NULL ,--REPORTING_CODE_DATE_VALUE
7203: NULL ,--REPORTING_CODE_NUM_VALUE

Line 7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7196: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7197: fnd_global.conc_request_id ,--REQUEST_ID
7198: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7199: fnd_global.conc_program_id ,--PROGRAM_ID
7200: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7201: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE --Bug#6615621
7202: NULL ,--REPORTING_CODE_DATE_VALUE
7203: NULL ,--REPORTING_CODE_NUM_VALUE
7204: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID

Line 7266: fnd_global.user_id ,

7262: THEN Initcap(lookups.meaning)
7263: ELSE
7264: lookups.meaning
7265: END,
7266: fnd_global.user_id ,
7267: sysdate ,
7268: fnd_global.user_id ,
7269: sysdate ,
7270: fnd_global.conc_login_id

Line 7268: fnd_global.user_id ,

7264: lookups.meaning
7265: END,
7266: fnd_global.user_id ,
7267: sysdate ,
7268: fnd_global.user_id ,
7269: sysdate ,
7270: fnd_global.conc_login_id
7271: FROM
7272: ZX_REPORTING_TYPES_B TYPES,

Line 7270: fnd_global.conc_login_id

7266: fnd_global.user_id ,
7267: sysdate ,
7268: fnd_global.user_id ,
7269: sysdate ,
7270: fnd_global.conc_login_id
7271: FROM
7272: ZX_REPORTING_TYPES_B TYPES,
7273: ZX_REPORTING_CODES_B CODES,
7274: FND_LOOKUP_VALUES lookups,

Line 7355: fnd_global.user_id ,

7351: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7352: NULL ,--EXCEPTION_CODE
7353: rates.EFFECTIVE_FROM ,
7354: NULL ,--EFFECTIVE_TO
7355: fnd_global.user_id ,
7356: SYSDATE ,
7357: fnd_global.user_id ,
7358: SYSDATE ,
7359: fnd_global.conc_login_id ,

Line 7357: fnd_global.user_id ,

7353: rates.EFFECTIVE_FROM ,
7354: NULL ,--EFFECTIVE_TO
7355: fnd_global.user_id ,
7356: SYSDATE ,
7357: fnd_global.user_id ,
7358: SYSDATE ,
7359: fnd_global.conc_login_id ,
7360: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7361: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7359: fnd_global.conc_login_id ,

7355: fnd_global.user_id ,
7356: SYSDATE ,
7357: fnd_global.user_id ,
7358: SYSDATE ,
7359: fnd_global.conc_login_id ,
7360: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7361: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7362: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7363: 1

Line 7427: fnd_global.user_id ,

7423: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7424: NULL ,--EXCEPTION_CODE
7425: rates.EFFECTIVE_FROM ,
7426: NULL ,--EFFECTIVE_TO
7427: fnd_global.user_id ,
7428: SYSDATE ,
7429: fnd_global.user_id ,
7430: SYSDATE ,
7431: fnd_global.conc_login_id ,

Line 7429: fnd_global.user_id ,

7425: rates.EFFECTIVE_FROM ,
7426: NULL ,--EFFECTIVE_TO
7427: fnd_global.user_id ,
7428: SYSDATE ,
7429: fnd_global.user_id ,
7430: SYSDATE ,
7431: fnd_global.conc_login_id ,
7432: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7433: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7431: fnd_global.conc_login_id ,

7427: fnd_global.user_id ,
7428: SYSDATE ,
7429: fnd_global.user_id ,
7430: SYSDATE ,
7431: fnd_global.conc_login_id ,
7432: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7433: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7434: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7435: 1

Line 7534: fnd_global.user_id ,--CREATED_BY

7530: l_effective_from ,--EFFECTIVE_FROM
7531: NULL ,--EFFECTIVE_TO
7532: 'MIGRATED' ,--RECORD_TYPE_CODE
7533: 'N' ,--HAS_REPORTING_CODES_FLAG
7534: fnd_global.user_id ,--CREATED_BY
7535: SYSDATE ,--CREATION_DATE
7536: fnd_global.user_id ,--LAST_UPDATED_BY
7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7536: fnd_global.user_id ,--LAST_UPDATED_BY

7532: 'MIGRATED' ,--RECORD_TYPE_CODE
7533: 'N' ,--HAS_REPORTING_CODES_FLAG
7534: fnd_global.user_id ,--CREATED_BY
7535: SYSDATE ,--CREATION_DATE
7536: fnd_global.user_id ,--LAST_UPDATED_BY
7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7534: fnd_global.user_id ,--CREATED_BY
7535: SYSDATE ,--CREATION_DATE
7536: fnd_global.user_id ,--LAST_UPDATED_BY
7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7541: fnd_global.conc_program_id ,--PROGRAM_ID
7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7539: fnd_global.conc_request_id ,--REQUEST_ID

7535: SYSDATE ,--CREATION_DATE
7536: fnd_global.user_id ,--LAST_UPDATED_BY
7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7541: fnd_global.conc_program_id ,--PROGRAM_ID
7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7543: 1 --OBJECT_VERSION_NUMBER

Line 7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7536: fnd_global.user_id ,--LAST_UPDATED_BY
7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7541: fnd_global.conc_program_id ,--PROGRAM_ID
7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7543: 1 --OBJECT_VERSION_NUMBER
7544: )

Line 7541: fnd_global.conc_program_id ,--PROGRAM_ID

7537: SYSDATE ,--LAST_UPDATE_DATE
7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7541: fnd_global.conc_program_id ,--PROGRAM_ID
7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7543: 1 --OBJECT_VERSION_NUMBER
7544: )
7545: SELECT

Line 7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7538: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7539: fnd_global.conc_request_id ,--REQUEST_ID
7540: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7541: fnd_global.conc_program_id ,--PROGRAM_ID
7542: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7543: 1 --OBJECT_VERSION_NUMBER
7544: )
7545: SELECT
7546: 'REVERSE_CHARGE_VAT' l_reporting_type_code,

Line 7575: fnd_global.user_id ,

7571: REPORTING_TYPE_ID ,
7572: LANGUAGE_CODE ,
7573: userenv('LANG') ,
7574: 'Reverse Charge VAT' ,
7575: fnd_global.user_id ,
7576: SYSDATE ,
7577: fnd_global.user_id ,
7578: SYSDATE ,
7579: fnd_global.conc_login_id

Line 7577: fnd_global.user_id ,

7573: userenv('LANG') ,
7574: 'Reverse Charge VAT' ,
7575: fnd_global.user_id ,
7576: SYSDATE ,
7577: fnd_global.user_id ,
7578: SYSDATE ,
7579: fnd_global.conc_login_id
7580: FROM
7581: (

Line 7579: fnd_global.conc_login_id

7575: fnd_global.user_id ,
7576: SYSDATE ,
7577: fnd_global.user_id ,
7578: SYSDATE ,
7579: fnd_global.conc_login_id
7580: FROM
7581: (
7582: SELECT
7583: TYPES.REPORTING_TYPE_ID ,

Line 7617: fnd_global.user_id ,--CREATED_BY

7613: zx_report_types_usages_s.nextval,--REPORTING_TYPE_USAGE_ID
7614: types.reporting_type_id ,--REPORTING_TYPE_ID
7615: 'ZX_RATES' ,--ENTITY_CODE
7616: 'Y' ,--ENABLED_FLAG
7617: fnd_global.user_id ,--CREATED_BY
7618: SYSDATE ,--CREATION_DATE
7619: fnd_global.user_id ,--LAST_UPDATED_BY
7620: SYSDATE ,--LAST_UPDATE_DATE
7621: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7619: fnd_global.user_id ,--LAST_UPDATED_BY

7615: 'ZX_RATES' ,--ENTITY_CODE
7616: 'Y' ,--ENABLED_FLAG
7617: fnd_global.user_id ,--CREATED_BY
7618: SYSDATE ,--CREATION_DATE
7619: fnd_global.user_id ,--LAST_UPDATED_BY
7620: SYSDATE ,--LAST_UPDATE_DATE
7621: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7622: 1 --OBJECT_VERSION_NUMBER
7623: FROM

Line 7621: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7617: fnd_global.user_id ,--CREATED_BY
7618: SYSDATE ,--CREATION_DATE
7619: fnd_global.user_id ,--LAST_UPDATED_BY
7620: SYSDATE ,--LAST_UPDATE_DATE
7621: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7622: 1 --OBJECT_VERSION_NUMBER
7623: FROM
7624: zx_reporting_types_b types
7625: WHERE types.reporting_type_code = 'REVERSE_CHARGE_VAT'

Line 7661: fnd_global.user_id ,--CREATED_BY

7657: NULL ,--EXCEPTION_CODE
7658: EFFECTIVE_FROM ,--EFFECTIVE_FROM
7659: NULL ,--EFFECTIVE_TO
7660: 'MIGRATED' ,--RECORD_TYPE_CODE
7661: fnd_global.user_id ,--CREATED_BY
7662: SYSDATE ,--CREATION_DATE
7663: fnd_global.user_id ,--LAST_UPDATED_BY
7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 7663: fnd_global.user_id ,--LAST_UPDATED_BY

7659: NULL ,--EFFECTIVE_TO
7660: 'MIGRATED' ,--RECORD_TYPE_CODE
7661: fnd_global.user_id ,--CREATED_BY
7662: SYSDATE ,--CREATION_DATE
7663: fnd_global.user_id ,--LAST_UPDATED_BY
7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

7661: fnd_global.user_id ,--CREATED_BY
7662: SYSDATE ,--CREATION_DATE
7663: fnd_global.user_id ,--LAST_UPDATED_BY
7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7668: fnd_global.conc_program_id ,--PROGRAM_ID
7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 7666: fnd_global.conc_request_id ,--REQUEST_ID

7662: SYSDATE ,--CREATION_DATE
7663: fnd_global.user_id ,--LAST_UPDATED_BY
7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7668: fnd_global.conc_program_id ,--PROGRAM_ID
7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7670: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE

Line 7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

7663: fnd_global.user_id ,--LAST_UPDATED_BY
7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7668: fnd_global.conc_program_id ,--PROGRAM_ID
7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7670: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7671: NULL ,--REPORTING_CODE_DATE_VALUE

Line 7668: fnd_global.conc_program_id ,--PROGRAM_ID

7664: SYSDATE ,--LAST_UPDATE_DATE
7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7668: fnd_global.conc_program_id ,--PROGRAM_ID
7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7670: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7671: NULL ,--REPORTING_CODE_DATE_VALUE
7672: NULL ,--REPORTING_CODE_NUM_VALUE

Line 7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

7665: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
7666: fnd_global.conc_request_id ,--REQUEST_ID
7667: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
7668: fnd_global.conc_program_id ,--PROGRAM_ID
7669: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
7670: REPORTING_CODE_CHAR_VALUE ,--REPORTING_CODE_CHAR_VALUE
7671: NULL ,--REPORTING_CODE_DATE_VALUE
7672: NULL ,--REPORTING_CODE_NUM_VALUE
7673: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID

Line 7722: fnd_global.user_id ,

7718: THEN Initcap(lookups.meaning)
7719: ELSE
7720: lookups.meaning
7721: END,
7722: fnd_global.user_id ,
7723: sysdate ,
7724: fnd_global.user_id ,
7725: sysdate ,
7726: fnd_global.conc_login_id

Line 7724: fnd_global.user_id ,

7720: lookups.meaning
7721: END,
7722: fnd_global.user_id ,
7723: sysdate ,
7724: fnd_global.user_id ,
7725: sysdate ,
7726: fnd_global.conc_login_id
7727: FROM
7728: ZX_REPORTING_TYPES_B TYPES,

Line 7726: fnd_global.conc_login_id

7722: fnd_global.user_id ,
7723: sysdate ,
7724: fnd_global.user_id ,
7725: sysdate ,
7726: fnd_global.conc_login_id
7727: FROM
7728: ZX_REPORTING_TYPES_B TYPES,
7729: ZX_REPORTING_CODES_B CODES,
7730: FND_LOOKUP_VALUES lookups,

Line 7780: fnd_global.user_id ,

7776: report_codes.REPORTING_CODE_ID ,--REPORTING_CODE_ID
7777: NULL ,--EXCEPTION_CODE
7778: rates.EFFECTIVE_FROM ,
7779: NULL ,--EFFECTIVE_TO
7780: fnd_global.user_id ,
7781: SYSDATE ,
7782: fnd_global.user_id ,
7783: SYSDATE ,
7784: fnd_global.conc_login_id ,

Line 7782: fnd_global.user_id ,

7778: rates.EFFECTIVE_FROM ,
7779: NULL ,--EFFECTIVE_TO
7780: fnd_global.user_id ,
7781: SYSDATE ,
7782: fnd_global.user_id ,
7783: SYSDATE ,
7784: fnd_global.conc_login_id ,
7785: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7786: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE

Line 7784: fnd_global.conc_login_id ,

7780: fnd_global.user_id ,
7781: SYSDATE ,
7782: fnd_global.user_id ,
7783: SYSDATE ,
7784: fnd_global.conc_login_id ,
7785: report_codes.REPORTING_CODE_CHAR_VALUE,--REPORTING_CODE_CHAR_VALUE
7786: report_codes.REPORTING_CODE_DATE_VALUE,--REPORTING_CODE_DATE_VALUE
7787: report_codes.REPORTING_CODE_NUM_VALUE , --REPORTING_CODE_NUM_VALUE
7788: 1

Line 7891: fnd_global.user_id,

7887: effective_from,
7888: NULL,
7889: ''MIGRATED'',
7890: ''Y'',
7891: fnd_global.user_id,
7892: SYSDATE,
7893: fnd_global.user_id,
7894: SYSDATE,
7895: fnd_global.conc_login_id,

Line 7893: fnd_global.user_id,

7889: ''MIGRATED'',
7890: ''Y'',
7891: fnd_global.user_id,
7892: SYSDATE,
7893: fnd_global.user_id,
7894: SYSDATE,
7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,

Line 7895: fnd_global.conc_login_id,

7891: fnd_global.user_id,
7892: SYSDATE,
7893: fnd_global.user_id,
7894: SYSDATE,
7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,
7898: fnd_global.conc_program_id,
7899: fnd_global.conc_login_id,

Line 7896: fnd_global.conc_request_id,

7892: SYSDATE,
7893: fnd_global.user_id,
7894: SYSDATE,
7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,
7898: fnd_global.conc_program_id,
7899: fnd_global.conc_login_id,
7900: 1

Line 7897: fnd_global.prog_appl_id,

7893: fnd_global.user_id,
7894: SYSDATE,
7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,
7898: fnd_global.conc_program_id,
7899: fnd_global.conc_login_id,
7900: 1
7901: )

Line 7898: fnd_global.conc_program_id,

7894: SYSDATE,
7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,
7898: fnd_global.conc_program_id,
7899: fnd_global.conc_login_id,
7900: 1
7901: )
7902: SELECT MIN(zx_rates.effective_from) effective_from

Line 7899: fnd_global.conc_login_id,

7895: fnd_global.conc_login_id,
7896: fnd_global.conc_request_id,
7897: fnd_global.prog_appl_id,
7898: fnd_global.conc_program_id,
7899: fnd_global.conc_login_id,
7900: 1
7901: )
7902: SELECT MIN(zx_rates.effective_from) effective_from
7903: FROM AR_VAT_TAX_ALL_B vat_tax,

Line 7959: fnd_global.user_id,

7955: effective_from,
7956: NULL,
7957: ''MIGRATED'',
7958: ''Y'',
7959: fnd_global.user_id,
7960: SYSDATE,
7961: fnd_global.user_id,
7962: SYSDATE,
7963: fnd_global.conc_login_id,

Line 7961: fnd_global.user_id,

7957: ''MIGRATED'',
7958: ''Y'',
7959: fnd_global.user_id,
7960: SYSDATE,
7961: fnd_global.user_id,
7962: SYSDATE,
7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,

Line 7963: fnd_global.conc_login_id,

7959: fnd_global.user_id,
7960: SYSDATE,
7961: fnd_global.user_id,
7962: SYSDATE,
7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,
7966: fnd_global.conc_program_id,
7967: fnd_global.conc_login_id,

Line 7964: fnd_global.conc_request_id,

7960: SYSDATE,
7961: fnd_global.user_id,
7962: SYSDATE,
7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,
7966: fnd_global.conc_program_id,
7967: fnd_global.conc_login_id,
7968: 1

Line 7965: fnd_global.prog_appl_id,

7961: fnd_global.user_id,
7962: SYSDATE,
7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,
7966: fnd_global.conc_program_id,
7967: fnd_global.conc_login_id,
7968: 1
7969: )

Line 7966: fnd_global.conc_program_id,

7962: SYSDATE,
7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,
7966: fnd_global.conc_program_id,
7967: fnd_global.conc_login_id,
7968: 1
7969: )
7970: SELECT MIN(zx_rates.effective_from) effective_from

Line 7967: fnd_global.conc_login_id,

7963: fnd_global.conc_login_id,
7964: fnd_global.conc_request_id,
7965: fnd_global.prog_appl_id,
7966: fnd_global.conc_program_id,
7967: fnd_global.conc_login_id,
7968: 1
7969: )
7970: SELECT MIN(zx_rates.effective_from) effective_from
7971: FROM AR_VAT_TAX_ALL_B vat_tax,

Line 8000: fnd_global.user_id ,

7996: userenv('LANG') ,
7997: decode(REPORTING_TYPE_CODE,
7998: 'ZX_INTRA_EU_TRX_TYPE','Intra EU Transaction Type',
7999: 'ZX_LGL_JUSTIFICATN_MSG_TYPE','Intra EU Legal Message Type') ,
8000: fnd_global.user_id ,
8001: SYSDATE ,
8002: fnd_global.user_id ,
8003: SYSDATE ,
8004: fnd_global.conc_login_id

Line 8002: fnd_global.user_id ,

7998: 'ZX_INTRA_EU_TRX_TYPE','Intra EU Transaction Type',
7999: 'ZX_LGL_JUSTIFICATN_MSG_TYPE','Intra EU Legal Message Type') ,
8000: fnd_global.user_id ,
8001: SYSDATE ,
8002: fnd_global.user_id ,
8003: SYSDATE ,
8004: fnd_global.conc_login_id
8005: FROM ( SELECT TYPES.REPORTING_TYPE_ID ,
8006: L.LANGUAGE_CODE,

Line 8004: fnd_global.conc_login_id

8000: fnd_global.user_id ,
8001: SYSDATE ,
8002: fnd_global.user_id ,
8003: SYSDATE ,
8004: fnd_global.conc_login_id
8005: FROM ( SELECT TYPES.REPORTING_TYPE_ID ,
8006: L.LANGUAGE_CODE,
8007: TYPES.REPORTING_TYPE_CODE
8008: FROM ZX_REPORTING_TYPES_B TYPES,

Line 8070: fnd_global.user_id , --CREATED_BY

8066: 'ZX_RATES','Y',
8067: 'ZX_STATUS','Y',
8068: 'ZX_PROCESS_RESULTS','Y',
8069: 'N') , --ENABLED_FLAG
8070: fnd_global.user_id , --CREATED_BY
8071: SYSDATE , --CREATION_DATE
8072: fnd_global.user_id , --LAST_UPDATED_BY
8073: SYSDATE , --LAST_UPDATE_DATE
8074: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

Line 8072: fnd_global.user_id , --LAST_UPDATED_BY

8068: 'ZX_PROCESS_RESULTS','Y',
8069: 'N') , --ENABLED_FLAG
8070: fnd_global.user_id , --CREATED_BY
8071: SYSDATE , --CREATION_DATE
8072: fnd_global.user_id , --LAST_UPDATED_BY
8073: SYSDATE , --LAST_UPDATE_DATE
8074: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
8075: reporting_type_id , --REPORTING_TYPE_ID
8076: 1 --OBJECT_VERSION_NUMBER

Line 8074: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN

8070: fnd_global.user_id , --CREATED_BY
8071: SYSDATE , --CREATION_DATE
8072: fnd_global.user_id , --LAST_UPDATED_BY
8073: SYSDATE , --LAST_UPDATE_DATE
8074: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
8075: reporting_type_id , --REPORTING_TYPE_ID
8076: 1 --OBJECT_VERSION_NUMBER
8077: FROM zx_reporting_types_b rep_type,
8078: fnd_lookups lookups

Line 8140: fnd_global.user_id ,--CREATED_BY

8136: NULL ,--EXCEPTION_CODE
8137: EFFECTIVE_FROM ,--EFFECTIVE_FROM
8138: NULL ,--EFFECTIVE_TO
8139: 'MIGRATED' ,--RECORD_TYPE_CODE
8140: fnd_global.user_id ,--CREATED_BY
8141: SYSDATE ,--CREATION_DATE
8142: fnd_global.user_id ,--LAST_UPDATED_BY
8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

Line 8142: fnd_global.user_id ,--LAST_UPDATED_BY

8138: NULL ,--EFFECTIVE_TO
8139: 'MIGRATED' ,--RECORD_TYPE_CODE
8140: fnd_global.user_id ,--CREATED_BY
8141: SYSDATE ,--CREATION_DATE
8142: fnd_global.user_id ,--LAST_UPDATED_BY
8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

Line 8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN

8140: fnd_global.user_id ,--CREATED_BY
8141: SYSDATE ,--CREATION_DATE
8142: fnd_global.user_id ,--LAST_UPDATED_BY
8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
8147: fnd_global.conc_program_id ,--PROGRAM_ID
8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

Line 8145: fnd_global.conc_request_id ,--REQUEST_ID

8141: SYSDATE ,--CREATION_DATE
8142: fnd_global.user_id ,--LAST_UPDATED_BY
8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
8147: fnd_global.conc_program_id ,--PROGRAM_ID
8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
8149: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE

Line 8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID

8142: fnd_global.user_id ,--LAST_UPDATED_BY
8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
8147: fnd_global.conc_program_id ,--PROGRAM_ID
8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
8149: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE
8150: NULL ,--REPORTING_CODE_DATE_VALUE

Line 8147: fnd_global.conc_program_id ,--PROGRAM_ID

8143: SYSDATE ,--LAST_UPDATE_DATE
8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
8147: fnd_global.conc_program_id ,--PROGRAM_ID
8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
8149: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE
8150: NULL ,--REPORTING_CODE_DATE_VALUE
8151: NULL ,--REPORTING_CODE_NUM_VALUE

Line 8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID

8144: fnd_global.conc_login_id ,--LAST_UPDATE_LOGIN
8145: fnd_global.conc_request_id ,--REQUEST_ID
8146: fnd_global.prog_appl_id ,--PROGRAM_APPLICATION_ID
8147: fnd_global.conc_program_id ,--PROGRAM_ID
8148: fnd_global.conc_login_id ,--PROGRAM_LOGIN_ID
8149: DECODE(DATATYPE,'TEXT',REPORTING_CODE_CHAR_VALUE,NULL),--REPORTING_CODE_CHAR_VALUE
8150: NULL ,--REPORTING_CODE_DATE_VALUE
8151: NULL ,--REPORTING_CODE_NUM_VALUE
8152: REPORTING_TYPE_ID ,--REPORTING_TYPE_ID

Line 8197: fnd_global.user_id ,

8193: WHEN lookups.meaning = UPPER(lookups.meaning)
8194: THEN Initcap(lookups.meaning)
8195: ELSE lookups.meaning
8196: END ,
8197: fnd_global.user_id ,
8198: SYSDATE ,
8199: fnd_global.user_id ,
8200: SYSDATE ,
8201: fnd_global.conc_login_id

Line 8199: fnd_global.user_id ,

8195: ELSE lookups.meaning
8196: END ,
8197: fnd_global.user_id ,
8198: SYSDATE ,
8199: fnd_global.user_id ,
8200: SYSDATE ,
8201: fnd_global.conc_login_id
8202: FROM ZX_REPORTING_TYPES_B TYPES,
8203: ZX_REPORTING_CODES_B CODES,

Line 8201: fnd_global.conc_login_id

8197: fnd_global.user_id ,
8198: SYSDATE ,
8199: fnd_global.user_id ,
8200: SYSDATE ,
8201: fnd_global.conc_login_id
8202: FROM ZX_REPORTING_TYPES_B TYPES,
8203: ZX_REPORTING_CODES_B CODES,
8204: FND_LOOKUP_VALUES lookups ,
8205: FND_LANGUAGES L

Line 8277: fnd_global.user_id,

8273: REPORTING_CODE_ID,
8274: NULL,
8275: EFFECTIVE_FROM,
8276: NULL,
8277: fnd_global.user_id,
8278: SYSDATE,
8279: fnd_global.user_id,
8280: SYSDATE,
8281: fnd_global.conc_login_id,

Line 8279: fnd_global.user_id,

8275: EFFECTIVE_FROM,
8276: NULL,
8277: fnd_global.user_id,
8278: SYSDATE,
8279: fnd_global.user_id,
8280: SYSDATE,
8281: fnd_global.conc_login_id,
8282: REPORTING_CODE_CHAR_VALUE,
8283: REPORTING_CODE_DATE_VALUE,

Line 8281: fnd_global.conc_login_id,

8277: fnd_global.user_id,
8278: SYSDATE,
8279: fnd_global.user_id,
8280: SYSDATE,
8281: fnd_global.conc_login_id,
8282: REPORTING_CODE_CHAR_VALUE,
8283: REPORTING_CODE_DATE_VALUE,
8284: REPORTING_CODE_NUM_VALUE,
8285: 1

Line 8345: fnd_global.user_id,

8341: REPORTING_CODE_ID,
8342: NULL,
8343: EFFECTIVE_FROM,
8344: NULL,
8345: fnd_global.user_id,
8346: SYSDATE,
8347: fnd_global.user_id,
8348: SYSDATE,
8349: fnd_global.conc_login_id,

Line 8347: fnd_global.user_id,

8343: EFFECTIVE_FROM,
8344: NULL,
8345: fnd_global.user_id,
8346: SYSDATE,
8347: fnd_global.user_id,
8348: SYSDATE,
8349: fnd_global.conc_login_id,
8350: REPORTING_CODE_CHAR_VALUE,
8351: REPORTING_CODE_DATE_VALUE,

Line 8349: fnd_global.conc_login_id,

8345: fnd_global.user_id,
8346: SYSDATE,
8347: fnd_global.user_id,
8348: SYSDATE,
8349: fnd_global.conc_login_id,
8350: REPORTING_CODE_CHAR_VALUE,
8351: REPORTING_CODE_DATE_VALUE,
8352: REPORTING_CODE_NUM_VALUE,
8353: 1