VIEW: APPS.JA_CN_CFS_ITEM_MAPPING_HDRS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')