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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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
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'
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: )
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:
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:
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
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
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 (
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
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
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'
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
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
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'
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
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
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'
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
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
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'
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
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
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'
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
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
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'
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
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
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'
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
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
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'
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
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
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'