APPS.ZX_MIGRATE_TAX_DEF dependencies on FND_GLOBAL

Line 347: fnd_global.user_id ,

343: ATTRIBUTE14 ,
344: ATTRIBUTE15 ,
345: TAG ,
346: SYSDATE ,
347: fnd_global.user_id ,
348: SYSDATE ,
349: fnd_global.user_id ,
350: fnd_global.conc_login_id
351: FROM FND_LOOKUP_VALUES ap_lookups

Line 349: fnd_global.user_id ,

345: TAG ,
346: SYSDATE ,
347: fnd_global.user_id ,
348: SYSDATE ,
349: fnd_global.user_id ,
350: fnd_global.conc_login_id
351: FROM FND_LOOKUP_VALUES ap_lookups
352: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
353: AND NOT EXISTS

Line 350: fnd_global.conc_login_id

346: SYSDATE ,
347: fnd_global.user_id ,
348: SYSDATE ,
349: fnd_global.user_id ,
350: fnd_global.conc_login_id
351: FROM FND_LOOKUP_VALUES ap_lookups
352: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
353: AND NOT EXISTS
354: (select 1 from FND_LOOKUP_VALUES

Line 444: fnd_global.user_id ,

440: ATTRIBUTE14 ,
441: ATTRIBUTE15 ,
442: TAG ,
443: SYSDATE ,
444: fnd_global.user_id ,
445: SYSDATE ,
446: fnd_global.user_id ,
447: fnd_global.conc_login_id
448: FROM FND_LOOKUP_VALUES ap_lookups

Line 446: fnd_global.user_id ,

442: TAG ,
443: SYSDATE ,
444: fnd_global.user_id ,
445: SYSDATE ,
446: fnd_global.user_id ,
447: fnd_global.conc_login_id
448: FROM FND_LOOKUP_VALUES ap_lookups
449: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
450: -- Changed the re-runnability check

Line 447: fnd_global.conc_login_id

443: SYSDATE ,
444: fnd_global.user_id ,
445: SYSDATE ,
446: fnd_global.user_id ,
447: fnd_global.conc_login_id
448: FROM FND_LOOKUP_VALUES ap_lookups
449: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
450: -- Changed the re-runnability check
451: AND NOT EXISTS

Line 534: fnd_global.user_id ,

530: 'E' ,
531: 0 ,
532: 0 ,
533: SYSDATE ,
534: fnd_global.user_id ,
535: SYSDATE ,
536: fnd_global.user_id ,
537: fnd_global.conc_login_id
538: )

Line 536: fnd_global.user_id ,

532: 0 ,
533: SYSDATE ,
534: fnd_global.user_id ,
535: SYSDATE ,
536: fnd_global.user_id ,
537: fnd_global.conc_login_id
538: )
539: WHEN (NOT EXISTS
540: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 537: fnd_global.conc_login_id

533: SYSDATE ,
534: fnd_global.user_id ,
535: SYSDATE ,
536: fnd_global.user_id ,
537: fnd_global.conc_login_id
538: )
539: WHEN (NOT EXISTS
540: (SELECT 1 FROM FND_LOOKUP_TYPES
541: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')

Line 564: fnd_global.user_id ,

560: 'E' ,
561: 0 ,
562: 0 ,
563: SYSDATE ,
564: fnd_global.user_id ,
565: SYSDATE ,
566: fnd_global.user_id ,
567: fnd_global.conc_login_id
568: )

Line 566: fnd_global.user_id ,

562: 0 ,
563: SYSDATE ,
564: fnd_global.user_id ,
565: SYSDATE ,
566: fnd_global.user_id ,
567: fnd_global.conc_login_id
568: )
569: WHEN (NOT EXISTS
570: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 567: fnd_global.conc_login_id

563: SYSDATE ,
564: fnd_global.user_id ,
565: SYSDATE ,
566: fnd_global.user_id ,
567: fnd_global.conc_login_id
568: )
569: WHEN (NOT EXISTS
570: (SELECT 1 FROM FND_LOOKUP_TYPES
571: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')

Line 594: fnd_global.user_id ,

590: 'E' ,
591: 0 ,
592: 0 ,
593: SYSDATE ,
594: fnd_global.user_id ,
595: SYSDATE ,
596: fnd_global.user_id ,
597: fnd_global.conc_login_id
598: )

Line 596: fnd_global.user_id ,

592: 0 ,
593: SYSDATE ,
594: fnd_global.user_id ,
595: SYSDATE ,
596: fnd_global.user_id ,
597: fnd_global.conc_login_id
598: )
599:
600: SELECT 1 FROM DUAL;

Line 597: fnd_global.conc_login_id

593: SYSDATE ,
594: fnd_global.user_id ,
595: SYSDATE ,
596: fnd_global.user_id ,
597: fnd_global.conc_login_id
598: )
599:
600: SELECT 1 FROM DUAL;
601:

Line 628: fnd_global.user_id ,

624: THEN Initcap(types.lookup_type)
625: ELSE types.lookup_type
626: END,--MEANING
627: types.lookup_type,--DESCRIPTION
628: fnd_global.user_id ,
629: SYSDATE ,
630: fnd_global.user_id ,
631: SYSDATE ,
632: fnd_global.conc_login_id

Line 630: fnd_global.user_id ,

626: END,--MEANING
627: types.lookup_type,--DESCRIPTION
628: fnd_global.user_id ,
629: SYSDATE ,
630: fnd_global.user_id ,
631: SYSDATE ,
632: fnd_global.conc_login_id
633: FROM FND_LOOKUP_TYPES types,
634: FND_LANGUAGES L

Line 632: fnd_global.conc_login_id

628: fnd_global.user_id ,
629: SYSDATE ,
630: fnd_global.user_id ,
631: SYSDATE ,
632: fnd_global.conc_login_id
633: FROM FND_LOOKUP_TYPES types,
634: FND_LANGUAGES L
635: WHERE L.INSTALLED_FLAG in ('I', 'B')
636: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',

Line 731: fnd_global.user_id ,

727: NULL ,--ATTRIBUTE14
728: NULL ,--ATTRIBUTE15
729: NULL ,--TAG
730: SYSDATE ,
731: fnd_global.user_id ,
732: SYSDATE ,
733: fnd_global.user_id ,
734: fnd_global.conc_login_id
735: FROM

Line 733: fnd_global.user_id ,

729: NULL ,--TAG
730: SYSDATE ,
731: fnd_global.user_id ,
732: SYSDATE ,
733: fnd_global.user_id ,
734: fnd_global.conc_login_id
735: FROM
736: (
737: SELECT

Line 734: fnd_global.conc_login_id

730: SYSDATE ,
731: fnd_global.user_id ,
732: SYSDATE ,
733: fnd_global.user_id ,
734: fnd_global.conc_login_id
735: FROM
736: (
737: SELECT
738: codes.name LOOKUP_CODE,

Line 858: fnd_global.user_id ,

854: NULL ,--ATTRIBUTE14
855: NULL ,--ATTRIBUTE15
856: NULL ,--TAG
857: SYSDATE ,
858: fnd_global.user_id ,
859: SYSDATE ,
860: fnd_global.user_id ,
861: fnd_global.conc_login_id
862: FROM

Line 860: fnd_global.user_id ,

856: NULL ,--TAG
857: SYSDATE ,
858: fnd_global.user_id ,
859: SYSDATE ,
860: fnd_global.user_id ,
861: fnd_global.conc_login_id
862: FROM
863: (
864: SELECT

Line 861: fnd_global.conc_login_id

857: SYSDATE ,
858: fnd_global.user_id ,
859: SYSDATE ,
860: fnd_global.user_id ,
861: fnd_global.conc_login_id
862: FROM
863: (
864: SELECT
865: codes.name LOOKUP_CODE,

Line 931: fnd_global.user_id , --created_by

927: TAX_TYPE , --tax_type
928: START_DATE , --effective_from
929: INACTIVE_DATE , --effective_to
930: 'AP' , --source
931: fnd_global.user_id , --created_by
932: SYSDATE , --creation_date
933: fnd_global.user_id , --last_updated_by
934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login

Line 933: fnd_global.user_id , --last_updated_by

929: INACTIVE_DATE , --effective_to
930: 'AP' , --source
931: fnd_global.user_id , --created_by
932: SYSDATE , --creation_date
933: fnd_global.user_id , --last_updated_by
934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id

Line 935: fnd_global.user_id , --last_update_login

931: fnd_global.user_id , --created_by
932: SYSDATE , --creation_date
933: fnd_global.user_id , --last_updated_by
934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id
938: fnd_global.conc_program_id , --program_id
939: fnd_global.conc_login_id , --program_login_id

Line 936: fnd_global.conc_request_id , --request_id

932: SYSDATE , --creation_date
933: fnd_global.user_id , --last_updated_by
934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id
938: fnd_global.conc_program_id , --program_id
939: fnd_global.conc_login_id , --program_login_id
940: codes.set_of_books_id , --ledger_id

Line 937: fnd_global.prog_appl_id , --program_application_id

933: fnd_global.user_id , --last_updated_by
934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id
938: fnd_global.conc_program_id , --program_id
939: fnd_global.conc_login_id , --program_login_id
940: codes.set_of_books_id , --ledger_id
941: codes.enabled_flag

Line 938: fnd_global.conc_program_id , --program_id

934: SYSDATE , --last_update_date
935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id
938: fnd_global.conc_program_id , --program_id
939: fnd_global.conc_login_id , --program_login_id
940: codes.set_of_books_id , --ledger_id
941: codes.enabled_flag
942: FROM

Line 939: fnd_global.conc_login_id , --program_login_id

935: fnd_global.user_id , --last_update_login
936: fnd_global.conc_request_id , --request_id
937: fnd_global.prog_appl_id , --program_application_id
938: fnd_global.conc_program_id , --program_id
939: fnd_global.conc_login_id , --program_login_id
940: codes.set_of_books_id , --ledger_id
941: codes.enabled_flag
942: FROM
943: AP_TAX_CODES_ALL codes

Line 1123: fnd_global.user_id ,

1119: ATTRIBUTE15 ,
1120: ATTRIBUTE_CATEGORY ,
1121: zx_rates_b_s.nextval ,--TAX_RATE_ID
1122: CONTENT_OWNER_ID ,
1123: fnd_global.user_id ,
1124: SYSDATE ,
1125: fnd_global.user_id ,
1126: SYSDATE ,
1127: fnd_global.conc_login_id ,

Line 1125: fnd_global.user_id ,

1121: zx_rates_b_s.nextval ,--TAX_RATE_ID
1122: CONTENT_OWNER_ID ,
1123: fnd_global.user_id ,
1124: SYSDATE ,
1125: fnd_global.user_id ,
1126: SYSDATE ,
1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID

Line 1127: fnd_global.conc_login_id ,

1123: fnd_global.user_id ,
1124: SYSDATE ,
1125: fnd_global.user_id ,
1126: SYSDATE ,
1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID
1130: fnd_global.conc_program_id , -- Program Id
1131: fnd_global.conc_login_id , -- Program Login ID

Line 1128: fnd_global.conc_request_id , -- Request Id

1124: SYSDATE ,
1125: fnd_global.user_id ,
1126: SYSDATE ,
1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID
1130: fnd_global.conc_program_id , -- Program Id
1131: fnd_global.conc_login_id , -- Program Login ID
1132: 'TAX_RATE' ,

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

1125: fnd_global.user_id ,
1126: SYSDATE ,
1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID
1130: fnd_global.conc_program_id , -- Program Id
1131: fnd_global.conc_login_id , -- Program Login ID
1132: 'TAX_RATE' ,
1133: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG

Line 1130: fnd_global.conc_program_id , -- Program Id

1126: SYSDATE ,
1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID
1130: fnd_global.conc_program_id , -- Program Id
1131: fnd_global.conc_login_id , -- Program Login ID
1132: 'TAX_RATE' ,
1133: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
1134: 1

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

1127: fnd_global.conc_login_id ,
1128: fnd_global.conc_request_id , -- Request Id
1129: fnd_global.prog_appl_id , -- Program Application ID
1130: fnd_global.conc_program_id , -- Program Id
1131: fnd_global.conc_login_id , -- Program Login ID
1132: 'TAX_RATE' ,
1133: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
1134: 1
1135: -- 6820043, commenting out description

Line 1219: fnd_global.user_id ,

1215: NULL ,
1216: NULL ,
1217: NULL ,
1218: NULL ,
1219: fnd_global.user_id ,
1220: SYSDATE ,
1221: fnd_global.user_id ,
1222: SYSDATE ,
1223: fnd_global.conc_login_id ,

Line 1221: fnd_global.user_id ,

1217: NULL ,
1218: NULL ,
1219: fnd_global.user_id ,
1220: SYSDATE ,
1221: fnd_global.user_id ,
1222: SYSDATE ,
1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID

Line 1223: fnd_global.conc_login_id ,

1219: fnd_global.user_id ,
1220: SYSDATE ,
1221: fnd_global.user_id ,
1222: SYSDATE ,
1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID
1226: fnd_global.conc_program_id , -- Program Id
1227: fnd_global.conc_login_id , -- Program Login ID

Line 1224: fnd_global.conc_request_id , -- Request Id

1220: SYSDATE ,
1221: fnd_global.user_id ,
1222: SYSDATE ,
1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID
1226: fnd_global.conc_program_id , -- Program Id
1227: fnd_global.conc_login_id , -- Program Login ID
1228: 1

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

1221: fnd_global.user_id ,
1222: SYSDATE ,
1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID
1226: fnd_global.conc_program_id , -- Program Id
1227: fnd_global.conc_login_id , -- Program Login ID
1228: 1
1229: )

Line 1226: fnd_global.conc_program_id , -- Program Id

1222: SYSDATE ,
1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID
1226: fnd_global.conc_program_id , -- Program Id
1227: fnd_global.conc_login_id , -- Program Login ID
1228: 1
1229: )
1230: SELECT

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

1223: fnd_global.conc_login_id ,
1224: fnd_global.conc_request_id , -- Request Id
1225: fnd_global.prog_appl_id , -- Program Application ID
1226: fnd_global.conc_program_id , -- Program Id
1227: fnd_global.conc_login_id , -- Program Login ID
1228: 1
1229: )
1230: SELECT
1231: results.tax_code_id TAX_RATE_ID,

Line 1540: fnd_global.user_id ,

1536: ATTRIBUTE15 ,
1537: ATTRIBUTE_CATEGORY ,
1538: zx_rates_b_s.nextval ,--TAX_RATE_ID
1539: CONTENT_OWNER_ID ,
1540: fnd_global.user_id ,
1541: SYSDATE ,
1542: fnd_global.user_id ,
1543: SYSDATE ,
1544: fnd_global.conc_login_id ,

Line 1542: fnd_global.user_id ,

1538: zx_rates_b_s.nextval ,--TAX_RATE_ID
1539: CONTENT_OWNER_ID ,
1540: fnd_global.user_id ,
1541: SYSDATE ,
1542: fnd_global.user_id ,
1543: SYSDATE ,
1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID

Line 1544: fnd_global.conc_login_id ,

1540: fnd_global.user_id ,
1541: SYSDATE ,
1542: fnd_global.user_id ,
1543: SYSDATE ,
1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID
1547: fnd_global.conc_program_id , -- Program Id
1548: fnd_global.conc_login_id , -- Program Login ID

Line 1545: fnd_global.conc_request_id , -- Request Id

1541: SYSDATE ,
1542: fnd_global.user_id ,
1543: SYSDATE ,
1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID
1547: fnd_global.conc_program_id , -- Program Id
1548: fnd_global.conc_login_id , -- Program Login ID
1549: 'TAX_RATE' ,

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

1542: fnd_global.user_id ,
1543: SYSDATE ,
1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID
1547: fnd_global.conc_program_id , -- Program Id
1548: fnd_global.conc_login_id , -- Program Login ID
1549: 'TAX_RATE' ,
1550: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 1547: fnd_global.conc_program_id , -- Program Id

1543: SYSDATE ,
1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID
1547: fnd_global.conc_program_id , -- Program Id
1548: fnd_global.conc_login_id , -- Program Login ID
1549: 'TAX_RATE' ,
1550: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
1551: 1

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

1544: fnd_global.conc_login_id ,
1545: fnd_global.conc_request_id , -- Request Id
1546: fnd_global.prog_appl_id , -- Program Application ID
1547: fnd_global.conc_program_id , -- Program Id
1548: fnd_global.conc_login_id , -- Program Login ID
1549: 'TAX_RATE' ,
1550: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
1551: 1
1552: -- 6820043, commenting out description

Line 1636: fnd_global.user_id ,

1632: NULL ,
1633: NULL ,
1634: NULL ,
1635: NULL ,
1636: fnd_global.user_id ,
1637: SYSDATE ,
1638: fnd_global.user_id ,
1639: SYSDATE ,
1640: fnd_global.conc_login_id ,

Line 1638: fnd_global.user_id ,

1634: NULL ,
1635: NULL ,
1636: fnd_global.user_id ,
1637: SYSDATE ,
1638: fnd_global.user_id ,
1639: SYSDATE ,
1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID

Line 1640: fnd_global.conc_login_id ,

1636: fnd_global.user_id ,
1637: SYSDATE ,
1638: fnd_global.user_id ,
1639: SYSDATE ,
1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID
1643: fnd_global.conc_program_id , -- Program Id
1644: fnd_global.conc_login_id , -- Program Login ID

Line 1641: fnd_global.conc_request_id , -- Request Id

1637: SYSDATE ,
1638: fnd_global.user_id ,
1639: SYSDATE ,
1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID
1643: fnd_global.conc_program_id , -- Program Id
1644: fnd_global.conc_login_id , -- Program Login ID
1645: 1

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

1638: fnd_global.user_id ,
1639: SYSDATE ,
1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID
1643: fnd_global.conc_program_id , -- Program Id
1644: fnd_global.conc_login_id , -- Program Login ID
1645: 1
1646: )

Line 1643: fnd_global.conc_program_id , -- Program Id

1639: SYSDATE ,
1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID
1643: fnd_global.conc_program_id , -- Program Id
1644: fnd_global.conc_login_id , -- Program Login ID
1645: 1
1646: )
1647: SELECT

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

1640: fnd_global.conc_login_id ,
1641: fnd_global.conc_request_id , -- Request Id
1642: fnd_global.prog_appl_id , -- Program Application ID
1643: fnd_global.conc_program_id , -- Program Id
1644: fnd_global.conc_login_id , -- Program Login ID
1645: 1
1646: )
1647: SELECT
1648: results.tax_code_id TAX_RATE_ID,

Line 1965: fnd_global.user_id ,

