[Home] [Help]
| Product: | AR - Receivables |
|---|---|
| Description: | SINGLE_ORG view |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DEDASSGN.DEDUCTN_ASSGNMT_ID
, DEDASSGN.CUSTOMER_TRX_ID
, DEDASSGN.ASSIGNED_TO_SALESREP_ID
, DEDASSGN.ASSIGNED_TO_COLLECTOR_ID
, DEDASSGN.DEDUCTN_TEXT
, DEDASSGN.DATE_ASSIGNED
, DEDASSGN.TRANSFER_TO_SALESREP_ID
, DEDASSGN.TRANSFER_TO_COLLECTOR_ID
, DEDASSGN.LAST_UPDATE_DATE
, DEDASSGN.LAST_UPDATED_BY
, DEDASSGN.CREATION_DATE
, DEDASSGN.CREATED_BY
, DEDASSGN.LAST_UPDATE_LOGIN
, DEDASSGN.ATTRIBUTE_CATEGORY
, DEDASSGN.ATTRIBUTE15
, DEDASSGN.ATTRIBUTE14
, DEDASSGN.ATTRIBUTE13
, DEDASSGN.ATTRIBUTE12
, DEDASSGN.ATTRIBUTE11
, DEDASSGN.ATTRIBUTE10
, DEDASSGN.ATTRIBUTE9
, DEDASSGN.ATTRIBUTE8
, DEDASSGN.ATTRIBUTE7
, DEDASSGN.ATTRIBUTE6
, DEDASSGN.ATTRIBUTE5
, DEDASSGN.ATTRIBUTE4
, DEDASSGN.ATTRIBUTE3
, DEDASSGN.ATTRIBUTE2
, DEDASSGN.ATTRIBUTE1
, DEDASSGN.ORG_ID
FROM AR_TA_DEDN_ASSGNS_ALL DEDASSGN
WHERE NVL(DEDASSGN.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)