eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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,
       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')
*/

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
, 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') */