JE_RU_FA_ASSET_LE

Details

Schema: FUSION
Object owner: FUSION
Object type: VIEW

Columns

Name
BOOK_TYPE_CODE ASSET_ID LEGAL_ENTITY_ID

Name

BOOK_TYPE_CODE

ASSET_ID

LEGAL_ENTITY_ID

Query

SQL_Statement
SELECT BC.BOOK_TYPE_CODE, DH.ASSET_ID, LEBSV.LEGAL_ENTITY_ID FROM FA_BOOK_CONTROLS BC, GL_LEDGERS GL, FND_KF_SEGMENT_INSTANCES SGI, FND_KF_SEGMENT_LABELS_B SLB, FND_KF_STR_INSTANCES_B SIB, FND_KF_SEGMENTS_B SGB, FND_KF_LABELED_SEGMENTS LS, FA_DISTRIBUTION_HISTORY DH, GL_CODE_COMBINATIONS GCC, GL_LEGAL_ENTITIES_BSVS LEBSV WHERE BC.SET_OF_BOOKS_ID = GL.LEDGER_ID AND SIB.STRUCTURE_INSTANCE_ID = SGI.STRUCTURE_INSTANCE_ID AND SGB.STRUCTURE_ID = SIB.STRUCTURE_ID AND SGB.SEGMENT_CODE = SGI.SEGMENT_CODE AND SLB.APPLICATION_ID = SIB.APPLICATION_ID AND SLB.KEY_FLEXFIELD_CODE = SIB.KEY_FLEXFIELD_CODE AND LS.STRUCTURE_ID = SGB.STRUCTURE_ID AND LS.SEGMENT_CODE = SGB.SEGMENT_CODE AND LS.SEGMENT_LABEL_CODE = SLB.SEGMENT_LABEL_CODE AND SIB.KEY_FLEXFIELD_CODE = 'GL#' AND SIB.APPLICATION_ID = 101 AND SIB.STRUCTURE_INSTANCE_NUMBER = GL.CHART_OF_ACCOUNTS_ID AND LS.SEGMENT_LABEL_CODE = 'GL_BALANCING' AND DH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND DH.TRANSACTION_HEADER_ID_OUT IS NULL AND GCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID AND LEBSV.FLEX_VALUE_SET_ID = SGI.VALUE_SET_ID AND LEBSV.FLEX_SEGMENT_VALUE = DECODE(UPPER(SGB.COLUMN_NAME), 'SEGMENT1',GCC.SEGMENT1,'SEGMENT2',GCC.SEGMENT2,'SEGMENT3',GCC.SEGMENT3,'SEGMENT4',GCC.SEGMENT4,'SEGMENT5',GCC.SEGMENT5, 'SEGMENT6',GCC.SEGMENT6,'SEGMENT7',GCC.SEGMENT7,'SEGMENT8',GCC.SEGMENT8,'SEGMENT9',GCC.SEGMENT9,'SEGMENT10',GCC.SEGMENT10, 'SEGMENT11',GCC.SEGMENT11,'SEGMENT12',GCC.SEGMENT12,'SEGMENT13',GCC.SEGMENT13,'SEGMENT14',GCC.SEGMENT14,'SEGMENT15',GCC.SEGMENT15)

SQL_Statement

SELECT

BC.BOOK_TYPE_CODE,

DH.ASSET_ID,

LEBSV.LEGAL_ENTITY_ID

FROM

FA_BOOK_CONTROLS BC,

GL_LEDGERS GL,

FND_KF_SEGMENT_INSTANCES SGI,

FND_KF_SEGMENT_LABELS_B SLB,

FND_KF_STR_INSTANCES_B SIB,

FND_KF_SEGMENTS_B SGB,

FND_KF_LABELED_SEGMENTS LS,

FA_DISTRIBUTION_HISTORY DH,

GL_CODE_COMBINATIONS GCC,

GL_LEGAL_ENTITIES_BSVS LEBSV

WHERE BC.SET_OF_BOOKS_ID = GL.LEDGER_ID

AND SIB.STRUCTURE_INSTANCE_ID = SGI.STRUCTURE_INSTANCE_ID

AND SGB.STRUCTURE_ID = SIB.STRUCTURE_ID

AND SGB.SEGMENT_CODE = SGI.SEGMENT_CODE

AND SLB.APPLICATION_ID = SIB.APPLICATION_ID

AND SLB.KEY_FLEXFIELD_CODE = SIB.KEY_FLEXFIELD_CODE

AND LS.STRUCTURE_ID = SGB.STRUCTURE_ID

AND LS.SEGMENT_CODE = SGB.SEGMENT_CODE

AND LS.SEGMENT_LABEL_CODE = SLB.SEGMENT_LABEL_CODE

AND SIB.KEY_FLEXFIELD_CODE = 'GL#'

AND SIB.APPLICATION_ID = 101

AND SIB.STRUCTURE_INSTANCE_NUMBER = GL.CHART_OF_ACCOUNTS_ID

AND LS.SEGMENT_LABEL_CODE = 'GL_BALANCING'

AND DH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE

AND DH.TRANSACTION_HEADER_ID_OUT IS NULL

AND GCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID

AND LEBSV.FLEX_VALUE_SET_ID = SGI.VALUE_SET_ID

AND LEBSV.FLEX_SEGMENT_VALUE = DECODE(UPPER(SGB.COLUMN_NAME),

'SEGMENT1',GCC.SEGMENT1,'SEGMENT2',GCC.SEGMENT2,'SEGMENT3',GCC.SEGMENT3,'SEGMENT4',GCC.SEGMENT4,'SEGMENT5',GCC.SEGMENT5,

'SEGMENT6',GCC.SEGMENT6,'SEGMENT7',GCC.SEGMENT7,'SEGMENT8',GCC.SEGMENT8,'SEGMENT9',GCC.SEGMENT9,'SEGMENT10',GCC.SEGMENT10,

'SEGMENT11',GCC.SEGMENT11,'SEGMENT12',GCC.SEGMENT12,'SEGMENT13',GCC.SEGMENT13,'SEGMENT14',GCC.SEGMENT14,'SEGMENT15',GCC.SEGMENT15)