View: AR_CASH_BASIS_DISTS_MRC_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_CASH_BASIS_DISTS_MRC_V

View Text

SELECT "CASH_BASIS_DISTRIBUTION_ID"
, "CREATED_BY"
, "CREATION_DATE"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "RECEIVABLE_APPLICATION_ID"
, "SOURCE"
, "SOURCE_ID"
, "TYPE"
, "PAYMENT_SCHEDULE_ID"
, "GL_DATE"
, "CURRENCY_CODE"
, "AMOUNT"
, "ACCTD_AMOUNT"
, "CODE_COMBINATION_ID"
, "POSTING_CONTROL_ID"
, "GL_POSTED_DATE"
, "RECEIVABLE_APPLICATION_ID_CASH"
, "ORG_ID"
FROM AR_MC_CASH_BASIS_DISTS_ALL
WHERE NVL(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 SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO')
, 45
, 10))
, -99 )

Columns