View: IGI_AR_CASH_BASIS_DISTS

Product:	IGI - Public Sector Financials International
Description:	Stores Combined Basis Accounting Cash Basis distributions
Implementation/DBA Data:	APPS.IGI_AR_CASH_BASIS_DISTS

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 IGI_AR_CASH_BASIS_DISTS_ALL
WHERE NVL(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)

Columns