VIEW: APPS.AR_CASH_BASIS_DISTS_MRC_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )