663: fnd_global.conc_login_id
664: FROM
665: ZX_REPORTING_TYPES_B TYPES,
666: ZX_REPORTING_CODES_B CODES,
667: FND_LOOKUP_VALUES lookups,
668: FND_LANGUAGES L
669: WHERE
670:
671: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
787: fnd_global.conc_login_id
788: FROM
789: ZX_REPORTING_TYPES_B TYPES,
790: ZX_REPORTING_CODES_B CODES,
791: FND_LOOKUP_VALUES lookups,
792: FND_LANGUAGES L
793: WHERE
794:
795: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
1155: fnd_global.conc_login_id
1156: FROM
1157: ZX_REPORTING_TYPES_B TYPES,
1158: ZX_REPORTING_CODES_B CODES,
1159: FND_LOOKUP_VALUES lookups,
1160: FND_LANGUAGES L
1161: WHERE
1162:
1163: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5405: fnd_global.conc_login_id
5406: FROM
5407: ZX_REPORTING_TYPES_B TYPES,
5408: ZX_REPORTING_CODES_B CODES,
5409: FND_LOOKUP_VALUES lookups,
5410: FND_LANGUAGES L
5411: WHERE
5412: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5413: AND TYPES.REPORTING_TYPE_CODE = 'CL_TAX_CODE_CLASSIF'
5453: fnd_global.conc_login_id
5454: FROM
5455: ZX_REPORTING_TYPES_B TYPES,
5456: ZX_REPORTING_CODES_B CODES,
5457: FND_LOOKUP_VALUES lookups,
5458: FND_LANGUAGES L
5459: WHERE
5460: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
5461: AND TYPES.REPORTING_TYPE_CODE = 'AR_TURN_OVER_JUR_CODE'
5567: fnd_global.conc_login_id
5568: FROM
5569: ZX_REPORTING_TYPES_B TYPES,
5570: ZX_REPORTING_CODES_B CODES,
5571: FND_LOOKUP_VALUES lookups,
5572: FND_LANGUAGES L
5573: WHERE
5574:
5575: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
6367: 0
6368: FROM
6369: ZX_REPORTING_TYPES_B TYPES,
6370: ZX_REPORTING_CODES_B CODES,
6371: FND_LOOKUP_VALUES lookups,
6372: FND_LANGUAGES L
6373: WHERE
6374:
6375: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
6787: 0
6788: FROM
6789: ZX_REPORTING_TYPES_B TYPES,
6790: ZX_REPORTING_CODES_B CODES,
6791: FND_LOOKUP_VALUES lookups,
6792: FND_LANGUAGES L
6793: WHERE
6794:
6795: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
7270: fnd_global.conc_login_id
7271: FROM
7272: ZX_REPORTING_TYPES_B TYPES,
7273: ZX_REPORTING_CODES_B CODES,
7274: FND_LOOKUP_VALUES lookups,
7275: FND_LANGUAGES L
7276: WHERE
7277:
7278: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
7726: fnd_global.conc_login_id
7727: FROM
7728: ZX_REPORTING_TYPES_B TYPES,
7729: ZX_REPORTING_CODES_B CODES,
7730: FND_LOOKUP_VALUES lookups,
7731: FND_LANGUAGES L
7732: WHERE
7733:
7734: TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
8200: SYSDATE ,
8201: fnd_global.conc_login_id
8202: FROM ZX_REPORTING_TYPES_B TYPES,
8203: ZX_REPORTING_CODES_B CODES,
8204: FND_LOOKUP_VALUES lookups ,
8205: FND_LANGUAGES L
8206: WHERE TYPES.REPORTING_TYPE_ID = CODES.REPORTING_TYPE_ID
8207: AND TYPES.REPORTING_TYPE_CODE in ('ZX_INTRA_EU_TRX_TYPE',
8208: 'ZX_LGL_JUSTIFICATN_MSG_TYPE')