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.

[Home] [Help]

APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_FC_CODES_DENORM_B

Line 2035: FROM ZX_FC_CODES_DENORM_B

2031: IF P_LOOKUP_TYPE = 'JATW_GUI_TYPE' then
2032: BEGIN
2033: SELECT CLASSIFICATION_NAME
2034: INTO x_lookup_meaning
2035: FROM ZX_FC_CODES_DENORM_B
2036: WHERE CLASSIFICATION_TYPE_CODE = 'DOCUMENT_SUBTYPE' and
2037: -- CLASSIFICATION_CODE_LEVEL = 2 and --Bug5453806
2038: CONCAT_CLASSIF_CODE = P_LOOKUP_CODE
2039: AND LANGUAGE = userenv('LANG') --Bug 5453957

Line 2065: FROM ZX_FC_CODES_DENORM_B

2061: ELSIF P_LOOKUP_TYPE = 'JATW_DEDUCTIBLE_TYPE' then
2062: BEGIN
2063: SELECT CLASSIFICATION_NAME
2064: INTO x_lookup_meaning
2065: FROM ZX_FC_CODES_DENORM_B
2066: WHERE CLASSIFICATION_TYPE_CODE = 'TRX_BUSINESS_CATEGORY' and
2067: -- CLASSIFICATION_CODE_LEVEL = 3 and --Bug5453806
2068: CONCAT_CLASSIF_CODE = P_LOOKUP_CODE
2069: AND LANGUAGE = userenv('LANG') --Bug 5453957