VIEW: APPS.AS_CURRENT_ENVIRONMENT_V

Source

View Text - Preformatted

SELECT ace.rowid ,ace.current_environment_id ,ace.address_id ,ace.customer_id ,ace.last_update_date ,ace.last_updated_by ,ace.creation_date ,ace.created_by ,ace.last_update_login ,ace.enabled_flag ,asit.interest_type ,ace.interest_type_id ,ace.primary_interest_code_id ,ace.secondary_interest_code_id ,aspic.code ,assic.code ,ace.description ,ace.source ,asll.meaning ,ace.source_id ,ace.inventory_item_id ,ace.quantity ,ace.price ,ace.amount ,ace.comments ,ace.user_def_num1 ,ace.user_def_num2 ,ace.user_def_num3 ,ace.user_def_text1 ,asl.meaning ,ace.user_def_text2 ,ace.user_def_text3 ,ace.installation_date ,ace.reevaluation_date ,ace.user_def_date ,ace.attribute_category ,ace.attribute1 ,ace.attribute2 ,ace.attribute3 ,ace.attribute4 ,ace.attribute5 ,ace.attribute6 ,ace.attribute7 ,ace.attribute8 ,ace.attribute9 ,ace.attribute10 ,ace.attribute11 ,ace.attribute12 ,ace.attribute13 ,ace.attribute14 ,ace.attribute15 FROM AS_LOOKUPS asl , AS_LOOKUPS asll , AS_INTEREST_CODES_V assic , AS_INTEREST_CODES_V aspic , AS_INTEREST_TYPES_VL asit , AS_CURRENT_ENVIRONMENT ace WHERE ace.user_def_text1 = asl.lookup_code(+) AND asl.lookup_type(+) = 'CURR_ENV_USER_DEF_TEXT1' AND ace.source = asll.lookup_code(+) AND asll.lookup_type(+) = 'COMPETITOR' AND ace.secondary_interest_code_id = assic.interest_code_id(+) AND ace.primary_interest_code_id = aspic.interest_code_id(+) AND ace.interest_type_id = asit.interest_type_id(+)

View Text - HTML Formatted

SELECT ACE.ROWID
, ACE.CURRENT_ENVIRONMENT_ID
, ACE.ADDRESS_ID
, ACE.CUSTOMER_ID
, ACE.LAST_UPDATE_DATE
, ACE.LAST_UPDATED_BY
, ACE.CREATION_DATE
, ACE.CREATED_BY
, ACE.LAST_UPDATE_LOGIN
, ACE.ENABLED_FLAG
, ASIT.INTEREST_TYPE
, ACE.INTEREST_TYPE_ID
, ACE.PRIMARY_INTEREST_CODE_ID
, ACE.SECONDARY_INTEREST_CODE_ID
, ASPIC.CODE
, ASSIC.CODE
, ACE.DESCRIPTION
, ACE.SOURCE
, ASLL.MEANING
, ACE.SOURCE_ID
, ACE.INVENTORY_ITEM_ID
, ACE.QUANTITY
, ACE.PRICE
, ACE.AMOUNT
, ACE.COMMENTS
, ACE.USER_DEF_NUM1
, ACE.USER_DEF_NUM2
, ACE.USER_DEF_NUM3
, ACE.USER_DEF_TEXT1
, ASL.MEANING
, ACE.USER_DEF_TEXT2
, ACE.USER_DEF_TEXT3
, ACE.INSTALLATION_DATE
, ACE.REEVALUATION_DATE
, ACE.USER_DEF_DATE
, ACE.ATTRIBUTE_CATEGORY
, ACE.ATTRIBUTE1
, ACE.ATTRIBUTE2
, ACE.ATTRIBUTE3
, ACE.ATTRIBUTE4
, ACE.ATTRIBUTE5
, ACE.ATTRIBUTE6
, ACE.ATTRIBUTE7
, ACE.ATTRIBUTE8
, ACE.ATTRIBUTE9
, ACE.ATTRIBUTE10
, ACE.ATTRIBUTE11
, ACE.ATTRIBUTE12
, ACE.ATTRIBUTE13
, ACE.ATTRIBUTE14
, ACE.ATTRIBUTE15
FROM AS_LOOKUPS ASL
, AS_LOOKUPS ASLL
, AS_INTEREST_CODES_V ASSIC
, AS_INTEREST_CODES_V ASPIC
, AS_INTEREST_TYPES_VL ASIT
, AS_CURRENT_ENVIRONMENT ACE
WHERE ACE.USER_DEF_TEXT1 = ASL.LOOKUP_CODE(+)
AND ASL.LOOKUP_TYPE(+) = 'CURR_ENV_USER_DEF_TEXT1'
AND ACE.SOURCE = ASLL.LOOKUP_CODE(+)
AND ASLL.LOOKUP_TYPE(+) = 'COMPETITOR'
AND ACE.SECONDARY_INTEREST_CODE_ID = ASSIC.INTEREST_CODE_ID(+)
AND ACE.PRIMARY_INTEREST_CODE_ID = ASPIC.INTEREST_CODE_ID(+)
AND ACE.INTEREST_TYPE_ID = ASIT.INTEREST_TYPE_ID(+)