View: AS_PTR_SALESREPS_V

View Text

SELECT SALE.ROWID
, SALE.SALESFORCE_ID
, SALE.LAST_UPDATE_DATE
, SALE.LAST_UPDATED_BY
, SALE.CREATION_DATE
, SALE.CREATED_BY
, SALE.LAST_UPDATE_LOGIN
, SALE.TYPE
, SALE.STATUS_CODE
, SALE.EMPLOYEE_PERSON_ID
, SALE.PARTNER_CUSTOMER_ID
, ADDR.CITY
, ADDR.ADDRESS1
, SALE.PARTNER_ADDRESS_ID
, SALE.PARTNER_CONTACT_ID
, SALE.ATTRIBUTE_CATEGORY
, SALE.ATTRIBUTE1
, SALE.ATTRIBUTE2
, SALE.ATTRIBUTE3
, SALE.ATTRIBUTE4
, SALE.ATTRIBUTE5
, SALE.ATTRIBUTE6
, SALE.ATTRIBUTE7
, SALE.ATTRIBUTE8
, SALE.ATTRIBUTE9
, SALE.ATTRIBUTE10
, SALE.ATTRIBUTE11
, SALE.ATTRIBUTE12
, SALE.ATTRIBUTE13
, SALE.ATTRIBUTE14
, SALE.ATTRIBUTE15
, RAREPS.ORG_ID
, CUST.CUSTOMER_NAME
, LOOK.MEANING
, CONT.FIRST_NAME
, CONT.LAST_NAME
, CONT.FIRST_NAME || ' ' || CONT.LAST_NAME
, PEOPLE.FIRST_NAME
, PEOPLE.LAST_NAME
, PEOPLE.FIRST_NAME || ' ' || PEOPLE.LAST_NAME
, SALE.SALES_GROUP_ID
, SG.NAME
, SG.MANAGER_PERSON_ID
, MGRPEOPLE.FIRST_NAME || ' ' || MGRPEOPLE.LAST_NAME
, RAREPS.STATUS
, CUST.CUSTOMER_NUMBER
, RAREPS.SALESREP_ID
, RAREPS.START_DATE_ACTIVE
, RAREPS.END_DATE_ACTIVE
, RAREPS.COMPENSATION_CURRENCY_CODE
, RAREPS.COST_CENTER
, RAREPS.CHARGE_TO_COST_CENTER
, RAREPS.START_PROCESSING_PERIOD_ID
, PS.PERIOD_NAME
, RAREPS.END_PROCESSING_PERIOD_ID
, PE.PERIOD_NAME
, RAREPS.ASSIGNED_TO_USER_ID
, U.USER_NAME
, RAREPS.SALES_CREDIT_TYPE_ID
, ST.NAME
, RAREPS.GL_ID_REV
, RAREPS.GL_ID_FREIGHT
, RAREPS.GL_ID_REC
, RAREPS.SET_OF_BOOKS_ID
, RAREPS.COMMISSIONABLE_FLAG
, CUST.CUSTOMER_NUMBER
, RAREPS.SALES_TAX_GEOCODE
, RAREPS.SALES_TAX_INSIDE_CITY_LIMITS
FROM RA_CUSTOMERS CUST
, AS_SALESFORCE SALE
, AS_SALES_GROUPS SG
, CN_PERIOD_STATUSES PS
, FND_USER U
, PER_ALL_PEOPLE_F PEOPLE
, PER_PEOPLE_X MGRPEOPLE
, RA_ADDRESSES ADDR
, RA_CONTACTS CONT
, RA_SALESREPS_ALL RAREPS
, SO_SALES_CREDIT_TYPES_115 ST
, AS_LOOKUPS LOOK
, CN_PERIOD_STATUSES PE
WHERE NVL(RAREPS.ORG_ID
, NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE( SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99) AND SALE.PARTNER_ADDRESS_ID = ADDR.ADDRESS_ID
AND ADDR.CUSTOMER_ID = CUST.CUSTOMER_ID
AND SALE.SALES_GROUP_ID = SG.SALES_GROUP_ID(+)
AND SG.MANAGER_PERSON_ID = MGRPEOPLE.PERSON_ID(+)
AND SALE.SALESFORCE_ID = RAREPS.SALESFORCE_ID(+)
AND RAREPS.START_PROCESSING_PERIOD_ID = PS.PERIOD_ID(+)
AND RAREPS.END_PROCESSING_PERIOD_ID = PE.PERIOD_ID(+)
AND RAREPS.ASSIGNED_TO_USER_ID = U.USER_ID(+)
AND RAREPS.SALES_CREDIT_TYPE_ID = ST.SALES_CREDIT_TYPE_ID(+)
AND SALE.PARTNER_CONTACT_ID = CONT.CONTACT_ID(+)
AND SALE.TYPE = 'PARTNER'
AND SALE.TYPE = LOOK.LOOKUP_CODE(+)
AND LOOK.LOOKUP_TYPE = 'SALESFORCE_TYPE'
AND SALE.EMPLOYEE_PERSON_ID = PEOPLE.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PEOPLE.EFFECTIVE_START_DATE(+) AND PEOPLE.EFFECTIVE_END_DATE(+)

Columns