APPS.ZX_MIGRATE_TAX_DEF dependencies on FND_GLOBAL

Line 323: fnd_global.user_id ,

319: ATTRIBUTE14 ,
320: ATTRIBUTE15 ,
321: TAG ,
322: SYSDATE ,
323: fnd_global.user_id ,
324: SYSDATE ,
325: fnd_global.user_id ,
326: fnd_global.conc_login_id
327: FROM FND_LOOKUP_VALUES ap_lookups

Line 325: fnd_global.user_id ,

321: TAG ,
322: SYSDATE ,
323: fnd_global.user_id ,
324: SYSDATE ,
325: fnd_global.user_id ,
326: fnd_global.conc_login_id
327: FROM FND_LOOKUP_VALUES ap_lookups
328: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
329: AND NOT EXISTS

Line 326: fnd_global.conc_login_id

322: SYSDATE ,
323: fnd_global.user_id ,
324: SYSDATE ,
325: fnd_global.user_id ,
326: fnd_global.conc_login_id
327: FROM FND_LOOKUP_VALUES ap_lookups
328: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
329: AND NOT EXISTS
330: (select 1 from FND_LOOKUP_VALUES

Line 420: fnd_global.user_id ,

416: ATTRIBUTE14 ,
417: ATTRIBUTE15 ,
418: TAG ,
419: SYSDATE ,
420: fnd_global.user_id ,
421: SYSDATE ,
422: fnd_global.user_id ,
423: fnd_global.conc_login_id
424: FROM FND_LOOKUP_VALUES ap_lookups

Line 422: fnd_global.user_id ,

418: TAG ,
419: SYSDATE ,
420: fnd_global.user_id ,
421: SYSDATE ,
422: fnd_global.user_id ,
423: fnd_global.conc_login_id
424: FROM FND_LOOKUP_VALUES ap_lookups
425: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
426: -- Changed the re-runnability check

Line 423: fnd_global.conc_login_id

419: SYSDATE ,
420: fnd_global.user_id ,
421: SYSDATE ,
422: fnd_global.user_id ,
423: fnd_global.conc_login_id
424: FROM FND_LOOKUP_VALUES ap_lookups
425: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
426: -- Changed the re-runnability check
427: AND NOT EXISTS

Line 510: fnd_global.user_id ,

506: 'E' ,
507: 0 ,
508: 0 ,
509: SYSDATE ,
510: fnd_global.user_id ,
511: SYSDATE ,
512: fnd_global.user_id ,
513: fnd_global.conc_login_id
514: )

Line 512: fnd_global.user_id ,

508: 0 ,
509: SYSDATE ,
510: fnd_global.user_id ,
511: SYSDATE ,
512: fnd_global.user_id ,
513: fnd_global.conc_login_id
514: )
515: WHEN (NOT EXISTS
516: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 513: fnd_global.conc_login_id

509: SYSDATE ,
510: fnd_global.user_id ,
511: SYSDATE ,
512: fnd_global.user_id ,
513: fnd_global.conc_login_id
514: )
515: WHEN (NOT EXISTS
516: (SELECT 1 FROM FND_LOOKUP_TYPES
517: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')

Line 540: fnd_global.user_id ,

536: 'E' ,
537: 0 ,
538: 0 ,
539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.user_id ,
543: fnd_global.conc_login_id
544: )

Line 542: fnd_global.user_id ,

538: 0 ,
539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.user_id ,
543: fnd_global.conc_login_id
544: )
545: WHEN (NOT EXISTS
546: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 543: fnd_global.conc_login_id

539: SYSDATE ,
540: fnd_global.user_id ,
541: SYSDATE ,
542: fnd_global.user_id ,
543: fnd_global.conc_login_id
544: )
545: WHEN (NOT EXISTS
546: (SELECT 1 FROM FND_LOOKUP_TYPES
547: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')

Line 570: fnd_global.user_id ,

566: 'E' ,
567: 0 ,
568: 0 ,
569: SYSDATE ,
570: fnd_global.user_id ,
571: SYSDATE ,
572: fnd_global.user_id ,
573: fnd_global.conc_login_id
574: )

Line 572: fnd_global.user_id ,

568: 0 ,
569: SYSDATE ,
570: fnd_global.user_id ,
571: SYSDATE ,
572: fnd_global.user_id ,
573: fnd_global.conc_login_id
574: )
575: SELECT 1 FROM DUAL;
576:

Line 573: fnd_global.conc_login_id

569: SYSDATE ,
570: fnd_global.user_id ,
571: SYSDATE ,
572: fnd_global.user_id ,
573: fnd_global.conc_login_id
574: )
575: SELECT 1 FROM DUAL;
576:
577: INSERT INTO FND_LOOKUP_TYPES_TL

Line 604: fnd_global.user_id ,

600: ELSE
601: types.lookup_type
602: END,--MEANING
603: types.lookup_type,--DESCRIPTION
604: fnd_global.user_id ,
605: SYSDATE ,
606: fnd_global.user_id ,
607: SYSDATE ,
608: fnd_global.conc_login_id

Line 606: fnd_global.user_id ,

602: END,--MEANING
603: types.lookup_type,--DESCRIPTION
604: fnd_global.user_id ,
605: SYSDATE ,
606: fnd_global.user_id ,
607: SYSDATE ,
608: fnd_global.conc_login_id
609: FROM FND_LOOKUP_TYPES types,
610: FND_LANGUAGES L

Line 608: fnd_global.conc_login_id

604: fnd_global.user_id ,
605: SYSDATE ,
606: fnd_global.user_id ,
607: SYSDATE ,
608: fnd_global.conc_login_id
609: FROM FND_LOOKUP_TYPES types,
610: FND_LANGUAGES L
611: WHERE L.INSTALLED_FLAG in ('I', 'B')
612: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',

Line 707: fnd_global.user_id ,

703: NULL ,--ATTRIBUTE14
704: NULL ,--ATTRIBUTE15
705: NULL ,--TAG
706: SYSDATE ,
707: fnd_global.user_id ,
708: SYSDATE ,
709: fnd_global.user_id ,
710: fnd_global.conc_login_id
711: FROM

Line 709: fnd_global.user_id ,

705: NULL ,--TAG
706: SYSDATE ,
707: fnd_global.user_id ,
708: SYSDATE ,
709: fnd_global.user_id ,
710: fnd_global.conc_login_id
711: FROM
712: (
713: SELECT

Line 710: fnd_global.conc_login_id

706: SYSDATE ,
707: fnd_global.user_id ,
708: SYSDATE ,
709: fnd_global.user_id ,
710: fnd_global.conc_login_id
711: FROM
712: (
713: SELECT
714: codes.name LOOKUP_CODE,

Line 834: fnd_global.user_id ,

830: NULL ,--ATTRIBUTE14
831: NULL ,--ATTRIBUTE15
832: NULL ,--TAG
833: SYSDATE ,
834: fnd_global.user_id ,
835: SYSDATE ,
836: fnd_global.user_id ,
837: fnd_global.conc_login_id
838: FROM

Line 836: fnd_global.user_id ,

832: NULL ,--TAG
833: SYSDATE ,
834: fnd_global.user_id ,
835: SYSDATE ,
836: fnd_global.user_id ,
837: fnd_global.conc_login_id
838: FROM
839: (
840: SELECT

Line 837: fnd_global.conc_login_id

833: SYSDATE ,
834: fnd_global.user_id ,
835: SYSDATE ,
836: fnd_global.user_id ,
837: fnd_global.conc_login_id
838: FROM
839: (
840: SELECT
841: codes.name LOOKUP_CODE,

Line 912: fnd_global.user_id , --created_by

908: TAX_TYPE , --tax_type
909: START_DATE , --effective_from
910: INACTIVE_DATE , --effective_to
911: 'AP' , --source
912: fnd_global.user_id , --created_by
913: SYSDATE , --creation_date
914: fnd_global.user_id , --last_updated_by
915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login

Line 914: fnd_global.user_id , --last_updated_by

910: INACTIVE_DATE , --effective_to
911: 'AP' , --source
912: fnd_global.user_id , --created_by
913: SYSDATE , --creation_date
914: fnd_global.user_id , --last_updated_by
915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id

Line 916: fnd_global.user_id , --last_update_login

912: fnd_global.user_id , --created_by
913: SYSDATE , --creation_date
914: fnd_global.user_id , --last_updated_by
915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id
919: fnd_global.conc_program_id , --program_id
920: fnd_global.conc_login_id , --program_login_id

Line 917: fnd_global.conc_request_id , --request_id

913: SYSDATE , --creation_date
914: fnd_global.user_id , --last_updated_by
915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id
919: fnd_global.conc_program_id , --program_id
920: fnd_global.conc_login_id , --program_login_id
921: codes.set_of_books_id , --ledger_id

Line 918: fnd_global.prog_appl_id , --program_application_id

914: fnd_global.user_id , --last_updated_by
915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id
919: fnd_global.conc_program_id , --program_id
920: fnd_global.conc_login_id , --program_login_id
921: codes.set_of_books_id , --ledger_id
922: codes.enabled_flag

Line 919: fnd_global.conc_program_id , --program_id

915: SYSDATE , --last_update_date
916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id
919: fnd_global.conc_program_id , --program_id
920: fnd_global.conc_login_id , --program_login_id
921: codes.set_of_books_id , --ledger_id
922: codes.enabled_flag
923: FROM

Line 920: fnd_global.conc_login_id , --program_login_id

916: fnd_global.user_id , --last_update_login
917: fnd_global.conc_request_id , --request_id
918: fnd_global.prog_appl_id , --program_application_id
919: fnd_global.conc_program_id , --program_id
920: fnd_global.conc_login_id , --program_login_id
921: codes.set_of_books_id , --ledger_id
922: codes.enabled_flag
923: FROM
924: AP_TAX_CODES_ALL codes

Line 1104: fnd_global.user_id ,

1100: ATTRIBUTE15 ,
1101: ATTRIBUTE_CATEGORY ,
1102: zx_rates_b_s.nextval ,--TAX_RATE_ID
1103: CONTENT_OWNER_ID ,
1104: fnd_global.user_id ,
1105: SYSDATE ,
1106: fnd_global.user_id ,
1107: SYSDATE ,
1108: fnd_global.conc_login_id ,

Line 1106: fnd_global.user_id ,

1102: zx_rates_b_s.nextval ,--TAX_RATE_ID
1103: CONTENT_OWNER_ID ,
1104: fnd_global.user_id ,
1105: SYSDATE ,
1106: fnd_global.user_id ,
1107: SYSDATE ,
1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID

Line 1108: fnd_global.conc_login_id ,

1104: fnd_global.user_id ,
1105: SYSDATE ,
1106: fnd_global.user_id ,
1107: SYSDATE ,
1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID
1111: fnd_global.conc_program_id , -- Program Id
1112: fnd_global.conc_login_id , -- Program Login ID

Line 1109: fnd_global.conc_request_id , -- Request Id

1105: SYSDATE ,
1106: fnd_global.user_id ,
1107: SYSDATE ,
1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID
1111: fnd_global.conc_program_id , -- Program Id
1112: fnd_global.conc_login_id , -- Program Login ID
1113: 'TAX_RATE' ,

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

1106: fnd_global.user_id ,
1107: SYSDATE ,
1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID
1111: fnd_global.conc_program_id , -- Program Id
1112: fnd_global.conc_login_id , -- Program Login ID
1113: 'TAX_RATE' ,
1114: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG

Line 1111: fnd_global.conc_program_id , -- Program Id

1107: SYSDATE ,
1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID
1111: fnd_global.conc_program_id , -- Program Id
1112: fnd_global.conc_login_id , -- Program Login ID
1113: 'TAX_RATE' ,
1114: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
1115: 1

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

1108: fnd_global.conc_login_id ,
1109: fnd_global.conc_request_id , -- Request Id
1110: fnd_global.prog_appl_id , -- Program Application ID
1111: fnd_global.conc_program_id , -- Program Id
1112: fnd_global.conc_login_id , -- Program Login ID
1113: 'TAX_RATE' ,
1114: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
1115: 1
1116: -- 6820043, commenting out description

Line 1200: fnd_global.user_id ,

1196: NULL ,
1197: NULL ,
1198: NULL ,
1199: NULL ,
1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id ,
1203: SYSDATE ,
1204: fnd_global.conc_login_id ,

Line 1202: fnd_global.user_id ,

1198: NULL ,
1199: NULL ,
1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id ,
1203: SYSDATE ,
1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID

Line 1204: fnd_global.conc_login_id ,

1200: fnd_global.user_id ,
1201: SYSDATE ,
1202: fnd_global.user_id ,
1203: SYSDATE ,
1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID
1207: fnd_global.conc_program_id , -- Program Id
1208: fnd_global.conc_login_id , -- Program Login ID

Line 1205: fnd_global.conc_request_id , -- Request Id

1201: SYSDATE ,
1202: fnd_global.user_id ,
1203: SYSDATE ,
1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID
1207: fnd_global.conc_program_id , -- Program Id
1208: fnd_global.conc_login_id , -- Program Login ID
1209: 1

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

1202: fnd_global.user_id ,
1203: SYSDATE ,
1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID
1207: fnd_global.conc_program_id , -- Program Id
1208: fnd_global.conc_login_id , -- Program Login ID
1209: 1
1210: )

Line 1207: fnd_global.conc_program_id , -- Program Id

1203: SYSDATE ,
1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID
1207: fnd_global.conc_program_id , -- Program Id
1208: fnd_global.conc_login_id , -- Program Login ID
1209: 1
1210: )
1211: SELECT

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

1204: fnd_global.conc_login_id ,
1205: fnd_global.conc_request_id , -- Request Id
1206: fnd_global.prog_appl_id , -- Program Application ID
1207: fnd_global.conc_program_id , -- Program Id
1208: fnd_global.conc_login_id , -- Program Login ID
1209: 1
1210: )
1211: SELECT
1212: results.tax_code_id TAX_RATE_ID,

Line 1525: fnd_global.user_id ,

1521: ATTRIBUTE15 ,
1522: ATTRIBUTE_CATEGORY ,
1523: zx_rates_b_s.nextval ,--TAX_RATE_ID
1524: CONTENT_OWNER_ID ,
1525: fnd_global.user_id ,
1526: SYSDATE ,
1527: fnd_global.user_id ,
1528: SYSDATE ,
1529: fnd_global.conc_login_id ,

Line 1527: fnd_global.user_id ,

1523: zx_rates_b_s.nextval ,--TAX_RATE_ID
1524: CONTENT_OWNER_ID ,
1525: fnd_global.user_id ,
1526: SYSDATE ,
1527: fnd_global.user_id ,
1528: SYSDATE ,
1529: fnd_global.conc_login_id ,
1530: fnd_global.conc_request_id , -- Request Id
1531: fnd_global.prog_appl_id , -- Program Application ID

Line 1529: fnd_global.conc_login_id ,

1525: fnd_global.user_id ,
1526: SYSDATE ,
1527: fnd_global.user_id ,
1528: SYSDATE ,
1529: fnd_global.conc_login_id ,
1530: fnd_global.conc_request_id , -- Request Id
1531: fnd_global.prog_appl_id , -- Program Application ID
1532: fnd_global.conc_program_id , -- Program Id
1533: fnd_global.conc_login_id , -- Program Login ID

Line 1530: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 1532: fnd_global.conc_program_id , -- Program Id

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

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

1529: fnd_global.conc_login_id ,
1530: fnd_global.conc_request_id , -- Request Id
1531: fnd_global.prog_appl_id , -- Program Application ID
1532: fnd_global.conc_program_id , -- Program Id
1533: fnd_global.conc_login_id , -- Program Login ID
1534: 'TAX_RATE' ,
1535: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
1536: 1
1537: -- 6820043, commenting out description

Line 1621: fnd_global.user_id ,

1617: NULL ,
1618: NULL ,
1619: NULL ,
1620: NULL ,
1621: fnd_global.user_id ,
1622: SYSDATE ,
1623: fnd_global.user_id ,
1624: SYSDATE ,
1625: fnd_global.conc_login_id ,

Line 1623: fnd_global.user_id ,

1619: NULL ,
1620: NULL ,
1621: fnd_global.user_id ,
1622: SYSDATE ,
1623: fnd_global.user_id ,
1624: SYSDATE ,
1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID

Line 1625: fnd_global.conc_login_id ,

1621: fnd_global.user_id ,
1622: SYSDATE ,
1623: fnd_global.user_id ,
1624: SYSDATE ,
1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID
1628: fnd_global.conc_program_id , -- Program Id
1629: fnd_global.conc_login_id , -- Program Login ID

Line 1626: fnd_global.conc_request_id , -- Request Id

1622: SYSDATE ,
1623: fnd_global.user_id ,
1624: SYSDATE ,
1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID
1628: fnd_global.conc_program_id , -- Program Id
1629: fnd_global.conc_login_id , -- Program Login ID
1630: 1

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

1623: fnd_global.user_id ,
1624: SYSDATE ,
1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID
1628: fnd_global.conc_program_id , -- Program Id
1629: fnd_global.conc_login_id , -- Program Login ID
1630: 1
1631: )

Line 1628: fnd_global.conc_program_id , -- Program Id

1624: SYSDATE ,
1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID
1628: fnd_global.conc_program_id , -- Program Id
1629: fnd_global.conc_login_id , -- Program Login ID
1630: 1
1631: )
1632: SELECT

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

1625: fnd_global.conc_login_id ,
1626: fnd_global.conc_request_id , -- Request Id
1627: fnd_global.prog_appl_id , -- Program Application ID
1628: fnd_global.conc_program_id , -- Program Id
1629: fnd_global.conc_login_id , -- Program Login ID
1630: 1
1631: )
1632: SELECT
1633: results.tax_code_id TAX_RATE_ID,

Line 1954: fnd_global.user_id ,

1950: ATTRIBUTE15 ,
1951: ATTRIBUTE_CATEGORY ,
1952: TAX_RATE_ID ,
1953: CONTENT_OWNER_ID ,
1954: fnd_global.user_id ,
1955: SYSDATE ,
1956: fnd_global.user_id ,
1957: SYSDATE ,
1958: fnd_global.conc_login_id ,

Line 1956: fnd_global.user_id ,

1952: TAX_RATE_ID ,
1953: CONTENT_OWNER_ID ,
1954: fnd_global.user_id ,
1955: SYSDATE ,
1956: fnd_global.user_id ,
1957: SYSDATE ,
1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID

Line 1958: fnd_global.conc_login_id ,

1954: fnd_global.user_id ,
1955: SYSDATE ,
1956: fnd_global.user_id ,
1957: SYSDATE ,
1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID
1961: fnd_global.conc_program_id , -- Program Id
1962: fnd_global.conc_login_id , -- Program Login ID

