Product: | AS - Sales Foundation |
---|---|
Description: | Sales quotas view |
Implementation/DBA Data: | Not implemented in this database |
SELECT QUOTA.PERIOD_NAME
, QUOTA.CREATED_BY
, QUOTA.CREATION_DATE
, QUOTA.LAST_UPDATED_BY
, QUOTA.LAST_UPDATE_DATE
, QUOTA.LAST_UPDATE_LOGIN
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, SGRP.GROUP_NAME
, PARTNER.CUSTOMER_NAME
, INTTYPE.INTEREST_TYPE
, INTCODE1.CODE
, INTCODE2.CODE
, QUOTA.SALESFORCE_ID
, QUOTA.EMPLOYEE_PERSON_ID
, QUOTA.PARTNER_CUSTOMER_ID
, QUOTA.PARTNER_ADDRESS_ID
, QUOTA.SALES_GROUP_ID
, QUOTA.CURRENCY_CODE
, QUOTA.QUOTA_AMOUNT
, QUOTA.REVENUE_FLAG
, QUOTA.SALES_QUOTA_ID
, QUOTA.INTEREST_TYPE_ID
, QUOTA.PRIMARY_INTEREST_CODE_ID
, QUOTA.SECONDARY_INTEREST_CODE_ID
, INTCODE2.PF_ITEM_ID
, INTCODE2.PF_ORGANIZATION_ID
, QUOTA.ITEM_ID
, QUOTA.ORGANIZATION_ID
, QUOTA.ATTRIBUTE_CATEGORY
, QUOTA.ATTRIBUTE1
, QUOTA.ATTRIBUTE2
, QUOTA.ATTRIBUTE3
, QUOTA.ATTRIBUTE4
, QUOTA.ATTRIBUTE5
, QUOTA.ATTRIBUTE6
, QUOTA.ATTRIBUTE7
, QUOTA.ATTRIBUTE8
, QUOTA.ATTRIBUTE9
, QUOTA.ATTRIBUTE10
, QUOTA.ATTRIBUTE11
, QUOTA.ATTRIBUTE12
, QUOTA.ATTRIBUTE13
, QUOTA.ATTRIBUTE14
, QUOTA.ATTRIBUTE15
, QUOTA.ROWID
FROM AS_INTEREST_TYPES_VL INTTYPE
, AS_INTEREST_CODES_VL INTCODE1
, AS_INTEREST_CODES_VL INTCODE2
, PER_ALL_PEOPLE_F PEOPLE
, JTF_RS_GROUPS_TL SGRP
, AS_PARTY_CUSTOMERS_V PARTNER
, AS_SALES_QUOTAS QUOTA
WHERE QUOTA.INTEREST_TYPE_ID = INTTYPE.INTEREST_TYPE_ID (+)
AND QUOTA.PRIMARY_INTEREST_CODE_ID = INTCODE1.INTEREST_CODE_ID (+)
AND QUOTA.SECONDARY_INTEREST_CODE_ID = INTCODE2.INTEREST_CODE_ID (+)
AND QUOTA.EMPLOYEE_PERSON_ID = PEOPLE.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+)
AND PEOPLE.EFFECTIVE_END_DATE(+)
AND QUOTA.SALES_GROUP_ID = SGRP.GROUP_ID (+)
AND SGRP.LANGUAGE = USERENV('LANG')
AND QUOTA.PARTNER_CUSTOMER_ID = PARTNER.CUSTOMER_ID (+)