Product: | AS - Sales Foundation |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT GRP.NAME
, GRP.START_DATE_ACTIVE
, GRP.END_DATE_ACTIVE
, '_LA:GRP.ENABLED_FLAG:AS_LOOKUPS:FLAG:MEANING'
, GRP.DESCRIPTION
, GRP.ACCOUNTING_CODE
, '_DF:AS:AS_SALES_GROUPS:GRP' -- RESOLVE FK
, PER.FIRST_NAME
, PER.LAST_NAME
, PARENT_GRP.NAME -- ID
, GRP.SALES_GROUP_ID
, GRP.PARENT_SALES_GROUP_ID
, GRP.MANAGER_PERSON_ID
, GRP.MANAGER_SALESFORCE_ID -- WHO
, GRP.LAST_UPDATE_DATE
, GRP.LAST_UPDATED_BY
, GRP.CREATION_DATE
, GRP.CREATED_BY
FROM PER_ALL_PEOPLE_F PER
, AS_SALES_GROUPS PARENT_GRP
, AS_SALES_GROUPS GRP
WHERE GRP.MANAGER_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND NVL(PER.EFFECTIVE_END_DATE (+)
, TRUNC(SYSDATE))
AND GRP.PARENT_SALES_GROUP_ID = PARENT_GRP.SALES_GROUP_ID (+) WITH READ ONLY