1961: ATTRIBUTE15 ,
1962: ATTRIBUTE_CATEGORY ,
1963: TAX_RATE_ID ,
1964: CONTENT_OWNER_ID ,
1965: fnd_global.user_id ,
1966: SYSDATE ,
1967: fnd_global.user_id ,
1968: SYSDATE ,
1969: fnd_global.conc_login_id ,

Line 1967: fnd_global.user_id ,

1963: TAX_RATE_ID ,
1964: CONTENT_OWNER_ID ,
1965: fnd_global.user_id ,
1966: SYSDATE ,
1967: fnd_global.user_id ,
1968: SYSDATE ,
1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID

Line 1969: fnd_global.conc_login_id ,

1965: fnd_global.user_id ,
1966: SYSDATE ,
1967: fnd_global.user_id ,
1968: SYSDATE ,
1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID
1972: fnd_global.conc_program_id , -- Program Id
1973: fnd_global.conc_login_id , -- Program Login ID

Line 1970: fnd_global.conc_request_id , -- Request Id

1966: SYSDATE ,
1967: fnd_global.user_id ,
1968: SYSDATE ,
1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID
1972: fnd_global.conc_program_id , -- Program Id
1973: fnd_global.conc_login_id , -- Program Login ID
1974: 'TAX_RATE' ,

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

1967: fnd_global.user_id ,
1968: SYSDATE ,
1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID
1972: fnd_global.conc_program_id , -- Program Id
1973: fnd_global.conc_login_id , -- Program Login ID
1974: 'TAX_RATE' ,
1975: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 1972: fnd_global.conc_program_id , -- Program Id

1968: SYSDATE ,
1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID
1972: fnd_global.conc_program_id , -- Program Id
1973: fnd_global.conc_login_id , -- Program Login ID
1974: 'TAX_RATE' ,
1975: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
1976: 1 ,

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

1969: fnd_global.conc_login_id ,
1970: fnd_global.conc_request_id , -- Request Id
1971: fnd_global.prog_appl_id , -- Program Application ID
1972: fnd_global.conc_program_id , -- Program Id
1973: fnd_global.conc_login_id , -- Program Login ID
1974: 'TAX_RATE' ,
1975: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
1976: 1 ,
1977: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 2063: fnd_global.user_id ,

2059: NULL ,
2060: NULL ,
2061: NULL ,
2062: NULL ,
2063: fnd_global.user_id ,
2064: SYSDATE ,
2065: fnd_global.user_id ,
2066: SYSDATE ,
2067: fnd_global.conc_login_id ,

Line 2065: fnd_global.user_id ,

2061: NULL ,
2062: NULL ,
2063: fnd_global.user_id ,
2064: SYSDATE ,
2065: fnd_global.user_id ,
2066: SYSDATE ,
2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID

Line 2067: fnd_global.conc_login_id ,

2063: fnd_global.user_id ,
2064: SYSDATE ,
2065: fnd_global.user_id ,
2066: SYSDATE ,
2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID
2070: fnd_global.conc_program_id , -- Program Id
2071: fnd_global.conc_login_id , -- Program Login ID

Line 2068: fnd_global.conc_request_id , -- Request Id

2064: SYSDATE ,
2065: fnd_global.user_id ,
2066: SYSDATE ,
2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID
2070: fnd_global.conc_program_id , -- Program Id
2071: fnd_global.conc_login_id , -- Program Login ID
2072: 1

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

2065: fnd_global.user_id ,
2066: SYSDATE ,
2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID
2070: fnd_global.conc_program_id , -- Program Id
2071: fnd_global.conc_login_id , -- Program Login ID
2072: 1
2073: )

Line 2070: fnd_global.conc_program_id , -- Program Id

2066: SYSDATE ,
2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID
2070: fnd_global.conc_program_id , -- Program Id
2071: fnd_global.conc_login_id , -- Program Login ID
2072: 1
2073: )
2074: SELECT

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

2067: fnd_global.conc_login_id ,
2068: fnd_global.conc_request_id , -- Request Id
2069: fnd_global.prog_appl_id , -- Program Application ID
2070: fnd_global.conc_program_id , -- Program Id
2071: fnd_global.conc_login_id , -- Program Login ID
2072: 1
2073: )
2074: SELECT
2075: results.tax_code_id TAX_RATE_ID,

Line 2389: fnd_global.user_id ,

2385: ATTRIBUTE15 ,
2386: ATTRIBUTE_CATEGORY ,
2387: TAX_RATE_ID ,
2388: CONTENT_OWNER_ID ,
2389: fnd_global.user_id ,
2390: SYSDATE ,
2391: fnd_global.user_id ,
2392: SYSDATE ,
2393: fnd_global.conc_login_id ,

Line 2391: fnd_global.user_id ,

2387: TAX_RATE_ID ,
2388: CONTENT_OWNER_ID ,
2389: fnd_global.user_id ,
2390: SYSDATE ,
2391: fnd_global.user_id ,
2392: SYSDATE ,
2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID

Line 2393: fnd_global.conc_login_id ,

2389: fnd_global.user_id ,
2390: SYSDATE ,
2391: fnd_global.user_id ,
2392: SYSDATE ,
2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID
2396: fnd_global.conc_program_id , -- Program Id
2397: fnd_global.conc_login_id , -- Program Login ID

Line 2394: fnd_global.conc_request_id , -- Request Id

2390: SYSDATE ,
2391: fnd_global.user_id ,
2392: SYSDATE ,
2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID
2396: fnd_global.conc_program_id , -- Program Id
2397: fnd_global.conc_login_id , -- Program Login ID
2398: 'TAX_RATE' ,

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

2391: fnd_global.user_id ,
2392: SYSDATE ,
2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID
2396: fnd_global.conc_program_id , -- Program Id
2397: fnd_global.conc_login_id , -- Program Login ID
2398: 'TAX_RATE' ,
2399: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 2396: fnd_global.conc_program_id , -- Program Id

2392: SYSDATE ,
2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID
2396: fnd_global.conc_program_id , -- Program Id
2397: fnd_global.conc_login_id , -- Program Login ID
2398: 'TAX_RATE' ,
2399: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
2400: 1 ,

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

2393: fnd_global.conc_login_id ,
2394: fnd_global.conc_request_id , -- Request Id
2395: fnd_global.prog_appl_id , -- Program Application ID
2396: fnd_global.conc_program_id , -- Program Id
2397: fnd_global.conc_login_id , -- Program Login ID
2398: 'TAX_RATE' ,
2399: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
2400: 1 ,
2401: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 2487: fnd_global.user_id ,

2483: NULL ,
2484: NULL ,
2485: NULL ,
2486: NULL ,
2487: fnd_global.user_id ,
2488: SYSDATE ,
2489: fnd_global.user_id ,
2490: SYSDATE ,
2491: fnd_global.conc_login_id ,

Line 2489: fnd_global.user_id ,

2485: NULL ,
2486: NULL ,
2487: fnd_global.user_id ,
2488: SYSDATE ,
2489: fnd_global.user_id ,
2490: SYSDATE ,
2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID

Line 2491: fnd_global.conc_login_id ,

2487: fnd_global.user_id ,
2488: SYSDATE ,
2489: fnd_global.user_id ,
2490: SYSDATE ,
2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID
2494: fnd_global.conc_program_id , -- Program Id
2495: fnd_global.conc_login_id , -- Program Login ID

Line 2492: fnd_global.conc_request_id , -- Request Id

2488: SYSDATE ,
2489: fnd_global.user_id ,
2490: SYSDATE ,
2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID
2494: fnd_global.conc_program_id , -- Program Id
2495: fnd_global.conc_login_id , -- Program Login ID
2496: 1

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

2489: fnd_global.user_id ,
2490: SYSDATE ,
2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID
2494: fnd_global.conc_program_id , -- Program Id
2495: fnd_global.conc_login_id , -- Program Login ID
2496: 1
2497: )

Line 2494: fnd_global.conc_program_id , -- Program Id

2490: SYSDATE ,
2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID
2494: fnd_global.conc_program_id , -- Program Id
2495: fnd_global.conc_login_id , -- Program Login ID
2496: 1
2497: )
2498: SELECT

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

2491: fnd_global.conc_login_id ,
2492: fnd_global.conc_request_id , -- Request Id
2493: fnd_global.prog_appl_id , -- Program Application ID
2494: fnd_global.conc_program_id , -- Program Id
2495: fnd_global.conc_login_id , -- Program Login ID
2496: 1
2497: )
2498: SELECT
2499: results.tax_code_id TAX_RATE_ID,

Line 2728: fnd_global.user_id ,

2724: THEN Initcap(TAX_RATE_CODE)||'-'||RATES.TAX_CLASS
2725: ELSE
2726: TAX_RATE_CODE||'-'||RATES.TAX_CLASS
2727: END,
2728: fnd_global.user_id ,
2729: SYSDATE ,
2730: fnd_global.user_id ,
2731: SYSDATE ,
2732: fnd_global.conc_login_id ,

Line 2730: fnd_global.user_id ,

2726: TAX_RATE_CODE||'-'||RATES.TAX_CLASS
2727: END,
2728: fnd_global.user_id ,
2729: SYSDATE ,
2730: fnd_global.user_id ,
2731: SYSDATE ,
2732: fnd_global.conc_login_id ,
2733: L.LANGUAGE_CODE,
2734: userenv('LANG'),

Line 2732: fnd_global.conc_login_id ,

2728: fnd_global.user_id ,
2729: SYSDATE ,
2730: fnd_global.user_id ,
2731: SYSDATE ,
2732: fnd_global.conc_login_id ,
2733: L.LANGUAGE_CODE,
2734: userenv('LANG'),
2735: avtb.description
2736: FROM FND_LANGUAGES L,

Line 2922: fnd_global.user_id ,

2918: ATTRIBUTE15 ,
2919: ATTRIBUTE_CATEGORY ,
2920: zx_rates_b_s.nextval ,--TAX_RATE_ID
2921: CONTENT_OWNER_ID ,
2922: fnd_global.user_id ,
2923: SYSDATE ,
2924: fnd_global.user_id ,
2925: SYSDATE ,
2926: fnd_global.conc_login_id ,

Line 2924: fnd_global.user_id ,

2920: zx_rates_b_s.nextval ,--TAX_RATE_ID
2921: CONTENT_OWNER_ID ,
2922: fnd_global.user_id ,
2923: SYSDATE ,
2924: fnd_global.user_id ,
2925: SYSDATE ,
2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID

Line 2926: fnd_global.conc_login_id ,

2922: fnd_global.user_id ,
2923: SYSDATE ,
2924: fnd_global.user_id ,
2925: SYSDATE ,
2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID
2929: fnd_global.conc_program_id , -- Program Id
2930: fnd_global.conc_login_id , -- Program Login ID

Line 2927: fnd_global.conc_request_id , -- Request Id

2923: SYSDATE ,
2924: fnd_global.user_id ,
2925: SYSDATE ,
2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID
2929: fnd_global.conc_program_id , -- Program Id
2930: fnd_global.conc_login_id , -- Program Login ID
2931: 'TAX_RATE' ,

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

2924: fnd_global.user_id ,
2925: SYSDATE ,
2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID
2929: fnd_global.conc_program_id , -- Program Id
2930: fnd_global.conc_login_id , -- Program Login ID
2931: 'TAX_RATE' ,
2932: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 2929: fnd_global.conc_program_id , -- Program Id

2925: SYSDATE ,
2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID
2929: fnd_global.conc_program_id , -- Program Id
2930: fnd_global.conc_login_id , -- Program Login ID
2931: 'TAX_RATE' ,
2932: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
2933: 1

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

2926: fnd_global.conc_login_id ,
2927: fnd_global.conc_request_id , -- Request Id
2928: fnd_global.prog_appl_id , -- Program Application ID
2929: fnd_global.conc_program_id , -- Program Id
2930: fnd_global.conc_login_id , -- Program Login ID
2931: 'TAX_RATE' ,
2932: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
2933: 1
2934: -- 6820043, commenting out description

Line 3018: fnd_global.user_id ,

3014: NULL ,
3015: NULL ,
3016: NULL ,
3017: NULL ,
3018: fnd_global.user_id ,
3019: SYSDATE ,
3020: fnd_global.user_id ,
3021: SYSDATE ,
3022: fnd_global.conc_login_id ,

Line 3020: fnd_global.user_id ,

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

Line 3022: fnd_global.conc_login_id ,

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

Line 3023: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 3025: fnd_global.conc_program_id , -- Program Id

3021: SYSDATE ,
3022: fnd_global.conc_login_id ,
3023: fnd_global.conc_request_id , -- Request Id
3024: fnd_global.prog_appl_id , -- Program Application ID
3025: fnd_global.conc_program_id , -- Program Id
3026: fnd_global.conc_login_id , -- Program Login ID
3027: 1
3028: )
3029: SELECT

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

3022: fnd_global.conc_login_id ,
3023: fnd_global.conc_request_id , -- Request Id
3024: fnd_global.prog_appl_id , -- Program Application ID
3025: fnd_global.conc_program_id , -- Program Id
3026: fnd_global.conc_login_id , -- Program Login ID
3027: 1
3028: )
3029: SELECT
3030: DISTINCT

Line 3235: fnd_global.user_id ,

3231: ATTRIBUTE15 ,
3232: ATTRIBUTE_CATEGORY ,
3233: zx_rates_b_s.nextval ,--TAX_RATE_ID
3234: CONTENT_OWNER_ID ,
3235: fnd_global.user_id ,
3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,

Line 3237: fnd_global.user_id ,

3233: zx_rates_b_s.nextval ,--TAX_RATE_ID
3234: CONTENT_OWNER_ID ,
3235: fnd_global.user_id ,
3236: SYSDATE ,
3237: fnd_global.user_id ,
3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID

Line 3239: fnd_global.conc_login_id ,

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

Line 3240: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 3242: fnd_global.conc_program_id , -- Program Id

3238: SYSDATE ,
3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 'TAX_RATE' ,
3245: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
3246: 1

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

3239: fnd_global.conc_login_id ,
3240: fnd_global.conc_request_id , -- Request Id
3241: fnd_global.prog_appl_id , -- Program Application ID
3242: fnd_global.conc_program_id , -- Program Id
3243: fnd_global.conc_login_id , -- Program Login ID
3244: 'TAX_RATE' ,
3245: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
3246: 1
3247: -- 6820043, commenting out description

Line 3331: fnd_global.user_id ,

3327: NULL ,
3328: NULL ,
3329: NULL ,
3330: NULL ,
3331: fnd_global.user_id ,
3332: SYSDATE ,
3333: fnd_global.user_id ,
3334: SYSDATE ,
3335: fnd_global.conc_login_id ,

Line 3333: fnd_global.user_id ,

3329: NULL ,
3330: NULL ,
3331: fnd_global.user_id ,
3332: SYSDATE ,
3333: fnd_global.user_id ,
3334: SYSDATE ,
3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID

Line 3335: fnd_global.conc_login_id ,

3331: fnd_global.user_id ,
3332: SYSDATE ,
3333: fnd_global.user_id ,
3334: SYSDATE ,
3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID
3338: fnd_global.conc_program_id , -- Program Id
3339: fnd_global.conc_login_id , -- Program Login ID

Line 3336: fnd_global.conc_request_id , -- Request Id

3332: SYSDATE ,
3333: fnd_global.user_id ,
3334: SYSDATE ,
3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID
3338: fnd_global.conc_program_id , -- Program Id
3339: fnd_global.conc_login_id , -- Program Login ID
3340: 1

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

3333: fnd_global.user_id ,
3334: SYSDATE ,
3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID
3338: fnd_global.conc_program_id , -- Program Id
3339: fnd_global.conc_login_id , -- Program Login ID
3340: 1
3341: )

Line 3338: fnd_global.conc_program_id , -- Program Id

3334: SYSDATE ,
3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID
3338: fnd_global.conc_program_id , -- Program Id
3339: fnd_global.conc_login_id , -- Program Login ID
3340: 1
3341: )
3342: SELECT

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

3335: fnd_global.conc_login_id ,
3336: fnd_global.conc_request_id , -- Request Id
3337: fnd_global.prog_appl_id , -- Program Application ID
3338: fnd_global.conc_program_id , -- Program Id
3339: fnd_global.conc_login_id , -- Program Login ID
3340: 1
3341: )
3342: SELECT
3343: DISTINCT

Line 3555: fnd_global.user_id ,

3551: ATTRIBUTE15 ,
3552: ATTRIBUTE_CATEGORY ,
3553: TAX_RATE_ID ,
3554: CONTENT_OWNER_ID ,
3555: fnd_global.user_id ,
3556: SYSDATE ,
3557: fnd_global.user_id ,
3558: SYSDATE ,
3559: fnd_global.conc_login_id ,

Line 3557: fnd_global.user_id ,

3553: TAX_RATE_ID ,
3554: CONTENT_OWNER_ID ,
3555: fnd_global.user_id ,
3556: SYSDATE ,
3557: fnd_global.user_id ,
3558: SYSDATE ,
3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID

Line 3559: fnd_global.conc_login_id ,

3555: fnd_global.user_id ,
3556: SYSDATE ,
3557: fnd_global.user_id ,
3558: SYSDATE ,
3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID
3562: fnd_global.conc_program_id , -- Program Id
3563: fnd_global.conc_login_id , -- Program Login ID

Line 3560: fnd_global.conc_request_id , -- Request Id

3556: SYSDATE ,
3557: fnd_global.user_id ,
3558: SYSDATE ,
3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID
3562: fnd_global.conc_program_id , -- Program Id
3563: fnd_global.conc_login_id , -- Program Login ID
3564: 'TAX_RATE' ,

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

3557: fnd_global.user_id ,
3558: SYSDATE ,
3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID
3562: fnd_global.conc_program_id , -- Program Id
3563: fnd_global.conc_login_id , -- Program Login ID
3564: 'TAX_RATE' ,
3565: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG

Line 3562: fnd_global.conc_program_id , -- Program Id

3558: SYSDATE ,
3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID
3562: fnd_global.conc_program_id , -- Program Id
3563: fnd_global.conc_login_id , -- Program Login ID
3564: 'TAX_RATE' ,
3565: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3566: 1 ,

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

3559: fnd_global.conc_login_id ,
3560: fnd_global.conc_request_id , -- Request Id
3561: fnd_global.prog_appl_id , -- Program Application ID
3562: fnd_global.conc_program_id , -- Program Id
3563: fnd_global.conc_login_id , -- Program Login ID
3564: 'TAX_RATE' ,
3565: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3566: 1 ,
3567: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 3653: fnd_global.user_id ,

3649: NULL ,
3650: NULL ,
3651: NULL ,
3652: NULL ,
3653: fnd_global.user_id ,
3654: SYSDATE ,
3655: fnd_global.user_id ,
3656: SYSDATE ,
3657: fnd_global.conc_login_id ,

Line 3655: fnd_global.user_id ,