Line 1959: fnd_global.conc_request_id , -- Request Id

1955: SYSDATE ,
1956: fnd_global.user_id ,
1957: SYSDATE ,
1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID
1961: fnd_global.conc_program_id , -- Program Id
1962: fnd_global.conc_login_id , -- Program Login ID
1963: 'TAX_RATE' ,

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

1956: fnd_global.user_id ,
1957: SYSDATE ,
1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID
1961: fnd_global.conc_program_id , -- Program Id
1962: fnd_global.conc_login_id , -- Program Login ID
1963: 'TAX_RATE' ,
1964: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 1961: fnd_global.conc_program_id , -- Program Id

1957: SYSDATE ,
1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID
1961: fnd_global.conc_program_id , -- Program Id
1962: fnd_global.conc_login_id , -- Program Login ID
1963: 'TAX_RATE' ,
1964: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
1965: 1 ,

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

1958: fnd_global.conc_login_id ,
1959: fnd_global.conc_request_id , -- Request Id
1960: fnd_global.prog_appl_id , -- Program Application ID
1961: fnd_global.conc_program_id , -- Program Id
1962: fnd_global.conc_login_id , -- Program Login ID
1963: 'TAX_RATE' ,
1964: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
1965: 1 ,
1966: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 2052: fnd_global.user_id ,

2048: NULL ,
2049: NULL ,
2050: NULL ,
2051: NULL ,
2052: fnd_global.user_id ,
2053: SYSDATE ,
2054: fnd_global.user_id ,
2055: SYSDATE ,
2056: fnd_global.conc_login_id ,

Line 2054: fnd_global.user_id ,

2050: NULL ,
2051: NULL ,
2052: fnd_global.user_id ,
2053: SYSDATE ,
2054: fnd_global.user_id ,
2055: SYSDATE ,
2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID

Line 2056: fnd_global.conc_login_id ,

2052: fnd_global.user_id ,
2053: SYSDATE ,
2054: fnd_global.user_id ,
2055: SYSDATE ,
2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID
2059: fnd_global.conc_program_id , -- Program Id
2060: fnd_global.conc_login_id , -- Program Login ID

Line 2057: fnd_global.conc_request_id , -- Request Id

2053: SYSDATE ,
2054: fnd_global.user_id ,
2055: SYSDATE ,
2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID
2059: fnd_global.conc_program_id , -- Program Id
2060: fnd_global.conc_login_id , -- Program Login ID
2061: 1

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

2054: fnd_global.user_id ,
2055: SYSDATE ,
2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID
2059: fnd_global.conc_program_id , -- Program Id
2060: fnd_global.conc_login_id , -- Program Login ID
2061: 1
2062: )

Line 2059: fnd_global.conc_program_id , -- Program Id

2055: SYSDATE ,
2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID
2059: fnd_global.conc_program_id , -- Program Id
2060: fnd_global.conc_login_id , -- Program Login ID
2061: 1
2062: )
2063: SELECT

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

2056: fnd_global.conc_login_id ,
2057: fnd_global.conc_request_id , -- Request Id
2058: fnd_global.prog_appl_id , -- Program Application ID
2059: fnd_global.conc_program_id , -- Program Id
2060: fnd_global.conc_login_id , -- Program Login ID
2061: 1
2062: )
2063: SELECT
2064: results.tax_code_id TAX_RATE_ID,

Line 2379: fnd_global.user_id ,

2375: ATTRIBUTE15 ,
2376: ATTRIBUTE_CATEGORY ,
2377: TAX_RATE_ID ,
2378: CONTENT_OWNER_ID ,
2379: fnd_global.user_id ,
2380: SYSDATE ,
2381: fnd_global.user_id ,
2382: SYSDATE ,
2383: fnd_global.conc_login_id ,

Line 2381: fnd_global.user_id ,

2377: TAX_RATE_ID ,
2378: CONTENT_OWNER_ID ,
2379: fnd_global.user_id ,
2380: SYSDATE ,
2381: fnd_global.user_id ,
2382: SYSDATE ,
2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID

Line 2383: fnd_global.conc_login_id ,

2379: fnd_global.user_id ,
2380: SYSDATE ,
2381: fnd_global.user_id ,
2382: SYSDATE ,
2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID
2386: fnd_global.conc_program_id , -- Program Id
2387: fnd_global.conc_login_id , -- Program Login ID

Line 2384: fnd_global.conc_request_id , -- Request Id

2380: SYSDATE ,
2381: fnd_global.user_id ,
2382: SYSDATE ,
2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID
2386: fnd_global.conc_program_id , -- Program Id
2387: fnd_global.conc_login_id , -- Program Login ID
2388: 'TAX_RATE' ,

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

2381: fnd_global.user_id ,
2382: SYSDATE ,
2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID
2386: fnd_global.conc_program_id , -- Program Id
2387: fnd_global.conc_login_id , -- Program Login ID
2388: 'TAX_RATE' ,
2389: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 2386: fnd_global.conc_program_id , -- Program Id

2382: SYSDATE ,
2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID
2386: fnd_global.conc_program_id , -- Program Id
2387: fnd_global.conc_login_id , -- Program Login ID
2388: 'TAX_RATE' ,
2389: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
2390: 1 ,

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

2383: fnd_global.conc_login_id ,
2384: fnd_global.conc_request_id , -- Request Id
2385: fnd_global.prog_appl_id , -- Program Application ID
2386: fnd_global.conc_program_id , -- Program Id
2387: fnd_global.conc_login_id , -- Program Login ID
2388: 'TAX_RATE' ,
2389: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
2390: 1 ,
2391: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 2477: fnd_global.user_id ,

2473: NULL ,
2474: NULL ,
2475: NULL ,
2476: NULL ,
2477: fnd_global.user_id ,
2478: SYSDATE ,
2479: fnd_global.user_id ,
2480: SYSDATE ,
2481: fnd_global.conc_login_id ,

Line 2479: fnd_global.user_id ,

2475: NULL ,
2476: NULL ,
2477: fnd_global.user_id ,
2478: SYSDATE ,
2479: fnd_global.user_id ,
2480: SYSDATE ,
2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID

Line 2481: fnd_global.conc_login_id ,

2477: fnd_global.user_id ,
2478: SYSDATE ,
2479: fnd_global.user_id ,
2480: SYSDATE ,
2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID
2484: fnd_global.conc_program_id , -- Program Id
2485: fnd_global.conc_login_id , -- Program Login ID

Line 2482: fnd_global.conc_request_id , -- Request Id

2478: SYSDATE ,
2479: fnd_global.user_id ,
2480: SYSDATE ,
2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID
2484: fnd_global.conc_program_id , -- Program Id
2485: fnd_global.conc_login_id , -- Program Login ID
2486: 1

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

2479: fnd_global.user_id ,
2480: SYSDATE ,
2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID
2484: fnd_global.conc_program_id , -- Program Id
2485: fnd_global.conc_login_id , -- Program Login ID
2486: 1
2487: )

Line 2484: fnd_global.conc_program_id , -- Program Id

2480: SYSDATE ,
2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID
2484: fnd_global.conc_program_id , -- Program Id
2485: fnd_global.conc_login_id , -- Program Login ID
2486: 1
2487: )
2488: SELECT

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

2481: fnd_global.conc_login_id ,
2482: fnd_global.conc_request_id , -- Request Id
2483: fnd_global.prog_appl_id , -- Program Application ID
2484: fnd_global.conc_program_id , -- Program Id
2485: fnd_global.conc_login_id , -- Program Login ID
2486: 1
2487: )
2488: SELECT
2489: results.tax_code_id TAX_RATE_ID,

Line 2714: fnd_global.user_id ,

2710: THEN Initcap(TAX_RATE_CODE)
2711: ELSE
2712: TAX_RATE_CODE
2713: END,
2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.user_id ,
2717: SYSDATE ,
2718: fnd_global.conc_login_id ,

Line 2716: fnd_global.user_id ,

2712: TAX_RATE_CODE
2713: END,
2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.user_id ,
2717: SYSDATE ,
2718: fnd_global.conc_login_id ,
2719: L.LANGUAGE_CODE,
2720: userenv('LANG'),

Line 2718: fnd_global.conc_login_id ,

2714: fnd_global.user_id ,
2715: SYSDATE ,
2716: fnd_global.user_id ,
2717: SYSDATE ,
2718: fnd_global.conc_login_id ,
2719: L.LANGUAGE_CODE,
2720: userenv('LANG'),
2721: avtb.description
2722: FROM FND_LANGUAGES L,

Line 2908: fnd_global.user_id ,

2904: ATTRIBUTE15 ,
2905: ATTRIBUTE_CATEGORY ,
2906: zx_rates_b_s.nextval ,--TAX_RATE_ID
2907: CONTENT_OWNER_ID ,
2908: fnd_global.user_id ,
2909: SYSDATE ,
2910: fnd_global.user_id ,
2911: SYSDATE ,
2912: fnd_global.conc_login_id ,

Line 2910: fnd_global.user_id ,

2906: zx_rates_b_s.nextval ,--TAX_RATE_ID
2907: CONTENT_OWNER_ID ,
2908: fnd_global.user_id ,
2909: SYSDATE ,
2910: fnd_global.user_id ,
2911: SYSDATE ,
2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID

Line 2912: fnd_global.conc_login_id ,

2908: fnd_global.user_id ,
2909: SYSDATE ,
2910: fnd_global.user_id ,
2911: SYSDATE ,
2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID
2915: fnd_global.conc_program_id , -- Program Id
2916: fnd_global.conc_login_id , -- Program Login ID

Line 2913: fnd_global.conc_request_id , -- Request Id

2909: SYSDATE ,
2910: fnd_global.user_id ,
2911: SYSDATE ,
2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID
2915: fnd_global.conc_program_id , -- Program Id
2916: fnd_global.conc_login_id , -- Program Login ID
2917: 'TAX_RATE' ,

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

2910: fnd_global.user_id ,
2911: SYSDATE ,
2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID
2915: fnd_global.conc_program_id , -- Program Id
2916: fnd_global.conc_login_id , -- Program Login ID
2917: 'TAX_RATE' ,
2918: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 2915: fnd_global.conc_program_id , -- Program Id

2911: SYSDATE ,
2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID
2915: fnd_global.conc_program_id , -- Program Id
2916: fnd_global.conc_login_id , -- Program Login ID
2917: 'TAX_RATE' ,
2918: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
2919: 1

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

2912: fnd_global.conc_login_id ,
2913: fnd_global.conc_request_id , -- Request Id
2914: fnd_global.prog_appl_id , -- Program Application ID
2915: fnd_global.conc_program_id , -- Program Id
2916: fnd_global.conc_login_id , -- Program Login ID
2917: 'TAX_RATE' ,
2918: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
2919: 1
2920: -- 6820043, commenting out description

Line 3004: fnd_global.user_id ,

3000: NULL ,
3001: NULL ,
3002: NULL ,
3003: NULL ,
3004: fnd_global.user_id ,
3005: SYSDATE ,
3006: fnd_global.user_id ,
3007: SYSDATE ,
3008: fnd_global.conc_login_id ,

Line 3006: fnd_global.user_id ,

3002: NULL ,
3003: NULL ,
3004: fnd_global.user_id ,
3005: SYSDATE ,
3006: fnd_global.user_id ,
3007: SYSDATE ,
3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID

Line 3008: fnd_global.conc_login_id ,

3004: fnd_global.user_id ,
3005: SYSDATE ,
3006: fnd_global.user_id ,
3007: SYSDATE ,
3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID
3011: fnd_global.conc_program_id , -- Program Id
3012: fnd_global.conc_login_id , -- Program Login ID

Line 3009: fnd_global.conc_request_id , -- Request Id

3005: SYSDATE ,
3006: fnd_global.user_id ,
3007: SYSDATE ,
3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID
3011: fnd_global.conc_program_id , -- Program Id
3012: fnd_global.conc_login_id , -- Program Login ID
3013: 1

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

3006: fnd_global.user_id ,
3007: SYSDATE ,
3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID
3011: fnd_global.conc_program_id , -- Program Id
3012: fnd_global.conc_login_id , -- Program Login ID
3013: 1
3014: )

Line 3011: fnd_global.conc_program_id , -- Program Id

3007: SYSDATE ,
3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID
3011: fnd_global.conc_program_id , -- Program Id
3012: fnd_global.conc_login_id , -- Program Login ID
3013: 1
3014: )
3015: SELECT

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

3008: fnd_global.conc_login_id ,
3009: fnd_global.conc_request_id , -- Request Id
3010: fnd_global.prog_appl_id , -- Program Application ID
3011: fnd_global.conc_program_id , -- Program Id
3012: fnd_global.conc_login_id , -- Program Login ID
3013: 1
3014: )
3015: SELECT
3016: DISTINCT

Line 3219: fnd_global.user_id ,

3215: ATTRIBUTE15 ,
3216: ATTRIBUTE_CATEGORY ,
3217: zx_rates_b_s.nextval ,--TAX_RATE_ID
3218: CONTENT_OWNER_ID ,
3219: fnd_global.user_id ,
3220: SYSDATE ,
3221: fnd_global.user_id ,
3222: SYSDATE ,
3223: fnd_global.conc_login_id ,

Line 3221: fnd_global.user_id ,

3217: zx_rates_b_s.nextval ,--TAX_RATE_ID
3218: CONTENT_OWNER_ID ,
3219: fnd_global.user_id ,
3220: SYSDATE ,
3221: fnd_global.user_id ,
3222: SYSDATE ,
3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID

Line 3223: fnd_global.conc_login_id ,

3219: fnd_global.user_id ,
3220: SYSDATE ,
3221: fnd_global.user_id ,
3222: SYSDATE ,
3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID
3226: fnd_global.conc_program_id , -- Program Id
3227: fnd_global.conc_login_id , -- Program Login ID

Line 3224: fnd_global.conc_request_id , -- Request Id

3220: SYSDATE ,
3221: fnd_global.user_id ,
3222: SYSDATE ,
3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID
3226: fnd_global.conc_program_id , -- Program Id
3227: fnd_global.conc_login_id , -- Program Login ID
3228: 'TAX_RATE' ,

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

3221: fnd_global.user_id ,
3222: SYSDATE ,
3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID
3226: fnd_global.conc_program_id , -- Program Id
3227: fnd_global.conc_login_id , -- Program Login ID
3228: 'TAX_RATE' ,
3229: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 3226: fnd_global.conc_program_id , -- Program Id

3222: SYSDATE ,
3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID
3226: fnd_global.conc_program_id , -- Program Id
3227: fnd_global.conc_login_id , -- Program Login ID
3228: 'TAX_RATE' ,
3229: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
3230: 1

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

3223: fnd_global.conc_login_id ,
3224: fnd_global.conc_request_id , -- Request Id
3225: fnd_global.prog_appl_id , -- Program Application ID
3226: fnd_global.conc_program_id , -- Program Id
3227: fnd_global.conc_login_id , -- Program Login ID
3228: 'TAX_RATE' ,
3229: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
3230: 1
3231: -- 6820043, commenting out description

Line 3315: fnd_global.user_id ,

3311: NULL ,
3312: NULL ,
3313: NULL ,
3314: NULL ,
3315: fnd_global.user_id ,
3316: SYSDATE ,
3317: fnd_global.user_id ,
3318: SYSDATE ,
3319: fnd_global.conc_login_id ,

Line 3317: fnd_global.user_id ,

3313: NULL ,
3314: NULL ,
3315: fnd_global.user_id ,
3316: SYSDATE ,
3317: fnd_global.user_id ,
3318: SYSDATE ,
3319: fnd_global.conc_login_id ,
3320: fnd_global.conc_request_id , -- Request Id
3321: fnd_global.prog_appl_id , -- Program Application ID

Line 3319: fnd_global.conc_login_id ,

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

Line 3320: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 3322: fnd_global.conc_program_id , -- Program Id

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

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

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

Line 3537: fnd_global.user_id ,

3533: ATTRIBUTE15 ,
3534: ATTRIBUTE_CATEGORY ,
3535: TAX_RATE_ID ,
3536: CONTENT_OWNER_ID ,
3537: fnd_global.user_id ,
3538: SYSDATE ,
3539: fnd_global.user_id ,
3540: SYSDATE ,
3541: fnd_global.conc_login_id ,

Line 3539: fnd_global.user_id ,

3535: TAX_RATE_ID ,
3536: CONTENT_OWNER_ID ,
3537: fnd_global.user_id ,
3538: SYSDATE ,
3539: fnd_global.user_id ,
3540: SYSDATE ,
3541: fnd_global.conc_login_id ,
3542: fnd_global.conc_request_id , -- Request Id
3543: fnd_global.prog_appl_id , -- Program Application ID

Line 3541: fnd_global.conc_login_id ,

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

Line 3542: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 3544: fnd_global.conc_program_id , -- Program Id

3540: SYSDATE ,
3541: fnd_global.conc_login_id ,
3542: fnd_global.conc_request_id , -- Request Id
3543: fnd_global.prog_appl_id , -- Program Application ID
3544: fnd_global.conc_program_id , -- Program Id
3545: fnd_global.conc_login_id , -- Program Login ID
3546: 'TAX_RATE' ,
3547: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3548: 1 ,

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

3541: fnd_global.conc_login_id ,
3542: fnd_global.conc_request_id , -- Request Id
3543: fnd_global.prog_appl_id , -- Program Application ID
3544: fnd_global.conc_program_id , -- Program Id
3545: fnd_global.conc_login_id , -- Program Login ID
3546: 'TAX_RATE' ,
3547: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3548: 1 ,
3549: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 3635: fnd_global.user_id ,

3631: NULL ,
3632: NULL ,
3633: NULL ,
3634: NULL ,
3635: fnd_global.user_id ,
3636: SYSDATE ,
3637: fnd_global.user_id ,
3638: SYSDATE ,
3639: fnd_global.conc_login_id ,

Line 3637: fnd_global.user_id ,

3633: NULL ,
3634: NULL ,
3635: fnd_global.user_id ,
3636: SYSDATE ,
3637: fnd_global.user_id ,
3638: SYSDATE ,
3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID

Line 3639: fnd_global.conc_login_id ,

3635: fnd_global.user_id ,
3636: SYSDATE ,
3637: fnd_global.user_id ,
3638: SYSDATE ,
3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID
3642: fnd_global.conc_program_id , -- Program Id
3643: fnd_global.conc_login_id , -- Program Login ID

Line 3640: fnd_global.conc_request_id , -- Request Id

3636: SYSDATE ,
3637: fnd_global.user_id ,
3638: SYSDATE ,
3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID
3642: fnd_global.conc_program_id , -- Program Id
3643: fnd_global.conc_login_id , -- Program Login ID
3644: 1

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

