DBA Data[Home] [Help]

APPS.ZX_MIGR_AR_TAX_GROUP_LOOKUPS dependencies on FND_GLOBAL

Line 184: fnd_global.user_id ,

180: 'S' ,
181: 0 ,
182: 0 ,
183: SYSDATE ,
184: fnd_global.user_id ,
185: SYSDATE ,
186: fnd_global.user_id ,
187: fnd_global.conc_login_id
188: )

Line 186: fnd_global.user_id ,

182: 0 ,
183: SYSDATE ,
184: fnd_global.user_id ,
185: SYSDATE ,
186: fnd_global.user_id ,
187: fnd_global.conc_login_id
188: )
189: WHEN (NOT EXISTS
190: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 187: fnd_global.conc_login_id

183: SYSDATE ,
184: fnd_global.user_id ,
185: SYSDATE ,
186: fnd_global.user_id ,
187: fnd_global.conc_login_id
188: )
189: WHEN (NOT EXISTS
190: (SELECT 1 FROM FND_LOOKUP_TYPES
191: WHERE LOOKUP_TYPE = 'ZX_CONDITION_OPERATOR'

Line 215: fnd_global.user_id ,

211: 'S' ,
212: 0 ,
213: 0 ,
214: SYSDATE ,
215: fnd_global.user_id ,
216: SYSDATE ,
217: fnd_global.user_id ,
218: fnd_global.conc_login_id
219: )

Line 217: fnd_global.user_id ,

213: 0 ,
214: SYSDATE ,
215: fnd_global.user_id ,
216: SYSDATE ,
217: fnd_global.user_id ,
218: fnd_global.conc_login_id
219: )
220: WHEN (NOT EXISTS
221: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 218: fnd_global.conc_login_id

214: SYSDATE ,
215: fnd_global.user_id ,
216: SYSDATE ,
217: fnd_global.user_id ,
218: fnd_global.conc_login_id
219: )
220: WHEN (NOT EXISTS
221: (SELECT 1 FROM FND_LOOKUP_TYPES
222: WHERE LOOKUP_TYPE = 'ZX_CONDITION_FIELD'

Line 246: fnd_global.user_id ,

242: 'S' ,
243: 0 ,
244: 0 ,
245: SYSDATE ,
246: fnd_global.user_id ,
247: SYSDATE ,
248: fnd_global.user_id ,
249: fnd_global.conc_login_id
250: )

Line 248: fnd_global.user_id ,

244: 0 ,
245: SYSDATE ,
246: fnd_global.user_id ,
247: SYSDATE ,
248: fnd_global.user_id ,
249: fnd_global.conc_login_id
250: )
251: WHEN (NOT EXISTS
252: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 249: fnd_global.conc_login_id

245: SYSDATE ,
246: fnd_global.user_id ,
247: SYSDATE ,
248: fnd_global.user_id ,
249: fnd_global.conc_login_id
250: )
251: WHEN (NOT EXISTS
252: (SELECT 1 FROM FND_LOOKUP_TYPES
253: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ENTITY'

Line 277: fnd_global.user_id ,

273: 'S' ,
274: 0 ,
275: 0 ,
276: SYSDATE ,
277: fnd_global.user_id ,
278: SYSDATE ,
279: fnd_global.user_id ,
280: fnd_global.conc_login_id
281: )

Line 279: fnd_global.user_id ,

275: 0 ,
276: SYSDATE ,
277: fnd_global.user_id ,
278: SYSDATE ,
279: fnd_global.user_id ,
280: fnd_global.conc_login_id
281: )
282: WHEN (NOT EXISTS
283: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 280: fnd_global.conc_login_id

276: SYSDATE ,
277: fnd_global.user_id ,
278: SYSDATE ,
279: fnd_global.user_id ,
280: fnd_global.conc_login_id
281: )
282: WHEN (NOT EXISTS
283: (SELECT 1 FROM FND_LOOKUP_TYPES
284: WHERE LOOKUP_TYPE = 'ZX_CONDITION_CLAUSE'

Line 308: fnd_global.user_id ,

304: 'S' ,
305: 0 ,
306: 0 ,
307: SYSDATE ,
308: fnd_global.user_id ,
309: SYSDATE ,
310: fnd_global.user_id ,
311: fnd_global.conc_login_id
312: )

Line 310: fnd_global.user_id ,

306: 0 ,
307: SYSDATE ,
308: fnd_global.user_id ,
309: SYSDATE ,
310: fnd_global.user_id ,
311: fnd_global.conc_login_id
312: )
313: WHEN (NOT EXISTS
314: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 311: fnd_global.conc_login_id

307: SYSDATE ,
308: fnd_global.user_id ,
309: SYSDATE ,
310: fnd_global.user_id ,
311: fnd_global.conc_login_id
312: )
313: WHEN (NOT EXISTS
314: (SELECT 1 FROM FND_LOOKUP_TYPES
315: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_TYPE'

Line 339: fnd_global.user_id ,

335: 'S' ,
336: 0 ,
337: 0 ,
338: SYSDATE ,
339: fnd_global.user_id ,
340: SYSDATE ,
341: fnd_global.user_id ,
342: fnd_global.conc_login_id
343: )

Line 341: fnd_global.user_id ,

337: 0 ,
338: SYSDATE ,
339: fnd_global.user_id ,
340: SYSDATE ,
341: fnd_global.user_id ,
342: fnd_global.conc_login_id
343: )
344: WHEN (NOT EXISTS
345: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 342: fnd_global.conc_login_id

338: SYSDATE ,
339: fnd_global.user_id ,
340: SYSDATE ,
341: fnd_global.user_id ,
342: fnd_global.conc_login_id
343: )
344: WHEN (NOT EXISTS
345: (SELECT 1 FROM FND_LOOKUP_TYPES
346: WHERE LOOKUP_TYPE = 'ZX_CONDITION_ACTION_CODE'

Line 370: fnd_global.user_id ,

366: 'S' ,
367: 0 ,
368: 0 ,
369: SYSDATE ,
370: fnd_global.user_id ,
371: SYSDATE ,
372: fnd_global.user_id ,
373: fnd_global.conc_login_id
374: )

Line 372: fnd_global.user_id ,

368: 0 ,
369: SYSDATE ,
370: fnd_global.user_id ,
371: SYSDATE ,
372: fnd_global.user_id ,
373: fnd_global.conc_login_id
374: )
375: WHEN (NOT EXISTS
376: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 373: fnd_global.conc_login_id

369: SYSDATE ,
370: fnd_global.user_id ,
371: SYSDATE ,
372: fnd_global.user_id ,
373: fnd_global.conc_login_id
374: )
375: WHEN (NOT EXISTS
376: (SELECT 1 FROM FND_LOOKUP_TYPES
377: WHERE LOOKUP_TYPE = 'ZX_CONDITION_VALUE'

Line 401: fnd_global.user_id ,

397: 'E' ,
398: 0 ,
399: 0 ,
400: SYSDATE ,
401: fnd_global.user_id ,
402: SYSDATE ,
403: fnd_global.user_id ,
404: fnd_global.conc_login_id
405: )

Line 403: fnd_global.user_id ,

399: 0 ,
400: SYSDATE ,
401: fnd_global.user_id ,
402: SYSDATE ,
403: fnd_global.user_id ,
404: fnd_global.conc_login_id
405: )
406: WHEN (NOT EXISTS
407: (SELECT 1 FROM FND_LOOKUP_TYPES

Line 404: fnd_global.conc_login_id

400: SYSDATE ,
401: fnd_global.user_id ,
402: SYSDATE ,
403: fnd_global.user_id ,
404: fnd_global.conc_login_id
405: )
406: WHEN (NOT EXISTS
407: (SELECT 1 FROM FND_LOOKUP_TYPES
408: WHERE LOOKUP_TYPE = 'ZX_TAX_CLASSIFICATION'

Line 432: fnd_global.user_id ,

428: 'E' ,
429: 0 ,
430: 0 ,
431: SYSDATE ,
432: fnd_global.user_id ,
433: SYSDATE ,
434: fnd_global.user_id ,
435: fnd_global.conc_login_id
436: )

Line 434: fnd_global.user_id ,

430: 0 ,
431: SYSDATE ,
432: fnd_global.user_id ,
433: SYSDATE ,
434: fnd_global.user_id ,
435: fnd_global.conc_login_id
436: )
437: SELECT 1 FROM DUAL;
438:

Line 435: fnd_global.conc_login_id

431: SYSDATE ,
432: fnd_global.user_id ,
433: SYSDATE ,
434: fnd_global.user_id ,
435: fnd_global.conc_login_id
436: )
437: SELECT 1 FROM DUAL;
438:
439:

