[Home] [Help]
| Product: | AS - Sales Foundation |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT AQP.ROWID
, AQP.QUOTA_PROFILE_ID
, AQP.LAST_UPDATE_DATE
, AQP.LAST_UPDATED_BY
, AQP.CREATION_DATE
, AQP.CREATED_BY
, AQP.LAST_UPDATE_LOGIN
, AQP.ORGANIZATION_ID
, AQP.SALESFORCE_ID
, AQP.EMPLOYEE_PERSON_ID
, PER.FIRST_NAME
, PER.LAST_NAME
, AQP.PARTNER_CUSTOMER_ID
, AQP.SALES_GROUP_ID
, GRP.GROUP_NAME
, AQP.INTEREST_TYPE_ID
, AIT.INTEREST_TYPE
, AQP.PRIMARY_INTEREST_CODE_ID
, AIC1.CODE
, AQP.SECONDARY_INTEREST_CODE_ID
, AIC2.CODE
, AQP.INVENTORY_ITEM_ID
, MSI.PADDED_CONCATENATED_SEGMENTS
, AQP.PERIOD_TYPE
, AQP.REVENUE_FLAG
, AQP.QUOTA_AMOUNT
, AQP.ACTIVE_FLAG
, AQP.RECORD_STATUS
, AQP.SPECIAL_NOTES
, AQP.ATTRIBUTE_CATEGORY
, AQP.ATTRIBUTE1
, AQP.ATTRIBUTE2
, AQP.ATTRIBUTE3
, AQP.ATTRIBUTE4
, AQP.ATTRIBUTE5
, AQP.ATTRIBUTE6
, AQP.ATTRIBUTE7
, AQP.ATTRIBUTE8
, AQP.ATTRIBUTE9
, AQP.ATTRIBUTE10
, AQP.ATTRIBUTE11
, AQP.ATTRIBUTE12
, AQP.ATTRIBUTE13
, AQP.ATTRIBUTE14
, AQP.ATTRIBUTE15
, AQP.CURRENCY_CODE
FROM AS_QUOTA_PROFILES AQP
, JTF_RS_GROUPS_TL GRP
, AS_INTEREST_TYPES_VL AIT
, MTL_SYSTEM_ITEMS_B_KFV MSI
, AS_INTEREST_CODES_VL AIC1
, AS_INTEREST_CODES_VL AIC2
, PER_PEOPLE_X PER
WHERE AQP.EMPLOYEE_PERSON_ID = PER.PERSON_ID(+)
AND AQP.SALES_GROUP_ID = GRP.GROUP_ID
AND GRP.LANGUAGE = USERENV('LANG')
AND (AQP.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND AQP.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+))
AND AQP.INTEREST_TYPE_ID = AIT.INTEREST_TYPE_ID(+)
AND AQP.PRIMARY_INTEREST_CODE_ID = AIC1.INTEREST_CODE_ID(+)
AND AQP.SECONDARY_INTEREST_CODE_ID = AIC2.INTEREST_CODE_ID(+)