[Home] [Help]
View: AR_TA_DEDUCTN_ASSIGNED_TO_V
Product: | AR - Receivables |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DECODE(DA.ASSIGNED_TO_SALESREP_ID
, NULL
, COL.NAME
, SAL.NAME) ASSIGNED_TO
FROM RA_SALESREPS SAL
, AR_COLLECTORS COL
, AR_TA_DEDN_ASSGNS_ALL DA
WHERE NVL(DA.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND NVL(SAL.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTR ( USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTR (USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND DA.ASSIGNED_TO_SALESREP_ID = SAL.SALESREP_ID (+)
AND DA.ASSIGNED_TO_COLLECTOR_ID = COL.COLLECTOR_ID (+) GROUP BY DECODE(DA.ASSIGNED_TO_SALESREP_ID
, NULL
, COL.NAME
, SAL.NAME)
Columns