3651: NULL ,
3652: NULL ,
3653: fnd_global.user_id ,
3654: SYSDATE ,
3655: fnd_global.user_id ,
3656: SYSDATE ,
3657: fnd_global.conc_login_id ,
3658: fnd_global.conc_request_id , -- Request Id
3659: fnd_global.prog_appl_id , -- Program Application ID

Line 3657: fnd_global.conc_login_id ,

3653: fnd_global.user_id ,
3654: SYSDATE ,
3655: fnd_global.user_id ,
3656: SYSDATE ,
3657: fnd_global.conc_login_id ,
3658: fnd_global.conc_request_id , -- Request Id
3659: fnd_global.prog_appl_id , -- Program Application ID
3660: fnd_global.conc_program_id , -- Program Id
3661: fnd_global.conc_login_id , -- Program Login ID

Line 3658: fnd_global.conc_request_id , -- Request Id

3654: SYSDATE ,
3655: fnd_global.user_id ,
3656: SYSDATE ,
3657: fnd_global.conc_login_id ,
3658: fnd_global.conc_request_id , -- Request Id
3659: fnd_global.prog_appl_id , -- Program Application ID
3660: fnd_global.conc_program_id , -- Program Id
3661: fnd_global.conc_login_id , -- Program Login ID
3662: 1

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

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

Line 3660: fnd_global.conc_program_id , -- Program Id

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

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

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

Line 3868: fnd_global.user_id ,

3864: ATTRIBUTE15 ,
3865: ATTRIBUTE_CATEGORY ,
3866: TAX_RATE_ID ,
3867: CONTENT_OWNER_ID ,
3868: fnd_global.user_id ,
3869: SYSDATE ,
3870: fnd_global.user_id ,
3871: SYSDATE ,
3872: fnd_global.conc_login_id ,

Line 3870: fnd_global.user_id ,

3866: TAX_RATE_ID ,
3867: CONTENT_OWNER_ID ,
3868: fnd_global.user_id ,
3869: SYSDATE ,
3870: fnd_global.user_id ,
3871: SYSDATE ,
3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID

Line 3872: fnd_global.conc_login_id ,

3868: fnd_global.user_id ,
3869: SYSDATE ,
3870: fnd_global.user_id ,
3871: SYSDATE ,
3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID
3875: fnd_global.conc_program_id , -- Program Id
3876: fnd_global.conc_login_id , -- Program Login ID

Line 3873: fnd_global.conc_request_id , -- Request Id

3869: SYSDATE ,
3870: fnd_global.user_id ,
3871: SYSDATE ,
3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID
3875: fnd_global.conc_program_id , -- Program Id
3876: fnd_global.conc_login_id , -- Program Login ID
3877: 'TAX_RATE' ,

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

3870: fnd_global.user_id ,
3871: SYSDATE ,
3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID
3875: fnd_global.conc_program_id , -- Program Id
3876: fnd_global.conc_login_id , -- Program Login ID
3877: 'TAX_RATE' ,
3878: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG

Line 3875: fnd_global.conc_program_id , -- Program Id

3871: SYSDATE ,
3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID
3875: fnd_global.conc_program_id , -- Program Id
3876: fnd_global.conc_login_id , -- Program Login ID
3877: 'TAX_RATE' ,
3878: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3879: 1 ,

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

3872: fnd_global.conc_login_id ,
3873: fnd_global.conc_request_id , -- Request Id
3874: fnd_global.prog_appl_id , -- Program Application ID
3875: fnd_global.conc_program_id , -- Program Id
3876: fnd_global.conc_login_id , -- Program Login ID
3877: 'TAX_RATE' ,
3878: 'Y' , -- ALLOW_ADHOC_TAX_RATE_FLAG
3879: 1 ,
3880: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 3966: fnd_global.user_id ,

3962: NULL ,
3963: NULL ,
3964: NULL ,
3965: NULL ,
3966: fnd_global.user_id ,
3967: SYSDATE ,
3968: fnd_global.user_id ,
3969: SYSDATE ,
3970: fnd_global.conc_login_id ,

Line 3968: fnd_global.user_id ,

3964: NULL ,
3965: NULL ,
3966: fnd_global.user_id ,
3967: SYSDATE ,
3968: fnd_global.user_id ,
3969: SYSDATE ,
3970: fnd_global.conc_login_id ,
3971: fnd_global.conc_request_id , -- Request Id
3972: fnd_global.prog_appl_id , -- Program Application ID

Line 3970: fnd_global.conc_login_id ,

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

Line 3971: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 3973: fnd_global.conc_program_id , -- Program Id

3969: SYSDATE ,
3970: fnd_global.conc_login_id ,
3971: fnd_global.conc_request_id , -- Request Id
3972: fnd_global.prog_appl_id , -- Program Application ID
3973: fnd_global.conc_program_id , -- Program Id
3974: fnd_global.conc_login_id , -- Program Login ID
3975: 1
3976: )
3977: SELECT

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

3970: fnd_global.conc_login_id ,
3971: fnd_global.conc_request_id , -- Request Id
3972: fnd_global.prog_appl_id , -- Program Application ID
3973: fnd_global.conc_program_id , -- Program Id
3974: fnd_global.conc_login_id , -- Program Login ID
3975: 1
3976: )
3977: SELECT
3978: DISTINCT

Line 4090: fnd_global.user_id ,

4086: CASE WHEN TAX_RATE_CODE = UPPER(TAX_RATE_CODE)
4087: THEN Initcap(TAX_RATE_CODE)
4088: ELSE TAX_RATE_CODE
4089: END ,
4090: fnd_global.user_id ,
4091: SYSDATE ,
4092: fnd_global.user_id ,
4093: SYSDATE ,
4094: fnd_global.conc_login_id ,

Line 4092: fnd_global.user_id ,

4088: ELSE TAX_RATE_CODE
4089: END ,
4090: fnd_global.user_id ,
4091: SYSDATE ,
4092: fnd_global.user_id ,
4093: SYSDATE ,
4094: fnd_global.conc_login_id ,
4095: L.LANGUAGE_CODE,
4096: userenv('LANG'),

Line 4094: fnd_global.conc_login_id ,

4090: fnd_global.user_id ,
4091: SYSDATE ,
4092: fnd_global.user_id ,
4093: SYSDATE ,
4094: fnd_global.conc_login_id ,
4095: L.LANGUAGE_CODE,
4096: userenv('LANG'),
4097: avtb.description
4098: FROM FND_LANGUAGES L,

Line 4280: fnd_global.user_id ,

4276: ATTRIBUTE15 ,
4277: ATTRIBUTE_CATEGORY ,
4278: zx_rates_b_s.nextval ,--TAX_RATE_ID
4279: CONTENT_OWNER_ID ,
4280: fnd_global.user_id ,
4281: SYSDATE ,
4282: fnd_global.user_id ,
4283: SYSDATE ,
4284: fnd_global.conc_login_id ,

Line 4282: fnd_global.user_id ,

4278: zx_rates_b_s.nextval ,--TAX_RATE_ID
4279: CONTENT_OWNER_ID ,
4280: fnd_global.user_id ,
4281: SYSDATE ,
4282: fnd_global.user_id ,
4283: SYSDATE ,
4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID

Line 4284: fnd_global.conc_login_id ,

4280: fnd_global.user_id ,
4281: SYSDATE ,
4282: fnd_global.user_id ,
4283: SYSDATE ,
4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID
4287: fnd_global.conc_program_id , -- Program Id
4288: fnd_global.conc_login_id , -- Program Login ID

Line 4285: fnd_global.conc_request_id , -- Request Id

4281: SYSDATE ,
4282: fnd_global.user_id ,
4283: SYSDATE ,
4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID
4287: fnd_global.conc_program_id , -- Program Id
4288: fnd_global.conc_login_id , -- Program Login ID
4289: 'TAX_RATE' ,

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

4282: fnd_global.user_id ,
4283: SYSDATE ,
4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID
4287: fnd_global.conc_program_id , -- Program Id
4288: fnd_global.conc_login_id , -- Program Login ID
4289: 'TAX_RATE' ,
4290: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4287: fnd_global.conc_program_id , -- Program Id

4283: SYSDATE ,
4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID
4287: fnd_global.conc_program_id , -- Program Id
4288: fnd_global.conc_login_id , -- Program Login ID
4289: 'TAX_RATE' ,
4290: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4291: 1

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

4284: fnd_global.conc_login_id ,
4285: fnd_global.conc_request_id , -- Request Id
4286: fnd_global.prog_appl_id , -- Program Application ID
4287: fnd_global.conc_program_id , -- Program Id
4288: fnd_global.conc_login_id , -- Program Login ID
4289: 'TAX_RATE' ,
4290: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4291: 1
4292: -- 6820043, commenting out description

Line 4376: fnd_global.user_id ,

4372: NULL ,
4373: NULL ,
4374: NULL ,
4375: NULL ,
4376: fnd_global.user_id ,
4377: SYSDATE ,
4378: fnd_global.user_id ,
4379: SYSDATE ,
4380: fnd_global.conc_login_id ,

Line 4378: fnd_global.user_id ,

4374: NULL ,
4375: NULL ,
4376: fnd_global.user_id ,
4377: SYSDATE ,
4378: fnd_global.user_id ,
4379: SYSDATE ,
4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID

Line 4380: fnd_global.conc_login_id ,

4376: fnd_global.user_id ,
4377: SYSDATE ,
4378: fnd_global.user_id ,
4379: SYSDATE ,
4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID
4383: fnd_global.conc_program_id , -- Program Id
4384: fnd_global.conc_login_id , -- Program Login ID

Line 4381: fnd_global.conc_request_id , -- Request Id

4377: SYSDATE ,
4378: fnd_global.user_id ,
4379: SYSDATE ,
4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID
4383: fnd_global.conc_program_id , -- Program Id
4384: fnd_global.conc_login_id , -- Program Login ID
4385: 1

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

4378: fnd_global.user_id ,
4379: SYSDATE ,
4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID
4383: fnd_global.conc_program_id , -- Program Id
4384: fnd_global.conc_login_id , -- Program Login ID
4385: 1
4386: )

Line 4383: fnd_global.conc_program_id , -- Program Id

4379: SYSDATE ,
4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID
4383: fnd_global.conc_program_id , -- Program Id
4384: fnd_global.conc_login_id , -- Program Login ID
4385: 1
4386: )
4387: SELECT

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

4380: fnd_global.conc_login_id ,
4381: fnd_global.conc_request_id , -- Request Id
4382: fnd_global.prog_appl_id , -- Program Application ID
4383: fnd_global.conc_program_id , -- Program Id
4384: fnd_global.conc_login_id , -- Program Login ID
4385: 1
4386: )
4387: SELECT
4388: results.tax_code_id TAX_RATE_ID,

Line 4591: fnd_global.user_id ,

4587: ATTRIBUTE15 ,
4588: ATTRIBUTE_CATEGORY ,
4589: zx_rates_b_s.nextval ,--TAX_RATE_ID
4590: CONTENT_OWNER_ID ,
4591: fnd_global.user_id ,
4592: SYSDATE ,
4593: fnd_global.user_id ,
4594: SYSDATE ,
4595: fnd_global.conc_login_id ,

Line 4593: fnd_global.user_id ,

4589: zx_rates_b_s.nextval ,--TAX_RATE_ID
4590: CONTENT_OWNER_ID ,
4591: fnd_global.user_id ,
4592: SYSDATE ,
4593: fnd_global.user_id ,
4594: SYSDATE ,
4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID

Line 4595: fnd_global.conc_login_id ,

4591: fnd_global.user_id ,
4592: SYSDATE ,
4593: fnd_global.user_id ,
4594: SYSDATE ,
4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID
4598: fnd_global.conc_program_id , -- Program Id
4599: fnd_global.conc_login_id , -- Program Login ID

Line 4596: fnd_global.conc_request_id , -- Request Id

4592: SYSDATE ,
4593: fnd_global.user_id ,
4594: SYSDATE ,
4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID
4598: fnd_global.conc_program_id , -- Program Id
4599: fnd_global.conc_login_id , -- Program Login ID
4600: 'TAX_RATE' ,

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

4593: fnd_global.user_id ,
4594: SYSDATE ,
4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID
4598: fnd_global.conc_program_id , -- Program Id
4599: fnd_global.conc_login_id , -- Program Login ID
4600: 'TAX_RATE' ,
4601: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4598: fnd_global.conc_program_id , -- Program Id

4594: SYSDATE ,
4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID
4598: fnd_global.conc_program_id , -- Program Id
4599: fnd_global.conc_login_id , -- Program Login ID
4600: 'TAX_RATE' ,
4601: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4602: 1

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

4595: fnd_global.conc_login_id ,
4596: fnd_global.conc_request_id , -- Request Id
4597: fnd_global.prog_appl_id , -- Program Application ID
4598: fnd_global.conc_program_id , -- Program Id
4599: fnd_global.conc_login_id , -- Program Login ID
4600: 'TAX_RATE' ,
4601: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4602: 1
4603: -- 6820043, commenting out description

Line 4687: fnd_global.user_id ,

4683: NULL ,
4684: NULL ,
4685: NULL ,
4686: NULL ,
4687: fnd_global.user_id ,
4688: SYSDATE ,
4689: fnd_global.user_id ,
4690: SYSDATE ,
4691: fnd_global.conc_login_id ,

Line 4689: fnd_global.user_id ,

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

Line 4691: fnd_global.conc_login_id ,

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

Line 4692: fnd_global.conc_request_id , -- Request Id

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

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

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

Line 4694: fnd_global.conc_program_id , -- Program Id

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

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

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

Line 4907: fnd_global.user_id ,

4903: ATTRIBUTE15 ,
4904: ATTRIBUTE_CATEGORY ,
4905: TAX_RATE_ID ,
4906: CONTENT_OWNER_ID ,
4907: fnd_global.user_id ,
4908: SYSDATE ,
4909: fnd_global.user_id ,
4910: SYSDATE ,
4911: fnd_global.conc_login_id ,

Line 4909: fnd_global.user_id ,

4905: TAX_RATE_ID ,
4906: CONTENT_OWNER_ID ,
4907: fnd_global.user_id ,
4908: SYSDATE ,
4909: fnd_global.user_id ,
4910: SYSDATE ,
4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID

Line 4911: fnd_global.conc_login_id ,

4907: fnd_global.user_id ,
4908: SYSDATE ,
4909: fnd_global.user_id ,
4910: SYSDATE ,
4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID
4914: fnd_global.conc_program_id , -- Program Id
4915: fnd_global.conc_login_id , -- Program Login ID

Line 4912: fnd_global.conc_request_id , -- Request Id

4908: SYSDATE ,
4909: fnd_global.user_id ,
4910: SYSDATE ,
4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID
4914: fnd_global.conc_program_id , -- Program Id
4915: fnd_global.conc_login_id , -- Program Login ID
4916: 'TAX_RATE' ,

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

4909: fnd_global.user_id ,
4910: SYSDATE ,
4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID
4914: fnd_global.conc_program_id , -- Program Id
4915: fnd_global.conc_login_id , -- Program Login ID
4916: 'TAX_RATE' ,
4917: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 4914: fnd_global.conc_program_id , -- Program Id

4910: SYSDATE ,
4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID
4914: fnd_global.conc_program_id , -- Program Id
4915: fnd_global.conc_login_id , -- Program Login ID
4916: 'TAX_RATE' ,
4917: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4918: 1 ,

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

4911: fnd_global.conc_login_id ,
4912: fnd_global.conc_request_id , -- Request Id
4913: fnd_global.prog_appl_id , -- Program Application ID
4914: fnd_global.conc_program_id , -- Program Id
4915: fnd_global.conc_login_id , -- Program Login ID
4916: 'TAX_RATE' ,
4917: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
4918: 1 ,
4919: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 5005: fnd_global.user_id ,

5001: NULL ,
5002: NULL ,
5003: NULL ,
5004: NULL ,
5005: fnd_global.user_id ,
5006: SYSDATE ,
5007: fnd_global.user_id ,
5008: SYSDATE ,
5009: fnd_global.conc_login_id ,

Line 5007: fnd_global.user_id ,

5003: NULL ,
5004: NULL ,
5005: fnd_global.user_id ,
5006: SYSDATE ,
5007: fnd_global.user_id ,
5008: SYSDATE ,
5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID

Line 5009: fnd_global.conc_login_id ,

5005: fnd_global.user_id ,
5006: SYSDATE ,
5007: fnd_global.user_id ,
5008: SYSDATE ,
5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID
5012: fnd_global.conc_program_id , -- Program Id
5013: fnd_global.conc_login_id , -- Program Login ID

Line 5010: fnd_global.conc_request_id , -- Request Id

5006: SYSDATE ,
5007: fnd_global.user_id ,
5008: SYSDATE ,
5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID
5012: fnd_global.conc_program_id , -- Program Id
5013: fnd_global.conc_login_id , -- Program Login ID
5014: 1

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

5007: fnd_global.user_id ,
5008: SYSDATE ,
5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID
5012: fnd_global.conc_program_id , -- Program Id
5013: fnd_global.conc_login_id , -- Program Login ID
5014: 1
5015: )

Line 5012: fnd_global.conc_program_id , -- Program Id

5008: SYSDATE ,
5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID
5012: fnd_global.conc_program_id , -- Program Id
5013: fnd_global.conc_login_id , -- Program Login ID
5014: 1
5015: )
5016: SELECT

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

5009: fnd_global.conc_login_id ,
5010: fnd_global.conc_request_id , -- Request Id
5011: fnd_global.prog_appl_id , -- Program Application ID
5012: fnd_global.conc_program_id , -- Program Id
5013: fnd_global.conc_login_id , -- Program Login ID
5014: 1
5015: )
5016: SELECT
5017: results.tax_code_id TAX_RATE_ID,

Line 5220: fnd_global.user_id ,

5216: ATTRIBUTE15 ,
5217: ATTRIBUTE_CATEGORY ,
5218: TAX_RATE_ID ,
5219: CONTENT_OWNER_ID ,
5220: fnd_global.user_id ,
5221: SYSDATE ,
5222: fnd_global.user_id ,
5223: SYSDATE ,
5224: fnd_global.conc_login_id ,

Line 5222: fnd_global.user_id ,

5218: TAX_RATE_ID ,
5219: CONTENT_OWNER_ID ,
5220: fnd_global.user_id ,
5221: SYSDATE ,
5222: fnd_global.user_id ,
5223: SYSDATE ,
5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID

Line 5224: fnd_global.conc_login_id ,

5220: fnd_global.user_id ,
5221: SYSDATE ,
5222: fnd_global.user_id ,
5223: SYSDATE ,
5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID
5227: fnd_global.conc_program_id , -- Program Id
5228: fnd_global.conc_login_id , -- Program Login ID