3637: fnd_global.user_id ,
3638: SYSDATE ,
3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID
3642: fnd_global.conc_program_id , -- Program Id
3643: fnd_global.conc_login_id , -- Program Login ID
3644: 1
3645: )

Line 3642: fnd_global.conc_program_id , -- Program Id

3638: SYSDATE ,
3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID
3642: fnd_global.conc_program_id , -- Program Id
3643: fnd_global.conc_login_id , -- Program Login ID
3644: 1
3645: )
3646: SELECT

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

3639: fnd_global.conc_login_id ,
3640: fnd_global.conc_request_id , -- Request Id
3641: fnd_global.prog_appl_id , -- Program Application ID
3642: fnd_global.conc_program_id , -- Program Id
3643: fnd_global.conc_login_id , -- Program Login ID
3644: 1
3645: )
3646: SELECT
3647: DISTINCT

Line 3848: fnd_global.user_id ,

3844: ATTRIBUTE15 ,
3845: ATTRIBUTE_CATEGORY ,
3846: TAX_RATE_ID ,
3847: CONTENT_OWNER_ID ,
3848: fnd_global.user_id ,
3849: SYSDATE ,
3850: fnd_global.user_id ,
3851: SYSDATE ,
3852: fnd_global.conc_login_id ,

Line 3850: fnd_global.user_id ,

3846: TAX_RATE_ID ,
3847: CONTENT_OWNER_ID ,
3848: fnd_global.user_id ,
3849: SYSDATE ,
3850: fnd_global.user_id ,
3851: SYSDATE ,
3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID

Line 3852: fnd_global.conc_login_id ,

3848: fnd_global.user_id ,
3849: SYSDATE ,
3850: fnd_global.user_id ,
3851: SYSDATE ,
3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID
3855: fnd_global.conc_program_id , -- Program Id
3856: fnd_global.conc_login_id , -- Program Login ID

Line 3853: fnd_global.conc_request_id , -- Request Id

3849: SYSDATE ,
3850: fnd_global.user_id ,
3851: SYSDATE ,
3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID
3855: fnd_global.conc_program_id , -- Program Id
3856: fnd_global.conc_login_id , -- Program Login ID
3857: 'TAX_RATE' ,

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

3850: fnd_global.user_id ,
3851: SYSDATE ,
3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID
3855: fnd_global.conc_program_id , -- Program Id
3856: fnd_global.conc_login_id , -- Program Login ID
3857: 'TAX_RATE' ,
3858: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG

Line 3855: fnd_global.conc_program_id , -- Program Id

3851: SYSDATE ,
3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID
3855: fnd_global.conc_program_id , -- Program Id
3856: fnd_global.conc_login_id , -- Program Login ID
3857: 'TAX_RATE' ,
3858: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3859: 1 ,

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

3852: fnd_global.conc_login_id ,
3853: fnd_global.conc_request_id , -- Request Id
3854: fnd_global.prog_appl_id , -- Program Application ID
3855: fnd_global.conc_program_id , -- Program Id
3856: fnd_global.conc_login_id , -- Program Login ID
3857: 'TAX_RATE' ,
3858: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3859: 1 ,
3860: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 3946: fnd_global.user_id ,

3942: NULL ,
3943: NULL ,
3944: NULL ,
3945: NULL ,
3946: fnd_global.user_id ,
3947: SYSDATE ,
3948: fnd_global.user_id ,
3949: SYSDATE ,
3950: fnd_global.conc_login_id ,

Line 3948: fnd_global.user_id ,

3944: NULL ,
3945: NULL ,
3946: fnd_global.user_id ,
3947: SYSDATE ,
3948: fnd_global.user_id ,
3949: SYSDATE ,
3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID

Line 3950: fnd_global.conc_login_id ,

3946: fnd_global.user_id ,
3947: SYSDATE ,
3948: fnd_global.user_id ,
3949: SYSDATE ,
3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID
3953: fnd_global.conc_program_id , -- Program Id
3954: fnd_global.conc_login_id , -- Program Login ID

Line 3951: fnd_global.conc_request_id , -- Request Id

3947: SYSDATE ,
3948: fnd_global.user_id ,
3949: SYSDATE ,
3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID
3953: fnd_global.conc_program_id , -- Program Id
3954: fnd_global.conc_login_id , -- Program Login ID
3955: 1

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

3948: fnd_global.user_id ,
3949: SYSDATE ,
3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID
3953: fnd_global.conc_program_id , -- Program Id
3954: fnd_global.conc_login_id , -- Program Login ID
3955: 1
3956: )

Line 3953: fnd_global.conc_program_id , -- Program Id

3949: SYSDATE ,
3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID
3953: fnd_global.conc_program_id , -- Program Id
3954: fnd_global.conc_login_id , -- Program Login ID
3955: 1
3956: )
3957: SELECT

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

3950: fnd_global.conc_login_id ,
3951: fnd_global.conc_request_id , -- Request Id
3952: fnd_global.prog_appl_id , -- Program Application ID
3953: fnd_global.conc_program_id , -- Program Id
3954: fnd_global.conc_login_id , -- Program Login ID
3955: 1
3956: )
3957: SELECT
3958: DISTINCT

Line 4068: fnd_global.user_id ,

4064: CASE WHEN TAX_RATE_CODE = UPPER(TAX_RATE_CODE)
4065: THEN Initcap(TAX_RATE_CODE)
4066: ELSE TAX_RATE_CODE
4067: END ,
4068: fnd_global.user_id ,
4069: SYSDATE ,
4070: fnd_global.user_id ,
4071: SYSDATE ,
4072: fnd_global.conc_login_id ,

Line 4070: fnd_global.user_id ,

4066: ELSE TAX_RATE_CODE
4067: END ,
4068: fnd_global.user_id ,
4069: SYSDATE ,
4070: fnd_global.user_id ,
4071: SYSDATE ,
4072: fnd_global.conc_login_id ,
4073: L.LANGUAGE_CODE,
4074: userenv('LANG'),

Line 4072: fnd_global.conc_login_id ,

4068: fnd_global.user_id ,
4069: SYSDATE ,
4070: fnd_global.user_id ,
4071: SYSDATE ,
4072: fnd_global.conc_login_id ,
4073: L.LANGUAGE_CODE,
4074: userenv('LANG'),
4075: avtb.description
4076: FROM FND_LANGUAGES L,

Line 4258: fnd_global.user_id ,

4254: ATTRIBUTE15 ,
4255: ATTRIBUTE_CATEGORY ,
4256: zx_rates_b_s.nextval ,--TAX_RATE_ID
4257: CONTENT_OWNER_ID ,
4258: fnd_global.user_id ,
4259: SYSDATE ,
4260: fnd_global.user_id ,
4261: SYSDATE ,
4262: fnd_global.conc_login_id ,

Line 4260: fnd_global.user_id ,

4256: zx_rates_b_s.nextval ,--TAX_RATE_ID
4257: CONTENT_OWNER_ID ,
4258: fnd_global.user_id ,
4259: SYSDATE ,
4260: fnd_global.user_id ,
4261: SYSDATE ,
4262: fnd_global.conc_login_id ,
4263: fnd_global.conc_request_id , -- Request Id
4264: fnd_global.prog_appl_id , -- Program Application ID

Line 4262: fnd_global.conc_login_id ,

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

Line 4263: fnd_global.conc_request_id , -- Request Id

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

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

4260: fnd_global.user_id ,
4261: SYSDATE ,
4262: fnd_global.conc_login_id ,
4263: fnd_global.conc_request_id , -- Request Id
4264: fnd_global.prog_appl_id , -- Program Application ID
4265: fnd_global.conc_program_id , -- Program Id
4266: fnd_global.conc_login_id , -- Program Login ID
4267: 'TAX_RATE' ,
4268: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4265: fnd_global.conc_program_id , -- Program Id

4261: SYSDATE ,
4262: fnd_global.conc_login_id ,
4263: fnd_global.conc_request_id , -- Request Id
4264: fnd_global.prog_appl_id , -- Program Application ID
4265: fnd_global.conc_program_id , -- Program Id
4266: fnd_global.conc_login_id , -- Program Login ID
4267: 'TAX_RATE' ,
4268: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4269: 1

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

4262: fnd_global.conc_login_id ,
4263: fnd_global.conc_request_id , -- Request Id
4264: fnd_global.prog_appl_id , -- Program Application ID
4265: fnd_global.conc_program_id , -- Program Id
4266: fnd_global.conc_login_id , -- Program Login ID
4267: 'TAX_RATE' ,
4268: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4269: 1
4270: -- 6820043, commenting out description

Line 4354: fnd_global.user_id ,

4350: NULL ,
4351: NULL ,
4352: NULL ,
4353: NULL ,
4354: fnd_global.user_id ,
4355: SYSDATE ,
4356: fnd_global.user_id ,
4357: SYSDATE ,
4358: fnd_global.conc_login_id ,

Line 4356: fnd_global.user_id ,

4352: NULL ,
4353: NULL ,
4354: fnd_global.user_id ,
4355: SYSDATE ,
4356: fnd_global.user_id ,
4357: SYSDATE ,
4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID

Line 4358: fnd_global.conc_login_id ,

4354: fnd_global.user_id ,
4355: SYSDATE ,
4356: fnd_global.user_id ,
4357: SYSDATE ,
4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID
4361: fnd_global.conc_program_id , -- Program Id
4362: fnd_global.conc_login_id , -- Program Login ID

Line 4359: fnd_global.conc_request_id , -- Request Id

4355: SYSDATE ,
4356: fnd_global.user_id ,
4357: SYSDATE ,
4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID
4361: fnd_global.conc_program_id , -- Program Id
4362: fnd_global.conc_login_id , -- Program Login ID
4363: 1

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

4356: fnd_global.user_id ,
4357: SYSDATE ,
4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID
4361: fnd_global.conc_program_id , -- Program Id
4362: fnd_global.conc_login_id , -- Program Login ID
4363: 1
4364: )

Line 4361: fnd_global.conc_program_id , -- Program Id

4357: SYSDATE ,
4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID
4361: fnd_global.conc_program_id , -- Program Id
4362: fnd_global.conc_login_id , -- Program Login ID
4363: 1
4364: )
4365: SELECT

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

4358: fnd_global.conc_login_id ,
4359: fnd_global.conc_request_id , -- Request Id
4360: fnd_global.prog_appl_id , -- Program Application ID
4361: fnd_global.conc_program_id , -- Program Id
4362: fnd_global.conc_login_id , -- Program Login ID
4363: 1
4364: )
4365: SELECT
4366: results.tax_code_id TAX_RATE_ID,

Line 4567: fnd_global.user_id ,

4563: ATTRIBUTE15 ,
4564: ATTRIBUTE_CATEGORY ,
4565: zx_rates_b_s.nextval ,--TAX_RATE_ID
4566: CONTENT_OWNER_ID ,
4567: fnd_global.user_id ,
4568: SYSDATE ,
4569: fnd_global.user_id ,
4570: SYSDATE ,
4571: fnd_global.conc_login_id ,

Line 4569: fnd_global.user_id ,

4565: zx_rates_b_s.nextval ,--TAX_RATE_ID
4566: CONTENT_OWNER_ID ,
4567: fnd_global.user_id ,
4568: SYSDATE ,
4569: fnd_global.user_id ,
4570: SYSDATE ,
4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID

Line 4571: fnd_global.conc_login_id ,

4567: fnd_global.user_id ,
4568: SYSDATE ,
4569: fnd_global.user_id ,
4570: SYSDATE ,
4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID
4574: fnd_global.conc_program_id , -- Program Id
4575: fnd_global.conc_login_id , -- Program Login ID

Line 4572: fnd_global.conc_request_id , -- Request Id

4568: SYSDATE ,
4569: fnd_global.user_id ,
4570: SYSDATE ,
4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID
4574: fnd_global.conc_program_id , -- Program Id
4575: fnd_global.conc_login_id , -- Program Login ID
4576: 'TAX_RATE' ,

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

4569: fnd_global.user_id ,
4570: SYSDATE ,
4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID
4574: fnd_global.conc_program_id , -- Program Id
4575: fnd_global.conc_login_id , -- Program Login ID
4576: 'TAX_RATE' ,
4577: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4574: fnd_global.conc_program_id , -- Program Id

4570: SYSDATE ,
4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID
4574: fnd_global.conc_program_id , -- Program Id
4575: fnd_global.conc_login_id , -- Program Login ID
4576: 'TAX_RATE' ,
4577: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4578: 1

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

4571: fnd_global.conc_login_id ,
4572: fnd_global.conc_request_id , -- Request Id
4573: fnd_global.prog_appl_id , -- Program Application ID
4574: fnd_global.conc_program_id , -- Program Id
4575: fnd_global.conc_login_id , -- Program Login ID
4576: 'TAX_RATE' ,
4577: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4578: 1
4579: -- 6820043, commenting out description

Line 4663: fnd_global.user_id ,

4659: NULL ,
4660: NULL ,
4661: NULL ,
4662: NULL ,
4663: fnd_global.user_id ,
4664: SYSDATE ,
4665: fnd_global.user_id ,
4666: SYSDATE ,
4667: fnd_global.conc_login_id ,

Line 4665: fnd_global.user_id ,

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

Line 4667: fnd_global.conc_login_id ,

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

Line 4668: fnd_global.conc_request_id , -- Request Id

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

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

4665: fnd_global.user_id ,
4666: SYSDATE ,
4667: fnd_global.conc_login_id ,
4668: fnd_global.conc_request_id , -- Request Id
4669: fnd_global.prog_appl_id , -- Program Application ID
4670: fnd_global.conc_program_id , -- Program Id
4671: fnd_global.conc_login_id , -- Program Login ID
4672: 1
4673: )

Line 4670: fnd_global.conc_program_id , -- Program Id

4666: SYSDATE ,
4667: fnd_global.conc_login_id ,
4668: fnd_global.conc_request_id , -- Request Id
4669: fnd_global.prog_appl_id , -- Program Application ID
4670: fnd_global.conc_program_id , -- Program Id
4671: fnd_global.conc_login_id , -- Program Login ID
4672: 1
4673: )
4674: SELECT

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

4667: fnd_global.conc_login_id ,
4668: fnd_global.conc_request_id , -- Request Id
4669: fnd_global.prog_appl_id , -- Program Application ID
4670: fnd_global.conc_program_id , -- Program Id
4671: fnd_global.conc_login_id , -- Program Login ID
4672: 1
4673: )
4674: SELECT
4675: results.tax_code_id TAX_RATE_ID,

Line 4881: fnd_global.user_id ,

4877: ATTRIBUTE15 ,
4878: ATTRIBUTE_CATEGORY ,
4879: TAX_RATE_ID ,
4880: CONTENT_OWNER_ID ,
4881: fnd_global.user_id ,
4882: SYSDATE ,
4883: fnd_global.user_id ,
4884: SYSDATE ,
4885: fnd_global.conc_login_id ,

Line 4883: fnd_global.user_id ,

4879: TAX_RATE_ID ,
4880: CONTENT_OWNER_ID ,
4881: fnd_global.user_id ,
4882: SYSDATE ,
4883: fnd_global.user_id ,
4884: SYSDATE ,
4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID

Line 4885: fnd_global.conc_login_id ,

4881: fnd_global.user_id ,
4882: SYSDATE ,
4883: fnd_global.user_id ,
4884: SYSDATE ,
4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID
4888: fnd_global.conc_program_id , -- Program Id
4889: fnd_global.conc_login_id , -- Program Login ID

Line 4886: fnd_global.conc_request_id , -- Request Id

4882: SYSDATE ,
4883: fnd_global.user_id ,
4884: SYSDATE ,
4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID
4888: fnd_global.conc_program_id , -- Program Id
4889: fnd_global.conc_login_id , -- Program Login ID
4890: 'TAX_RATE' ,

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

4883: fnd_global.user_id ,
4884: SYSDATE ,
4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID
4888: fnd_global.conc_program_id , -- Program Id
4889: fnd_global.conc_login_id , -- Program Login ID
4890: 'TAX_RATE' ,
4891: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4888: fnd_global.conc_program_id , -- Program Id

4884: SYSDATE ,
4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID
4888: fnd_global.conc_program_id , -- Program Id
4889: fnd_global.conc_login_id , -- Program Login ID
4890: 'TAX_RATE' ,
4891: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4892: 1 ,

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

4885: fnd_global.conc_login_id ,
4886: fnd_global.conc_request_id , -- Request Id
4887: fnd_global.prog_appl_id , -- Program Application ID
4888: fnd_global.conc_program_id , -- Program Id
4889: fnd_global.conc_login_id , -- Program Login ID
4890: 'TAX_RATE' ,
4891: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4892: 1 ,
4893: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 4979: fnd_global.user_id ,

4975: NULL ,
4976: NULL ,
4977: NULL ,
4978: NULL ,
4979: fnd_global.user_id ,
4980: SYSDATE ,
4981: fnd_global.user_id ,
4982: SYSDATE ,
4983: fnd_global.conc_login_id ,

Line 4981: fnd_global.user_id ,

4977: NULL ,
4978: NULL ,
4979: fnd_global.user_id ,
4980: SYSDATE ,
4981: fnd_global.user_id ,
4982: SYSDATE ,
4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID

Line 4983: fnd_global.conc_login_id ,

4979: fnd_global.user_id ,
4980: SYSDATE ,
4981: fnd_global.user_id ,
4982: SYSDATE ,
4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID
4986: fnd_global.conc_program_id , -- Program Id
4987: fnd_global.conc_login_id , -- Program Login ID

Line 4984: fnd_global.conc_request_id , -- Request Id

4980: SYSDATE ,
4981: fnd_global.user_id ,
4982: SYSDATE ,
4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID
4986: fnd_global.conc_program_id , -- Program Id
4987: fnd_global.conc_login_id , -- Program Login ID
4988: 1

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

4981: fnd_global.user_id ,
4982: SYSDATE ,
4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID
4986: fnd_global.conc_program_id , -- Program Id
4987: fnd_global.conc_login_id , -- Program Login ID
4988: 1
4989: )

Line 4986: fnd_global.conc_program_id , -- Program Id

4982: SYSDATE ,
4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID
4986: fnd_global.conc_program_id , -- Program Id
4987: fnd_global.conc_login_id , -- Program Login ID
4988: 1
4989: )
4990: SELECT

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

4983: fnd_global.conc_login_id ,
4984: fnd_global.conc_request_id , -- Request Id
4985: fnd_global.prog_appl_id , -- Program Application ID
4986: fnd_global.conc_program_id , -- Program Id
4987: fnd_global.conc_login_id , -- Program Login ID
4988: 1
4989: )
4990: SELECT
4991: results.tax_code_id TAX_RATE_ID,

