View: JA_CN_CFS_ITEM_MAPPING_HDRS_V

Product:	FND - Application Object Library
Description:
Implementation/DBA Data:	APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V

View Text

SELECT CIM.MAPPING_HEADER_ID MAPPING_HEADER_ID
, CIM.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, CIM.APPLICATION_ID APPLICATION_ID
, APP.APPLICATION_NAME APPLICATION_NAME
, --EV.NAME EVENT_CLASS
, CIM.EVENT_CLASS_CODE EVENT_CLASS
, CIM.EVENT_CLASS_CODE EVENT_CLASS_CODE
, AH.NAME ANALYTICAL_CRITERION
, CIM.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, CIM.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, CIM.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, --SUR.SOURCE_CODE SOURCE_CODE
, /*B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VIEW_APPLICATION_ID LOOKUP_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, */ CIM.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CIM.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CIM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CIM.LAST_UPDATE_BY LAST_UPDATE_BY
, CIM.CREATION_DATE CREATION_DATE
, CIM.CREATED_BY CREATED_BY
, CIM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JA_CN_CFS_ITEM_MAPPING_HDRS CIM
, XLA_ANALYTICAL_HDRS_TL AH
, XLA_ANALYTICAL_DTLS_TL AD
, XLA_ANALYTICAL_DTLS_B ADL
, --XLA_ANALYTICAL_SOURCES SUR
, --XLA_SOURCES_B B
, --XLA_EVENT_CLASSES_TL EV
, FND_APPLICATION_TL APP
WHERE CIM.ANALYTICAL_CRITERION_CODE IN ( SELECT ANALYTICAL_CRITERION_CODE
FROM XLA_ANALYTICAL_SOURCES XAS
WHERE CIM.APPLICATION_ID = XAS.SOURCE_APPLICATION_ID
AND CIM.APPLICATION_ID = XAS.APPLICATION_ID
AND CIM.AMB_CONTEXT_CODE = XAS.AMB_CONTEXT_CODE
AND CIM.ANALYTICAL_CRITERION_TYPE_CODE = XAS.ANALYTICAL_CRITERION_TYPE_CODE
AND CIM.ANALYTICAL_CRITERION_CODE = XAS.ANALYTICAL_CRITERION_CODE ) --CIM.APPLICATION_ID = SUR.SOURCE_APPLICATION_ID
AND CIM.AMB_CONTEXT_CODE = AH.AMB_CONTEXT_CODE
AND CIM.ANALYTICAL_CRITERION_CODE = AH.ANALYTICAL_CRITERION_CODE
AND CIM.ANALYTICAL_CRITERION_TYPE_CODE = AH.ANALYTICAL_CRITERION_TYPE_CODE
AND AH.AMB_CONTEXT_CODE = AD.AMB_CONTEXT_CODE
AND AH.ANALYTICAL_CRITERION_CODE = AD.ANALYTICAL_CRITERION_CODE
AND AH.ANALYTICAL_CRITERION_TYPE_CODE = AD.ANALYTICAL_CRITERION_TYPE_CODE
AND AH.AMB_CONTEXT_CODE = ADL.AMB_CONTEXT_CODE
AND AH.ANALYTICAL_CRITERION_CODE = ADL.ANALYTICAL_CRITERION_CODE
AND AH.ANALYTICAL_CRITERION_TYPE_CODE = ADL.ANALYTICAL_CRITERION_TYPE_CODE
AND ADL.GROUPING_ORDER = 1
AND ADL.ANALYTICAL_DETAIL_CODE = AD.ANALYTICAL_DETAIL_CODE --AND AH.ANALYTICAL_CRITERION_CODE = SUR.ANALYTICAL_CRITERION_CODE --AND AH.AMB_CONTEXT_CODE = SUR.AMB_CONTEXT_CODE --AND AH.ANALYTICAL_CRITERION_TYPE_CODE = SUR.ANALYTICAL_CRITERION_TYPE_CODE --AND AD.ANALYTICAL_DETAIL_CODE = SUR.ANALYTICAL_DETAIL_CODE --AND CIM.APPLICATION_ID = SUR.APPLICATION_ID
AND APP.APPLICATION_ID = CIM.APPLICATION_ID --AND B.APPLICATION_ID = APP.APPLICATION_ID --AND B.SOURCE_CODE = SUR.SOURCE_CODE --AND B.SOURCE_TYPE_CODE = SUR.SOURCE_TYPE_CODE --AND SUR.APPLICATION_ID = EV.APPLICATION_ID --AND SUR.ENTITY_CODE = EV.ENTITY_CODE --AND SUR.EVENT_CLASS_CODE = EV.EVENT_CLASS_CODE --AND EV.EVENT_CLASS_CODE = CIM.EVENT_CLASS_CODE
AND APP.LANGUAGE = USERENV('LANG') --AND EV.LANGUAGE = USERENV('LANG')
AND AH.LANGUAGE = USERENV('LANG')
AND AD.LANGUAGE = USERENV('LANG') --| HISTORY | --| 27/11/2010 CHUANLING SHAO MODIFIED FIX BUG # 9608568 --| --| --+======================================================================*/ /* SELECT CIM.MAPPING_HEADER_ID MAPPING_HEADER_ID
, CIM.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, CIM.APPLICATION_ID APPLICATION_ID
, APP.APPLICATION_NAME APPLICATION_NAME
, EV.NAME EVENT_CLASS
, CIM.EVENT_CLASS_CODE EVENT_CLASS_CODE
, AH.NAME ANALYTICAL_CRITERION
, CIM.ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_CODE
, CIM.AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, CIM.ANALYTICAL_CRITERION_TYPE_CODE ANALYTICAL_CRITERION_TYPE_CODE
, SUR.SOURCE_CODE SOURCE_CODE
, B.SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, B.FLEX_VALUE_SET_ID FLEX_VALUE_SET_ID
, B.VIEW_APPLICATION_ID LOOKUP_APPLICATION_ID
, B.LOOKUP_TYPE LOOKUP_TYPE
, B.KEY_FLEXFIELD_FLAG KEY_FLEXFIELD_FLAG
, B.SEGMENT_CODE SEGMENT_CODE
, B.FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, B.ID_FLEX_CODE ID_FLEX_CODE
, CIM.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CIM.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CIM.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CIM.LAST_UPDATE_BY LAST_UPDATE_BY
, CIM.CREATION_DATE CREATION_DATE
, CIM.CREATED_BY CREATED_BY
, CIM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM JA_CN_CFS_ITEM_MAPPING_HDRS CIM
, XLA_ANALYTICAL_HDRS_TL AH
, XLA_ANALYTICAL_DTLS_TL AD
, XLA_ANALYTICAL_DTLS_B ADL
, XLA_ANALYTICAL_SOURCES SUR
, XLA_SOURCES_B B
, XLA_EVENT_CLASSES_TL EV
, FND_APPLICATION_TL APP
WHERE CIM.APPLICATION_ID = SUR.SOURCE_APPLICATION_ID
AND CIM.AMB_CONTEXT_CODE = AH.AMB_CONTEXT_CODE
AND CIM.ANALYTICAL_CRITERION_CODE = AH.ANALYTICAL_CRITERION_CODE
AND CIM.ANALYTICAL_CRITERION_TYPE_CODE = AH.ANALYTICAL_CRITERION_TYPE_CODE
AND AH.AMB_CONTEXT_CODE = AD.AMB_CONTEXT_CODE
AND AH.ANALYTICAL_CRITERION_CODE = AD.ANALYTICAL_CRITERION_CODE
AND AH.ANALYTICAL_CRITERION_TYPE_CODE = AD.ANALYTICAL_CRITERION_TYPE_CODE
AND AH.AMB_CONTEXT_CODE = ADL.AMB_CONTEXT_CODE
AND AH.ANALYTICAL_CRITERION_CODE = ADL.ANALYTICAL_CRITERION_CODE
AND AH.ANALYTICAL_CRITERION_TYPE_CODE = ADL.ANALYTICAL_CRITERION_TYPE_CODE
AND ADL.GROUPING_ORDER = 1
AND ADL.ANALYTICAL_DETAIL_CODE = AD.ANALYTICAL_DETAIL_CODE
AND AH.ANALYTICAL_CRITERION_CODE = SUR.ANALYTICAL_CRITERION_CODE
AND AH.AMB_CONTEXT_CODE = SUR.AMB_CONTEXT_CODE
AND AH.ANALYTICAL_CRITERION_TYPE_CODE = SUR.ANALYTICAL_CRITERION_TYPE_CODE
AND AD.ANALYTICAL_DETAIL_CODE = SUR.ANALYTICAL_DETAIL_CODE
AND CIM.APPLICATION_ID = SUR.APPLICATION_ID
AND APP.APPLICATION_ID = CIM.APPLICATION_ID
AND B.APPLICATION_ID = APP.APPLICATION_ID
AND B.SOURCE_CODE = SUR.SOURCE_CODE
AND B.SOURCE_TYPE_CODE = SUR.SOURCE_TYPE_CODE
AND SUR.APPLICATION_ID = EV.APPLICATION_ID
AND SUR.ENTITY_CODE = EV.ENTITY_CODE
AND SUR.EVENT_CLASS_CODE = EV.EVENT_CLASS_CODE
AND EV.EVENT_CLASS_CODE = CIM.EVENT_CLASS_CODE
AND APP.LANGUAGE = USERENV('LANG')
AND EV.LANGUAGE = USERENV('LANG')
AND AH.LANGUAGE = USERENV('LANG')
AND AD.LANGUAGE = USERENV('LANG') */