Product: | AS - Sales Foundation |
---|---|
Description: | Current Environment |
Implementation/DBA Data: | APPS.AS_CURRENT_ENVIRONMENT_V |
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(+)