Product: | FII - Financial Intelligence |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FII_PROD_ASSIGN_TYPE_V |
SELECT DMR.ROWID ROW_ID
, DMR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, DMR.LAST_UPDATED_BY LAST_UPDATED_BY
, DMR.CREATION_DATE CREATION_DATE
, DMR.CREATED_BY CREATED_BY
, DMR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DMR.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, FS.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, DMR.STATUS_CODE STATUS_CODE
, DMR.MAPPING_TYPE_CODE ASSIGNMENT_TYPE_CODE
, DMR.APPLICATION_COLUMN_NAME1 APPLICATION_COLUMN_NAME
, FSEG.SEGMENT_NAME SEGMENT_NAME FROM FII_DIM_MAPPING_RULES DMR
, FND_ID_FLEX_STRUCTURES_VL FS
, FND_ID_FLEX_SEGMENTS_VL FSEG
WHERE DMR.DIMENSION_SHORT_NAME = 'ENI_ITEM_VBH_CAT'
AND FS.ID_FLEX_NUM = DMR.CHART_OF_ACCOUNTS_ID
AND FS.ID_FLEX_CODE = 'GL#'
AND FS.APPLICATION_ID = 101
AND FSEG.APPLICATION_ID(+) = 101
AND FSEG.ID_FLEX_CODE(+) = 'GL#'
AND FSEG.ID_FLEX_NUM(+) = DMR.CHART_OF_ACCOUNTS_ID
AND FSEG.APPLICATION_COLUMN_NAME(+) = DMR.APPLICATION_COLUMN_NAME1