Line 5192: fnd_global.user_id ,

5188: ATTRIBUTE15 ,
5189: ATTRIBUTE_CATEGORY ,
5190: TAX_RATE_ID ,
5191: CONTENT_OWNER_ID ,
5192: fnd_global.user_id ,
5193: SYSDATE ,
5194: fnd_global.user_id ,
5195: SYSDATE ,
5196: fnd_global.conc_login_id ,

Line 5194: fnd_global.user_id ,

5190: TAX_RATE_ID ,
5191: CONTENT_OWNER_ID ,
5192: fnd_global.user_id ,
5193: SYSDATE ,
5194: fnd_global.user_id ,
5195: SYSDATE ,
5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID

Line 5196: fnd_global.conc_login_id ,

5192: fnd_global.user_id ,
5193: SYSDATE ,
5194: fnd_global.user_id ,
5195: SYSDATE ,
5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID
5199: fnd_global.conc_program_id , -- Program Id
5200: fnd_global.conc_login_id , -- Program Login ID

Line 5197: fnd_global.conc_request_id , -- Request Id

5193: SYSDATE ,
5194: fnd_global.user_id ,
5195: SYSDATE ,
5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID
5199: fnd_global.conc_program_id , -- Program Id
5200: fnd_global.conc_login_id , -- Program Login ID
5201: 'TAX_RATE' ,

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

5194: fnd_global.user_id ,
5195: SYSDATE ,
5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID
5199: fnd_global.conc_program_id , -- Program Id
5200: fnd_global.conc_login_id , -- Program Login ID
5201: 'TAX_RATE' ,
5202: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5199: fnd_global.conc_program_id , -- Program Id

5195: SYSDATE ,
5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID
5199: fnd_global.conc_program_id , -- Program Id
5200: fnd_global.conc_login_id , -- Program Login ID
5201: 'TAX_RATE' ,
5202: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5203: 1 ,

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

5196: fnd_global.conc_login_id ,
5197: fnd_global.conc_request_id , -- Request Id
5198: fnd_global.prog_appl_id , -- Program Application ID
5199: fnd_global.conc_program_id , -- Program Id
5200: fnd_global.conc_login_id , -- Program Login ID
5201: 'TAX_RATE' ,
5202: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5203: 1 ,
5204: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 5290: fnd_global.user_id ,

5286: NULL ,
5287: NULL ,
5288: NULL ,
5289: NULL ,
5290: fnd_global.user_id ,
5291: SYSDATE ,
5292: fnd_global.user_id ,
5293: SYSDATE ,
5294: fnd_global.conc_login_id ,

Line 5292: fnd_global.user_id ,

5288: NULL ,
5289: NULL ,
5290: fnd_global.user_id ,
5291: SYSDATE ,
5292: fnd_global.user_id ,
5293: SYSDATE ,
5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID

Line 5294: fnd_global.conc_login_id ,

5290: fnd_global.user_id ,
5291: SYSDATE ,
5292: fnd_global.user_id ,
5293: SYSDATE ,
5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID
5297: fnd_global.conc_program_id , -- Program Id
5298: fnd_global.conc_login_id , -- Program Login ID

Line 5295: fnd_global.conc_request_id , -- Request Id

5291: SYSDATE ,
5292: fnd_global.user_id ,
5293: SYSDATE ,
5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID
5297: fnd_global.conc_program_id , -- Program Id
5298: fnd_global.conc_login_id , -- Program Login ID
5299: 1

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

5292: fnd_global.user_id ,
5293: SYSDATE ,
5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID
5297: fnd_global.conc_program_id , -- Program Id
5298: fnd_global.conc_login_id , -- Program Login ID
5299: 1
5300: )

Line 5297: fnd_global.conc_program_id , -- Program Id

5293: SYSDATE ,
5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID
5297: fnd_global.conc_program_id , -- Program Id
5298: fnd_global.conc_login_id , -- Program Login ID
5299: 1
5300: )
5301: SELECT

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

5294: fnd_global.conc_login_id ,
5295: fnd_global.conc_request_id , -- Request Id
5296: fnd_global.prog_appl_id , -- Program Application ID
5297: fnd_global.conc_program_id , -- Program Id
5298: fnd_global.conc_login_id , -- Program Login ID
5299: 1
5300: )
5301: SELECT
5302: results.tax_code_id TAX_RATE_ID,

Line 5409: fnd_global.user_id ,

5405: CASE WHEN TAX_RATE_CODE = UPPER(TAX_RATE_CODE)
5406: THEN Initcap(TAX_RATE_CODE)
5407: ELSE TAX_RATE_CODE
5408: END ,
5409: fnd_global.user_id ,
5410: SYSDATE ,
5411: fnd_global.user_id ,
5412: SYSDATE ,
5413: fnd_global.conc_login_id ,

Line 5411: fnd_global.user_id ,

5407: ELSE TAX_RATE_CODE
5408: END ,
5409: fnd_global.user_id ,
5410: SYSDATE ,
5411: fnd_global.user_id ,
5412: SYSDATE ,
5413: fnd_global.conc_login_id ,
5414: L.LANGUAGE_CODE,
5415: userenv('LANG'),

Line 5413: fnd_global.conc_login_id ,

5409: fnd_global.user_id ,
5410: SYSDATE ,
5411: fnd_global.user_id ,
5412: SYSDATE ,
5413: fnd_global.conc_login_id ,
5414: L.LANGUAGE_CODE,
5415: userenv('LANG'),
5416: avtb.description
5417: FROM FND_LANGUAGES L,

Line 5583: fnd_global.user_id ,

5579: RECORD_TYPE_CODE ,
5580: 'INPUT' ,
5581: ZX_RATES_B_S.NEXTVAL ,
5582: CONTENT_OWNER_ID ,
5583: fnd_global.user_id ,
5584: SYSDATE ,
5585: fnd_global.user_id ,
5586: SYSDATE ,
5587: fnd_global.conc_login_id ,

Line 5585: fnd_global.user_id ,

5581: ZX_RATES_B_S.NEXTVAL ,
5582: CONTENT_OWNER_ID ,
5583: fnd_global.user_id ,
5584: SYSDATE ,
5585: fnd_global.user_id ,
5586: SYSDATE ,
5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID

Line 5587: fnd_global.conc_login_id ,

5583: fnd_global.user_id ,
5584: SYSDATE ,
5585: fnd_global.user_id ,
5586: SYSDATE ,
5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID
5590: fnd_global.conc_program_id , -- Program Id
5591: fnd_global.conc_login_id , -- Program Login ID

Line 5588: fnd_global.conc_request_id , -- Request Id

5584: SYSDATE ,
5585: fnd_global.user_id ,
5586: SYSDATE ,
5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID
5590: fnd_global.conc_program_id , -- Program Id
5591: fnd_global.conc_login_id , -- Program Login ID
5592: 'TAX_RATE' ,

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

5585: fnd_global.user_id ,
5586: SYSDATE ,
5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID
5590: fnd_global.conc_program_id , -- Program Id
5591: fnd_global.conc_login_id , -- Program Login ID
5592: 'TAX_RATE' ,
5593: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5590: fnd_global.conc_program_id , -- Program Id

5586: SYSDATE ,
5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID
5590: fnd_global.conc_program_id , -- Program Id
5591: fnd_global.conc_login_id , -- Program Login ID
5592: 'TAX_RATE' ,
5593: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5594: 1

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

5587: fnd_global.conc_login_id ,
5588: fnd_global.conc_request_id , -- Request Id
5589: fnd_global.prog_appl_id , -- Program Application ID
5590: fnd_global.conc_program_id , -- Program Id
5591: fnd_global.conc_login_id , -- Program Login ID
5592: 'TAX_RATE' ,
5593: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5594: 1
5595: FROM

Line 5712: fnd_global.user_id ,

5708: THEN Initcap(TAX_RATE_CODE)
5709: ELSE
5710: TAX_RATE_CODE
5711: END,
5712: fnd_global.user_id ,
5713: SYSDATE ,
5714: fnd_global.user_id ,
5715: SYSDATE ,
5716: fnd_global.conc_login_id ,

Line 5714: fnd_global.user_id ,

5710: TAX_RATE_CODE
5711: END,
5712: fnd_global.user_id ,
5713: SYSDATE ,
5714: fnd_global.user_id ,
5715: SYSDATE ,
5716: fnd_global.conc_login_id ,
5717: L.LANGUAGE_CODE,
5718: userenv('LANG'),

Line 5716: fnd_global.conc_login_id ,

5712: fnd_global.user_id ,
5713: SYSDATE ,
5714: fnd_global.user_id ,
5715: SYSDATE ,
5716: fnd_global.conc_login_id ,
5717: L.LANGUAGE_CODE,
5718: userenv('LANG'),
5719: avtb.description
5720: FROM FND_LANGUAGES L,

Line 5861: fnd_global.user_id ,

5857: RECORD_TYPE_CODE ,
5858: 'INPUT' ,
5859: ZX_RATES_B_S.NEXTVAL ,
5860: CONTENT_OWNER_ID ,
5861: fnd_global.user_id ,
5862: SYSDATE ,
5863: fnd_global.user_id ,
5864: SYSDATE ,
5865: fnd_global.conc_login_id ,

Line 5863: fnd_global.user_id ,

5859: ZX_RATES_B_S.NEXTVAL ,
5860: CONTENT_OWNER_ID ,
5861: fnd_global.user_id ,
5862: SYSDATE ,
5863: fnd_global.user_id ,
5864: SYSDATE ,
5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID

Line 5865: fnd_global.conc_login_id ,

5861: fnd_global.user_id ,
5862: SYSDATE ,
5863: fnd_global.user_id ,
5864: SYSDATE ,
5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID
5868: fnd_global.conc_program_id , -- Program Id
5869: fnd_global.conc_login_id , -- Program Login ID

Line 5866: fnd_global.conc_request_id , -- Request Id

5862: SYSDATE ,
5863: fnd_global.user_id ,
5864: SYSDATE ,
5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID
5868: fnd_global.conc_program_id , -- Program Id
5869: fnd_global.conc_login_id , -- Program Login ID
5870: 'TAX_RATE' ,

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

5863: fnd_global.user_id ,
5864: SYSDATE ,
5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID
5868: fnd_global.conc_program_id , -- Program Id
5869: fnd_global.conc_login_id , -- Program Login ID
5870: 'TAX_RATE' ,
5871: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5868: fnd_global.conc_program_id , -- Program Id

5864: SYSDATE ,
5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID
5868: fnd_global.conc_program_id , -- Program Id
5869: fnd_global.conc_login_id , -- Program Login ID
5870: 'TAX_RATE' ,
5871: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5872: 1

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

5865: fnd_global.conc_login_id ,
5866: fnd_global.conc_request_id , -- Request Id
5867: fnd_global.prog_appl_id , -- Program Application ID
5868: fnd_global.conc_program_id , -- Program Id
5869: fnd_global.conc_login_id , -- Program Login ID
5870: 'TAX_RATE' ,
5871: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5872: 1
5873: FROM

Line 6052: fnd_global.user_id ,

6048: RECORD_TYPE_CODE ,
6049: 'INPUT' ,
6050: ZX_RATES_B_S.NEXTVAL ,
6051: CONTENT_OWNER_ID ,
6052: fnd_global.user_id ,
6053: SYSDATE ,
6054: fnd_global.user_id ,
6055: SYSDATE ,
6056: fnd_global.conc_login_id ,

Line 6054: fnd_global.user_id ,

6050: ZX_RATES_B_S.NEXTVAL ,
6051: CONTENT_OWNER_ID ,
6052: fnd_global.user_id ,
6053: SYSDATE ,
6054: fnd_global.user_id ,
6055: SYSDATE ,
6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID

Line 6056: fnd_global.conc_login_id ,

6052: fnd_global.user_id ,
6053: SYSDATE ,
6054: fnd_global.user_id ,
6055: SYSDATE ,
6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID
6059: fnd_global.conc_program_id , -- Program Id
6060: fnd_global.conc_login_id , -- Program Login ID

Line 6057: fnd_global.conc_request_id , -- Request Id

6053: SYSDATE ,
6054: fnd_global.user_id ,
6055: SYSDATE ,
6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID
6059: fnd_global.conc_program_id , -- Program Id
6060: fnd_global.conc_login_id , -- Program Login ID
6061: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE

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

6054: fnd_global.user_id ,
6055: SYSDATE ,
6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID
6059: fnd_global.conc_program_id , -- Program Id
6060: fnd_global.conc_login_id , -- Program Login ID
6061: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6062: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 6059: fnd_global.conc_program_id , -- Program Id

6055: SYSDATE ,
6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID
6059: fnd_global.conc_program_id , -- Program Id
6060: fnd_global.conc_login_id , -- Program Login ID
6061: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6062: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
6063: 1

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

6056: fnd_global.conc_login_id ,
6057: fnd_global.conc_request_id , -- Request Id
6058: fnd_global.prog_appl_id , -- Program Application ID
6059: fnd_global.conc_program_id , -- Program Id
6060: fnd_global.conc_login_id , -- Program Login ID
6061: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6062: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
6063: 1
6064: FROM

Line 6134: fnd_global.user_id ,

6130: THEN Initcap(TAX_RATE_CODE)
6131: ELSE
6132: TAX_RATE_CODE
6133: END ,
6134: fnd_global.user_id ,
6135: SYSDATE ,
6136: fnd_global.user_id ,
6137: SYSDATE ,
6138: fnd_global.conc_login_id ,

Line 6136: fnd_global.user_id ,

6132: TAX_RATE_CODE
6133: END ,
6134: fnd_global.user_id ,
6135: SYSDATE ,
6136: fnd_global.user_id ,
6137: SYSDATE ,
6138: fnd_global.conc_login_id ,
6139: L.LANGUAGE_CODE,
6140: userenv('LANG')

Line 6138: fnd_global.conc_login_id ,

6134: fnd_global.user_id ,
6135: SYSDATE ,
6136: fnd_global.user_id ,
6137: SYSDATE ,
6138: fnd_global.conc_login_id ,
6139: L.LANGUAGE_CODE,
6140: userenv('LANG')
6141: FROM FND_LANGUAGES L,
6142: ZX_RATES_B RATES

Line 6281: fnd_global.user_id,

6277: NULL,
6278: NULL,
6279: NULL,
6280: SYSDATE,
6281: fnd_global.user_id,
6282: SYSDATE,
6283: fnd_global.user_id,
6284: fnd_global.conc_login_id,
6285: fnd_global.conc_request_id ,-- Request Id

Line 6283: fnd_global.user_id,

6279: NULL,
6280: SYSDATE,
6281: fnd_global.user_id,
6282: SYSDATE,
6283: fnd_global.user_id,
6284: fnd_global.conc_login_id,
6285: fnd_global.conc_request_id ,-- Request Id
6286: 1
6287: FROM

Line 6284: fnd_global.conc_login_id,