Line 467: fnd_global.user_id ,

463: L.LANGUAGE_CODE ,
464: userenv('LANG') ,
465: Initcap(types.lookup_type),--MEANING
466: types.lookup_type,--DESCRIPTION
467: fnd_global.user_id ,
468: SYSDATE ,
469: fnd_global.user_id ,
470: SYSDATE ,
471: fnd_global.conc_login_id

Line 469: fnd_global.user_id ,

465: Initcap(types.lookup_type),--MEANING
466: types.lookup_type,--DESCRIPTION
467: fnd_global.user_id ,
468: SYSDATE ,
469: fnd_global.user_id ,
470: SYSDATE ,
471: fnd_global.conc_login_id
472: FROM FND_LOOKUP_TYPES types,
473: FND_LANGUAGES L

Line 471: fnd_global.conc_login_id

467: fnd_global.user_id ,
468: SYSDATE ,
469: fnd_global.user_id ,
470: SYSDATE ,
471: fnd_global.conc_login_id
472: FROM FND_LOOKUP_TYPES types,
473: FND_LANGUAGES L
474: WHERE L.INSTALLED_FLAG in ('I', 'B')
475: AND types.lookup_type in (

Line 567: fnd_global.user_id ,

563: NULL ,--ATTRIBUTE14
564: NULL ,--ATTRIBUTE15
565: NULL ,--TAG
566: SYSDATE ,
567: fnd_global.user_id ,
568: SYSDATE ,
569: fnd_global.user_id ,
570: fnd_global.conc_login_id
571: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 569: fnd_global.user_id ,

565: NULL ,--TAG
566: SYSDATE ,
567: fnd_global.user_id ,
568: SYSDATE ,
569: fnd_global.user_id ,
570: fnd_global.conc_login_id
571: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
572: WHERE lk.lookup_type = 'TAX_CONDITION_TYPE'
573: AND view_application_id = 222

Line 570: fnd_global.conc_login_id

566: SYSDATE ,
567: fnd_global.user_id ,
568: SYSDATE ,
569: fnd_global.user_id ,
570: fnd_global.conc_login_id
571: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
572: WHERE lk.lookup_type = 'TAX_CONDITION_TYPE'
573: AND view_application_id = 222
574: AND lk.language = 'US'

Line 652: fnd_global.user_id ,

648: NULL ,--ATTRIBUTE14
649: NULL ,--ATTRIBUTE15
650: NULL ,--TAG
651: SYSDATE ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: fnd_global.conc_login_id
656: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 654: fnd_global.user_id ,

650: NULL ,--TAG
651: SYSDATE ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: fnd_global.conc_login_id
656: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
657: WHERE lk.lookup_type = 'TAX_CONDITION_OPERATOR'
658: AND view_application_id = 222

Line 655: fnd_global.conc_login_id

651: SYSDATE ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: fnd_global.conc_login_id
656: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
657: WHERE lk.lookup_type = 'TAX_CONDITION_OPERATOR'
658: AND view_application_id = 222
659: AND lk.language = 'US'

Line 737: fnd_global.user_id ,

733: NULL ,--ATTRIBUTE14
734: NULL ,--ATTRIBUTE15
735: NULL ,--TAG
736: SYSDATE ,
737: fnd_global.user_id ,
738: SYSDATE ,
739: fnd_global.user_id ,
740: fnd_global.conc_login_id
741: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 739: fnd_global.user_id ,

735: NULL ,--TAG
736: SYSDATE ,
737: fnd_global.user_id ,
738: SYSDATE ,
739: fnd_global.user_id ,
740: fnd_global.conc_login_id
741: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
742: WHERE lk.lookup_type = 'TAX_CONDITION_FIELD'
743: AND view_application_id = 222

Line 740: fnd_global.conc_login_id

736: SYSDATE ,
737: fnd_global.user_id ,
738: SYSDATE ,
739: fnd_global.user_id ,
740: fnd_global.conc_login_id
741: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
742: WHERE lk.lookup_type = 'TAX_CONDITION_FIELD'
743: AND view_application_id = 222
744: AND lk.language = 'US'

Line 822: fnd_global.user_id ,

818: NULL ,--ATTRIBUTE14
819: NULL ,--ATTRIBUTE15
820: NULL ,--TAG
821: SYSDATE ,
822: fnd_global.user_id ,
823: SYSDATE ,
824: fnd_global.user_id ,
825: fnd_global.conc_login_id
826: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 824: fnd_global.user_id ,

820: NULL ,--TAG
821: SYSDATE ,
822: fnd_global.user_id ,
823: SYSDATE ,
824: fnd_global.user_id ,
825: fnd_global.conc_login_id
826: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
827: WHERE lk.lookup_type = 'TAX_CONDITION_ENTITY'
828: AND view_application_id = 222

Line 825: fnd_global.conc_login_id

821: SYSDATE ,
822: fnd_global.user_id ,
823: SYSDATE ,
824: fnd_global.user_id ,
825: fnd_global.conc_login_id
826: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
827: WHERE lk.lookup_type = 'TAX_CONDITION_ENTITY'
828: AND view_application_id = 222
829: AND lk.language = 'US'

Line 907: fnd_global.user_id ,

903: NULL ,--ATTRIBUTE14
904: NULL ,--ATTRIBUTE15
905: NULL ,--TAG
906: SYSDATE ,
907: fnd_global.user_id ,
908: SYSDATE ,
909: fnd_global.user_id ,
910: fnd_global.conc_login_id
911: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 909: fnd_global.user_id ,

905: NULL ,--TAG
906: SYSDATE ,
907: fnd_global.user_id ,
908: SYSDATE ,
909: fnd_global.user_id ,
910: fnd_global.conc_login_id
911: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
912: WHERE lk.lookup_type = 'TAX_CONDITION_CLAUSE'
913: AND view_application_id = 222

Line 910: fnd_global.conc_login_id

906: SYSDATE ,
907: fnd_global.user_id ,
908: SYSDATE ,
909: fnd_global.user_id ,
910: fnd_global.conc_login_id
911: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
912: WHERE lk.lookup_type = 'TAX_CONDITION_CLAUSE'
913: AND view_application_id = 222
914: AND lk.language = 'US'

Line 992: fnd_global.user_id ,

988: NULL ,--ATTRIBUTE14
989: NULL ,--ATTRIBUTE15
990: NULL ,--TAG
991: SYSDATE ,
992: fnd_global.user_id ,
993: SYSDATE ,
994: fnd_global.user_id ,
995: fnd_global.conc_login_id
996: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 994: fnd_global.user_id ,

990: NULL ,--TAG
991: SYSDATE ,
992: fnd_global.user_id ,
993: SYSDATE ,
994: fnd_global.user_id ,
995: fnd_global.conc_login_id
996: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
997: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_TYPE'
998: AND view_application_id = 222

Line 995: fnd_global.conc_login_id

991: SYSDATE ,
992: fnd_global.user_id ,
993: SYSDATE ,
994: fnd_global.user_id ,
995: fnd_global.conc_login_id
996: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
997: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_TYPE'
998: AND view_application_id = 222
999: AND lk.language = 'US'

Line 1077: fnd_global.user_id ,

1073: NULL ,--ATTRIBUTE14
1074: NULL ,--ATTRIBUTE15
1075: NULL ,--TAG
1076: SYSDATE ,
1077: fnd_global.user_id ,
1078: SYSDATE ,
1079: fnd_global.user_id ,
1080: fnd_global.conc_login_id
1081: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 1079: fnd_global.user_id ,

1075: NULL ,--TAG
1076: SYSDATE ,
1077: fnd_global.user_id ,
1078: SYSDATE ,
1079: fnd_global.user_id ,
1080: fnd_global.conc_login_id
1081: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1082: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_CODE'
1083: AND view_application_id = 222

Line 1080: fnd_global.conc_login_id

1076: SYSDATE ,
1077: fnd_global.user_id ,
1078: SYSDATE ,
1079: fnd_global.user_id ,
1080: fnd_global.conc_login_id
1081: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1082: WHERE lk.lookup_type = 'TAX_CONDITION_ACTION_CODE'
1083: AND view_application_id = 222
1084: AND lk.language = 'US'

Line 1162: fnd_global.user_id ,

1158: NULL ,--ATTRIBUTE14
1159: NULL ,--ATTRIBUTE15
1160: NULL ,--TAG
1161: SYSDATE ,
1162: fnd_global.user_id ,
1163: SYSDATE ,
1164: fnd_global.user_id ,
1165: fnd_global.conc_login_id
1166: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 1164: fnd_global.user_id ,

1160: NULL ,--TAG
1161: SYSDATE ,
1162: fnd_global.user_id ,
1163: SYSDATE ,
1164: fnd_global.user_id ,
1165: fnd_global.conc_login_id
1166: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1167: WHERE lk.lookup_type = 'TAX_CONDITION_VALUE'
1168: AND view_application_id = 222

Line 1165: fnd_global.conc_login_id

1161: SYSDATE ,
1162: fnd_global.user_id ,
1163: SYSDATE ,
1164: fnd_global.user_id ,
1165: fnd_global.conc_login_id
1166: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1167: WHERE lk.lookup_type = 'TAX_CONDITION_VALUE'
1168: AND view_application_id = 222
1169: AND lk.language = 'US'

Line 1247: fnd_global.user_id ,

1243: NULL ,--ATTRIBUTE14
1244: NULL ,--ATTRIBUTE15
1245: NULL ,--TAG
1246: SYSDATE ,
1247: fnd_global.user_id ,
1248: SYSDATE ,
1249: fnd_global.user_id ,
1250: fnd_global.conc_login_id
1251: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l

Line 1249: fnd_global.user_id ,

1245: NULL ,--TAG
1246: SYSDATE ,
1247: fnd_global.user_id ,
1248: SYSDATE ,
1249: fnd_global.user_id ,
1250: fnd_global.conc_login_id
1251: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1252: WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
1253: AND view_application_id = 222

Line 1250: fnd_global.conc_login_id

1246: SYSDATE ,
1247: fnd_global.user_id ,
1248: SYSDATE ,
1249: fnd_global.user_id ,
1250: fnd_global.conc_login_id
1251: FROM FND_LOOKUP_VALUES lk, FND_LANGUAGES l
1252: WHERE lk.lookup_type = 'AR_TAX_CLASSIFICATION'
1253: AND view_application_id = 222
1254: AND lk.language = 'US'