VIEW: APPS.GL_COA_MAPPINGS_V

Source

View Text - Preformatted

SELECT map.rowid ROW_ID, map.coa_mapping_id MAPPING_ID, map.name NAME, map.last_update_date LAST_UPDATE_DATE, map.last_updated_by LAST_UPDATED_BY, from_coa.id_flex_structure_name FROM_CHART_OF_ACCOUNTS_NAME, from_coa.id_flex_num FROM_CHART_OF_ACCOUNTS_ID, to_coa.id_flex_structure_name TO_CHART_OF_ACCOUNTS_NAME, to_coa.id_flex_num TO_CHART_OF_ACCOUNTS_ID, map.creation_date CREATION_DATE, map.created_by CREATED_BY, map.last_update_login LAST_UPDATE_LOGIN, map.description DESCRIPTION, map.start_date_active START_DATE_ACTIVE, map.end_date_active END_DATE_ACTIVE, map.security_flag SECURITY_FLAG, decode(map.security_flag, 'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_COA_MAPPING_V', 'GL_DAS_COA_MAPPING', to_char(map.coa_mapping_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE, decode(map.security_flag, 'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_COA_MAPPING_U', 'GL_DAS_COA_MAPPING', to_char(map.coa_mapping_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') USE_PRIVILEGE, decode(map.security_flag, 'Y', decode(fnd_data_security.check_function(1.0, 'GL_DAS_COA_MAPPING_M', 'GL_DAS_COA_MAPPING', to_char(map.coa_mapping_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') MODIFY_PRIVILEGE FROM gl_coa_mappings map, fnd_id_flex_structures_v from_coa, fnd_id_flex_structures_v to_coa WHERE map.from_coa_id = from_coa.id_flex_num AND map.to_coa_id = to_coa.id_flex_num AND from_coa.application_id = 101 AND from_coa.id_flex_code = 'GL#' AND to_coa.application_id = 101 AND to_coa.id_flex_code = 'GL#'

View Text - HTML Formatted

SELECT MAP.ROWID ROW_ID
, MAP.COA_MAPPING_ID MAPPING_ID
, MAP.NAME NAME
, MAP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAP.LAST_UPDATED_BY LAST_UPDATED_BY
, FROM_COA.ID_FLEX_STRUCTURE_NAME FROM_CHART_OF_ACCOUNTS_NAME
, FROM_COA.ID_FLEX_NUM FROM_CHART_OF_ACCOUNTS_ID
, TO_COA.ID_FLEX_STRUCTURE_NAME TO_CHART_OF_ACCOUNTS_NAME
, TO_COA.ID_FLEX_NUM TO_CHART_OF_ACCOUNTS_ID
, MAP.CREATION_DATE CREATION_DATE
, MAP.CREATED_BY CREATED_BY
, MAP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MAP.DESCRIPTION DESCRIPTION
, MAP.START_DATE_ACTIVE START_DATE_ACTIVE
, MAP.END_DATE_ACTIVE END_DATE_ACTIVE
, MAP.SECURITY_FLAG SECURITY_FLAG
, DECODE(MAP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_COA_MAPPING_V'
, 'GL_DAS_COA_MAPPING'
, TO_CHAR(MAP.COA_MAPPING_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(MAP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_COA_MAPPING_U'
, 'GL_DAS_COA_MAPPING'
, TO_CHAR(MAP.COA_MAPPING_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(MAP.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_COA_MAPPING_M'
, 'GL_DAS_COA_MAPPING'
, TO_CHAR(MAP.COA_MAPPING_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_COA_MAPPINGS MAP
, FND_ID_FLEX_STRUCTURES_V FROM_COA
, FND_ID_FLEX_STRUCTURES_V TO_COA
WHERE MAP.FROM_COA_ID = FROM_COA.ID_FLEX_NUM
AND MAP.TO_COA_ID = TO_COA.ID_FLEX_NUM
AND FROM_COA.APPLICATION_ID = 101
AND FROM_COA.ID_FLEX_CODE = 'GL#'
AND TO_COA.APPLICATION_ID = 101
AND TO_COA.ID_FLEX_CODE = 'GL#'