View: ASFV_SALES_CREDITS

View Text

SELECT CRED.REVENUE_AMOUNT
, CRED.REVENUE_PERCENT
, CRED.QUOTA_CREDIT_AMOUNT
, CRED.QUOTA_CREDIT_PERCENT
, '_DF:AS:AS_SALES_CREDITS:CRED' -- RESOLVE FK
, LEAD.LEAD_NUMBER
, LEAD.DESCRIPTION
, GRP.NAME
, PER.FIRST_NAME
, PER.LAST_NAME
, CUST.CUSTOMER_NAME
, ADDR.CITY
, ADDR.COUNTRY -- ID
, CRED.SALES_CREDIT_ID
, CRED.LEAD_ID
, CRED.LEAD_LINE_ID
, CRED.SALESFORCE_ID
, CRED.SALESGROUP_ID
, CRED.PARTNER_CUSTOMER_ID
, CRED.PARTNER_ADDRESS_ID -- WHO
, CRED.LAST_UPDATE_DATE
, CRED.LAST_UPDATED_BY
, CRED.CREATION_DATE
, CRED.CREATED_BY
FROM RA_CUSTOMERS CUST
, RA_ADDRESSES_ALL ADDR
, PER_ALL_PEOPLE_F PER
, AS_SALESFORCE SF
, AS_SALES_GROUPS GRP
, AS_LEADS_ALL LEAD
, AS_SALES_CREDITS CRED
WHERE CRED.PARTNER_CUSTOMER_ID = CUST.CUSTOMER_ID (+)
AND CRED.PARTNER_ADDRESS_ID = ADDR.ADDRESS_ID (+)
AND CRED.SALESFORCE_ID = SF.SALESFORCE_ID (+)
AND SF.EMPLOYEE_PERSON_ID = PER.PERSON_ID (+)
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE (+)
AND NVL(PER.EFFECTIVE_END_DATE (+)
, TRUNC(SYSDATE)) AND CRED.SALESGROUP_ID = GRP.SALES_GROUP_ID (+) AND CRED.LEAD_ID = LEAD.LEAD_ID WITH READ ONLY

Columns