FND Design Data [Home] [Help]

View: SO_SALESPERSONS_ACTIVE_V

Product: OE - Order Entry
Description:
Implementation/DBA Data: ViewAPPS.SO_SALESPERSONS_ACTIVE_V
View Text

SELECT NAME SALESPERSON
, SALESREP_ID
, SALESREP_NUMBER
FROM RA_SALESREPS
WHERE SALESREP_ID NOT IN (-1
, -2)
AND NVL(STATUS
, 'A') = 'A'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))

Columns

Name
SALESPERSON
SALESREP_ID
SALESREP_NUMBER