Line 5225: fnd_global.conc_request_id , -- Request Id

5221: SYSDATE ,
5222: fnd_global.user_id ,
5223: SYSDATE ,
5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID
5227: fnd_global.conc_program_id , -- Program Id
5228: fnd_global.conc_login_id , -- Program Login ID
5229: 'TAX_RATE' ,

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

5222: fnd_global.user_id ,
5223: SYSDATE ,
5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID
5227: fnd_global.conc_program_id , -- Program Id
5228: fnd_global.conc_login_id , -- Program Login ID
5229: 'TAX_RATE' ,
5230: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5227: fnd_global.conc_program_id , -- Program Id

5223: SYSDATE ,
5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID
5227: fnd_global.conc_program_id , -- Program Id
5228: fnd_global.conc_login_id , -- Program Login ID
5229: 'TAX_RATE' ,
5230: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5231: 1 ,

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

5224: fnd_global.conc_login_id ,
5225: fnd_global.conc_request_id , -- Request Id
5226: fnd_global.prog_appl_id , -- Program Application ID
5227: fnd_global.conc_program_id , -- Program Id
5228: fnd_global.conc_login_id , -- Program Login ID
5229: 'TAX_RATE' ,
5230: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5231: 1 ,
5232: -- Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 5318: fnd_global.user_id ,

5314: NULL ,
5315: NULL ,
5316: NULL ,
5317: NULL ,
5318: fnd_global.user_id ,
5319: SYSDATE ,
5320: fnd_global.user_id ,
5321: SYSDATE ,
5322: fnd_global.conc_login_id ,

Line 5320: fnd_global.user_id ,

5316: NULL ,
5317: NULL ,
5318: fnd_global.user_id ,
5319: SYSDATE ,
5320: fnd_global.user_id ,
5321: SYSDATE ,
5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID

Line 5322: fnd_global.conc_login_id ,

5318: fnd_global.user_id ,
5319: SYSDATE ,
5320: fnd_global.user_id ,
5321: SYSDATE ,
5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID
5325: fnd_global.conc_program_id , -- Program Id
5326: fnd_global.conc_login_id , -- Program Login ID

Line 5323: fnd_global.conc_request_id , -- Request Id

5319: SYSDATE ,
5320: fnd_global.user_id ,
5321: SYSDATE ,
5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID
5325: fnd_global.conc_program_id , -- Program Id
5326: fnd_global.conc_login_id , -- Program Login ID
5327: 1

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

5320: fnd_global.user_id ,
5321: SYSDATE ,
5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID
5325: fnd_global.conc_program_id , -- Program Id
5326: fnd_global.conc_login_id , -- Program Login ID
5327: 1
5328: )

Line 5325: fnd_global.conc_program_id , -- Program Id

5321: SYSDATE ,
5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID
5325: fnd_global.conc_program_id , -- Program Id
5326: fnd_global.conc_login_id , -- Program Login ID
5327: 1
5328: )
5329: SELECT

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

5322: fnd_global.conc_login_id ,
5323: fnd_global.conc_request_id , -- Request Id
5324: fnd_global.prog_appl_id , -- Program Application ID
5325: fnd_global.conc_program_id , -- Program Id
5326: fnd_global.conc_login_id , -- Program Login ID
5327: 1
5328: )
5329: SELECT
5330: results.tax_code_id TAX_RATE_ID,

Line 5439: fnd_global.user_id ,

5435: CASE WHEN TAX_RATE_CODE = UPPER(TAX_RATE_CODE)
5436: THEN Initcap(TAX_RATE_CODE)
5437: ELSE TAX_RATE_CODE
5438: END ,
5439: fnd_global.user_id ,
5440: SYSDATE ,
5441: fnd_global.user_id ,
5442: SYSDATE ,
5443: fnd_global.conc_login_id ,

Line 5441: fnd_global.user_id ,

5437: ELSE TAX_RATE_CODE
5438: END ,
5439: fnd_global.user_id ,
5440: SYSDATE ,
5441: fnd_global.user_id ,
5442: SYSDATE ,
5443: fnd_global.conc_login_id ,
5444: L.LANGUAGE_CODE,
5445: userenv('LANG'),

Line 5443: fnd_global.conc_login_id ,

5439: fnd_global.user_id ,
5440: SYSDATE ,
5441: fnd_global.user_id ,
5442: SYSDATE ,
5443: fnd_global.conc_login_id ,
5444: L.LANGUAGE_CODE,
5445: userenv('LANG'),
5446: avtb.description
5447: FROM FND_LANGUAGES L,

Line 5613: fnd_global.user_id ,

5609: RECORD_TYPE_CODE ,
5610: 'INPUT' ,
5611: ZX_RATES_B_S.NEXTVAL ,
5612: CONTENT_OWNER_ID ,
5613: fnd_global.user_id ,
5614: SYSDATE ,
5615: fnd_global.user_id ,
5616: SYSDATE ,
5617: fnd_global.conc_login_id ,

Line 5615: fnd_global.user_id ,

5611: ZX_RATES_B_S.NEXTVAL ,
5612: CONTENT_OWNER_ID ,
5613: fnd_global.user_id ,
5614: SYSDATE ,
5615: fnd_global.user_id ,
5616: SYSDATE ,
5617: fnd_global.conc_login_id ,
5618: fnd_global.conc_request_id , -- Request Id
5619: fnd_global.prog_appl_id , -- Program Application ID

Line 5617: fnd_global.conc_login_id ,

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

Line 5618: fnd_global.conc_request_id , -- Request Id

5614: SYSDATE ,
5615: fnd_global.user_id ,
5616: SYSDATE ,
5617: fnd_global.conc_login_id ,
5618: fnd_global.conc_request_id , -- Request Id
5619: fnd_global.prog_appl_id , -- Program Application ID
5620: fnd_global.conc_program_id , -- Program Id
5621: fnd_global.conc_login_id , -- Program Login ID
5622: 'TAX_RATE' ,

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

5615: fnd_global.user_id ,
5616: SYSDATE ,
5617: fnd_global.conc_login_id ,
5618: fnd_global.conc_request_id , -- Request Id
5619: fnd_global.prog_appl_id , -- Program Application ID
5620: fnd_global.conc_program_id , -- Program Id
5621: fnd_global.conc_login_id , -- Program Login ID
5622: 'TAX_RATE' ,
5623: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5620: fnd_global.conc_program_id , -- Program Id

5616: SYSDATE ,
5617: fnd_global.conc_login_id ,
5618: fnd_global.conc_request_id , -- Request Id
5619: fnd_global.prog_appl_id , -- Program Application ID
5620: fnd_global.conc_program_id , -- Program Id
5621: fnd_global.conc_login_id , -- Program Login ID
5622: 'TAX_RATE' ,
5623: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5624: 1

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

5617: fnd_global.conc_login_id ,
5618: fnd_global.conc_request_id , -- Request Id
5619: fnd_global.prog_appl_id , -- Program Application ID
5620: fnd_global.conc_program_id , -- Program Id
5621: fnd_global.conc_login_id , -- Program Login ID
5622: 'TAX_RATE' ,
5623: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5624: 1
5625: FROM

Line 5743: fnd_global.user_id ,

5739: THEN Initcap(TAX_RATE_CODE)
5740: ELSE
5741: TAX_RATE_CODE
5742: END,
5743: fnd_global.user_id ,
5744: SYSDATE ,
5745: fnd_global.user_id ,
5746: SYSDATE ,
5747: fnd_global.conc_login_id ,

Line 5745: fnd_global.user_id ,

5741: TAX_RATE_CODE
5742: END,
5743: fnd_global.user_id ,
5744: SYSDATE ,
5745: fnd_global.user_id ,
5746: SYSDATE ,
5747: fnd_global.conc_login_id ,
5748: L.LANGUAGE_CODE,
5749: userenv('LANG'),

Line 5747: fnd_global.conc_login_id ,

5743: fnd_global.user_id ,
5744: SYSDATE ,
5745: fnd_global.user_id ,
5746: SYSDATE ,
5747: fnd_global.conc_login_id ,
5748: L.LANGUAGE_CODE,
5749: userenv('LANG'),
5750: avtb.description
5751: FROM FND_LANGUAGES L,

Line 5892: fnd_global.user_id ,

5888: RECORD_TYPE_CODE ,
5889: 'INPUT' ,
5890: ZX_RATES_B_S.NEXTVAL ,
5891: CONTENT_OWNER_ID ,
5892: fnd_global.user_id ,
5893: SYSDATE ,
5894: fnd_global.user_id ,
5895: SYSDATE ,
5896: fnd_global.conc_login_id ,

Line 5894: fnd_global.user_id ,

5890: ZX_RATES_B_S.NEXTVAL ,
5891: CONTENT_OWNER_ID ,
5892: fnd_global.user_id ,
5893: SYSDATE ,
5894: fnd_global.user_id ,
5895: SYSDATE ,
5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID

Line 5896: fnd_global.conc_login_id ,

5892: fnd_global.user_id ,
5893: SYSDATE ,
5894: fnd_global.user_id ,
5895: SYSDATE ,
5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID
5899: fnd_global.conc_program_id , -- Program Id
5900: fnd_global.conc_login_id , -- Program Login ID

Line 5897: fnd_global.conc_request_id , -- Request Id

5893: SYSDATE ,
5894: fnd_global.user_id ,
5895: SYSDATE ,
5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID
5899: fnd_global.conc_program_id , -- Program Id
5900: fnd_global.conc_login_id , -- Program Login ID
5901: 'TAX_RATE' ,

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

5894: fnd_global.user_id ,
5895: SYSDATE ,
5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID
5899: fnd_global.conc_program_id , -- Program Id
5900: fnd_global.conc_login_id , -- Program Login ID
5901: 'TAX_RATE' ,
5902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 5899: fnd_global.conc_program_id , -- Program Id

5895: SYSDATE ,
5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID
5899: fnd_global.conc_program_id , -- Program Id
5900: fnd_global.conc_login_id , -- Program Login ID
5901: 'TAX_RATE' ,
5902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5903: 1

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

5896: fnd_global.conc_login_id ,
5897: fnd_global.conc_request_id , -- Request Id
5898: fnd_global.prog_appl_id , -- Program Application ID
5899: fnd_global.conc_program_id , -- Program Id
5900: fnd_global.conc_login_id , -- Program Login ID
5901: 'TAX_RATE' ,
5902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
5903: 1
5904: FROM

Line 6083: fnd_global.user_id ,

6079: RECORD_TYPE_CODE ,
6080: 'INPUT' ,
6081: ZX_RATES_B_S.NEXTVAL ,
6082: CONTENT_OWNER_ID ,
6083: fnd_global.user_id ,
6084: SYSDATE ,
6085: fnd_global.user_id ,
6086: SYSDATE ,
6087: fnd_global.conc_login_id ,

Line 6085: fnd_global.user_id ,

6081: ZX_RATES_B_S.NEXTVAL ,
6082: CONTENT_OWNER_ID ,
6083: fnd_global.user_id ,
6084: SYSDATE ,
6085: fnd_global.user_id ,
6086: SYSDATE ,
6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID

Line 6087: fnd_global.conc_login_id ,

6083: fnd_global.user_id ,
6084: SYSDATE ,
6085: fnd_global.user_id ,
6086: SYSDATE ,
6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID
6090: fnd_global.conc_program_id , -- Program Id
6091: fnd_global.conc_login_id , -- Program Login ID

Line 6088: fnd_global.conc_request_id , -- Request Id

6084: SYSDATE ,
6085: fnd_global.user_id ,
6086: SYSDATE ,
6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID
6090: fnd_global.conc_program_id , -- Program Id
6091: fnd_global.conc_login_id , -- Program Login ID
6092: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE

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

6085: fnd_global.user_id ,
6086: SYSDATE ,
6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID
6090: fnd_global.conc_program_id , -- Program Id
6091: fnd_global.conc_login_id , -- Program Login ID
6092: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6093: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 6090: fnd_global.conc_program_id , -- Program Id

6086: SYSDATE ,
6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID
6090: fnd_global.conc_program_id , -- Program Id
6091: fnd_global.conc_login_id , -- Program Login ID
6092: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6093: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
6094: 1

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

6087: fnd_global.conc_login_id ,
6088: fnd_global.conc_request_id , -- Request Id
6089: fnd_global.prog_appl_id , -- Program Application ID
6090: fnd_global.conc_program_id , -- Program Id
6091: fnd_global.conc_login_id , -- Program Login ID
6092: 'TAX_RATE' , -- ADJ_FOR_ADHOC_AMT_CODE
6093: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
6094: 1
6095: FROM

Line 6165: fnd_global.user_id ,

6161: THEN Initcap(TAX_RATE_CODE)
6162: ELSE
6163: TAX_RATE_CODE
6164: END ,
6165: fnd_global.user_id ,
6166: SYSDATE ,
6167: fnd_global.user_id ,
6168: SYSDATE ,
6169: fnd_global.conc_login_id ,

Line 6167: fnd_global.user_id ,

6163: TAX_RATE_CODE
6164: END ,
6165: fnd_global.user_id ,
6166: SYSDATE ,
6167: fnd_global.user_id ,
6168: SYSDATE ,
6169: fnd_global.conc_login_id ,
6170: L.LANGUAGE_CODE,
6171: userenv('LANG')

Line 6169: fnd_global.conc_login_id ,

6165: fnd_global.user_id ,
6166: SYSDATE ,
6167: fnd_global.user_id ,
6168: SYSDATE ,
6169: fnd_global.conc_login_id ,
6170: L.LANGUAGE_CODE,
6171: userenv('LANG')
6172: FROM FND_LANGUAGES L,
6173: ZX_RATES_B RATES

Line 6312: fnd_global.user_id,

6308: NULL,
6309: NULL,
6310: NULL,
6311: SYSDATE,
6312: fnd_global.user_id,
6313: SYSDATE,
6314: fnd_global.user_id,
6315: fnd_global.conc_login_id,
6316: fnd_global.conc_request_id ,-- Request Id

Line 6314: fnd_global.user_id,

6310: NULL,
6311: SYSDATE,
6312: fnd_global.user_id,
6313: SYSDATE,
6314: fnd_global.user_id,
6315: fnd_global.conc_login_id,
6316: fnd_global.conc_request_id ,-- Request Id
6317: 1
6318: FROM

Line 6315: fnd_global.conc_login_id,

