Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT INTTYPE.INTEREST_TYPE
, INTTYPE.DESCRIPTION
, '_LA:INTTYPE.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:INTTYPE.COMPANY_CLASSIFICATION_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:INTTYPE.CONTACT_INTEREST_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:INTTYPE.LEAD_CLASSIFICATION_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:INTTYPE.EXPECTED_PURCHASE_FLAG:AS_LOOKUPS:FLAG:MEANING'
, '_LA:INTTYPE.CURRENT_ENVIRONMENT_FLAG:AS_LOOKUPS:FLAG:MEANING' -- RESOLVE FK
, PARA.ORGANIZATION_CODE
, ORG.NAME -- ID
, INTTYPE.INTEREST_TYPE_ID
, INTTYPE.ORG_ID -- WHO
, INTTYPE.LAST_UPDATE_DATE
, INTTYPE.LAST_UPDATED_BY
, INTTYPE.CREATION_DATE
, INTTYPE.CREATED_BY
FROM MTL_PARAMETERS PARA
, HR_ALL_ORGANIZATION_UNITS ORG
, AS_INTEREST_TYPES_ALL INTTYPE
WHERE INTTYPE.ORG_ID = PARA.ORGANIZATION_ID (+)
AND INTTYPE.ORG_ID = ORG.ORGANIZATION_ID (+) AND '_SEC:INTTYPE.ORG_ID' IS NOT NULL WITH READ ONLY