6280: SYSDATE,
6281: fnd_global.user_id,
6282: SYSDATE,
6283: fnd_global.user_id,
6284: fnd_global.conc_login_id,
6285: fnd_global.conc_request_id ,-- Request Id
6286: 1
6287: FROM
6288: (

Line 6285: fnd_global.conc_request_id ,-- Request Id

6281: fnd_global.user_id,
6282: SYSDATE,
6283: fnd_global.user_id,
6284: fnd_global.conc_login_id,
6285: fnd_global.conc_request_id ,-- Request Id
6286: 1
6287: FROM
6288: (
6289: SELECT TAX_REGIME_CODE,

Line 6417: fnd_global.user_id,

6413: NULL,
6414: NULL,
6415: NULL,
6416: SYSDATE,
6417: fnd_global.user_id,
6418: SYSDATE,
6419: fnd_global.user_id,
6420: fnd_global.conc_login_id,
6421: fnd_global.conc_request_id ,-- Request Id

Line 6419: fnd_global.user_id,

6415: NULL,
6416: SYSDATE,
6417: fnd_global.user_id,
6418: SYSDATE,
6419: fnd_global.user_id,
6420: fnd_global.conc_login_id,
6421: fnd_global.conc_request_id ,-- Request Id
6422: 1
6423: FROM

Line 6420: fnd_global.conc_login_id,

6416: SYSDATE,
6417: fnd_global.user_id,
6418: SYSDATE,
6419: fnd_global.user_id,
6420: fnd_global.conc_login_id,
6421: fnd_global.conc_request_id ,-- Request Id
6422: 1
6423: FROM
6424:

Line 6421: fnd_global.conc_request_id ,-- Request Id

6417: fnd_global.user_id,
6418: SYSDATE,
6419: fnd_global.user_id,
6420: fnd_global.conc_login_id,
6421: fnd_global.conc_request_id ,-- Request Id
6422: 1
6423: FROM
6424:
6425: (SELECT

Line 6550: fnd_global.user_id,

6546: NULL,
6547: NULL,
6548: NULL,
6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: fnd_global.conc_request_id ,-- Request Id

Line 6552: fnd_global.user_id,

6548: NULL,
6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: fnd_global.conc_request_id ,-- Request Id
6555: 1
6556: FROM

Line 6553: fnd_global.conc_login_id,

6549: SYSDATE,
6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: fnd_global.conc_request_id ,-- Request Id
6555: 1
6556: FROM
6557:

Line 6554: fnd_global.conc_request_id ,-- Request Id

6550: fnd_global.user_id,
6551: SYSDATE,
6552: fnd_global.user_id,
6553: fnd_global.conc_login_id,
6554: fnd_global.conc_request_id ,-- Request Id
6555: 1
6556: FROM
6557:
6558: (SELECT

Line 6628: fnd_global.user_id,

6624: ELSE
6625: lookups.MEANING
6626: END,
6627: SYSDATE,
6628: fnd_global.user_id,
6629: SYSDATE,
6630: fnd_global.user_id,
6631: fnd_global.conc_login_id,
6632: L.LANGUAGE_CODE,

Line 6630: fnd_global.user_id,

6626: END,
6627: SYSDATE,
6628: fnd_global.user_id,
6629: SYSDATE,
6630: fnd_global.user_id,
6631: fnd_global.conc_login_id,
6632: L.LANGUAGE_CODE,
6633: userenv('LANG')
6634: FROM

Line 6631: fnd_global.conc_login_id,

6627: SYSDATE,
6628: fnd_global.user_id,
6629: SYSDATE,
6630: fnd_global.user_id,
6631: fnd_global.conc_login_id,
6632: L.LANGUAGE_CODE,
6633: userenv('LANG')
6634: FROM
6635: FND_LANGUAGES L,

Line 6691: fnd_global.user_id,

6687: ELSE
6688: TAX_STATUS_CODE
6689: END,
6690: SYSDATE,
6691: fnd_global.user_id,
6692: SYSDATE,
6693: fnd_global.user_id,
6694: fnd_global.conc_login_id,
6695: L.LANGUAGE_CODE,

Line 6693: fnd_global.user_id,

6689: END,
6690: SYSDATE,
6691: fnd_global.user_id,
6692: SYSDATE,
6693: fnd_global.user_id,
6694: fnd_global.conc_login_id,
6695: L.LANGUAGE_CODE,
6696: userenv('LANG')
6697: FROM

Line 6694: fnd_global.conc_login_id,

6690: SYSDATE,
6691: fnd_global.user_id,
6692: SYSDATE,
6693: fnd_global.user_id,
6694: fnd_global.conc_login_id,
6695: L.LANGUAGE_CODE,
6696: userenv('LANG')
6697: FROM
6698: FND_LANGUAGES L,

Line 7023: fnd_global.user_id ,

7019: COLL_TAX_AUTHORITY_ID ,
7020: NULL ,--THRSHLD_CHK_TMPLT_CODE
7021: DEF_PRIMARY_REC_RATE_CODE ,
7022: NULL ,
7023: fnd_global.user_id ,
7024: SYSDATE ,
7025: fnd_global.user_id ,
7026: SYSDATE ,
7027: fnd_global.conc_login_id ,

Line 7025: fnd_global.user_id ,

7021: DEF_PRIMARY_REC_RATE_CODE ,
7022: NULL ,
7023: fnd_global.user_id ,
7024: SYSDATE ,
7025: fnd_global.user_id ,
7026: SYSDATE ,
7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID

Line 7027: fnd_global.conc_login_id ,

7023: fnd_global.user_id ,
7024: SYSDATE ,
7025: fnd_global.user_id ,
7026: SYSDATE ,
7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID
7030: fnd_global.conc_program_id ,--Program Id
7031: fnd_global.conc_login_id ,--Program Login ID

Line 7028: fnd_global.conc_request_id ,--Request Id

7024: SYSDATE ,
7025: fnd_global.user_id ,
7026: SYSDATE ,
7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID
7030: fnd_global.conc_program_id ,--Program Id
7031: fnd_global.conc_login_id ,--Program Login ID
7032: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7025: fnd_global.user_id ,
7026: SYSDATE ,
7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID
7030: fnd_global.conc_program_id ,--Program Id
7031: fnd_global.conc_login_id ,--Program Login ID
7032: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7033: 1 ,

Line 7030: fnd_global.conc_program_id ,--Program Id

7026: SYSDATE ,
7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID
7030: fnd_global.conc_program_id ,--Program Id
7031: fnd_global.conc_login_id ,--Program Login ID
7032: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7033: 1 ,
7034: DECODE((select tax_type_code

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

7027: fnd_global.conc_login_id ,
7028: fnd_global.conc_request_id ,--Request Id
7029: fnd_global.prog_appl_id ,--Program Application ID
7030: fnd_global.conc_program_id ,--Program Id
7031: fnd_global.conc_login_id ,--Program Login ID
7032: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7033: 1 ,
7034: DECODE((select tax_type_code
7035: from

Line 7419: fnd_global.user_id ,

7415: COLL_TAX_AUTHORITY_ID ,
7416: NULL ,--THRSHLD_CHK_TMPLT_CODE
7417: DEF_PRIMARY_REC_RATE_CODE ,
7418: NULL ,
7419: fnd_global.user_id ,
7420: SYSDATE ,
7421: fnd_global.user_id ,
7422: SYSDATE ,
7423: fnd_global.conc_login_id ,

Line 7421: fnd_global.user_id ,

7417: DEF_PRIMARY_REC_RATE_CODE ,
7418: NULL ,
7419: fnd_global.user_id ,
7420: SYSDATE ,
7421: fnd_global.user_id ,
7422: SYSDATE ,
7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID

Line 7423: fnd_global.conc_login_id ,

7419: fnd_global.user_id ,
7420: SYSDATE ,
7421: fnd_global.user_id ,
7422: SYSDATE ,
7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID
7426: fnd_global.conc_program_id ,--Program Id
7427: fnd_global.conc_login_id ,--Program Login ID

Line 7424: fnd_global.conc_request_id ,--Request Id

7420: SYSDATE ,
7421: fnd_global.user_id ,
7422: SYSDATE ,
7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID
7426: fnd_global.conc_program_id ,--Program Id
7427: fnd_global.conc_login_id ,--Program Login ID
7428: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7421: fnd_global.user_id ,
7422: SYSDATE ,
7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID
7426: fnd_global.conc_program_id ,--Program Id
7427: fnd_global.conc_login_id ,--Program Login ID
7428: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7429: 1 ,

Line 7426: fnd_global.conc_program_id ,--Program Id

7422: SYSDATE ,
7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID
7426: fnd_global.conc_program_id ,--Program Id
7427: fnd_global.conc_login_id ,--Program Login ID
7428: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7429: 1 ,
7430: DECODE((select tax_type_code

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

7423: fnd_global.conc_login_id ,
7424: fnd_global.conc_request_id ,--Request Id
7425: fnd_global.prog_appl_id ,--Program Application ID
7426: fnd_global.conc_program_id ,--Program Id
7427: fnd_global.conc_login_id ,--Program Login ID
7428: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7429: 1 ,
7430: DECODE((select tax_type_code
7431: from

Line 7824: fnd_global.user_id ,

7820: COLL_TAX_AUTHORITY_ID ,
7821: NULL ,--THRSHLD_CHK_TMPLT_CODE
7822: DEF_PRIMARY_REC_RATE_CODE ,
7823: NULL ,
7824: fnd_global.user_id ,
7825: SYSDATE ,
7826: fnd_global.user_id ,
7827: SYSDATE ,
7828: fnd_global.conc_login_id ,

Line 7826: fnd_global.user_id ,

7822: DEF_PRIMARY_REC_RATE_CODE ,
7823: NULL ,
7824: fnd_global.user_id ,
7825: SYSDATE ,
7826: fnd_global.user_id ,
7827: SYSDATE ,
7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID

Line 7828: fnd_global.conc_login_id ,

7824: fnd_global.user_id ,
7825: SYSDATE ,
7826: fnd_global.user_id ,
7827: SYSDATE ,
7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID
7831: fnd_global.conc_program_id ,--Program Id
7832: fnd_global.conc_login_id ,--Program Login ID

Line 7829: fnd_global.conc_request_id ,--Request Id

7825: SYSDATE ,
7826: fnd_global.user_id ,
7827: SYSDATE ,
7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID
7831: fnd_global.conc_program_id ,--Program Id
7832: fnd_global.conc_login_id ,--Program Login ID
7833: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7826: fnd_global.user_id ,
7827: SYSDATE ,
7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID
7831: fnd_global.conc_program_id ,--Program Id
7832: fnd_global.conc_login_id ,--Program Login ID
7833: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7834: 1 ,

Line 7831: fnd_global.conc_program_id ,--Program Id

7827: SYSDATE ,
7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID
7831: fnd_global.conc_program_id ,--Program Id
7832: fnd_global.conc_login_id ,--Program Login ID
7833: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7834: 1 ,
7835: DECODE((select tax_type_code

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

7828: fnd_global.conc_login_id ,
7829: fnd_global.conc_request_id ,--Request Id
7830: fnd_global.prog_appl_id ,--Program Application ID
7831: fnd_global.conc_program_id ,--Program Id
7832: fnd_global.conc_login_id ,--Program Login ID
7833: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7834: 1 ,
7835: DECODE((select tax_type_code
7836: from

Line 8249: fnd_global.user_id ,

8245: COLL_TAX_AUTHORITY_ID ,
8246: NULL ,--THRSHLD_CHK_TMPLT_CODE
8247: DEF_PRIMARY_REC_RATE_CODE ,
8248: NULL ,
8249: fnd_global.user_id ,
8250: SYSDATE ,
8251: fnd_global.user_id ,
8252: SYSDATE ,
8253: fnd_global.conc_login_id ,

Line 8251: fnd_global.user_id ,

8247: DEF_PRIMARY_REC_RATE_CODE ,
8248: NULL ,
8249: fnd_global.user_id ,
8250: SYSDATE ,
8251: fnd_global.user_id ,
8252: SYSDATE ,
8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID

Line 8253: fnd_global.conc_login_id ,

8249: fnd_global.user_id ,
8250: SYSDATE ,
8251: fnd_global.user_id ,
8252: SYSDATE ,
8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID
8256: fnd_global.conc_program_id ,--Program Id
8257: fnd_global.conc_login_id ,--Program Login ID

Line 8254: fnd_global.conc_request_id ,--Request Id

8250: SYSDATE ,
8251: fnd_global.user_id ,
8252: SYSDATE ,
8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID
8256: fnd_global.conc_program_id ,--Program Id
8257: fnd_global.conc_login_id ,--Program Login ID
8258: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

8251: fnd_global.user_id ,
8252: SYSDATE ,
8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID
8256: fnd_global.conc_program_id ,--Program Id
8257: fnd_global.conc_login_id ,--Program Login ID
8258: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8259: 1 ,

Line 8256: fnd_global.conc_program_id ,--Program Id

8252: SYSDATE ,
8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID
8256: fnd_global.conc_program_id ,--Program Id
8257: fnd_global.conc_login_id ,--Program Login ID
8258: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8259: 1 ,
8260: DECODE((select tax_type_code

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

8253: fnd_global.conc_login_id ,
8254: fnd_global.conc_request_id ,--Request Id
8255: fnd_global.prog_appl_id ,--Program Application ID
8256: fnd_global.conc_program_id ,--Program Id
8257: fnd_global.conc_login_id ,--Program Login ID
8258: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8259: 1 ,
8260: DECODE((select tax_type_code
8261: from

Line 8465: fnd_global.user_id ,

8461: ELSE
8462: flv.meaning
8463: END ,
8464: SYSDATE ,
8465: fnd_global.user_id ,
8466: SYSDATE ,
8467: fnd_global.user_id ,
8468: fnd_global.conc_login_id ,
8469: taxes.tax_id

Line 8467: fnd_global.user_id ,

8463: END ,
8464: SYSDATE ,
8465: fnd_global.user_id ,
8466: SYSDATE ,
8467: fnd_global.user_id ,
8468: fnd_global.conc_login_id ,
8469: taxes.tax_id
8470: FROM
8471: zx_taxes_b taxes,

Line 8468: fnd_global.conc_login_id ,

8464: SYSDATE ,
8465: fnd_global.user_id ,
8466: SYSDATE ,
8467: fnd_global.user_id ,
8468: fnd_global.conc_login_id ,
8469: taxes.tax_id
8470: FROM
8471: zx_taxes_b taxes,
8472: zx_rates_b rates,

Line 8515: fnd_global.user_id ,

8511: ELSE
8512: flv.meaning
8513: END,
8514: SYSDATE ,
8515: fnd_global.user_id ,
8516: SYSDATE ,
8517: fnd_global.user_id ,
8518: fnd_global.conc_login_id ,
8519: taxes.tax_id

Line 8517: fnd_global.user_id ,

8513: END,
8514: SYSDATE ,
8515: fnd_global.user_id ,
8516: SYSDATE ,
8517: fnd_global.user_id ,
8518: fnd_global.conc_login_id ,
8519: taxes.tax_id
8520: FROM
8521: zx_taxes_b taxes,

Line 8518: fnd_global.conc_login_id ,

8514: SYSDATE ,
8515: fnd_global.user_id ,
8516: SYSDATE ,
8517: fnd_global.user_id ,
8518: fnd_global.conc_login_id ,
8519: taxes.tax_id
8520: FROM
8521: zx_taxes_b taxes,
8522: zx_rates_b rates,

Line 8562: fnd_global.user_id ,

8558: ELSE
8559: flv.meaning
8560: END,
8561: SYSDATE ,
8562: fnd_global.user_id ,
8563: SYSDATE ,
8564: fnd_global.user_id ,
8565: fnd_global.conc_login_id ,
8566: taxes.tax_id

Line 8564: fnd_global.user_id ,

8560: END,
8561: SYSDATE ,
8562: fnd_global.user_id ,
8563: SYSDATE ,
8564: fnd_global.user_id ,
8565: fnd_global.conc_login_id ,
8566: taxes.tax_id
8567: FROM
8568: zx_taxes_b taxes,

Line 8565: fnd_global.conc_login_id ,

8561: SYSDATE ,
8562: fnd_global.user_id ,
8563: SYSDATE ,
8564: fnd_global.user_id ,
8565: fnd_global.conc_login_id ,
8566: taxes.tax_id
8567: FROM
8568: zx_taxes_b taxes,
8569: zx_rates_b rates,

Line 8609: fnd_global.user_id ,

8605: ELSE
8606: flv.meaning
8607: END,
8608: SYSDATE ,
8609: fnd_global.user_id ,
8610: SYSDATE ,
8611: fnd_global.user_id ,
8612: fnd_global.conc_login_id ,
8613: taxes.tax_id

Line 8611: fnd_global.user_id ,

8607: END,
8608: SYSDATE ,
8609: fnd_global.user_id ,
8610: SYSDATE ,
8611: fnd_global.user_id ,
8612: fnd_global.conc_login_id ,
8613: taxes.tax_id
8614: FROM
8615: zx_taxes_b taxes,

Line 8612: fnd_global.conc_login_id ,

8608: SYSDATE ,
8609: fnd_global.user_id ,
8610: SYSDATE ,
8611: fnd_global.user_id ,
8612: fnd_global.conc_login_id ,
8613: taxes.tax_id
8614: FROM
8615: zx_taxes_b taxes,
8616: zx_rates_b rates,

Line 8665: fnd_global.user_id ,

8661: ELSE
8662: B.TAX
8663: END,
8664: SYSDATE ,
8665: fnd_global.user_id ,
8666: SYSDATE ,
8667: fnd_global.user_id ,
8668: fnd_global.conc_login_id ,
8669: B.TAX_ID

Line 8667: fnd_global.user_id ,

8663: END,
8664: SYSDATE ,
8665: fnd_global.user_id ,
8666: SYSDATE ,
8667: fnd_global.user_id ,
8668: fnd_global.conc_login_id ,
8669: B.TAX_ID
8670: FROM
8671: FND_LANGUAGES L,

Line 8668: fnd_global.conc_login_id ,

8664: SYSDATE ,
8665: fnd_global.user_id ,
8666: SYSDATE ,
8667: fnd_global.user_id ,
8668: fnd_global.conc_login_id ,
8669: B.TAX_ID
8670: FROM
8671: FND_LANGUAGES L,
8672: ZX_TAXES_B B

Line 8789: fnd_global.user_id ,

8785: 'MIGRATED' ,
8786: NULL ,
8787: NULL ,
8788: zx_det_factor_templ_b_s.nextval ,
8789: fnd_global.user_id ,
8790: SYSDATE ,
8791: fnd_global.user_id ,
8792: SYSDATE ,
8793: fnd_global.conc_login_id ,

Line 8791: fnd_global.user_id ,

8787: NULL ,
8788: zx_det_factor_templ_b_s.nextval ,
8789: fnd_global.user_id ,
8790: SYSDATE ,
8791: fnd_global.user_id ,
8792: SYSDATE ,
8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID

Line 8793: fnd_global.conc_login_id ,

8789: fnd_global.user_id ,
8790: SYSDATE ,
8791: fnd_global.user_id ,
8792: SYSDATE ,
8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID

Line 8794: fnd_global.conc_request_id ,--Request Id

8790: SYSDATE ,
8791: fnd_global.user_id ,
8792: SYSDATE ,
8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID
8798: 1

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

8791: fnd_global.user_id ,
8792: SYSDATE ,
8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID
8798: 1
8799: FROM DUAL

Line 8796: fnd_global.conc_program_id ,--Program Id

8792: SYSDATE ,
8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID
8798: 1
8799: FROM DUAL
8800: WHERE not exists (select 1

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

8793: fnd_global.conc_login_id ,
8794: fnd_global.conc_request_id ,--Request Id
8795: fnd_global.prog_appl_id ,--Program Application ID
8796: fnd_global.conc_program_id ,--Program Id
8797: fnd_global.conc_login_id , --Program Login ID
8798: 1
8799: FROM DUAL
8800: WHERE not exists (select 1
8801: from ZX_DET_FACTOR_TEMPL_B

Line 8831: fnd_global.user_id ,

8827: END,
8828: B.DET_FACTOR_TEMPL_CODE ,
8829: B.DET_FACTOR_TEMPL_ID ,
8830: SYSDATE ,
8831: fnd_global.user_id ,
8832: SYSDATE ,
8833: fnd_global.user_id ,
8834: fnd_global.conc_login_id
8835: FROM

Line 8833: fnd_global.user_id ,

8829: B.DET_FACTOR_TEMPL_ID ,
8830: SYSDATE ,
8831: fnd_global.user_id ,
8832: SYSDATE ,
8833: fnd_global.user_id ,
8834: fnd_global.conc_login_id
8835: FROM
8836: FND_LANGUAGES L,
8837: ZX_DET_FACTOR_TEMPL_B B

Line 8834: fnd_global.conc_login_id

8830: SYSDATE ,
8831: fnd_global.user_id ,
8832: SYSDATE ,
8833: fnd_global.user_id ,
8834: fnd_global.conc_login_id
8835: FROM
8836: FND_LANGUAGES L,
8837: ZX_DET_FACTOR_TEMPL_B B
8838: WHERE

Line 8877: fnd_global.user_id ,

8873: REQUIRED_FLAG ,
8874: RECORD_TYPE_CODE ,
8875: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8876: DET_FACTOR_TEMPL_ID ,
8877: fnd_global.user_id ,
8878: SYSDATE ,
8879: fnd_global.user_id ,
8880: SYSDATE ,
8881: fnd_global.conc_login_id ,

Line 8879: fnd_global.user_id ,

8875: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8876: DET_FACTOR_TEMPL_ID ,
8877: fnd_global.user_id ,
8878: SYSDATE ,
8879: fnd_global.user_id ,
8880: SYSDATE ,
8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID

Line 8881: fnd_global.conc_login_id ,

8877: fnd_global.user_id ,
8878: SYSDATE ,
8879: fnd_global.user_id ,
8880: SYSDATE ,
8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID
8884: fnd_global.conc_program_id ,--Program Id
8885: fnd_global.conc_login_id --Program Login ID

Line 8882: fnd_global.conc_request_id ,--Request Id

8878: SYSDATE ,
8879: fnd_global.user_id ,
8880: SYSDATE ,
8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID
8884: fnd_global.conc_program_id ,--Program Id
8885: fnd_global.conc_login_id --Program Login ID
8886: FROM

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

8879: fnd_global.user_id ,
8880: SYSDATE ,
8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID
8884: fnd_global.conc_program_id ,--Program Id
8885: fnd_global.conc_login_id --Program Login ID
8886: FROM
8887: (

Line 8884: fnd_global.conc_program_id ,--Program Id

8880: SYSDATE ,
8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID
8884: fnd_global.conc_program_id ,--Program Id
8885: fnd_global.conc_login_id --Program Login ID
8886: FROM
8887: (
8888: SELECT

Line 8885: fnd_global.conc_login_id --Program Login ID

8881: fnd_global.conc_login_id ,
8882: fnd_global.conc_request_id ,--Request Id
8883: fnd_global.prog_appl_id ,--Program Application ID
8884: fnd_global.conc_program_id ,--Program Id
8885: fnd_global.conc_login_id --Program Login ID
8886: FROM
8887: (
8888: SELECT
8889: 'ACCOUNTING_FLEXFIELD' DETERMINING_FACTOR_CLASS_CODE ,

Line 9018: fnd_global.user_id ,

9014: ALPHANUMERIC_VALUE ,
9015: VALUE_LOW ,
9016: VALUE_HIGH ,
9017: zx_conditions_s.nextval ,--CONDITION_ID
9018: fnd_global.user_id ,
9019: SYSDATE ,
9020: fnd_global.user_id ,
9021: SYSDATE ,
9022: fnd_global.conc_login_id ,

Line 9020: fnd_global.user_id ,

9016: VALUE_HIGH ,
9017: zx_conditions_s.nextval ,--CONDITION_ID
9018: fnd_global.user_id ,
9019: SYSDATE ,
9020: fnd_global.user_id ,
9021: SYSDATE ,
9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID

Line 9022: fnd_global.conc_login_id ,

9018: fnd_global.user_id ,
9019: SYSDATE ,
9020: fnd_global.user_id ,
9021: SYSDATE ,
9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID
9025: fnd_global.conc_program_id ,--Program Id
9026: fnd_global.conc_login_id ,--Program Login ID

Line 9023: fnd_global.conc_request_id ,--Request Id

9019: SYSDATE ,
9020: fnd_global.user_id ,
9021: SYSDATE ,
9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID
9025: fnd_global.conc_program_id ,--Program Id
9026: fnd_global.conc_login_id ,--Program Login ID
9027: 1

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

9020: fnd_global.user_id ,
9021: SYSDATE ,
9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID
9025: fnd_global.conc_program_id ,--Program Id
9026: fnd_global.conc_login_id ,--Program Login ID
9027: 1
9028: FROM

Line 9025: fnd_global.conc_program_id ,--Program Id

9021: SYSDATE ,
9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID
9025: fnd_global.conc_program_id ,--Program Id
9026: fnd_global.conc_login_id ,--Program Login ID
9027: 1
9028: FROM
9029: (

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

9022: fnd_global.conc_login_id ,
9023: fnd_global.conc_request_id ,--Request Id
9024: fnd_global.prog_appl_id ,--Program Application ID
9025: fnd_global.conc_program_id ,--Program Id
9026: fnd_global.conc_login_id ,--Program Login ID
9027: 1
9028: FROM
9029: (
9030: SELECT

Line 9182: fnd_global.user_id ,

9178: 'MIGRATED' ,--RECORD_TYPE_CODE
9179: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9180: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9181: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9182: fnd_global.user_id ,
9183: SYSDATE ,
9184: fnd_global.user_id ,
9185: SYSDATE ,
9186: fnd_global.conc_login_id ,

Line 9184: fnd_global.user_id ,

9180: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9181: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9182: fnd_global.user_id ,
9183: SYSDATE ,
9184: fnd_global.user_id ,
9185: SYSDATE ,
9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID

Line 9186: fnd_global.conc_login_id ,

9182: fnd_global.user_id ,
9183: SYSDATE ,
9184: fnd_global.user_id ,
9185: SYSDATE ,
9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID
9189: fnd_global.conc_program_id ,--Program Id
9190: fnd_global.conc_login_id ,--Program Login ID

Line 9187: fnd_global.conc_request_id ,--Request Id

9183: SYSDATE ,
9184: fnd_global.user_id ,
9185: SYSDATE ,
9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID
9189: fnd_global.conc_program_id ,--Program Id
9190: fnd_global.conc_login_id ,--Program Login ID
9191: 1

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

9184: fnd_global.user_id ,
9185: SYSDATE ,
9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID
9189: fnd_global.conc_program_id ,--Program Id
9190: fnd_global.conc_login_id ,--Program Login ID
9191: 1
9192: FROM

Line 9189: fnd_global.conc_program_id ,--Program Id

9185: SYSDATE ,
9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID
9189: fnd_global.conc_program_id ,--Program Id
9190: fnd_global.conc_login_id ,--Program Login ID
9191: 1
9192: FROM
9193: ap_tax_recvry_rules_all RULES,

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

9186: fnd_global.conc_login_id ,
9187: fnd_global.conc_request_id ,--Request Id
9188: fnd_global.prog_appl_id ,--Program Application ID
9189: fnd_global.conc_program_id ,--Program Id
9190: fnd_global.conc_login_id ,--Program Login ID
9191: 1
9192: FROM
9193: ap_tax_recvry_rules_all RULES,
9194: --ap_system_parameters_all ASP,

Line 9313: fnd_global.user_id ,

9309: 'MIGRATED' ,--RECORD_TYPE_CODE
9310: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9311: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9312: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9313: fnd_global.user_id ,
9314: SYSDATE ,
9315: fnd_global.user_id ,
9316: SYSDATE ,
9317: fnd_global.conc_login_id ,

Line 9315: fnd_global.user_id ,

9311: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9312: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9313: fnd_global.user_id ,
9314: SYSDATE ,
9315: fnd_global.user_id ,
9316: SYSDATE ,
9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID

Line 9317: fnd_global.conc_login_id ,

9313: fnd_global.user_id ,
9314: SYSDATE ,
9315: fnd_global.user_id ,
9316: SYSDATE ,
9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID
9320: fnd_global.conc_program_id ,--Program Id
9321: fnd_global.conc_login_id ,--Program Login ID

Line 9318: fnd_global.conc_request_id ,--Request Id

9314: SYSDATE ,
9315: fnd_global.user_id ,
9316: SYSDATE ,
9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID
9320: fnd_global.conc_program_id ,--Program Id
9321: fnd_global.conc_login_id ,--Program Login ID
9322: 1

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

9315: fnd_global.user_id ,
9316: SYSDATE ,
9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID
9320: fnd_global.conc_program_id ,--Program Id
9321: fnd_global.conc_login_id ,--Program Login ID
9322: 1
9323: FROM

Line 9320: fnd_global.conc_program_id ,--Program Id

9316: SYSDATE ,
9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID
9320: fnd_global.conc_program_id ,--Program Id
9321: fnd_global.conc_login_id ,--Program Login ID
9322: 1
9323: FROM
9324: ap_tax_recvry_rules_all RULES,

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

9317: fnd_global.conc_login_id ,
9318: fnd_global.conc_request_id ,--Request Id
9319: fnd_global.prog_appl_id ,--Program Application ID
9320: fnd_global.conc_program_id ,--Program Id
9321: fnd_global.conc_login_id ,--Program Login ID
9322: 1
9323: FROM
9324: ap_tax_recvry_rules_all RULES,
9325: --ap_system_parameters_all ASP,

Line 9388: fnd_global.user_id ,

9384: END,
9385: B.CONDITION_GROUP_CODE ,
9386: B.CONDITION_GROUP_ID ,
9387: SYSDATE ,
9388: fnd_global.user_id ,
9389: SYSDATE ,
9390: fnd_global.user_id ,
9391: fnd_global.conc_login_id
9392: FROM

Line 9390: fnd_global.user_id ,

9386: B.CONDITION_GROUP_ID ,
9387: SYSDATE ,
9388: fnd_global.user_id ,
9389: SYSDATE ,
9390: fnd_global.user_id ,
9391: fnd_global.conc_login_id
9392: FROM
9393: FND_LANGUAGES L,
9394: ZX_CONDITION_GROUPS_B B

Line 9391: fnd_global.conc_login_id

9387: SYSDATE ,
9388: fnd_global.user_id ,
9389: SYSDATE ,
9390: fnd_global.user_id ,
9391: fnd_global.conc_login_id
9392: FROM
9393: FND_LANGUAGES L,
9394: ZX_CONDITION_GROUPS_B B
9395: WHERE

Line 9498: fnd_global.user_id ,

9494: 'MIGRATED' ,--RECORD_TYPE_CODE
9495: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9496: CONTENT_OWNER_ID ,
9497: zx_rules_b_s.nextval ,--TAX_RULE_ID
9498: fnd_global.user_id ,
9499: SYSDATE ,
9500: fnd_global.user_id ,
9501: SYSDATE ,
9502: fnd_global.conc_login_id ,

Line 9500: fnd_global.user_id ,

9496: CONTENT_OWNER_ID ,
9497: zx_rules_b_s.nextval ,--TAX_RULE_ID
9498: fnd_global.user_id ,
9499: SYSDATE ,
9500: fnd_global.user_id ,
9501: SYSDATE ,
9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID

Line 9502: fnd_global.conc_login_id ,

9498: fnd_global.user_id ,
9499: SYSDATE ,
9500: fnd_global.user_id ,
9501: SYSDATE ,
9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID
9505: fnd_global.conc_program_id ,--Program Id
9506: fnd_global.conc_login_id ,--Program Login ID

Line 9503: fnd_global.conc_request_id ,--Request Id

9499: SYSDATE ,
9500: fnd_global.user_id ,
9501: SYSDATE ,
9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID
9505: fnd_global.conc_program_id ,--Program Id
9506: fnd_global.conc_login_id ,--Program Login ID
9507: 1

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

9500: fnd_global.user_id ,
9501: SYSDATE ,
9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID
9505: fnd_global.conc_program_id ,--Program Id
9506: fnd_global.conc_login_id ,--Program Login ID
9507: 1
9508: FROM

Line 9505: fnd_global.conc_program_id ,--Program Id

9501: SYSDATE ,
9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID
9505: fnd_global.conc_program_id ,--Program Id
9506: fnd_global.conc_login_id ,--Program Login ID
9507: 1
9508: FROM
9509: (

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

9502: fnd_global.conc_login_id ,
9503: fnd_global.conc_request_id ,--Request Id
9504: fnd_global.prog_appl_id ,--Program Application ID
9505: fnd_global.conc_program_id ,--Program Id
9506: fnd_global.conc_login_id ,--Program Login ID
9507: 1
9508: FROM
9509: (
9510: SELECT

Line 9614: fnd_global.user_id ,

9610: 'MIGRATED' ,--RECORD_TYPE_CODE
9611: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9612: CONTENT_OWNER_ID ,
9613: zx_rules_b_s.nextval ,--TAX_RULE_ID
9614: fnd_global.user_id ,
9615: SYSDATE ,
9616: fnd_global.user_id ,
9617: SYSDATE ,
9618: fnd_global.conc_login_id ,

Line 9616: fnd_global.user_id ,

9612: CONTENT_OWNER_ID ,
9613: zx_rules_b_s.nextval ,--TAX_RULE_ID
9614: fnd_global.user_id ,
9615: SYSDATE ,
9616: fnd_global.user_id ,
9617: SYSDATE ,
9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID

Line 9618: fnd_global.conc_login_id ,

9614: fnd_global.user_id ,
9615: SYSDATE ,
9616: fnd_global.user_id ,
9617: SYSDATE ,
9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID
9621: fnd_global.conc_program_id ,--Program Id
9622: fnd_global.conc_login_id ,--Program Login ID

Line 9619: fnd_global.conc_request_id ,--Request Id

9615: SYSDATE ,
9616: fnd_global.user_id ,
9617: SYSDATE ,
9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID
9621: fnd_global.conc_program_id ,--Program Id
9622: fnd_global.conc_login_id ,--Program Login ID
9623: 1

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

9616: fnd_global.user_id ,
9617: SYSDATE ,
9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID
9621: fnd_global.conc_program_id ,--Program Id
9622: fnd_global.conc_login_id ,--Program Login ID
9623: 1
9624: FROM

Line 9621: fnd_global.conc_program_id ,--Program Id

9617: SYSDATE ,
9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID
9621: fnd_global.conc_program_id ,--Program Id
9622: fnd_global.conc_login_id ,--Program Login ID
9623: 1
9624: FROM
9625: (

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

9618: fnd_global.conc_login_id ,
9619: fnd_global.conc_request_id ,--Request Id
9620: fnd_global.prog_appl_id ,--Program Application ID
9621: fnd_global.conc_program_id ,--Program Id
9622: fnd_global.conc_login_id ,--Program Login ID
9623: 1
9624: FROM
9625: (
9626: SELECT

Line 9713: fnd_global.user_id ,

9709: END,
9710: B.TAX_RULE_CODE ,
9711: B.TAX_RULE_ID ,
9712: SYSDATE ,
9713: fnd_global.user_id ,
9714: SYSDATE ,
9715: fnd_global.user_id ,
9716: fnd_global.conc_login_id
9717: FROM

Line 9715: fnd_global.user_id ,

9711: B.TAX_RULE_ID ,
9712: SYSDATE ,
9713: fnd_global.user_id ,
9714: SYSDATE ,
9715: fnd_global.user_id ,
9716: fnd_global.conc_login_id
9717: FROM
9718: FND_LANGUAGES L,
9719: ZX_RULES_B B

Line 9716: fnd_global.conc_login_id

9712: SYSDATE ,
9713: fnd_global.user_id ,
9714: SYSDATE ,
9715: fnd_global.user_id ,
9716: fnd_global.conc_login_id
9717: FROM
9718: FND_LANGUAGES L,
9719: ZX_RULES_B B
9720: WHERE

Line 9798: fnd_global.user_id ,

9794: zx_process_results_s.nextval ,--RESULT_ID
9795: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
9796: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9797: TAX_RULE_ID ,--TAX_RULE_ID
9798: fnd_global.user_id ,
9799: SYSDATE ,
9800: fnd_global.user_id ,
9801: SYSDATE ,
9802: fnd_global.conc_login_id ,

Line 9800: fnd_global.user_id ,

9796: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9797: TAX_RULE_ID ,--TAX_RULE_ID
9798: fnd_global.user_id ,
9799: SYSDATE ,
9800: fnd_global.user_id ,
9801: SYSDATE ,
9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID

Line 9802: fnd_global.conc_login_id ,

9798: fnd_global.user_id ,
9799: SYSDATE ,
9800: fnd_global.user_id ,
9801: SYSDATE ,
9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID
9805: fnd_global.conc_program_id ,--Program Id
9806: fnd_global.conc_login_id , --Program Login ID

Line 9803: fnd_global.conc_request_id ,--Request Id

9799: SYSDATE ,
9800: fnd_global.user_id ,
9801: SYSDATE ,
9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID
9805: fnd_global.conc_program_id ,--Program Id
9806: fnd_global.conc_login_id , --Program Login ID
9807: 1

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

9800: fnd_global.user_id ,
9801: SYSDATE ,
9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID
9805: fnd_global.conc_program_id ,--Program Id
9806: fnd_global.conc_login_id , --Program Login ID
9807: 1
9808: FROM

Line 9805: fnd_global.conc_program_id ,--Program Id

9801: SYSDATE ,
9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID
9805: fnd_global.conc_program_id ,--Program Id
9806: fnd_global.conc_login_id , --Program Login ID
9807: 1
9808: FROM
9809: (SELECT DISTINCT

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

9802: fnd_global.conc_login_id ,
9803: fnd_global.conc_request_id ,--Request Id
9804: fnd_global.prog_appl_id ,--Program Application ID
9805: fnd_global.conc_program_id ,--Program Id
9806: fnd_global.conc_login_id , --Program Login ID
9807: 1
9808: FROM
9809: (SELECT DISTINCT
9810: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE

Line 9937: fnd_global.user_id ,

9933: zx_process_results_s.nextval ,--RESULT_ID
9934: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
9935: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9936: TAX_RULE_ID ,--TAX_RULE_ID
9937: fnd_global.user_id ,
9938: SYSDATE ,
9939: fnd_global.user_id ,
9940: SYSDATE ,
9941: fnd_global.conc_login_id ,

Line 9939: fnd_global.user_id ,

9935: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
9936: TAX_RULE_ID ,--TAX_RULE_ID
9937: fnd_global.user_id ,
9938: SYSDATE ,
9939: fnd_global.user_id ,
9940: SYSDATE ,
9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID

Line 9941: fnd_global.conc_login_id ,

9937: fnd_global.user_id ,
9938: SYSDATE ,
9939: fnd_global.user_id ,
9940: SYSDATE ,
9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID
9944: fnd_global.conc_program_id ,--Program Id
9945: fnd_global.conc_login_id , --Program Login ID

Line 9942: fnd_global.conc_request_id ,--Request Id

9938: SYSDATE ,
9939: fnd_global.user_id ,
9940: SYSDATE ,
9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID
9944: fnd_global.conc_program_id ,--Program Id
9945: fnd_global.conc_login_id , --Program Login ID
9946: 1

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

9939: fnd_global.user_id ,
9940: SYSDATE ,
9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID
9944: fnd_global.conc_program_id ,--Program Id
9945: fnd_global.conc_login_id , --Program Login ID
9946: 1
9947: FROM

Line 9944: fnd_global.conc_program_id ,--Program Id

9940: SYSDATE ,
9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID
9944: fnd_global.conc_program_id ,--Program Id
9945: fnd_global.conc_login_id , --Program Login ID
9946: 1
9947: FROM
9948: (SELECT DISTINCT

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

9941: fnd_global.conc_login_id ,
9942: fnd_global.conc_request_id ,--Request Id
9943: fnd_global.prog_appl_id ,--Program Application ID
9944: fnd_global.conc_program_id ,--Program Id
9945: fnd_global.conc_login_id , --Program Login ID
9946: 1
9947: FROM
9948: (SELECT DISTINCT
9949: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE

Line 10275: fnd_global.user_id,

10271: NULL,
10272: NULL,
10273: NULL,
10274: 'MIGRATED',
10275: fnd_global.user_id,
10276: SYSDATE,
10277: fnd_global.user_id,
10278: SYSDATE,
10279: fnd_global.conc_login_id,

Line 10277: fnd_global.user_id,

10273: NULL,
10274: 'MIGRATED',
10275: fnd_global.user_id,
10276: SYSDATE,
10277: fnd_global.user_id,
10278: SYSDATE,
10279: fnd_global.conc_login_id,
10280: fnd_global.conc_request_id,
10281: fnd_global.prog_appl_id,

Line 10279: fnd_global.conc_login_id,

10275: fnd_global.user_id,
10276: SYSDATE,
10277: fnd_global.user_id,
10278: SYSDATE,
10279: fnd_global.conc_login_id,
10280: fnd_global.conc_request_id,
10281: fnd_global.prog_appl_id,
10282: fnd_global.conc_program_id,
10283: NULL,

Line 10280: fnd_global.conc_request_id,

10276: SYSDATE,
10277: fnd_global.user_id,
10278: SYSDATE,
10279: fnd_global.conc_login_id,
10280: fnd_global.conc_request_id,
10281: fnd_global.prog_appl_id,
10282: fnd_global.conc_program_id,
10283: NULL,
10284: NULL,

Line 10281: fnd_global.prog_appl_id,

10277: fnd_global.user_id,
10278: SYSDATE,
10279: fnd_global.conc_login_id,
10280: fnd_global.conc_request_id,
10281: fnd_global.prog_appl_id,
10282: fnd_global.conc_program_id,
10283: NULL,
10284: NULL,
10285: NULL,

Line 10282: fnd_global.conc_program_id,

10278: SYSDATE,
10279: fnd_global.conc_login_id,
10280: fnd_global.conc_request_id,
10281: fnd_global.prog_appl_id,
10282: fnd_global.conc_program_id,
10283: NULL,
10284: NULL,
10285: NULL,
10286: NULL,

Line 10299: fnd_global.conc_login_id,

10295: NULL,
10296: NULL,
10297: NULL,
10298: NULL,
10299: fnd_global.conc_login_id,
10300: zx_accounts_s.nextval,
10301: pg_max_tax_id_tab(j),
10302: pg_max_ledger_id_tab(j),
10303: pg_max_org_id_tab(j),

Line 10559: fnd_global.user_id ,

10555: ATTRIBUTE15 ,
10556: ATTRIBUTE_CATEGORY ,
10557: zx_rates_b_s.nextval ,--TAX_RATE_ID
10558: CONTENT_OWNER_ID ,
10559: fnd_global.user_id ,
10560: SYSDATE ,
10561: fnd_global.user_id ,
10562: SYSDATE ,
10563: fnd_global.conc_login_id ,

Line 10561: fnd_global.user_id ,

10557: zx_rates_b_s.nextval ,--TAX_RATE_ID
10558: CONTENT_OWNER_ID ,
10559: fnd_global.user_id ,
10560: SYSDATE ,
10561: fnd_global.user_id ,
10562: SYSDATE ,
10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID

Line 10563: fnd_global.conc_login_id ,

10559: fnd_global.user_id ,
10560: SYSDATE ,
10561: fnd_global.user_id ,
10562: SYSDATE ,
10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID
10566: fnd_global.conc_program_id , -- Program Id
10567: fnd_global.conc_login_id , -- Program Login ID

Line 10564: fnd_global.conc_request_id , -- Request Id

10560: SYSDATE ,
10561: fnd_global.user_id ,
10562: SYSDATE ,
10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID
10566: fnd_global.conc_program_id , -- Program Id
10567: fnd_global.conc_login_id , -- Program Login ID
10568: 'TAX_RATE' ,

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

10561: fnd_global.user_id ,
10562: SYSDATE ,
10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID
10566: fnd_global.conc_program_id , -- Program Id
10567: fnd_global.conc_login_id , -- Program Login ID
10568: 'TAX_RATE' ,
10569: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 10566: fnd_global.conc_program_id , -- Program Id

10562: SYSDATE ,
10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID
10566: fnd_global.conc_program_id , -- Program Id
10567: fnd_global.conc_login_id , -- Program Login ID
10568: 'TAX_RATE' ,
10569: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10570: 1

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

10563: fnd_global.conc_login_id ,
10564: fnd_global.conc_request_id , -- Request Id
10565: fnd_global.prog_appl_id , -- Program Application ID
10566: fnd_global.conc_program_id , -- Program Id
10567: fnd_global.conc_login_id , -- Program Login ID
10568: 'TAX_RATE' ,
10569: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10570: 1
10571: -- 6820043, commenting out description

Line 10655: fnd_global.user_id ,

10651: NULL ,
10652: NULL ,
10653: NULL ,
10654: NULL ,
10655: fnd_global.user_id ,
10656: SYSDATE ,
10657: fnd_global.user_id ,
10658: SYSDATE ,
10659: fnd_global.conc_login_id ,

Line 10657: fnd_global.user_id ,

10653: NULL ,
10654: NULL ,
10655: fnd_global.user_id ,
10656: SYSDATE ,
10657: fnd_global.user_id ,
10658: SYSDATE ,
10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID

Line 10659: fnd_global.conc_login_id ,

10655: fnd_global.user_id ,
10656: SYSDATE ,
10657: fnd_global.user_id ,
10658: SYSDATE ,
10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID
10662: fnd_global.conc_program_id , -- Program Id
10663: fnd_global.conc_login_id , -- Program Login ID

Line 10660: fnd_global.conc_request_id , -- Request Id

10656: SYSDATE ,
10657: fnd_global.user_id ,
10658: SYSDATE ,
10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID
10662: fnd_global.conc_program_id , -- Program Id
10663: fnd_global.conc_login_id , -- Program Login ID
10664: 1

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

10657: fnd_global.user_id ,
10658: SYSDATE ,
10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID
10662: fnd_global.conc_program_id , -- Program Id
10663: fnd_global.conc_login_id , -- Program Login ID
10664: 1
10665: )

Line 10662: fnd_global.conc_program_id , -- Program Id

10658: SYSDATE ,
10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID
10662: fnd_global.conc_program_id , -- Program Id
10663: fnd_global.conc_login_id , -- Program Login ID
10664: 1
10665: )
10666: SELECT

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

10659: fnd_global.conc_login_id ,
10660: fnd_global.conc_request_id , -- Request Id
10661: fnd_global.prog_appl_id , -- Program Application ID
10662: fnd_global.conc_program_id , -- Program Id
10663: fnd_global.conc_login_id , -- Program Login ID
10664: 1
10665: )
10666: SELECT
10667: results.tax_code_id TAX_RATE_ID,

Line 10982: fnd_global.user_id ,

10978: ATTRIBUTE15 ,
10979: ATTRIBUTE_CATEGORY ,
10980: zx_rates_b_s.nextval ,--TAX_RATE_ID
10981: CONTENT_OWNER_ID ,
10982: fnd_global.user_id ,
10983: SYSDATE ,
10984: fnd_global.user_id ,
10985: SYSDATE ,
10986: fnd_global.conc_login_id ,

Line 10984: fnd_global.user_id ,

10980: zx_rates_b_s.nextval ,--TAX_RATE_ID
10981: CONTENT_OWNER_ID ,
10982: fnd_global.user_id ,
10983: SYSDATE ,
10984: fnd_global.user_id ,
10985: SYSDATE ,
10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID

Line 10986: fnd_global.conc_login_id ,

10982: fnd_global.user_id ,
10983: SYSDATE ,
10984: fnd_global.user_id ,
10985: SYSDATE ,
10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID
10989: fnd_global.conc_program_id , -- Program Id
10990: fnd_global.conc_login_id , -- Program Login ID

Line 10987: fnd_global.conc_request_id , -- Request Id

10983: SYSDATE ,
10984: fnd_global.user_id ,
10985: SYSDATE ,
10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID
10989: fnd_global.conc_program_id , -- Program Id
10990: fnd_global.conc_login_id , -- Program Login ID
10991: 'TAX_RATE' ,

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

10984: fnd_global.user_id ,
10985: SYSDATE ,
10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID
10989: fnd_global.conc_program_id , -- Program Id
10990: fnd_global.conc_login_id , -- Program Login ID
10991: 'TAX_RATE' ,
10992: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 10989: fnd_global.conc_program_id , -- Program Id

10985: SYSDATE ,
10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID
10989: fnd_global.conc_program_id , -- Program Id
10990: fnd_global.conc_login_id , -- Program Login ID
10991: 'TAX_RATE' ,
10992: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10993: 1

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

10986: fnd_global.conc_login_id ,
10987: fnd_global.conc_request_id , -- Request Id
10988: fnd_global.prog_appl_id , -- Program Application ID
10989: fnd_global.conc_program_id , -- Program Id
10990: fnd_global.conc_login_id , -- Program Login ID
10991: 'TAX_RATE' ,
10992: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10993: 1
10994: -- 6820043, commenting out description

Line 11078: fnd_global.user_id ,

11074: NULL ,
11075: NULL ,
11076: NULL ,
11077: NULL ,
11078: fnd_global.user_id ,
11079: SYSDATE ,
11080: fnd_global.user_id ,
11081: SYSDATE ,
11082: fnd_global.conc_login_id ,

Line 11080: fnd_global.user_id ,

11076: NULL ,
11077: NULL ,
11078: fnd_global.user_id ,
11079: SYSDATE ,
11080: fnd_global.user_id ,
11081: SYSDATE ,
11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID

Line 11082: fnd_global.conc_login_id ,

11078: fnd_global.user_id ,
11079: SYSDATE ,
11080: fnd_global.user_id ,
11081: SYSDATE ,
11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID
11085: fnd_global.conc_program_id , -- Program Id
11086: fnd_global.conc_login_id , -- Program Login ID

Line 11083: fnd_global.conc_request_id , -- Request Id

11079: SYSDATE ,
11080: fnd_global.user_id ,
11081: SYSDATE ,
11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID
11085: fnd_global.conc_program_id , -- Program Id
11086: fnd_global.conc_login_id , -- Program Login ID
11087: 1

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

11080: fnd_global.user_id ,
11081: SYSDATE ,
11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID
11085: fnd_global.conc_program_id , -- Program Id
11086: fnd_global.conc_login_id , -- Program Login ID
11087: 1
11088: )

Line 11085: fnd_global.conc_program_id , -- Program Id

11081: SYSDATE ,
11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID
11085: fnd_global.conc_program_id , -- Program Id
11086: fnd_global.conc_login_id , -- Program Login ID
11087: 1
11088: )
11089: SELECT

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

11082: fnd_global.conc_login_id ,
11083: fnd_global.conc_request_id , -- Request Id
11084: fnd_global.prog_appl_id , -- Program Application ID
11085: fnd_global.conc_program_id , -- Program Id
11086: fnd_global.conc_login_id , -- Program Login ID
11087: 1
11088: )
11089: SELECT
11090: results.tax_code_id TAX_RATE_ID,

Line 11417: fnd_global.user_id ,

11413: ATTRIBUTE15 ,
11414: ATTRIBUTE_CATEGORY ,
11415: TAX_RATE_ID ,
11416: CONTENT_OWNER_ID ,
11417: fnd_global.user_id ,
11418: SYSDATE ,
11419: fnd_global.user_id ,
11420: SYSDATE ,
11421: fnd_global.conc_login_id ,

Line 11419: fnd_global.user_id ,

11415: TAX_RATE_ID ,
11416: CONTENT_OWNER_ID ,
11417: fnd_global.user_id ,
11418: SYSDATE ,
11419: fnd_global.user_id ,
11420: SYSDATE ,
11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID

Line 11421: fnd_global.conc_login_id ,

11417: fnd_global.user_id ,
11418: SYSDATE ,
11419: fnd_global.user_id ,
11420: SYSDATE ,
11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID
11424: fnd_global.conc_program_id , -- Program Id
11425: fnd_global.conc_login_id , -- Program Login ID

Line 11422: fnd_global.conc_request_id , -- Request Id

11418: SYSDATE ,
11419: fnd_global.user_id ,
11420: SYSDATE ,
11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID
11424: fnd_global.conc_program_id , -- Program Id
11425: fnd_global.conc_login_id , -- Program Login ID
11426: 'TAX_RATE' ,

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

11419: fnd_global.user_id ,
11420: SYSDATE ,
11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID
11424: fnd_global.conc_program_id , -- Program Id
11425: fnd_global.conc_login_id , -- Program Login ID
11426: 'TAX_RATE' ,
11427: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 11424: fnd_global.conc_program_id , -- Program Id

11420: SYSDATE ,
11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID
11424: fnd_global.conc_program_id , -- Program Id
11425: fnd_global.conc_login_id , -- Program Login ID
11426: 'TAX_RATE' ,
11427: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11428: 1 ,

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

11421: fnd_global.conc_login_id ,
11422: fnd_global.conc_request_id , -- Request Id
11423: fnd_global.prog_appl_id , -- Program Application ID
11424: fnd_global.conc_program_id , -- Program Id
11425: fnd_global.conc_login_id , -- Program Login ID
11426: 'TAX_RATE' ,
11427: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11428: 1 ,
11429: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 11515: fnd_global.user_id ,

11511: NULL ,
11512: NULL ,
11513: NULL ,
11514: NULL ,
11515: fnd_global.user_id ,
11516: SYSDATE ,
11517: fnd_global.user_id ,
11518: SYSDATE ,
11519: fnd_global.conc_login_id ,

Line 11517: fnd_global.user_id ,

11513: NULL ,
11514: NULL ,
11515: fnd_global.user_id ,
11516: SYSDATE ,
11517: fnd_global.user_id ,
11518: SYSDATE ,
11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID

Line 11519: fnd_global.conc_login_id ,

11515: fnd_global.user_id ,
11516: SYSDATE ,
11517: fnd_global.user_id ,
11518: SYSDATE ,
11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID
11522: fnd_global.conc_program_id , -- Program Id
11523: fnd_global.conc_login_id , -- Program Login ID

Line 11520: fnd_global.conc_request_id , -- Request Id

11516: SYSDATE ,
11517: fnd_global.user_id ,
11518: SYSDATE ,
11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID
11522: fnd_global.conc_program_id , -- Program Id
11523: fnd_global.conc_login_id , -- Program Login ID
11524: 1

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

11517: fnd_global.user_id ,
11518: SYSDATE ,
11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID
11522: fnd_global.conc_program_id , -- Program Id
11523: fnd_global.conc_login_id , -- Program Login ID
11524: 1
11525: )

Line 11522: fnd_global.conc_program_id , -- Program Id

11518: SYSDATE ,
11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID
11522: fnd_global.conc_program_id , -- Program Id
11523: fnd_global.conc_login_id , -- Program Login ID
11524: 1
11525: )
11526: SELECT

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

11519: fnd_global.conc_login_id ,
11520: fnd_global.conc_request_id , -- Request Id
11521: fnd_global.prog_appl_id , -- Program Application ID
11522: fnd_global.conc_program_id , -- Program Id
11523: fnd_global.conc_login_id , -- Program Login ID
11524: 1
11525: )
11526: SELECT
11527: results.tax_code_id TAX_RATE_ID,

Line 11842: fnd_global.user_id ,

11838: ATTRIBUTE15 ,
11839: ATTRIBUTE_CATEGORY ,
11840: TAX_RATE_ID ,
11841: CONTENT_OWNER_ID ,
11842: fnd_global.user_id ,
11843: SYSDATE ,
11844: fnd_global.user_id ,
11845: SYSDATE ,
11846: fnd_global.conc_login_id ,

Line 11844: fnd_global.user_id ,

11840: TAX_RATE_ID ,
11841: CONTENT_OWNER_ID ,
11842: fnd_global.user_id ,
11843: SYSDATE ,
11844: fnd_global.user_id ,
11845: SYSDATE ,
11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID

Line 11846: fnd_global.conc_login_id ,

11842: fnd_global.user_id ,
11843: SYSDATE ,
11844: fnd_global.user_id ,
11845: SYSDATE ,
11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID
11849: fnd_global.conc_program_id , -- Program Id
11850: fnd_global.conc_login_id , -- Program Login ID

Line 11847: fnd_global.conc_request_id , -- Request Id

11843: SYSDATE ,
11844: fnd_global.user_id ,
11845: SYSDATE ,
11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID
11849: fnd_global.conc_program_id , -- Program Id
11850: fnd_global.conc_login_id , -- Program Login ID
11851: 'TAX_RATE' ,

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

11844: fnd_global.user_id ,
11845: SYSDATE ,
11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID
11849: fnd_global.conc_program_id , -- Program Id
11850: fnd_global.conc_login_id , -- Program Login ID
11851: 'TAX_RATE' ,
11852: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 11849: fnd_global.conc_program_id , -- Program Id

11845: SYSDATE ,
11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID
11849: fnd_global.conc_program_id , -- Program Id
11850: fnd_global.conc_login_id , -- Program Login ID
11851: 'TAX_RATE' ,
11852: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11853: 1 ,

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

11846: fnd_global.conc_login_id ,
11847: fnd_global.conc_request_id , -- Request Id
11848: fnd_global.prog_appl_id , -- Program Application ID
11849: fnd_global.conc_program_id , -- Program Id
11850: fnd_global.conc_login_id , -- Program Login ID
11851: 'TAX_RATE' ,
11852: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11853: 1 ,
11854: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 11940: fnd_global.user_id ,

11936: NULL ,
11937: NULL ,
11938: NULL ,
11939: NULL ,
11940: fnd_global.user_id ,
11941: SYSDATE ,
11942: fnd_global.user_id ,
11943: SYSDATE ,
11944: fnd_global.conc_login_id ,

Line 11942: fnd_global.user_id ,

11938: NULL ,
11939: NULL ,
11940: fnd_global.user_id ,
11941: SYSDATE ,
11942: fnd_global.user_id ,
11943: SYSDATE ,
11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID

Line 11944: fnd_global.conc_login_id ,

11940: fnd_global.user_id ,
11941: SYSDATE ,
11942: fnd_global.user_id ,
11943: SYSDATE ,
11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID
11947: fnd_global.conc_program_id , -- Program Id
11948: fnd_global.conc_login_id , -- Program Login ID

Line 11945: fnd_global.conc_request_id , -- Request Id

11941: SYSDATE ,
11942: fnd_global.user_id ,
11943: SYSDATE ,
11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID
11947: fnd_global.conc_program_id , -- Program Id
11948: fnd_global.conc_login_id , -- Program Login ID
11949: 1

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

11942: fnd_global.user_id ,
11943: SYSDATE ,
11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID
11947: fnd_global.conc_program_id , -- Program Id
11948: fnd_global.conc_login_id , -- Program Login ID
11949: 1
11950: )

Line 11947: fnd_global.conc_program_id , -- Program Id

11943: SYSDATE ,
11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID
11947: fnd_global.conc_program_id , -- Program Id
11948: fnd_global.conc_login_id , -- Program Login ID
11949: 1
11950: )
11951: SELECT

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

11944: fnd_global.conc_login_id ,
11945: fnd_global.conc_request_id , -- Request Id
11946: fnd_global.prog_appl_id , -- Program Application ID
11947: fnd_global.conc_program_id , -- Program Id
11948: fnd_global.conc_login_id , -- Program Login ID
11949: 1
11950: )
11951: SELECT
11952: results.tax_code_id TAX_RATE_ID,

Line 12286: fnd_global.user_id ,

12282: ATTRIBUTE15 ,
12283: ATTRIBUTE_CATEGORY ,
12284: zx_rates_b_s.nextval ,--TAX_RATE_ID
12285: CONTENT_OWNER_ID ,
12286: fnd_global.user_id ,
12287: SYSDATE ,
12288: fnd_global.user_id ,
12289: SYSDATE ,
12290: fnd_global.conc_login_id ,

Line 12288: fnd_global.user_id ,

12284: zx_rates_b_s.nextval ,--TAX_RATE_ID
12285: CONTENT_OWNER_ID ,
12286: fnd_global.user_id ,
12287: SYSDATE ,
12288: fnd_global.user_id ,
12289: SYSDATE ,
12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID

Line 12290: fnd_global.conc_login_id ,

12286: fnd_global.user_id ,
12287: SYSDATE ,
12288: fnd_global.user_id ,
12289: SYSDATE ,
12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID
12293: fnd_global.conc_program_id , -- Program Id
12294: fnd_global.conc_login_id , -- Program Login ID

Line 12291: fnd_global.conc_request_id , -- Request Id

12287: SYSDATE ,
12288: fnd_global.user_id ,
12289: SYSDATE ,
12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID
12293: fnd_global.conc_program_id , -- Program Id
12294: fnd_global.conc_login_id , -- Program Login ID
12295: 'TAX_RATE' ,

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

12288: fnd_global.user_id ,
12289: SYSDATE ,
12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID
12293: fnd_global.conc_program_id , -- Program Id
12294: fnd_global.conc_login_id , -- Program Login ID
12295: 'TAX_RATE' ,
12296: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 12293: fnd_global.conc_program_id , -- Program Id

12289: SYSDATE ,
12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID
12293: fnd_global.conc_program_id , -- Program Id
12294: fnd_global.conc_login_id , -- Program Login ID
12295: 'TAX_RATE' ,
12296: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12297: 1

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

12290: fnd_global.conc_login_id ,
12291: fnd_global.conc_request_id , -- Request Id
12292: fnd_global.prog_appl_id , -- Program Application ID
12293: fnd_global.conc_program_id , -- Program Id
12294: fnd_global.conc_login_id , -- Program Login ID
12295: 'TAX_RATE' ,
12296: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12297: 1
12298: -- 6820043, commenting out description

Line 12382: fnd_global.user_id ,

12378: NULL ,
12379: NULL ,
12380: NULL ,
12381: NULL ,
12382: fnd_global.user_id ,
12383: SYSDATE ,
12384: fnd_global.user_id ,
12385: SYSDATE ,
12386: fnd_global.conc_login_id ,

Line 12384: fnd_global.user_id ,

12380: NULL ,
12381: NULL ,
12382: fnd_global.user_id ,
12383: SYSDATE ,
12384: fnd_global.user_id ,
12385: SYSDATE ,
12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID

Line 12386: fnd_global.conc_login_id ,

12382: fnd_global.user_id ,
12383: SYSDATE ,
12384: fnd_global.user_id ,
12385: SYSDATE ,
12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID
12389: fnd_global.conc_program_id , -- Program Id
12390: fnd_global.conc_login_id , -- Program Login ID

Line 12387: fnd_global.conc_request_id , -- Request Id

12383: SYSDATE ,
12384: fnd_global.user_id ,
12385: SYSDATE ,
12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID
12389: fnd_global.conc_program_id , -- Program Id
12390: fnd_global.conc_login_id , -- Program Login ID
12391: 1

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

12384: fnd_global.user_id ,
12385: SYSDATE ,
12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID
12389: fnd_global.conc_program_id , -- Program Id
12390: fnd_global.conc_login_id , -- Program Login ID
12391: 1
12392: )

Line 12389: fnd_global.conc_program_id , -- Program Id

12385: SYSDATE ,
12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID
12389: fnd_global.conc_program_id , -- Program Id
12390: fnd_global.conc_login_id , -- Program Login ID
12391: 1
12392: )
12393: SELECT

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

12386: fnd_global.conc_login_id ,
12387: fnd_global.conc_request_id , -- Request Id
12388: fnd_global.prog_appl_id , -- Program Application ID
12389: fnd_global.conc_program_id , -- Program Id
12390: fnd_global.conc_login_id , -- Program Login ID
12391: 1
12392: )
12393: SELECT
12394: results.tax_code_id TAX_RATE_ID,

Line 12711: fnd_global.user_id ,

12707: ATTRIBUTE15 ,
12708: ATTRIBUTE_CATEGORY ,
12709: zx_rates_b_s.nextval ,--TAX_RATE_ID
12710: CONTENT_OWNER_ID ,
12711: fnd_global.user_id ,
12712: SYSDATE ,
12713: fnd_global.user_id ,
12714: SYSDATE ,
12715: fnd_global.conc_login_id ,

Line 12713: fnd_global.user_id ,

12709: zx_rates_b_s.nextval ,--TAX_RATE_ID
12710: CONTENT_OWNER_ID ,
12711: fnd_global.user_id ,
12712: SYSDATE ,
12713: fnd_global.user_id ,
12714: SYSDATE ,
12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID

Line 12715: fnd_global.conc_login_id ,

12711: fnd_global.user_id ,
12712: SYSDATE ,
12713: fnd_global.user_id ,
12714: SYSDATE ,
12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID
12718: fnd_global.conc_program_id , -- Program Id
12719: fnd_global.conc_login_id , -- Program Login ID

Line 12716: fnd_global.conc_request_id , -- Request Id

12712: SYSDATE ,
12713: fnd_global.user_id ,
12714: SYSDATE ,
12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID
12718: fnd_global.conc_program_id , -- Program Id
12719: fnd_global.conc_login_id , -- Program Login ID
12720: 'TAX_RATE' ,

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

12713: fnd_global.user_id ,
12714: SYSDATE ,
12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID
12718: fnd_global.conc_program_id , -- Program Id
12719: fnd_global.conc_login_id , -- Program Login ID
12720: 'TAX_RATE' ,
12721: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 12718: fnd_global.conc_program_id , -- Program Id

12714: SYSDATE ,
12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID
12718: fnd_global.conc_program_id , -- Program Id
12719: fnd_global.conc_login_id , -- Program Login ID
12720: 'TAX_RATE' ,
12721: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12722: 1

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

12715: fnd_global.conc_login_id ,
12716: fnd_global.conc_request_id , -- Request Id
12717: fnd_global.prog_appl_id , -- Program Application ID
12718: fnd_global.conc_program_id , -- Program Id
12719: fnd_global.conc_login_id , -- Program Login ID
12720: 'TAX_RATE' ,
12721: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12722: 1
12723: -- , DESCRIPTION -- Bug 4705196

Line 12806: fnd_global.user_id ,

12802: NULL ,
12803: NULL ,
12804: NULL ,
12805: NULL ,
12806: fnd_global.user_id ,
12807: SYSDATE ,
12808: fnd_global.user_id ,
12809: SYSDATE ,
12810: fnd_global.conc_login_id ,

Line 12808: fnd_global.user_id ,

12804: NULL ,
12805: NULL ,
12806: fnd_global.user_id ,
12807: SYSDATE ,
12808: fnd_global.user_id ,
12809: SYSDATE ,
12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID

Line 12810: fnd_global.conc_login_id ,

12806: fnd_global.user_id ,
12807: SYSDATE ,
12808: fnd_global.user_id ,
12809: SYSDATE ,
12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID
12813: fnd_global.conc_program_id , -- Program Id
12814: fnd_global.conc_login_id , -- Program Login ID

Line 12811: fnd_global.conc_request_id , -- Request Id

12807: SYSDATE ,
12808: fnd_global.user_id ,
12809: SYSDATE ,
12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID
12813: fnd_global.conc_program_id , -- Program Id
12814: fnd_global.conc_login_id , -- Program Login ID
12815: 1

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

12808: fnd_global.user_id ,
12809: SYSDATE ,
12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID
12813: fnd_global.conc_program_id , -- Program Id
12814: fnd_global.conc_login_id , -- Program Login ID
12815: 1
12816: )

Line 12813: fnd_global.conc_program_id , -- Program Id

12809: SYSDATE ,
12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID
12813: fnd_global.conc_program_id , -- Program Id
12814: fnd_global.conc_login_id , -- Program Login ID
12815: 1
12816: )
12817: SELECT

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

12810: fnd_global.conc_login_id ,
12811: fnd_global.conc_request_id , -- Request Id
12812: fnd_global.prog_appl_id , -- Program Application ID
12813: fnd_global.conc_program_id , -- Program Id
12814: fnd_global.conc_login_id , -- Program Login ID
12815: 1
12816: )
12817: SELECT
12818: results.tax_code_id TAX_RATE_ID,

Line 13147: fnd_global.user_id ,

13143: ATTRIBUTE15 ,
13144: ATTRIBUTE_CATEGORY ,
13145: TAX_RATE_ID ,
13146: CONTENT_OWNER_ID ,
13147: fnd_global.user_id ,
13148: SYSDATE ,
13149: fnd_global.user_id ,
13150: SYSDATE ,
13151: fnd_global.conc_login_id ,

Line 13149: fnd_global.user_id ,

13145: TAX_RATE_ID ,
13146: CONTENT_OWNER_ID ,
13147: fnd_global.user_id ,
13148: SYSDATE ,
13149: fnd_global.user_id ,
13150: SYSDATE ,
13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID

Line 13151: fnd_global.conc_login_id ,

13147: fnd_global.user_id ,
13148: SYSDATE ,
13149: fnd_global.user_id ,
13150: SYSDATE ,
13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID
13154: fnd_global.conc_program_id , -- Program Id
13155: fnd_global.conc_login_id , -- Program Login ID

Line 13152: fnd_global.conc_request_id , -- Request Id

13148: SYSDATE ,
13149: fnd_global.user_id ,
13150: SYSDATE ,
13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID
13154: fnd_global.conc_program_id , -- Program Id
13155: fnd_global.conc_login_id , -- Program Login ID
13156: 'TAX_RATE' ,

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

13149: fnd_global.user_id ,
13150: SYSDATE ,
13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID
13154: fnd_global.conc_program_id , -- Program Id
13155: fnd_global.conc_login_id , -- Program Login ID
13156: 'TAX_RATE' ,
13157: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 13154: fnd_global.conc_program_id , -- Program Id

13150: SYSDATE ,
13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID
13154: fnd_global.conc_program_id , -- Program Id
13155: fnd_global.conc_login_id , -- Program Login ID
13156: 'TAX_RATE' ,
13157: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13158: 1 ,

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

13151: fnd_global.conc_login_id ,
13152: fnd_global.conc_request_id , -- Request Id
13153: fnd_global.prog_appl_id , -- Program Application ID
13154: fnd_global.conc_program_id , -- Program Id
13155: fnd_global.conc_login_id , -- Program Login ID
13156: 'TAX_RATE' ,
13157: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13158: 1 ,
13159: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 13245: fnd_global.user_id ,

13241: NULL ,
13242: NULL ,
13243: NULL ,
13244: NULL ,
13245: fnd_global.user_id ,
13246: SYSDATE ,
13247: fnd_global.user_id ,
13248: SYSDATE ,
13249: fnd_global.conc_login_id ,

Line 13247: fnd_global.user_id ,

13243: NULL ,
13244: NULL ,
13245: fnd_global.user_id ,
13246: SYSDATE ,
13247: fnd_global.user_id ,
13248: SYSDATE ,
13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID

Line 13249: fnd_global.conc_login_id ,

13245: fnd_global.user_id ,
13246: SYSDATE ,
13247: fnd_global.user_id ,
13248: SYSDATE ,
13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID
13252: fnd_global.conc_program_id , -- Program Id
13253: fnd_global.conc_login_id , -- Program Login ID

Line 13250: fnd_global.conc_request_id , -- Request Id

13246: SYSDATE ,
13247: fnd_global.user_id ,
13248: SYSDATE ,
13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID
13252: fnd_global.conc_program_id , -- Program Id
13253: fnd_global.conc_login_id , -- Program Login ID
13254: 1

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

13247: fnd_global.user_id ,
13248: SYSDATE ,
13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID
13252: fnd_global.conc_program_id , -- Program Id
13253: fnd_global.conc_login_id , -- Program Login ID
13254: 1
13255: )

Line 13252: fnd_global.conc_program_id , -- Program Id

13248: SYSDATE ,
13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID
13252: fnd_global.conc_program_id , -- Program Id
13253: fnd_global.conc_login_id , -- Program Login ID
13254: 1
13255: )
13256: SELECT

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

13249: fnd_global.conc_login_id ,
13250: fnd_global.conc_request_id , -- Request Id
13251: fnd_global.prog_appl_id , -- Program Application ID
13252: fnd_global.conc_program_id , -- Program Id
13253: fnd_global.conc_login_id , -- Program Login ID
13254: 1
13255: )
13256: SELECT
13257: results.tax_code_id TAX_RATE_ID,

Line 13572: fnd_global.user_id ,

13568: ATTRIBUTE15 ,
13569: ATTRIBUTE_CATEGORY ,
13570: TAX_RATE_ID ,
13571: CONTENT_OWNER_ID ,
13572: fnd_global.user_id ,
13573: SYSDATE ,
13574: fnd_global.user_id ,
13575: SYSDATE ,
13576: fnd_global.conc_login_id ,

Line 13574: fnd_global.user_id ,

13570: TAX_RATE_ID ,
13571: CONTENT_OWNER_ID ,
13572: fnd_global.user_id ,
13573: SYSDATE ,
13574: fnd_global.user_id ,
13575: SYSDATE ,
13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID

Line 13576: fnd_global.conc_login_id ,

13572: fnd_global.user_id ,
13573: SYSDATE ,
13574: fnd_global.user_id ,
13575: SYSDATE ,
13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID
13579: fnd_global.conc_program_id , -- Program Id
13580: fnd_global.conc_login_id , -- Program Login ID

Line 13577: fnd_global.conc_request_id , -- Request Id

13573: SYSDATE ,
13574: fnd_global.user_id ,
13575: SYSDATE ,
13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID
13579: fnd_global.conc_program_id , -- Program Id
13580: fnd_global.conc_login_id , -- Program Login ID
13581: 'TAX_RATE' ,

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

13574: fnd_global.user_id ,
13575: SYSDATE ,
13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID
13579: fnd_global.conc_program_id , -- Program Id
13580: fnd_global.conc_login_id , -- Program Login ID
13581: 'TAX_RATE' ,
13582: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 13579: fnd_global.conc_program_id , -- Program Id

13575: SYSDATE ,
13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID
13579: fnd_global.conc_program_id , -- Program Id
13580: fnd_global.conc_login_id , -- Program Login ID
13581: 'TAX_RATE' ,
13582: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13583: 1 ,

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

13576: fnd_global.conc_login_id ,
13577: fnd_global.conc_request_id , -- Request Id
13578: fnd_global.prog_appl_id , -- Program Application ID
13579: fnd_global.conc_program_id , -- Program Id
13580: fnd_global.conc_login_id , -- Program Login ID
13581: 'TAX_RATE' ,
13582: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13583: 1 ,
13584: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 13670: fnd_global.user_id ,

13666: NULL ,
13667: NULL ,
13668: NULL ,
13669: NULL ,
13670: fnd_global.user_id ,
13671: SYSDATE ,
13672: fnd_global.user_id ,
13673: SYSDATE ,
13674: fnd_global.conc_login_id ,

Line 13672: fnd_global.user_id ,

13668: NULL ,
13669: NULL ,
13670: fnd_global.user_id ,
13671: SYSDATE ,
13672: fnd_global.user_id ,
13673: SYSDATE ,
13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID

Line 13674: fnd_global.conc_login_id ,

13670: fnd_global.user_id ,
13671: SYSDATE ,
13672: fnd_global.user_id ,
13673: SYSDATE ,
13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID
13677: fnd_global.conc_program_id , -- Program Id
13678: fnd_global.conc_login_id , -- Program Login ID

Line 13675: fnd_global.conc_request_id , -- Request Id

13671: SYSDATE ,
13672: fnd_global.user_id ,
13673: SYSDATE ,
13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID
13677: fnd_global.conc_program_id , -- Program Id
13678: fnd_global.conc_login_id , -- Program Login ID
13679: 1

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

13672: fnd_global.user_id ,
13673: SYSDATE ,
13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID
13677: fnd_global.conc_program_id , -- Program Id
13678: fnd_global.conc_login_id , -- Program Login ID
13679: 1
13680: )

Line 13677: fnd_global.conc_program_id , -- Program Id

13673: SYSDATE ,
13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID
13677: fnd_global.conc_program_id , -- Program Id
13678: fnd_global.conc_login_id , -- Program Login ID
13679: 1
13680: )
13681: SELECT

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

13674: fnd_global.conc_login_id ,
13675: fnd_global.conc_request_id , -- Request Id
13676: fnd_global.prog_appl_id , -- Program Application ID
13677: fnd_global.conc_program_id , -- Program Id
13678: fnd_global.conc_login_id , -- Program Login ID
13679: 1
13680: )
13681: SELECT
13682: results.tax_code_id TAX_RATE_ID,

Line 13911: fnd_global.user_id ,

13907: THEN Initcap(TAX_RATE_CODE)
13908: ELSE
13909: TAX_RATE_CODE
13910: END ,
13911: fnd_global.user_id ,
13912: SYSDATE ,
13913: fnd_global.user_id ,
13914: SYSDATE ,
13915: fnd_global.conc_login_id ,

Line 13913: fnd_global.user_id ,

13909: TAX_RATE_CODE
13910: END ,
13911: fnd_global.user_id ,
13912: SYSDATE ,
13913: fnd_global.user_id ,
13914: SYSDATE ,
13915: fnd_global.conc_login_id ,
13916: L.LANGUAGE_CODE,
13917: userenv('LANG'),

Line 13915: fnd_global.conc_login_id ,

13911: fnd_global.user_id ,
13912: SYSDATE ,
13913: fnd_global.user_id ,
13914: SYSDATE ,
13915: fnd_global.conc_login_id ,
13916: L.LANGUAGE_CODE,
13917: userenv('LANG'),
13918: avtb.description
13919: FROM FND_LANGUAGES L,