6311: SYSDATE,
6312: fnd_global.user_id,
6313: SYSDATE,
6314: fnd_global.user_id,
6315: fnd_global.conc_login_id,
6316: fnd_global.conc_request_id ,-- Request Id
6317: 1
6318: FROM
6319: (

Line 6316: fnd_global.conc_request_id ,-- Request Id

6312: fnd_global.user_id,
6313: SYSDATE,
6314: fnd_global.user_id,
6315: fnd_global.conc_login_id,
6316: fnd_global.conc_request_id ,-- Request Id
6317: 1
6318: FROM
6319: (
6320: SELECT TAX_REGIME_CODE,

Line 6448: fnd_global.user_id,

6444: NULL,
6445: NULL,
6446: NULL,
6447: SYSDATE,
6448: fnd_global.user_id,
6449: SYSDATE,
6450: fnd_global.user_id,
6451: fnd_global.conc_login_id,
6452: fnd_global.conc_request_id ,-- Request Id

Line 6450: fnd_global.user_id,

6446: NULL,
6447: SYSDATE,
6448: fnd_global.user_id,
6449: SYSDATE,
6450: fnd_global.user_id,
6451: fnd_global.conc_login_id,
6452: fnd_global.conc_request_id ,-- Request Id
6453: 1
6454: FROM

Line 6451: fnd_global.conc_login_id,

6447: SYSDATE,
6448: fnd_global.user_id,
6449: SYSDATE,
6450: fnd_global.user_id,
6451: fnd_global.conc_login_id,
6452: fnd_global.conc_request_id ,-- Request Id
6453: 1
6454: FROM
6455:

Line 6452: fnd_global.conc_request_id ,-- Request Id

6448: fnd_global.user_id,
6449: SYSDATE,
6450: fnd_global.user_id,
6451: fnd_global.conc_login_id,
6452: fnd_global.conc_request_id ,-- Request Id
6453: 1
6454: FROM
6455:
6456: (SELECT

Line 6581: fnd_global.user_id,

6577: NULL,
6578: NULL,
6579: NULL,
6580: SYSDATE,
6581: fnd_global.user_id,
6582: SYSDATE,
6583: fnd_global.user_id,
6584: fnd_global.conc_login_id,
6585: fnd_global.conc_request_id ,-- Request Id

Line 6583: fnd_global.user_id,

6579: NULL,
6580: SYSDATE,
6581: fnd_global.user_id,
6582: SYSDATE,
6583: fnd_global.user_id,
6584: fnd_global.conc_login_id,
6585: fnd_global.conc_request_id ,-- Request Id
6586: 1
6587: FROM

Line 6584: fnd_global.conc_login_id,

6580: SYSDATE,
6581: fnd_global.user_id,
6582: SYSDATE,
6583: fnd_global.user_id,
6584: fnd_global.conc_login_id,
6585: fnd_global.conc_request_id ,-- Request Id
6586: 1
6587: FROM
6588:

Line 6585: fnd_global.conc_request_id ,-- Request Id

6581: fnd_global.user_id,
6582: SYSDATE,
6583: fnd_global.user_id,
6584: fnd_global.conc_login_id,
6585: fnd_global.conc_request_id ,-- Request Id
6586: 1
6587: FROM
6588:
6589: (SELECT

Line 6659: fnd_global.user_id,

6655: ELSE
6656: lookups.MEANING
6657: END,
6658: SYSDATE,
6659: fnd_global.user_id,
6660: SYSDATE,
6661: fnd_global.user_id,
6662: fnd_global.conc_login_id,
6663: L.LANGUAGE_CODE,

Line 6661: fnd_global.user_id,

6657: END,
6658: SYSDATE,
6659: fnd_global.user_id,
6660: SYSDATE,
6661: fnd_global.user_id,
6662: fnd_global.conc_login_id,
6663: L.LANGUAGE_CODE,
6664: userenv('LANG')
6665: FROM

Line 6662: fnd_global.conc_login_id,

6658: SYSDATE,
6659: fnd_global.user_id,
6660: SYSDATE,
6661: fnd_global.user_id,
6662: fnd_global.conc_login_id,
6663: L.LANGUAGE_CODE,
6664: userenv('LANG')
6665: FROM
6666: FND_LANGUAGES L,

Line 6722: fnd_global.user_id,

6718: ELSE
6719: TAX_STATUS_CODE
6720: END,
6721: SYSDATE,
6722: fnd_global.user_id,
6723: SYSDATE,
6724: fnd_global.user_id,
6725: fnd_global.conc_login_id,
6726: L.LANGUAGE_CODE,

Line 6724: fnd_global.user_id,

6720: END,
6721: SYSDATE,
6722: fnd_global.user_id,
6723: SYSDATE,
6724: fnd_global.user_id,
6725: fnd_global.conc_login_id,
6726: L.LANGUAGE_CODE,
6727: userenv('LANG')
6728: FROM

Line 6725: fnd_global.conc_login_id,

6721: SYSDATE,
6722: fnd_global.user_id,
6723: SYSDATE,
6724: fnd_global.user_id,
6725: fnd_global.conc_login_id,
6726: L.LANGUAGE_CODE,
6727: userenv('LANG')
6728: FROM
6729: FND_LANGUAGES L,

Line 7051: fnd_global.user_id ,

7047: COLL_TAX_AUTHORITY_ID ,
7048: NULL ,--THRSHLD_CHK_TMPLT_CODE
7049: DEF_PRIMARY_REC_RATE_CODE ,
7050: NULL ,
7051: fnd_global.user_id ,
7052: SYSDATE ,
7053: fnd_global.user_id ,
7054: SYSDATE ,
7055: fnd_global.conc_login_id ,

Line 7053: fnd_global.user_id ,

7049: DEF_PRIMARY_REC_RATE_CODE ,
7050: NULL ,
7051: fnd_global.user_id ,
7052: SYSDATE ,
7053: fnd_global.user_id ,
7054: SYSDATE ,
7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID

Line 7055: fnd_global.conc_login_id ,

7051: fnd_global.user_id ,
7052: SYSDATE ,
7053: fnd_global.user_id ,
7054: SYSDATE ,
7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID
7058: fnd_global.conc_program_id ,--Program Id
7059: fnd_global.conc_login_id ,--Program Login ID

Line 7056: fnd_global.conc_request_id ,--Request Id

7052: SYSDATE ,
7053: fnd_global.user_id ,
7054: SYSDATE ,
7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID
7058: fnd_global.conc_program_id ,--Program Id
7059: fnd_global.conc_login_id ,--Program Login ID
7060: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7053: fnd_global.user_id ,
7054: SYSDATE ,
7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID
7058: fnd_global.conc_program_id ,--Program Id
7059: fnd_global.conc_login_id ,--Program Login ID
7060: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7061: 1 ,

Line 7058: fnd_global.conc_program_id ,--Program Id

7054: SYSDATE ,
7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID
7058: fnd_global.conc_program_id ,--Program Id
7059: fnd_global.conc_login_id ,--Program Login ID
7060: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7061: 1 ,
7062: DECODE((select tax_type_code

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

7055: fnd_global.conc_login_id ,
7056: fnd_global.conc_request_id ,--Request Id
7057: fnd_global.prog_appl_id ,--Program Application ID
7058: fnd_global.conc_program_id ,--Program Id
7059: fnd_global.conc_login_id ,--Program Login ID
7060: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7061: 1 ,
7062: DECODE((select tax_type_code
7063: from

Line 7443: fnd_global.user_id ,

7439: COLL_TAX_AUTHORITY_ID ,
7440: NULL ,--THRSHLD_CHK_TMPLT_CODE
7441: DEF_PRIMARY_REC_RATE_CODE ,
7442: NULL ,
7443: fnd_global.user_id ,
7444: SYSDATE ,
7445: fnd_global.user_id ,
7446: SYSDATE ,
7447: fnd_global.conc_login_id ,

Line 7445: fnd_global.user_id ,

7441: DEF_PRIMARY_REC_RATE_CODE ,
7442: NULL ,
7443: fnd_global.user_id ,
7444: SYSDATE ,
7445: fnd_global.user_id ,
7446: SYSDATE ,
7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID

Line 7447: fnd_global.conc_login_id ,

7443: fnd_global.user_id ,
7444: SYSDATE ,
7445: fnd_global.user_id ,
7446: SYSDATE ,
7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID
7450: fnd_global.conc_program_id ,--Program Id
7451: fnd_global.conc_login_id ,--Program Login ID

Line 7448: fnd_global.conc_request_id ,--Request Id

7444: SYSDATE ,
7445: fnd_global.user_id ,
7446: SYSDATE ,
7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID
7450: fnd_global.conc_program_id ,--Program Id
7451: fnd_global.conc_login_id ,--Program Login ID
7452: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7445: fnd_global.user_id ,
7446: SYSDATE ,
7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID
7450: fnd_global.conc_program_id ,--Program Id
7451: fnd_global.conc_login_id ,--Program Login ID
7452: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7453: 1 ,

Line 7450: fnd_global.conc_program_id ,--Program Id

7446: SYSDATE ,
7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID
7450: fnd_global.conc_program_id ,--Program Id
7451: fnd_global.conc_login_id ,--Program Login ID
7452: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7453: 1 ,
7454: DECODE((select tax_type_code

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

7447: fnd_global.conc_login_id ,
7448: fnd_global.conc_request_id ,--Request Id
7449: fnd_global.prog_appl_id ,--Program Application ID
7450: fnd_global.conc_program_id ,--Program Id
7451: fnd_global.conc_login_id ,--Program Login ID
7452: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7453: 1 ,
7454: DECODE((select tax_type_code
7455: from

Line 7846: fnd_global.user_id ,

7842: COLL_TAX_AUTHORITY_ID ,
7843: NULL ,--THRSHLD_CHK_TMPLT_CODE
7844: DEF_PRIMARY_REC_RATE_CODE ,
7845: NULL ,
7846: fnd_global.user_id ,
7847: SYSDATE ,
7848: fnd_global.user_id ,
7849: SYSDATE ,
7850: fnd_global.conc_login_id ,

Line 7848: fnd_global.user_id ,

7844: DEF_PRIMARY_REC_RATE_CODE ,
7845: NULL ,
7846: fnd_global.user_id ,
7847: SYSDATE ,
7848: fnd_global.user_id ,
7849: SYSDATE ,
7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID

Line 7850: fnd_global.conc_login_id ,

7846: fnd_global.user_id ,
7847: SYSDATE ,
7848: fnd_global.user_id ,
7849: SYSDATE ,
7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID
7853: fnd_global.conc_program_id ,--Program Id
7854: fnd_global.conc_login_id ,--Program Login ID

Line 7851: fnd_global.conc_request_id ,--Request Id

7847: SYSDATE ,
7848: fnd_global.user_id ,
7849: SYSDATE ,
7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID
7853: fnd_global.conc_program_id ,--Program Id
7854: fnd_global.conc_login_id ,--Program Login ID
7855: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

7848: fnd_global.user_id ,
7849: SYSDATE ,
7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID
7853: fnd_global.conc_program_id ,--Program Id
7854: fnd_global.conc_login_id ,--Program Login ID
7855: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7856: 1 ,

Line 7853: fnd_global.conc_program_id ,--Program Id

7849: SYSDATE ,
7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID
7853: fnd_global.conc_program_id ,--Program Id
7854: fnd_global.conc_login_id ,--Program Login ID
7855: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7856: 1 ,
7857: DECODE((select tax_type_code

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

7850: fnd_global.conc_login_id ,
7851: fnd_global.conc_request_id ,--Request Id
7852: fnd_global.prog_appl_id ,--Program Application ID
7853: fnd_global.conc_program_id ,--Program Id
7854: fnd_global.conc_login_id ,--Program Login ID
7855: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
7856: 1 ,
7857: DECODE((select tax_type_code
7858: from

Line 8271: fnd_global.user_id ,

8267: COLL_TAX_AUTHORITY_ID ,
8268: NULL ,--THRSHLD_CHK_TMPLT_CODE
8269: DEF_PRIMARY_REC_RATE_CODE ,
8270: NULL ,
8271: fnd_global.user_id ,
8272: SYSDATE ,
8273: fnd_global.user_id ,
8274: SYSDATE ,
8275: fnd_global.conc_login_id ,

Line 8273: fnd_global.user_id ,

8269: DEF_PRIMARY_REC_RATE_CODE ,
8270: NULL ,
8271: fnd_global.user_id ,
8272: SYSDATE ,
8273: fnd_global.user_id ,
8274: SYSDATE ,
8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID

Line 8275: fnd_global.conc_login_id ,

8271: fnd_global.user_id ,
8272: SYSDATE ,
8273: fnd_global.user_id ,
8274: SYSDATE ,
8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID
8278: fnd_global.conc_program_id ,--Program Id
8279: fnd_global.conc_login_id ,--Program Login ID

Line 8276: fnd_global.conc_request_id ,--Request Id

8272: SYSDATE ,
8273: fnd_global.user_id ,
8274: SYSDATE ,
8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID
8278: fnd_global.conc_program_id ,--Program Id
8279: fnd_global.conc_login_id ,--Program Login ID
8280: NULL ,--OVERRIDE_GEOGRAPHY_TYPE

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

8273: fnd_global.user_id ,
8274: SYSDATE ,
8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID
8278: fnd_global.conc_program_id ,--Program Id
8279: fnd_global.conc_login_id ,--Program Login ID
8280: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8281: 1 ,

Line 8278: fnd_global.conc_program_id ,--Program Id

8274: SYSDATE ,
8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID
8278: fnd_global.conc_program_id ,--Program Id
8279: fnd_global.conc_login_id ,--Program Login ID
8280: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8281: 1 ,
8282: DECODE((select tax_type_code

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

8275: fnd_global.conc_login_id ,
8276: fnd_global.conc_request_id ,--Request Id
8277: fnd_global.prog_appl_id ,--Program Application ID
8278: fnd_global.conc_program_id ,--Program Id
8279: fnd_global.conc_login_id ,--Program Login ID
8280: NULL ,--OVERRIDE_GEOGRAPHY_TYPE
8281: 1 ,
8282: DECODE((select tax_type_code
8283: from

Line 8487: fnd_global.user_id ,

8483: ELSE
8484: flv.meaning
8485: END ,
8486: SYSDATE ,
8487: fnd_global.user_id ,
8488: SYSDATE ,
8489: fnd_global.user_id ,
8490: fnd_global.conc_login_id ,
8491: taxes.tax_id

Line 8489: fnd_global.user_id ,

8485: END ,
8486: SYSDATE ,
8487: fnd_global.user_id ,
8488: SYSDATE ,
8489: fnd_global.user_id ,
8490: fnd_global.conc_login_id ,
8491: taxes.tax_id
8492: FROM
8493: zx_taxes_b taxes,

Line 8490: fnd_global.conc_login_id ,

8486: SYSDATE ,
8487: fnd_global.user_id ,
8488: SYSDATE ,
8489: fnd_global.user_id ,
8490: fnd_global.conc_login_id ,
8491: taxes.tax_id
8492: FROM
8493: zx_taxes_b taxes,
8494: zx_rates_b rates,

Line 8537: fnd_global.user_id ,

8533: ELSE
8534: flv.meaning
8535: END,
8536: SYSDATE ,
8537: fnd_global.user_id ,
8538: SYSDATE ,
8539: fnd_global.user_id ,
8540: fnd_global.conc_login_id ,
8541: taxes.tax_id

Line 8539: fnd_global.user_id ,

8535: END,
8536: SYSDATE ,
8537: fnd_global.user_id ,
8538: SYSDATE ,
8539: fnd_global.user_id ,
8540: fnd_global.conc_login_id ,
8541: taxes.tax_id
8542: FROM
8543: zx_taxes_b taxes,

Line 8540: fnd_global.conc_login_id ,

8536: SYSDATE ,
8537: fnd_global.user_id ,
8538: SYSDATE ,
8539: fnd_global.user_id ,
8540: fnd_global.conc_login_id ,
8541: taxes.tax_id
8542: FROM
8543: zx_taxes_b taxes,
8544: zx_rates_b rates,

Line 8584: fnd_global.user_id ,

8580: ELSE
8581: flv.meaning
8582: END,
8583: SYSDATE ,
8584: fnd_global.user_id ,
8585: SYSDATE ,
8586: fnd_global.user_id ,
8587: fnd_global.conc_login_id ,
8588: taxes.tax_id

Line 8586: fnd_global.user_id ,

8582: END,
8583: SYSDATE ,
8584: fnd_global.user_id ,
8585: SYSDATE ,
8586: fnd_global.user_id ,
8587: fnd_global.conc_login_id ,
8588: taxes.tax_id
8589: FROM
8590: zx_taxes_b taxes,

Line 8587: fnd_global.conc_login_id ,

8583: SYSDATE ,
8584: fnd_global.user_id ,
8585: SYSDATE ,
8586: fnd_global.user_id ,
8587: fnd_global.conc_login_id ,
8588: taxes.tax_id
8589: FROM
8590: zx_taxes_b taxes,
8591: zx_rates_b rates,

Line 8631: fnd_global.user_id ,

8627: ELSE
8628: flv.meaning
8629: END,
8630: SYSDATE ,
8631: fnd_global.user_id ,
8632: SYSDATE ,
8633: fnd_global.user_id ,
8634: fnd_global.conc_login_id ,
8635: taxes.tax_id

Line 8633: fnd_global.user_id ,

8629: END,
8630: SYSDATE ,
8631: fnd_global.user_id ,
8632: SYSDATE ,
8633: fnd_global.user_id ,
8634: fnd_global.conc_login_id ,
8635: taxes.tax_id
8636: FROM
8637: zx_taxes_b taxes,

Line 8634: fnd_global.conc_login_id ,

8630: SYSDATE ,
8631: fnd_global.user_id ,
8632: SYSDATE ,
8633: fnd_global.user_id ,
8634: fnd_global.conc_login_id ,
8635: taxes.tax_id
8636: FROM
8637: zx_taxes_b taxes,
8638: zx_rates_b rates,

Line 8687: fnd_global.user_id ,

8683: ELSE
8684: B.TAX
8685: END,
8686: SYSDATE ,
8687: fnd_global.user_id ,
8688: SYSDATE ,
8689: fnd_global.user_id ,
8690: fnd_global.conc_login_id ,
8691: B.TAX_ID

Line 8689: fnd_global.user_id ,

8685: END,
8686: SYSDATE ,
8687: fnd_global.user_id ,
8688: SYSDATE ,
8689: fnd_global.user_id ,
8690: fnd_global.conc_login_id ,
8691: B.TAX_ID
8692: FROM
8693: FND_LANGUAGES L,

Line 8690: fnd_global.conc_login_id ,

8686: SYSDATE ,
8687: fnd_global.user_id ,
8688: SYSDATE ,
8689: fnd_global.user_id ,
8690: fnd_global.conc_login_id ,
8691: B.TAX_ID
8692: FROM
8693: FND_LANGUAGES L,
8694: ZX_TAXES_B B

Line 8811: fnd_global.user_id ,

8807: 'MIGRATED' ,
8808: NULL ,
8809: NULL ,
8810: zx_det_factor_templ_b_s.nextval ,
8811: fnd_global.user_id ,
8812: SYSDATE ,
8813: fnd_global.user_id ,
8814: SYSDATE ,
8815: fnd_global.conc_login_id ,

Line 8813: fnd_global.user_id ,

8809: NULL ,
8810: zx_det_factor_templ_b_s.nextval ,
8811: fnd_global.user_id ,
8812: SYSDATE ,
8813: fnd_global.user_id ,
8814: SYSDATE ,
8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID

Line 8815: fnd_global.conc_login_id ,

8811: fnd_global.user_id ,
8812: SYSDATE ,
8813: fnd_global.user_id ,
8814: SYSDATE ,
8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID

Line 8816: fnd_global.conc_request_id ,--Request Id

8812: SYSDATE ,
8813: fnd_global.user_id ,
8814: SYSDATE ,
8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID
8820: 1

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

8813: fnd_global.user_id ,
8814: SYSDATE ,
8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID
8820: 1
8821: FROM DUAL

Line 8818: fnd_global.conc_program_id ,--Program Id

8814: SYSDATE ,
8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID
8820: 1
8821: FROM DUAL
8822: WHERE not exists (select 1

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

8815: fnd_global.conc_login_id ,
8816: fnd_global.conc_request_id ,--Request Id
8817: fnd_global.prog_appl_id ,--Program Application ID
8818: fnd_global.conc_program_id ,--Program Id
8819: fnd_global.conc_login_id , --Program Login ID
8820: 1
8821: FROM DUAL
8822: WHERE not exists (select 1
8823: from ZX_DET_FACTOR_TEMPL_B

Line 8853: fnd_global.user_id ,

8849: END,
8850: B.DET_FACTOR_TEMPL_CODE ,
8851: B.DET_FACTOR_TEMPL_ID ,
8852: SYSDATE ,
8853: fnd_global.user_id ,
8854: SYSDATE ,
8855: fnd_global.user_id ,
8856: fnd_global.conc_login_id
8857: FROM

Line 8855: fnd_global.user_id ,

8851: B.DET_FACTOR_TEMPL_ID ,
8852: SYSDATE ,
8853: fnd_global.user_id ,
8854: SYSDATE ,
8855: fnd_global.user_id ,
8856: fnd_global.conc_login_id
8857: FROM
8858: FND_LANGUAGES L,
8859: ZX_DET_FACTOR_TEMPL_B B

Line 8856: fnd_global.conc_login_id

8852: SYSDATE ,
8853: fnd_global.user_id ,
8854: SYSDATE ,
8855: fnd_global.user_id ,
8856: fnd_global.conc_login_id
8857: FROM
8858: FND_LANGUAGES L,
8859: ZX_DET_FACTOR_TEMPL_B B
8860: WHERE

Line 8901: fnd_global.user_id ,

8897: REQUIRED_FLAG ,
8898: RECORD_TYPE_CODE ,
8899: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8900: DET_FACTOR_TEMPL_ID ,
8901: fnd_global.user_id ,
8902: SYSDATE ,
8903: fnd_global.user_id ,
8904: SYSDATE ,
8905: fnd_global.conc_login_id ,

Line 8903: fnd_global.user_id ,

8899: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8900: DET_FACTOR_TEMPL_ID ,
8901: fnd_global.user_id ,
8902: SYSDATE ,
8903: fnd_global.user_id ,
8904: SYSDATE ,
8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID

Line 8905: fnd_global.conc_login_id ,

8901: fnd_global.user_id ,
8902: SYSDATE ,
8903: fnd_global.user_id ,
8904: SYSDATE ,
8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID
8908: fnd_global.conc_program_id ,--Program Id
8909: fnd_global.conc_login_id --Program Login ID

Line 8906: fnd_global.conc_request_id ,--Request Id

8902: SYSDATE ,
8903: fnd_global.user_id ,
8904: SYSDATE ,
8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID
8908: fnd_global.conc_program_id ,--Program Id
8909: fnd_global.conc_login_id --Program Login ID
8910: FROM

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

8903: fnd_global.user_id ,
8904: SYSDATE ,
8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID
8908: fnd_global.conc_program_id ,--Program Id
8909: fnd_global.conc_login_id --Program Login ID
8910: FROM
8911: (

Line 8908: fnd_global.conc_program_id ,--Program Id

8904: SYSDATE ,
8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID
8908: fnd_global.conc_program_id ,--Program Id
8909: fnd_global.conc_login_id --Program Login ID
8910: FROM
8911: (
8912: SELECT

Line 8909: fnd_global.conc_login_id --Program Login ID

8905: fnd_global.conc_login_id ,
8906: fnd_global.conc_request_id ,--Request Id
8907: fnd_global.prog_appl_id ,--Program Application ID
8908: fnd_global.conc_program_id ,--Program Id
8909: fnd_global.conc_login_id --Program Login ID
8910: FROM
8911: (
8912: SELECT
8913: 'ACCOUNTING_FLEXFIELD' DETERMINING_FACTOR_CLASS_CODE ,

Line 9043: fnd_global.user_id ,

9039: ALPHANUMERIC_VALUE ,
9040: VALUE_LOW ,
9041: VALUE_HIGH ,
9042: zx_conditions_s.nextval ,--CONDITION_ID
9043: fnd_global.user_id ,
9044: SYSDATE ,
9045: fnd_global.user_id ,
9046: SYSDATE ,
9047: fnd_global.conc_login_id ,

Line 9045: fnd_global.user_id ,

9041: VALUE_HIGH ,
9042: zx_conditions_s.nextval ,--CONDITION_ID
9043: fnd_global.user_id ,
9044: SYSDATE ,
9045: fnd_global.user_id ,
9046: SYSDATE ,
9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID

Line 9047: fnd_global.conc_login_id ,

9043: fnd_global.user_id ,
9044: SYSDATE ,
9045: fnd_global.user_id ,
9046: SYSDATE ,
9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID
9050: fnd_global.conc_program_id ,--Program Id
9051: fnd_global.conc_login_id ,--Program Login ID

Line 9048: fnd_global.conc_request_id ,--Request Id

9044: SYSDATE ,
9045: fnd_global.user_id ,
9046: SYSDATE ,
9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID
9050: fnd_global.conc_program_id ,--Program Id
9051: fnd_global.conc_login_id ,--Program Login ID
9052: 1

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

9045: fnd_global.user_id ,
9046: SYSDATE ,
9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID
9050: fnd_global.conc_program_id ,--Program Id
9051: fnd_global.conc_login_id ,--Program Login ID
9052: 1
9053: FROM

Line 9050: fnd_global.conc_program_id ,--Program Id

9046: SYSDATE ,
9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID
9050: fnd_global.conc_program_id ,--Program Id
9051: fnd_global.conc_login_id ,--Program Login ID
9052: 1
9053: FROM
9054: (

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

9047: fnd_global.conc_login_id ,
9048: fnd_global.conc_request_id ,--Request Id
9049: fnd_global.prog_appl_id ,--Program Application ID
9050: fnd_global.conc_program_id ,--Program Id
9051: fnd_global.conc_login_id ,--Program Login ID
9052: 1
9053: FROM
9054: (
9055: SELECT

Line 9204: fnd_global.user_id ,

9200: 'MIGRATED' ,--RECORD_TYPE_CODE
9201: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9202: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9203: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9204: fnd_global.user_id ,
9205: SYSDATE ,
9206: fnd_global.user_id ,
9207: SYSDATE ,
9208: fnd_global.conc_login_id ,

Line 9206: fnd_global.user_id ,

9202: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9203: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9204: fnd_global.user_id ,
9205: SYSDATE ,
9206: fnd_global.user_id ,
9207: SYSDATE ,
9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID

Line 9208: fnd_global.conc_login_id ,

9204: fnd_global.user_id ,
9205: SYSDATE ,
9206: fnd_global.user_id ,
9207: SYSDATE ,
9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID
9211: fnd_global.conc_program_id ,--Program Id
9212: fnd_global.conc_login_id ,--Program Login ID

Line 9209: fnd_global.conc_request_id ,--Request Id

9205: SYSDATE ,
9206: fnd_global.user_id ,
9207: SYSDATE ,
9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID
9211: fnd_global.conc_program_id ,--Program Id
9212: fnd_global.conc_login_id ,--Program Login ID
9213: 1

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

9206: fnd_global.user_id ,
9207: SYSDATE ,
9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID
9211: fnd_global.conc_program_id ,--Program Id
9212: fnd_global.conc_login_id ,--Program Login ID
9213: 1
9214: FROM

Line 9211: fnd_global.conc_program_id ,--Program Id

9207: SYSDATE ,
9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID
9211: fnd_global.conc_program_id ,--Program Id
9212: fnd_global.conc_login_id ,--Program Login ID
9213: 1
9214: FROM
9215: ap_tax_recvry_rules_all RULES,

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

9208: fnd_global.conc_login_id ,
9209: fnd_global.conc_request_id ,--Request Id
9210: fnd_global.prog_appl_id ,--Program Application ID
9211: fnd_global.conc_program_id ,--Program Id
9212: fnd_global.conc_login_id ,--Program Login ID
9213: 1
9214: FROM
9215: ap_tax_recvry_rules_all RULES,
9216: --ap_system_parameters_all ASP,

Line 9336: fnd_global.user_id ,

9332: 'MIGRATED' ,--RECORD_TYPE_CODE
9333: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9334: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9335: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9336: fnd_global.user_id ,
9337: SYSDATE ,
9338: fnd_global.user_id ,
9339: SYSDATE ,
9340: fnd_global.conc_login_id ,

Line 9338: fnd_global.user_id ,

9334: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9335: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9336: fnd_global.user_id ,
9337: SYSDATE ,
9338: fnd_global.user_id ,
9339: SYSDATE ,
9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID

Line 9340: fnd_global.conc_login_id ,

9336: fnd_global.user_id ,
9337: SYSDATE ,
9338: fnd_global.user_id ,
9339: SYSDATE ,
9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID
9343: fnd_global.conc_program_id ,--Program Id
9344: fnd_global.conc_login_id ,--Program Login ID

Line 9341: fnd_global.conc_request_id ,--Request Id

9337: SYSDATE ,
9338: fnd_global.user_id ,
9339: SYSDATE ,
9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID
9343: fnd_global.conc_program_id ,--Program Id
9344: fnd_global.conc_login_id ,--Program Login ID
9345: 1

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

9338: fnd_global.user_id ,
9339: SYSDATE ,
9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID
9343: fnd_global.conc_program_id ,--Program Id
9344: fnd_global.conc_login_id ,--Program Login ID
9345: 1
9346: FROM

Line 9343: fnd_global.conc_program_id ,--Program Id

9339: SYSDATE ,
9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID
9343: fnd_global.conc_program_id ,--Program Id
9344: fnd_global.conc_login_id ,--Program Login ID
9345: 1
9346: FROM
9347: ap_tax_recvry_rules_all RULES,

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

9340: fnd_global.conc_login_id ,
9341: fnd_global.conc_request_id ,--Request Id
9342: fnd_global.prog_appl_id ,--Program Application ID
9343: fnd_global.conc_program_id ,--Program Id
9344: fnd_global.conc_login_id ,--Program Login ID
9345: 1
9346: FROM
9347: ap_tax_recvry_rules_all RULES,
9348: --ap_system_parameters_all ASP,

Line 9474: fnd_global.user_id ,

9470: 'MIGRATED' ,--RECORD_TYPE_CODE
9471: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9472: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9473: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9474: fnd_global.user_id ,
9475: SYSDATE ,
9476: fnd_global.user_id ,
9477: SYSDATE ,
9478: fnd_global.conc_login_id ,

Line 9476: fnd_global.user_id ,

9472: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9473: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9474: fnd_global.user_id ,
9475: SYSDATE ,
9476: fnd_global.user_id ,
9477: SYSDATE ,
9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID

Line 9478: fnd_global.conc_login_id ,

9474: fnd_global.user_id ,
9475: SYSDATE ,
9476: fnd_global.user_id ,
9477: SYSDATE ,
9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID
9481: fnd_global.conc_program_id ,--Program Id
9482: fnd_global.conc_login_id ,--Program Login ID

Line 9479: fnd_global.conc_request_id ,--Request Id

9475: SYSDATE ,
9476: fnd_global.user_id ,
9477: SYSDATE ,
9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID
9481: fnd_global.conc_program_id ,--Program Id
9482: fnd_global.conc_login_id ,--Program Login ID
9483: 1

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

9476: fnd_global.user_id ,
9477: SYSDATE ,
9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID
9481: fnd_global.conc_program_id ,--Program Id
9482: fnd_global.conc_login_id ,--Program Login ID
9483: 1
9484: FROM

Line 9481: fnd_global.conc_program_id ,--Program Id

9477: SYSDATE ,
9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID
9481: fnd_global.conc_program_id ,--Program Id
9482: fnd_global.conc_login_id ,--Program Login ID
9483: 1
9484: FROM
9485: ap_tax_recvry_rules_all RULES,

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

9478: fnd_global.conc_login_id ,
9479: fnd_global.conc_request_id ,--Request Id
9480: fnd_global.prog_appl_id ,--Program Application ID
9481: fnd_global.conc_program_id ,--Program Id
9482: fnd_global.conc_login_id ,--Program Login ID
9483: 1
9484: FROM
9485: ap_tax_recvry_rules_all RULES,
9486: --ap_system_parameters_all ASP,

Line 9608: fnd_global.user_id ,

9604: 'MIGRATED' ,--RECORD_TYPE_CODE
9605: SOB.SET_OF_BOOKS_ID ,--LEDGER_ID
9606: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9607: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9608: fnd_global.user_id ,
9609: SYSDATE ,
9610: fnd_global.user_id ,
9611: SYSDATE ,
9612: fnd_global.conc_login_id ,

Line 9610: fnd_global.user_id ,

9606: SOB.CHART_OF_ACCOUNTS_ID ,--CHART_OF_ACCOUNTS_ID
9607: zx_condition_groups_b_s.nextval ,--CONDITION_GROUP_ID
9608: fnd_global.user_id ,
9609: SYSDATE ,
9610: fnd_global.user_id ,
9611: SYSDATE ,
9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID

Line 9612: fnd_global.conc_login_id ,

9608: fnd_global.user_id ,
9609: SYSDATE ,
9610: fnd_global.user_id ,
9611: SYSDATE ,
9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID
9615: fnd_global.conc_program_id ,--Program Id
9616: fnd_global.conc_login_id ,--Program Login ID

Line 9613: fnd_global.conc_request_id ,--Request Id

9609: SYSDATE ,
9610: fnd_global.user_id ,
9611: SYSDATE ,
9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID
9615: fnd_global.conc_program_id ,--Program Id
9616: fnd_global.conc_login_id ,--Program Login ID
9617: 1

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

9610: fnd_global.user_id ,
9611: SYSDATE ,
9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID
9615: fnd_global.conc_program_id ,--Program Id
9616: fnd_global.conc_login_id ,--Program Login ID
9617: 1
9618: FROM

Line 9615: fnd_global.conc_program_id ,--Program Id

9611: SYSDATE ,
9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID
9615: fnd_global.conc_program_id ,--Program Id
9616: fnd_global.conc_login_id ,--Program Login ID
9617: 1
9618: FROM
9619: ap_tax_recvry_rules_all RULES,

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

9612: fnd_global.conc_login_id ,
9613: fnd_global.conc_request_id ,--Request Id
9614: fnd_global.prog_appl_id ,--Program Application ID
9615: fnd_global.conc_program_id ,--Program Id
9616: fnd_global.conc_login_id ,--Program Login ID
9617: 1
9618: FROM
9619: ap_tax_recvry_rules_all RULES,
9620: --ap_system_parameters_all ASP,

Line 9686: fnd_global.user_id ,

9682: END,
9683: B.CONDITION_GROUP_CODE ,
9684: B.CONDITION_GROUP_ID ,
9685: SYSDATE ,
9686: fnd_global.user_id ,
9687: SYSDATE ,
9688: fnd_global.user_id ,
9689: fnd_global.conc_login_id
9690: FROM

Line 9688: fnd_global.user_id ,

9684: B.CONDITION_GROUP_ID ,
9685: SYSDATE ,
9686: fnd_global.user_id ,
9687: SYSDATE ,
9688: fnd_global.user_id ,
9689: fnd_global.conc_login_id
9690: FROM
9691: FND_LANGUAGES L,
9692: ZX_CONDITION_GROUPS_B B

Line 9689: fnd_global.conc_login_id

9685: SYSDATE ,
9686: fnd_global.user_id ,
9687: SYSDATE ,
9688: fnd_global.user_id ,
9689: fnd_global.conc_login_id
9690: FROM
9691: FND_LANGUAGES L,
9692: ZX_CONDITION_GROUPS_B B
9693: WHERE

Line 9796: fnd_global.user_id ,

9792: 'MIGRATED' ,--RECORD_TYPE_CODE
9793: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9794: CONTENT_OWNER_ID ,
9795: zx_rules_b_s.nextval ,--TAX_RULE_ID
9796: fnd_global.user_id ,
9797: SYSDATE ,
9798: fnd_global.user_id ,
9799: SYSDATE ,
9800: fnd_global.conc_login_id ,

Line 9798: fnd_global.user_id ,

9794: CONTENT_OWNER_ID ,
9795: zx_rules_b_s.nextval ,--TAX_RULE_ID
9796: fnd_global.user_id ,
9797: SYSDATE ,
9798: fnd_global.user_id ,
9799: SYSDATE ,
9800: fnd_global.conc_login_id ,
9801: fnd_global.conc_request_id ,--Request Id
9802: fnd_global.prog_appl_id ,--Program Application ID

Line 9800: fnd_global.conc_login_id ,

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

Line 9801: fnd_global.conc_request_id ,--Request Id

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

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

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

Line 9803: fnd_global.conc_program_id ,--Program Id

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

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

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

Line 9907: fnd_global.user_id ,

9903: 'MIGRATED' ,--RECORD_TYPE_CODE
9904: 'EX Acct String Range-Party FC' ,--DET_FACTOR_TEMPL_CODE
9905: CONTENT_OWNER_ID ,
9906: zx_rules_b_s.nextval ,--TAX_RULE_ID
9907: fnd_global.user_id ,
9908: SYSDATE ,
9909: fnd_global.user_id ,
9910: SYSDATE ,
9911: fnd_global.conc_login_id ,

Line 9909: fnd_global.user_id ,

9905: CONTENT_OWNER_ID ,
9906: zx_rules_b_s.nextval ,--TAX_RULE_ID
9907: fnd_global.user_id ,
9908: SYSDATE ,
9909: fnd_global.user_id ,
9910: SYSDATE ,
9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID

Line 9911: fnd_global.conc_login_id ,

9907: fnd_global.user_id ,
9908: SYSDATE ,
9909: fnd_global.user_id ,
9910: SYSDATE ,
9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID
9914: fnd_global.conc_program_id ,--Program Id
9915: fnd_global.conc_login_id ,--Program Login ID

Line 9912: fnd_global.conc_request_id ,--Request Id

9908: SYSDATE ,
9909: fnd_global.user_id ,
9910: SYSDATE ,
9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID
9914: fnd_global.conc_program_id ,--Program Id
9915: fnd_global.conc_login_id ,--Program Login ID
9916: 1

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

9909: fnd_global.user_id ,
9910: SYSDATE ,
9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID
9914: fnd_global.conc_program_id ,--Program Id
9915: fnd_global.conc_login_id ,--Program Login ID
9916: 1
9917: FROM

Line 9914: fnd_global.conc_program_id ,--Program Id

9910: SYSDATE ,
9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID
9914: fnd_global.conc_program_id ,--Program Id
9915: fnd_global.conc_login_id ,--Program Login ID
9916: 1
9917: FROM
9918: (

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

9911: fnd_global.conc_login_id ,
9912: fnd_global.conc_request_id ,--Request Id
9913: fnd_global.prog_appl_id ,--Program Application ID
9914: fnd_global.conc_program_id ,--Program Id
9915: fnd_global.conc_login_id ,--Program Login ID
9916: 1
9917: FROM
9918: (
9919: SELECT

Line 10001: fnd_global.user_id ,

9997: END,
9998: Result.description,
9999: result.TAX_RULE_ID ,
10000: SYSDATE ,
10001: fnd_global.user_id ,
10002: SYSDATE ,
10003: fnd_global.user_id ,
10004: fnd_global.conc_login_id
10005: FROM (SELECT DISTINCT b.tax_rule_code

Line 10003: fnd_global.user_id ,

9999: result.TAX_RULE_ID ,
10000: SYSDATE ,
10001: fnd_global.user_id ,
10002: SYSDATE ,
10003: fnd_global.user_id ,
10004: fnd_global.conc_login_id
10005: FROM (SELECT DISTINCT b.tax_rule_code
10006: ,b.tax_rule_id
10007: ,rules.description

Line 10004: fnd_global.conc_login_id

10000: SYSDATE ,
10001: fnd_global.user_id ,
10002: SYSDATE ,
10003: fnd_global.user_id ,
10004: fnd_global.conc_login_id
10005: FROM (SELECT DISTINCT b.tax_rule_code
10006: ,b.tax_rule_id
10007: ,rules.description
10008: ,l.LANGUAGE_CODE

Line 10095: fnd_global.user_id ,

10091: zx_process_results_s.nextval ,--RESULT_ID
10092: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
10093: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10094: TAX_RULE_ID ,--TAX_RULE_ID
10095: fnd_global.user_id ,
10096: SYSDATE ,
10097: fnd_global.user_id ,
10098: SYSDATE ,
10099: fnd_global.conc_login_id ,

Line 10097: fnd_global.user_id ,

10093: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10094: TAX_RULE_ID ,--TAX_RULE_ID
10095: fnd_global.user_id ,
10096: SYSDATE ,
10097: fnd_global.user_id ,
10098: SYSDATE ,
10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID

Line 10099: fnd_global.conc_login_id ,

10095: fnd_global.user_id ,
10096: SYSDATE ,
10097: fnd_global.user_id ,
10098: SYSDATE ,
10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID
10102: fnd_global.conc_program_id ,--Program Id
10103: fnd_global.conc_login_id , --Program Login ID

Line 10100: fnd_global.conc_request_id ,--Request Id

10096: SYSDATE ,
10097: fnd_global.user_id ,
10098: SYSDATE ,
10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID
10102: fnd_global.conc_program_id ,--Program Id
10103: fnd_global.conc_login_id , --Program Login ID
10104: 1

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

10097: fnd_global.user_id ,
10098: SYSDATE ,
10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID
10102: fnd_global.conc_program_id ,--Program Id
10103: fnd_global.conc_login_id , --Program Login ID
10104: 1
10105: FROM

Line 10102: fnd_global.conc_program_id ,--Program Id

10098: SYSDATE ,
10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID
10102: fnd_global.conc_program_id ,--Program Id
10103: fnd_global.conc_login_id , --Program Login ID
10104: 1
10105: FROM
10106: (SELECT DISTINCT

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

10099: fnd_global.conc_login_id ,
10100: fnd_global.conc_request_id ,--Request Id
10101: fnd_global.prog_appl_id ,--Program Application ID
10102: fnd_global.conc_program_id ,--Program Id
10103: fnd_global.conc_login_id , --Program Login ID
10104: 1
10105: FROM
10106: (SELECT DISTINCT
10107: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE

Line 10251: fnd_global.user_id ,

10247: zx_process_results_s.nextval ,--RESULT_ID
10248: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
10249: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10250: TAX_RULE_ID ,--TAX_RULE_ID
10251: fnd_global.user_id ,
10252: SYSDATE ,
10253: fnd_global.user_id ,
10254: SYSDATE ,
10255: fnd_global.conc_login_id ,

Line 10253: fnd_global.user_id ,

10249: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10250: TAX_RULE_ID ,--TAX_RULE_ID
10251: fnd_global.user_id ,
10252: SYSDATE ,
10253: fnd_global.user_id ,
10254: SYSDATE ,
10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID

Line 10255: fnd_global.conc_login_id ,

10251: fnd_global.user_id ,
10252: SYSDATE ,
10253: fnd_global.user_id ,
10254: SYSDATE ,
10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID
10258: fnd_global.conc_program_id ,--Program Id
10259: fnd_global.conc_login_id , --Program Login ID

Line 10256: fnd_global.conc_request_id ,--Request Id

10252: SYSDATE ,
10253: fnd_global.user_id ,
10254: SYSDATE ,
10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID
10258: fnd_global.conc_program_id ,--Program Id
10259: fnd_global.conc_login_id , --Program Login ID
10260: 1

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

10253: fnd_global.user_id ,
10254: SYSDATE ,
10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID
10258: fnd_global.conc_program_id ,--Program Id
10259: fnd_global.conc_login_id , --Program Login ID
10260: 1
10261: FROM

Line 10258: fnd_global.conc_program_id ,--Program Id

10254: SYSDATE ,
10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID
10258: fnd_global.conc_program_id ,--Program Id
10259: fnd_global.conc_login_id , --Program Login ID
10260: 1
10261: FROM
10262: (SELECT DISTINCT

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

10255: fnd_global.conc_login_id ,
10256: fnd_global.conc_request_id ,--Request Id
10257: fnd_global.prog_appl_id ,--Program Application ID
10258: fnd_global.conc_program_id ,--Program Id
10259: fnd_global.conc_login_id , --Program Login ID
10260: 1
10261: FROM
10262: (SELECT DISTINCT
10263: GROUPS.condition_group_code CONDITION_GROUP_CODE,--CONDITION_GROUP_CODE

Line 10608: fnd_global.user_id,

10604: NULL,
10605: NULL,
10606: NULL,
10607: 'MIGRATED',
10608: fnd_global.user_id,
10609: SYSDATE,
10610: fnd_global.user_id,
10611: SYSDATE,
10612: fnd_global.conc_login_id,

Line 10610: fnd_global.user_id,

10606: NULL,
10607: 'MIGRATED',
10608: fnd_global.user_id,
10609: SYSDATE,
10610: fnd_global.user_id,
10611: SYSDATE,
10612: fnd_global.conc_login_id,
10613: fnd_global.conc_request_id,
10614: fnd_global.prog_appl_id,

Line 10612: fnd_global.conc_login_id,

10608: fnd_global.user_id,
10609: SYSDATE,
10610: fnd_global.user_id,
10611: SYSDATE,
10612: fnd_global.conc_login_id,
10613: fnd_global.conc_request_id,
10614: fnd_global.prog_appl_id,
10615: fnd_global.conc_program_id,
10616: NULL,

Line 10613: fnd_global.conc_request_id,

10609: SYSDATE,
10610: fnd_global.user_id,
10611: SYSDATE,
10612: fnd_global.conc_login_id,
10613: fnd_global.conc_request_id,
10614: fnd_global.prog_appl_id,
10615: fnd_global.conc_program_id,
10616: NULL,
10617: NULL,

Line 10614: fnd_global.prog_appl_id,

10610: fnd_global.user_id,
10611: SYSDATE,
10612: fnd_global.conc_login_id,
10613: fnd_global.conc_request_id,
10614: fnd_global.prog_appl_id,
10615: fnd_global.conc_program_id,
10616: NULL,
10617: NULL,
10618: NULL,

Line 10615: fnd_global.conc_program_id,

10611: SYSDATE,
10612: fnd_global.conc_login_id,
10613: fnd_global.conc_request_id,
10614: fnd_global.prog_appl_id,
10615: fnd_global.conc_program_id,
10616: NULL,
10617: NULL,
10618: NULL,
10619: NULL,

Line 10632: fnd_global.conc_login_id,

10628: NULL,
10629: NULL,
10630: NULL,
10631: NULL,
10632: fnd_global.conc_login_id,
10633: zx_accounts_s.nextval,
10634: pg_max_tax_id_tab(j),
10635: pg_max_ledger_id_tab(j),
10636: pg_max_org_id_tab(j),

Line 10892: fnd_global.user_id ,

10888: ATTRIBUTE15 ,
10889: ATTRIBUTE_CATEGORY ,
10890: zx_rates_b_s.nextval ,--TAX_RATE_ID
10891: CONTENT_OWNER_ID ,
10892: fnd_global.user_id ,
10893: SYSDATE ,
10894: fnd_global.user_id ,
10895: SYSDATE ,
10896: fnd_global.conc_login_id ,

Line 10894: fnd_global.user_id ,

10890: zx_rates_b_s.nextval ,--TAX_RATE_ID
10891: CONTENT_OWNER_ID ,
10892: fnd_global.user_id ,
10893: SYSDATE ,
10894: fnd_global.user_id ,
10895: SYSDATE ,
10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID

Line 10896: fnd_global.conc_login_id ,

10892: fnd_global.user_id ,
10893: SYSDATE ,
10894: fnd_global.user_id ,
10895: SYSDATE ,
10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID
10899: fnd_global.conc_program_id , -- Program Id
10900: fnd_global.conc_login_id , -- Program Login ID

Line 10897: fnd_global.conc_request_id , -- Request Id

10893: SYSDATE ,
10894: fnd_global.user_id ,
10895: SYSDATE ,
10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID
10899: fnd_global.conc_program_id , -- Program Id
10900: fnd_global.conc_login_id , -- Program Login ID
10901: 'TAX_RATE' ,

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

10894: fnd_global.user_id ,
10895: SYSDATE ,
10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID
10899: fnd_global.conc_program_id , -- Program Id
10900: fnd_global.conc_login_id , -- Program Login ID
10901: 'TAX_RATE' ,
10902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 10899: fnd_global.conc_program_id , -- Program Id

10895: SYSDATE ,
10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID
10899: fnd_global.conc_program_id , -- Program Id
10900: fnd_global.conc_login_id , -- Program Login ID
10901: 'TAX_RATE' ,
10902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10903: 1

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

10896: fnd_global.conc_login_id ,
10897: fnd_global.conc_request_id , -- Request Id
10898: fnd_global.prog_appl_id , -- Program Application ID
10899: fnd_global.conc_program_id , -- Program Id
10900: fnd_global.conc_login_id , -- Program Login ID
10901: 'TAX_RATE' ,
10902: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
10903: 1
10904: -- 6820043, commenting out description

Line 10988: fnd_global.user_id ,

10984: NULL ,
10985: NULL ,
10986: NULL ,
10987: NULL ,
10988: fnd_global.user_id ,
10989: SYSDATE ,
10990: fnd_global.user_id ,
10991: SYSDATE ,
10992: fnd_global.conc_login_id ,

Line 10990: fnd_global.user_id ,

10986: NULL ,
10987: NULL ,
10988: fnd_global.user_id ,
10989: SYSDATE ,
10990: fnd_global.user_id ,
10991: SYSDATE ,
10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID

Line 10992: fnd_global.conc_login_id ,

10988: fnd_global.user_id ,
10989: SYSDATE ,
10990: fnd_global.user_id ,
10991: SYSDATE ,
10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID
10995: fnd_global.conc_program_id , -- Program Id
10996: fnd_global.conc_login_id , -- Program Login ID

Line 10993: fnd_global.conc_request_id , -- Request Id

10989: SYSDATE ,
10990: fnd_global.user_id ,
10991: SYSDATE ,
10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID
10995: fnd_global.conc_program_id , -- Program Id
10996: fnd_global.conc_login_id , -- Program Login ID
10997: 1

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

10990: fnd_global.user_id ,
10991: SYSDATE ,
10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID
10995: fnd_global.conc_program_id , -- Program Id
10996: fnd_global.conc_login_id , -- Program Login ID
10997: 1
10998: )

Line 10995: fnd_global.conc_program_id , -- Program Id

10991: SYSDATE ,
10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID
10995: fnd_global.conc_program_id , -- Program Id
10996: fnd_global.conc_login_id , -- Program Login ID
10997: 1
10998: )
10999: SELECT

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

10992: fnd_global.conc_login_id ,
10993: fnd_global.conc_request_id , -- Request Id
10994: fnd_global.prog_appl_id , -- Program Application ID
10995: fnd_global.conc_program_id , -- Program Id
10996: fnd_global.conc_login_id , -- Program Login ID
10997: 1
10998: )
10999: SELECT
11000: results.tax_code_id TAX_RATE_ID,

Line 11314: fnd_global.user_id ,

11310: ATTRIBUTE15 ,
11311: ATTRIBUTE_CATEGORY ,
11312: zx_rates_b_s.nextval ,--TAX_RATE_ID
11313: CONTENT_OWNER_ID ,
11314: fnd_global.user_id ,
11315: SYSDATE ,
11316: fnd_global.user_id ,
11317: SYSDATE ,
11318: fnd_global.conc_login_id ,

Line 11316: fnd_global.user_id ,

11312: zx_rates_b_s.nextval ,--TAX_RATE_ID
11313: CONTENT_OWNER_ID ,
11314: fnd_global.user_id ,
11315: SYSDATE ,
11316: fnd_global.user_id ,
11317: SYSDATE ,
11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID

Line 11318: fnd_global.conc_login_id ,

11314: fnd_global.user_id ,
11315: SYSDATE ,
11316: fnd_global.user_id ,
11317: SYSDATE ,
11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID
11321: fnd_global.conc_program_id , -- Program Id
11322: fnd_global.conc_login_id , -- Program Login ID

Line 11319: fnd_global.conc_request_id , -- Request Id

11315: SYSDATE ,
11316: fnd_global.user_id ,
11317: SYSDATE ,
11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID
11321: fnd_global.conc_program_id , -- Program Id
11322: fnd_global.conc_login_id , -- Program Login ID
11323: 'TAX_RATE' ,

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

11316: fnd_global.user_id ,
11317: SYSDATE ,
11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID
11321: fnd_global.conc_program_id , -- Program Id
11322: fnd_global.conc_login_id , -- Program Login ID
11323: 'TAX_RATE' ,
11324: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 11321: fnd_global.conc_program_id , -- Program Id

11317: SYSDATE ,
11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID
11321: fnd_global.conc_program_id , -- Program Id
11322: fnd_global.conc_login_id , -- Program Login ID
11323: 'TAX_RATE' ,
11324: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
11325: 1

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

11318: fnd_global.conc_login_id ,
11319: fnd_global.conc_request_id , -- Request Id
11320: fnd_global.prog_appl_id , -- Program Application ID
11321: fnd_global.conc_program_id , -- Program Id
11322: fnd_global.conc_login_id , -- Program Login ID
11323: 'TAX_RATE' ,
11324: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
11325: 1
11326: -- 6820043, commenting out description

Line 11410: fnd_global.user_id ,

11406: NULL ,
11407: NULL ,
11408: NULL ,
11409: NULL ,
11410: fnd_global.user_id ,
11411: SYSDATE ,
11412: fnd_global.user_id ,
11413: SYSDATE ,
11414: fnd_global.conc_login_id ,

Line 11412: fnd_global.user_id ,

11408: NULL ,
11409: NULL ,
11410: fnd_global.user_id ,
11411: SYSDATE ,
11412: fnd_global.user_id ,
11413: SYSDATE ,
11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID

Line 11414: fnd_global.conc_login_id ,

11410: fnd_global.user_id ,
11411: SYSDATE ,
11412: fnd_global.user_id ,
11413: SYSDATE ,
11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID
11417: fnd_global.conc_program_id , -- Program Id
11418: fnd_global.conc_login_id , -- Program Login ID

Line 11415: fnd_global.conc_request_id , -- Request Id

11411: SYSDATE ,
11412: fnd_global.user_id ,
11413: SYSDATE ,
11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID
11417: fnd_global.conc_program_id , -- Program Id
11418: fnd_global.conc_login_id , -- Program Login ID
11419: 1

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

11412: fnd_global.user_id ,
11413: SYSDATE ,
11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID
11417: fnd_global.conc_program_id , -- Program Id
11418: fnd_global.conc_login_id , -- Program Login ID
11419: 1
11420: )

Line 11417: fnd_global.conc_program_id , -- Program Id

11413: SYSDATE ,
11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID
11417: fnd_global.conc_program_id , -- Program Id
11418: fnd_global.conc_login_id , -- Program Login ID
11419: 1
11420: )
11421: SELECT

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

11414: fnd_global.conc_login_id ,
11415: fnd_global.conc_request_id , -- Request Id
11416: fnd_global.prog_appl_id , -- Program Application ID
11417: fnd_global.conc_program_id , -- Program Id
11418: fnd_global.conc_login_id , -- Program Login ID
11419: 1
11420: )
11421: SELECT
11422: results.tax_code_id TAX_RATE_ID,

Line 11748: fnd_global.user_id ,

11744: ATTRIBUTE15 ,
11745: ATTRIBUTE_CATEGORY ,
11746: TAX_RATE_ID ,
11747: CONTENT_OWNER_ID ,
11748: fnd_global.user_id ,
11749: SYSDATE ,
11750: fnd_global.user_id ,
11751: SYSDATE ,
11752: fnd_global.conc_login_id ,

Line 11750: fnd_global.user_id ,

11746: TAX_RATE_ID ,
11747: CONTENT_OWNER_ID ,
11748: fnd_global.user_id ,
11749: SYSDATE ,
11750: fnd_global.user_id ,
11751: SYSDATE ,
11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID

Line 11752: fnd_global.conc_login_id ,

11748: fnd_global.user_id ,
11749: SYSDATE ,
11750: fnd_global.user_id ,
11751: SYSDATE ,
11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID
11755: fnd_global.conc_program_id , -- Program Id
11756: fnd_global.conc_login_id , -- Program Login ID

Line 11753: fnd_global.conc_request_id , -- Request Id

11749: SYSDATE ,
11750: fnd_global.user_id ,
11751: SYSDATE ,
11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID
11755: fnd_global.conc_program_id , -- Program Id
11756: fnd_global.conc_login_id , -- Program Login ID
11757: 'TAX_RATE' ,

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

11750: fnd_global.user_id ,
11751: SYSDATE ,
11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID
11755: fnd_global.conc_program_id , -- Program Id
11756: fnd_global.conc_login_id , -- Program Login ID
11757: 'TAX_RATE' ,
11758: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 11755: fnd_global.conc_program_id , -- Program Id

11751: SYSDATE ,
11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID
11755: fnd_global.conc_program_id , -- Program Id
11756: fnd_global.conc_login_id , -- Program Login ID
11757: 'TAX_RATE' ,
11758: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11759: 1 ,

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

11752: fnd_global.conc_login_id ,
11753: fnd_global.conc_request_id , -- Request Id
11754: fnd_global.prog_appl_id , -- Program Application ID
11755: fnd_global.conc_program_id , -- Program Id
11756: fnd_global.conc_login_id , -- Program Login ID
11757: 'TAX_RATE' ,
11758: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
11759: 1 ,
11760: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 11846: fnd_global.user_id ,

11842: NULL ,
11843: NULL ,
11844: NULL ,
11845: NULL ,
11846: fnd_global.user_id ,
11847: SYSDATE ,
11848: fnd_global.user_id ,
11849: SYSDATE ,
11850: fnd_global.conc_login_id ,

Line 11848: fnd_global.user_id ,

11844: NULL ,
11845: NULL ,
11846: fnd_global.user_id ,
11847: SYSDATE ,
11848: fnd_global.user_id ,
11849: SYSDATE ,
11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID

Line 11850: fnd_global.conc_login_id ,

11846: fnd_global.user_id ,
11847: SYSDATE ,
11848: fnd_global.user_id ,
11849: SYSDATE ,
11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID
11853: fnd_global.conc_program_id , -- Program Id
11854: fnd_global.conc_login_id , -- Program Login ID

Line 11851: fnd_global.conc_request_id , -- Request Id

11847: SYSDATE ,
11848: fnd_global.user_id ,
11849: SYSDATE ,
11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID
11853: fnd_global.conc_program_id , -- Program Id
11854: fnd_global.conc_login_id , -- Program Login ID
11855: 1

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

11848: fnd_global.user_id ,
11849: SYSDATE ,
11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID
11853: fnd_global.conc_program_id , -- Program Id
11854: fnd_global.conc_login_id , -- Program Login ID
11855: 1
11856: )

Line 11853: fnd_global.conc_program_id , -- Program Id

11849: SYSDATE ,
11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID
11853: fnd_global.conc_program_id , -- Program Id
11854: fnd_global.conc_login_id , -- Program Login ID
11855: 1
11856: )
11857: SELECT

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

11850: fnd_global.conc_login_id ,
11851: fnd_global.conc_request_id , -- Request Id
11852: fnd_global.prog_appl_id , -- Program Application ID
11853: fnd_global.conc_program_id , -- Program Id
11854: fnd_global.conc_login_id , -- Program Login ID
11855: 1
11856: )
11857: SELECT
11858: results.tax_code_id TAX_RATE_ID,

Line 12172: fnd_global.user_id ,

12168: ATTRIBUTE15 ,
12169: ATTRIBUTE_CATEGORY ,
12170: TAX_RATE_ID ,
12171: CONTENT_OWNER_ID ,
12172: fnd_global.user_id ,
12173: SYSDATE ,
12174: fnd_global.user_id ,
12175: SYSDATE ,
12176: fnd_global.conc_login_id ,

Line 12174: fnd_global.user_id ,

12170: TAX_RATE_ID ,
12171: CONTENT_OWNER_ID ,
12172: fnd_global.user_id ,
12173: SYSDATE ,
12174: fnd_global.user_id ,
12175: SYSDATE ,
12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID

Line 12176: fnd_global.conc_login_id ,

12172: fnd_global.user_id ,
12173: SYSDATE ,
12174: fnd_global.user_id ,
12175: SYSDATE ,
12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID
12179: fnd_global.conc_program_id , -- Program Id
12180: fnd_global.conc_login_id , -- Program Login ID

Line 12177: fnd_global.conc_request_id , -- Request Id

12173: SYSDATE ,
12174: fnd_global.user_id ,
12175: SYSDATE ,
12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID
12179: fnd_global.conc_program_id , -- Program Id
12180: fnd_global.conc_login_id , -- Program Login ID
12181: 'TAX_RATE' ,

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

12174: fnd_global.user_id ,
12175: SYSDATE ,
12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID
12179: fnd_global.conc_program_id , -- Program Id
12180: fnd_global.conc_login_id , -- Program Login ID
12181: 'TAX_RATE' ,
12182: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 12179: fnd_global.conc_program_id , -- Program Id

12175: SYSDATE ,
12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID
12179: fnd_global.conc_program_id , -- Program Id
12180: fnd_global.conc_login_id , -- Program Login ID
12181: 'TAX_RATE' ,
12182: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
12183: 1 ,

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

12176: fnd_global.conc_login_id ,
12177: fnd_global.conc_request_id , -- Request Id
12178: fnd_global.prog_appl_id , -- Program Application ID
12179: fnd_global.conc_program_id , -- Program Id
12180: fnd_global.conc_login_id , -- Program Login ID
12181: 'TAX_RATE' ,
12182: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
12183: 1 ,
12184: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 12270: fnd_global.user_id ,

12266: NULL ,
12267: NULL ,
12268: NULL ,
12269: NULL ,
12270: fnd_global.user_id ,
12271: SYSDATE ,
12272: fnd_global.user_id ,
12273: SYSDATE ,
12274: fnd_global.conc_login_id ,

Line 12272: fnd_global.user_id ,

12268: NULL ,
12269: NULL ,
12270: fnd_global.user_id ,
12271: SYSDATE ,
12272: fnd_global.user_id ,
12273: SYSDATE ,
12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID

Line 12274: fnd_global.conc_login_id ,

12270: fnd_global.user_id ,
12271: SYSDATE ,
12272: fnd_global.user_id ,
12273: SYSDATE ,
12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID
12277: fnd_global.conc_program_id , -- Program Id
12278: fnd_global.conc_login_id , -- Program Login ID

Line 12275: fnd_global.conc_request_id , -- Request Id

12271: SYSDATE ,
12272: fnd_global.user_id ,
12273: SYSDATE ,
12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID
12277: fnd_global.conc_program_id , -- Program Id
12278: fnd_global.conc_login_id , -- Program Login ID
12279: 1

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

12272: fnd_global.user_id ,
12273: SYSDATE ,
12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID
12277: fnd_global.conc_program_id , -- Program Id
12278: fnd_global.conc_login_id , -- Program Login ID
12279: 1
12280: )

Line 12277: fnd_global.conc_program_id , -- Program Id

12273: SYSDATE ,
12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID
12277: fnd_global.conc_program_id , -- Program Id
12278: fnd_global.conc_login_id , -- Program Login ID
12279: 1
12280: )
12281: SELECT

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

12274: fnd_global.conc_login_id ,
12275: fnd_global.conc_request_id , -- Request Id
12276: fnd_global.prog_appl_id , -- Program Application ID
12277: fnd_global.conc_program_id , -- Program Id
12278: fnd_global.conc_login_id , -- Program Login ID
12279: 1
12280: )
12281: SELECT
12282: results.tax_code_id TAX_RATE_ID,

Line 12615: fnd_global.user_id ,

12611: ATTRIBUTE15 ,
12612: ATTRIBUTE_CATEGORY ,
12613: zx_rates_b_s.nextval ,--TAX_RATE_ID
12614: CONTENT_OWNER_ID ,
12615: fnd_global.user_id ,
12616: SYSDATE ,
12617: fnd_global.user_id ,
12618: SYSDATE ,
12619: fnd_global.conc_login_id ,

Line 12617: fnd_global.user_id ,

12613: zx_rates_b_s.nextval ,--TAX_RATE_ID
12614: CONTENT_OWNER_ID ,
12615: fnd_global.user_id ,
12616: SYSDATE ,
12617: fnd_global.user_id ,
12618: SYSDATE ,
12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID

Line 12619: fnd_global.conc_login_id ,

12615: fnd_global.user_id ,
12616: SYSDATE ,
12617: fnd_global.user_id ,
12618: SYSDATE ,
12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID
12622: fnd_global.conc_program_id , -- Program Id
12623: fnd_global.conc_login_id , -- Program Login ID

Line 12620: fnd_global.conc_request_id , -- Request Id

12616: SYSDATE ,
12617: fnd_global.user_id ,
12618: SYSDATE ,
12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID
12622: fnd_global.conc_program_id , -- Program Id
12623: fnd_global.conc_login_id , -- Program Login ID
12624: 'TAX_RATE' ,

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

12617: fnd_global.user_id ,
12618: SYSDATE ,
12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID
12622: fnd_global.conc_program_id , -- Program Id
12623: fnd_global.conc_login_id , -- Program Login ID
12624: 'TAX_RATE' ,
12625: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 12622: fnd_global.conc_program_id , -- Program Id

12618: SYSDATE ,
12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID
12622: fnd_global.conc_program_id , -- Program Id
12623: fnd_global.conc_login_id , -- Program Login ID
12624: 'TAX_RATE' ,
12625: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12626: 1

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

12619: fnd_global.conc_login_id ,
12620: fnd_global.conc_request_id , -- Request Id
12621: fnd_global.prog_appl_id , -- Program Application ID
12622: fnd_global.conc_program_id , -- Program Id
12623: fnd_global.conc_login_id , -- Program Login ID
12624: 'TAX_RATE' ,
12625: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
12626: 1
12627: -- 6820043, commenting out description

Line 12711: fnd_global.user_id ,

12707: NULL ,
12708: NULL ,
12709: NULL ,
12710: NULL ,
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: NULL ,
12710: NULL ,
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: 1

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: 1
12721: )

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: 1
12721: )
12722: SELECT

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: 1
12721: )
12722: SELECT
12723: results.tax_code_id TAX_RATE_ID,

Line 13039: fnd_global.user_id ,

13035: ATTRIBUTE15 ,
13036: ATTRIBUTE_CATEGORY ,
13037: zx_rates_b_s.nextval ,--TAX_RATE_ID
13038: CONTENT_OWNER_ID ,
13039: fnd_global.user_id ,
13040: SYSDATE ,
13041: fnd_global.user_id ,
13042: SYSDATE ,
13043: fnd_global.conc_login_id ,

Line 13041: fnd_global.user_id ,

13037: zx_rates_b_s.nextval ,--TAX_RATE_ID
13038: CONTENT_OWNER_ID ,
13039: fnd_global.user_id ,
13040: SYSDATE ,
13041: fnd_global.user_id ,
13042: SYSDATE ,
13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID

Line 13043: fnd_global.conc_login_id ,

13039: fnd_global.user_id ,
13040: SYSDATE ,
13041: fnd_global.user_id ,
13042: SYSDATE ,
13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID
13046: fnd_global.conc_program_id , -- Program Id
13047: fnd_global.conc_login_id , -- Program Login ID

Line 13044: fnd_global.conc_request_id , -- Request Id

13040: SYSDATE ,
13041: fnd_global.user_id ,
13042: SYSDATE ,
13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID
13046: fnd_global.conc_program_id , -- Program Id
13047: fnd_global.conc_login_id , -- Program Login ID
13048: 'TAX_RATE' ,

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

13041: fnd_global.user_id ,
13042: SYSDATE ,
13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID
13046: fnd_global.conc_program_id , -- Program Id
13047: fnd_global.conc_login_id , -- Program Login ID
13048: 'TAX_RATE' ,
13049: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG

Line 13046: fnd_global.conc_program_id , -- Program Id

13042: SYSDATE ,
13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID
13046: fnd_global.conc_program_id , -- Program Id
13047: fnd_global.conc_login_id , -- Program Login ID
13048: 'TAX_RATE' ,
13049: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
13050: 1

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

13043: fnd_global.conc_login_id ,
13044: fnd_global.conc_request_id , -- Request Id
13045: fnd_global.prog_appl_id , -- Program Application ID
13046: fnd_global.conc_program_id , -- Program Id
13047: fnd_global.conc_login_id , -- Program Login ID
13048: 'TAX_RATE' ,
13049: 'Y' ,-- ALLOW_ADHOC_TAX_RATE_FLAG
13050: 1
13051: -- , DESCRIPTION -- Bug 4705196

Line 13134: fnd_global.user_id ,

13130: NULL ,
13131: NULL ,
13132: NULL ,
13133: NULL ,
13134: fnd_global.user_id ,
13135: SYSDATE ,
13136: fnd_global.user_id ,
13137: SYSDATE ,
13138: fnd_global.conc_login_id ,

Line 13136: fnd_global.user_id ,

13132: NULL ,
13133: NULL ,
13134: fnd_global.user_id ,
13135: SYSDATE ,
13136: fnd_global.user_id ,
13137: SYSDATE ,
13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID

Line 13138: fnd_global.conc_login_id ,

13134: fnd_global.user_id ,
13135: SYSDATE ,
13136: fnd_global.user_id ,
13137: SYSDATE ,
13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID
13141: fnd_global.conc_program_id , -- Program Id
13142: fnd_global.conc_login_id , -- Program Login ID

Line 13139: fnd_global.conc_request_id , -- Request Id

13135: SYSDATE ,
13136: fnd_global.user_id ,
13137: SYSDATE ,
13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID
13141: fnd_global.conc_program_id , -- Program Id
13142: fnd_global.conc_login_id , -- Program Login ID
13143: 1

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

13136: fnd_global.user_id ,
13137: SYSDATE ,
13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID
13141: fnd_global.conc_program_id , -- Program Id
13142: fnd_global.conc_login_id , -- Program Login ID
13143: 1
13144: )

Line 13141: fnd_global.conc_program_id , -- Program Id

13137: SYSDATE ,
13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID
13141: fnd_global.conc_program_id , -- Program Id
13142: fnd_global.conc_login_id , -- Program Login ID
13143: 1
13144: )
13145: SELECT

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

13138: fnd_global.conc_login_id ,
13139: fnd_global.conc_request_id , -- Request Id
13140: fnd_global.prog_appl_id , -- Program Application ID
13141: fnd_global.conc_program_id , -- Program Id
13142: fnd_global.conc_login_id , -- Program Login ID
13143: 1
13144: )
13145: SELECT
13146: results.tax_code_id TAX_RATE_ID,

Line 13474: fnd_global.user_id ,

13470: ATTRIBUTE15 ,
13471: ATTRIBUTE_CATEGORY ,
13472: TAX_RATE_ID ,
13473: CONTENT_OWNER_ID ,
13474: fnd_global.user_id ,
13475: SYSDATE ,
13476: fnd_global.user_id ,
13477: SYSDATE ,
13478: fnd_global.conc_login_id ,

Line 13476: fnd_global.user_id ,

13472: TAX_RATE_ID ,
13473: CONTENT_OWNER_ID ,
13474: fnd_global.user_id ,
13475: SYSDATE ,
13476: fnd_global.user_id ,
13477: SYSDATE ,
13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID

Line 13478: fnd_global.conc_login_id ,

13474: fnd_global.user_id ,
13475: SYSDATE ,
13476: fnd_global.user_id ,
13477: SYSDATE ,
13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID
13481: fnd_global.conc_program_id , -- Program Id
13482: fnd_global.conc_login_id , -- Program Login ID

Line 13479: fnd_global.conc_request_id , -- Request Id

13475: SYSDATE ,
13476: fnd_global.user_id ,
13477: SYSDATE ,
13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID
13481: fnd_global.conc_program_id , -- Program Id
13482: fnd_global.conc_login_id , -- Program Login ID
13483: 'TAX_RATE' ,

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

13476: fnd_global.user_id ,
13477: SYSDATE ,
13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID
13481: fnd_global.conc_program_id , -- Program Id
13482: fnd_global.conc_login_id , -- Program Login ID
13483: 'TAX_RATE' ,
13484: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 13481: fnd_global.conc_program_id , -- Program Id

13477: SYSDATE ,
13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID
13481: fnd_global.conc_program_id , -- Program Id
13482: fnd_global.conc_login_id , -- Program Login ID
13483: 'TAX_RATE' ,
13484: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13485: 1 ,

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

13478: fnd_global.conc_login_id ,
13479: fnd_global.conc_request_id , -- Request Id
13480: fnd_global.prog_appl_id , -- Program Application ID
13481: fnd_global.conc_program_id , -- Program Id
13482: fnd_global.conc_login_id , -- Program Login ID
13483: 'TAX_RATE' ,
13484: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13485: 1 ,
13486: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 13572: fnd_global.user_id ,

13568: NULL ,
13569: NULL ,
13570: NULL ,
13571: NULL ,
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: NULL ,
13571: NULL ,
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: 1

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: 1
13582: )

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: 1
13582: )
13583: SELECT

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: 1
13582: )
13583: SELECT
13584: results.tax_code_id TAX_RATE_ID,

Line 13898: fnd_global.user_id ,

13894: ATTRIBUTE15 ,
13895: ATTRIBUTE_CATEGORY ,
13896: TAX_RATE_ID ,
13897: CONTENT_OWNER_ID ,
13898: fnd_global.user_id ,
13899: SYSDATE ,
13900: fnd_global.user_id ,
13901: SYSDATE ,
13902: fnd_global.conc_login_id ,

Line 13900: fnd_global.user_id ,

13896: TAX_RATE_ID ,
13897: CONTENT_OWNER_ID ,
13898: fnd_global.user_id ,
13899: SYSDATE ,
13900: fnd_global.user_id ,
13901: SYSDATE ,
13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID

Line 13902: fnd_global.conc_login_id ,

13898: fnd_global.user_id ,
13899: SYSDATE ,
13900: fnd_global.user_id ,
13901: SYSDATE ,
13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID
13905: fnd_global.conc_program_id , -- Program Id
13906: fnd_global.conc_login_id , -- Program Login ID

Line 13903: fnd_global.conc_request_id , -- Request Id

13899: SYSDATE ,
13900: fnd_global.user_id ,
13901: SYSDATE ,
13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID
13905: fnd_global.conc_program_id , -- Program Id
13906: fnd_global.conc_login_id , -- Program Login ID
13907: 'TAX_RATE' ,

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

13900: fnd_global.user_id ,
13901: SYSDATE ,
13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID
13905: fnd_global.conc_program_id , -- Program Id
13906: fnd_global.conc_login_id , -- Program Login ID
13907: 'TAX_RATE' ,
13908: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG

Line 13905: fnd_global.conc_program_id , -- Program Id

13901: SYSDATE ,
13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID
13905: fnd_global.conc_program_id , -- Program Id
13906: fnd_global.conc_login_id , -- Program Login ID
13907: 'TAX_RATE' ,
13908: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13909: 1 ,

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

13902: fnd_global.conc_login_id ,
13903: fnd_global.conc_request_id , -- Request Id
13904: fnd_global.prog_appl_id , -- Program Application ID
13905: fnd_global.conc_program_id , -- Program Id
13906: fnd_global.conc_login_id , -- Program Login ID
13907: 'TAX_RATE' ,
13908: 'Y' , --ALLOW_ADHOC_TAX_RATE_FLAG
13909: 1 ,
13910: --Bug 4241667 : SOURCE_ID = TAX_RATE_ID for AP TAX CODES

Line 13996: fnd_global.user_id ,

13992: NULL ,
13993: NULL ,
13994: NULL ,
13995: NULL ,
13996: fnd_global.user_id ,
13997: SYSDATE ,
13998: fnd_global.user_id ,
13999: SYSDATE ,
14000: fnd_global.conc_login_id ,

Line 13998: fnd_global.user_id ,

13994: NULL ,
13995: NULL ,
13996: fnd_global.user_id ,
13997: SYSDATE ,
13998: fnd_global.user_id ,
13999: SYSDATE ,
14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID

Line 14000: fnd_global.conc_login_id ,

13996: fnd_global.user_id ,
13997: SYSDATE ,
13998: fnd_global.user_id ,
13999: SYSDATE ,
14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID
14003: fnd_global.conc_program_id , -- Program Id
14004: fnd_global.conc_login_id , -- Program Login ID

Line 14001: fnd_global.conc_request_id , -- Request Id

13997: SYSDATE ,
13998: fnd_global.user_id ,
13999: SYSDATE ,
14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID
14003: fnd_global.conc_program_id , -- Program Id
14004: fnd_global.conc_login_id , -- Program Login ID
14005: 1

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

13998: fnd_global.user_id ,
13999: SYSDATE ,
14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID
14003: fnd_global.conc_program_id , -- Program Id
14004: fnd_global.conc_login_id , -- Program Login ID
14005: 1
14006: )

Line 14003: fnd_global.conc_program_id , -- Program Id

13999: SYSDATE ,
14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID
14003: fnd_global.conc_program_id , -- Program Id
14004: fnd_global.conc_login_id , -- Program Login ID
14005: 1
14006: )
14007: SELECT

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

14000: fnd_global.conc_login_id ,
14001: fnd_global.conc_request_id , -- Request Id
14002: fnd_global.prog_appl_id , -- Program Application ID
14003: fnd_global.conc_program_id , -- Program Id
14004: fnd_global.conc_login_id , -- Program Login ID
14005: 1
14006: )
14007: SELECT
14008: results.tax_code_id TAX_RATE_ID,

Line 14236: fnd_global.user_id ,

14232: THEN Initcap(TAX_RATE_CODE)
14233: ELSE
14234: TAX_RATE_CODE
14235: END ,
14236: fnd_global.user_id ,
14237: SYSDATE ,
14238: fnd_global.user_id ,
14239: SYSDATE ,
14240: fnd_global.conc_login_id ,

Line 14238: fnd_global.user_id ,

14234: TAX_RATE_CODE
14235: END ,
14236: fnd_global.user_id ,
14237: SYSDATE ,
14238: fnd_global.user_id ,
14239: SYSDATE ,
14240: fnd_global.conc_login_id ,
14241: L.LANGUAGE_CODE,
14242: userenv('LANG'),

Line 14240: fnd_global.conc_login_id ,

14236: fnd_global.user_id ,
14237: SYSDATE ,
14238: fnd_global.user_id ,
14239: SYSDATE ,
14240: fnd_global.conc_login_id ,
14241: L.LANGUAGE_CODE,
14242: userenv('LANG'),
14243: avtb.description
14244: FROM FND_LANGUAGES L,