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.

[Home] [Help]

VIEW: XLA.XLA_AMB_UPDATED_COMPS#

Source

View Text - Preformatted


select AMB_UPDATED_COMP_ID AMB_UPDATED_COMP_ID, APPLICATION_ID APPLICATION_ID, AMB_CONTEXT_CODE AMB_CONTEXT_CODE, COMPONENT_TYPE_CODE COMPONENT_TYPE_CODE, COMPONENT_KEY COMPONENT_KEY, ENTITY_CODE ENTITY_CODE, EVENT_CLASS_CODE EVENT_CLASS_CODE, EVENT_TYPE_CODE EVENT_TYPE_CODE, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE, PRODUCT_RULE_CODE PRODUCT_RULE_CODE, ACCT_LINE_TYPE_CODE ACCT_LINE_TYPE_CODE, ACCT_LINE_CODE ACCT_LINE_CODE, COMPONENT_OWNER_CODE COMPONENT_OWNER_CODE, COMPONENT_CODE COMPONENT_CODE, MERGE_IMPACT_CODE MERGE_IMPACT_CODE, PROPERTY_CODE PROPERTY_CODE, LOOKUP_TYPE LOOKUP_TYPE, OLD_VALUE OLD_VALUE, NEW_VALUE NEW_VALUE, PARENT_COMPONENT_TYPE_CODE PARENT_COMPONENT_TYPE_CODE, PARENT_COMPONENT_KEY PARENT_COMPONENT_KEY, MERGE_ENABLED_FLAG MERGE_ENABLED_FLAG, MERGE_FLAG MERGE_FLAG, DUPLICATE_COMPONENT_CODE DUPLICATE_COMPONENT_CODE, DUPLICATE_COMPONENT_NAME DUPLICATE_COMPONENT_NAME, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, PARENT_COMPONENT_OWNER_CODE PARENT_COMPONENT_OWNER_CODE, PARENT_COMPONENT_CODE PARENT_COMPONENT_CODE, OLD_SOURCE_APP_ID OLD_SOURCE_APP_ID, OLD_SOURCE_TYPE_CODE OLD_SOURCE_TYPE_CODE, OLD_SOURCE_CODE OLD_SOURCE_CODE, NEW_SOURCE_APP_ID NEW_SOURCE_APP_ID, NEW_SOURCE_TYPE_CODE NEW_SOURCE_TYPE_CODE, NEW_SOURCE_CODE NEW_SOURCE_CODE, COMPONENT_APPLICATION_ID COMPONENT_APPLICATION_ID from "XLA"."XLA_AMB_UPDATED_COMPS"

View Text - HTML Formatted

SELECT AMB_UPDATED_COMP_ID AMB_UPDATED_COMP_ID
, APPLICATION_ID APPLICATION_ID
, AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, COMPONENT_TYPE_CODE COMPONENT_TYPE_CODE
, COMPONENT_KEY COMPONENT_KEY
, ENTITY_CODE ENTITY_CODE
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, ACCT_LINE_TYPE_CODE ACCT_LINE_TYPE_CODE
, ACCT_LINE_CODE ACCT_LINE_CODE
, COMPONENT_OWNER_CODE COMPONENT_OWNER_CODE
, COMPONENT_CODE COMPONENT_CODE
, MERGE_IMPACT_CODE MERGE_IMPACT_CODE
, PROPERTY_CODE PROPERTY_CODE
, LOOKUP_TYPE LOOKUP_TYPE
, OLD_VALUE OLD_VALUE
, NEW_VALUE NEW_VALUE
, PARENT_COMPONENT_TYPE_CODE PARENT_COMPONENT_TYPE_CODE
, PARENT_COMPONENT_KEY PARENT_COMPONENT_KEY
, MERGE_ENABLED_FLAG MERGE_ENABLED_FLAG
, MERGE_FLAG MERGE_FLAG
, DUPLICATE_COMPONENT_CODE DUPLICATE_COMPONENT_CODE
, DUPLICATE_COMPONENT_NAME DUPLICATE_COMPONENT_NAME
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, PARENT_COMPONENT_OWNER_CODE PARENT_COMPONENT_OWNER_CODE
, PARENT_COMPONENT_CODE PARENT_COMPONENT_CODE
, OLD_SOURCE_APP_ID OLD_SOURCE_APP_ID
, OLD_SOURCE_TYPE_CODE OLD_SOURCE_TYPE_CODE
, OLD_SOURCE_CODE OLD_SOURCE_CODE
, NEW_SOURCE_APP_ID NEW_SOURCE_APP_ID
, NEW_SOURCE_TYPE_CODE NEW_SOURCE_TYPE_CODE
, NEW_SOURCE_CODE NEW_SOURCE_CODE
, COMPONENT_APPLICATION_ID COMPONENT_APPLICATION_ID
FROM "XLA"."XLA_AMB_UPDATED_COMPS"