eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_MIGRATE_REP_ENTITIES_PKG dependencies on FND_LANGUAGES

Line 668: FND_LANGUAGES L

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
672: AND TYPES.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'

Line 751: FND_LANGUAGES L

747: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME -- Bug 4886324
748:
749: FROM
750: ZX_REPORTING_TYPES_B TYPES,
751: FND_LANGUAGES L
752: WHERE
753: TYPES.RECORD_TYPE_CODE = 'MIGRATED'
754: AND L.INSTALLED_FLAG in ('I', 'B')
755: ) TYPES

Line 792: FND_LANGUAGES L

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
796: AND TYPES.REPORTING_TYPE_CODE = 'AR_DGI_TRX_CODE'

Line 847: FND_LANGUAGES L

843: SYSDATE ,
844: fnd_global.conc_login_id
845: FROM
846: ZX_REPORTING_CODES_B CODES,
847: FND_LANGUAGES L
848:
849: WHERE
850: CODES.RECORD_TYPE_CODE = 'MIGRATED'
851: AND L.INSTALLED_FLAG in ('I', 'B')

Line 1160: FND_LANGUAGES L

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
1164: AND TYPES.REPORTING_TYPE_CODE = p_reporting_type_code

Line 2668: AND codes.LANGUAGE = (select nvl(language_code,'US') from FND_LANGUAGES where installed_flag = 'B' )

2664: codes.vat_tax_id = Nvl(rates.source_id,rates.tax_rate_id)
2665: AND rates.record_type_code = 'MIGRATED'
2666: AND report_types.tax_regime_code = rates.tax_regime_code
2667: AND codes.printed_tax_name = report_codes.REPORTING_CODE_CHAR_VALUE
2668: AND codes.LANGUAGE = (select nvl(language_code,'US') from FND_LANGUAGES where installed_flag = 'B' )
2669: AND report_types.reporting_type_id = report_codes.reporting_type_id
2670: AND report_types.REPORTING_TYPE_CODE= 'PRINTED_TAX_RATE_NAME'
2671: AND report_codes.record_type_code = 'MIGRATED'
2672:

Line 4793: select nvl(language_code,'US') into l_language_code from FND_LANGUAGES where installed_flag = 'B' ;

4789: declare
4790: l_language_code varchar2(30);
4791: l_seqid number;
4792: begin
4793: select nvl(language_code,'US') into l_language_code from FND_LANGUAGES where installed_flag = 'B' ;
4794:
4795:
4796: for cursor_rec in
4797: (select vat_tax_id from ar_vat_tax_all_b )

Line 5255: FND_LANGUAGES L

5251: THEN 'Korean Business Locations'
5252: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME -- Bug 4886324
5253: FROM
5254: ZX_REPORTING_TYPES_B TYPES,
5255: FND_LANGUAGES L
5256: WHERE
5257:
5258: TYPES.RECORD_TYPE_CODE = 'MIGRATED'
5259: AND L.INSTALLED_FLAG in ('I', 'B')

Line 5410: FND_LANGUAGES L

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'
5414: AND lookups.LOOKUP_TYPE = 'JLCL_TAX_CODE_CLASS'

Line 5458: FND_LANGUAGES L

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'
5462: AND lookups.LOOKUP_TYPE = 'JLZZ_AR_TO_JURISDICTION_CODE'

Line 5572: FND_LANGUAGES L

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
5576: AND TYPES.REPORTING_TYPE_CODE = 'KR_LOCATION'

Line 6228: FND_LANGUAGES L

6224: ELSE types.REPORTING_TYPE_CODE END REPORTING_TYPE_NAME
6225:
6226: FROM
6227: ZX_REPORTING_TYPES_B TYPES,
6228: FND_LANGUAGES L
6229: WHERE
6230: TYPES.RECORD_TYPE_CODE = 'SEEDED'
6231: AND L.INSTALLED_FLAG in ('I', 'B')
6232: ) TYPES

Line 6372: FND_LANGUAGES L

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
6376: AND TYPES.REPORTING_TYPE_CODE = p_reporting_type_code

Line 6635: FND_LANGUAGES L

6631: SYSDATE ,
6632: 0
6633: FROM
6634: ZX_REPORTING_CODES_B CODES,
6635: FND_LANGUAGES L
6636: WHERE
6637: CODES.RECORD_TYPE_CODE = 'SEEDED'
6638: AND codes.reporting_type_id = ( SELECT reporting_type_id FROM ZX_REPORTING_TYPES_B
6639: WHERE REPORTING_TYPE_CODE = 'PT_LOCATION' AND record_type_code = 'SEEDED' )

Line 6792: FND_LANGUAGES L

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
6796: AND TYPES.REPORTING_TYPE_CODE = 'TW_GOVERNMENT_TAX_TYPE'

Line 7073: FND_LANGUAGES L

7069: TYPES.REPORTING_TYPE_ID ,
7070: L.LANGUAGE_CODE
7071: FROM
7072: ZX_REPORTING_TYPES_B TYPES,
7073: FND_LANGUAGES L
7074: WHERE TYPES.RECORD_TYPE_CODE = 'MIGRATED'
7075: AND TYPES.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'
7076: AND L.INSTALLED_FLAG in ('I', 'B')
7077: ) TYPES

Line 7275: FND_LANGUAGES L

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
7279: AND TYPES.REPORTING_TYPE_CODE = 'EMEA_VAT_REPORTING_TYPE'

Line 7587: FND_LANGUAGES L

7583: TYPES.REPORTING_TYPE_ID ,
7584: L.LANGUAGE_CODE
7585: FROM
7586: ZX_REPORTING_TYPES_B TYPES,
7587: FND_LANGUAGES L
7588: WHERE TYPES.RECORD_TYPE_CODE = 'MIGRATED'
7589: AND TYPES.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'
7590: AND L.INSTALLED_FLAG in ('I', 'B')
7591: ) TYPES

Line 7731: FND_LANGUAGES L

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
7735: AND TYPES.REPORTING_TYPE_CODE = 'REVERSE_CHARGE_VAT'

Line 8009: FND_LANGUAGES L

8005: FROM ( SELECT TYPES.REPORTING_TYPE_ID ,
8006: L.LANGUAGE_CODE,
8007: TYPES.REPORTING_TYPE_CODE
8008: FROM ZX_REPORTING_TYPES_B TYPES,
8009: FND_LANGUAGES L
8010: WHERE TYPES.RECORD_TYPE_CODE = 'MIGRATED'
8011: AND TYPES.REPORTING_TYPE_CODE in ('ZX_INTRA_EU_TRX_TYPE',
8012: 'ZX_LGL_JUSTIFICATN_MSG_TYPE')
8013: AND L.INSTALLED_FLAG IN ('I',

Line 8205: FND_LANGUAGES L

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')
8209: AND lookups.LOOKUP_TYPE = decode(types.REPORTING_TYPE_CODE,