View: PSB_AE_LINES

View Text

SELECT "AE_LINE_ID"
, "AE_HEADER_ID"
, "AE_LINE_NUMBER"
, "AE_LINE_TYPE_CODE"
, "CODE_COMBINATION_ID"
, "ACTUAL_FLAG"
, "CURRENCY_CODE"
, "SERVICE_PACKAGE_ID" "CURRENCY_CONVERSION_TYPE"
, "CURRENCY_CONVERSION_DATE"
, "CURRENCY_CONVERSION_RATE"
, "ENTERED_DR"
, "ENTERED_CR"
, "ACCOUNTED_DR"
, "ACCOUNTED_CR"
, "SOURCE_TABLE"
, "SOURCE_ID"
, "GL_SL_LINK_ID"
, "DESCRIPTION"
, "ACCOUNTING_ERROR_CODE"
, "GL_TRANSFER_ERROR_CODE"
, "STAT_AMOUNT"
, "USSGL_TRANSACTION_CODE"
, "SUBLEDGER_DOC_SEQUENCE_ID"
, "SUBLEDGER_DOC_SEQUENCE_VALUE"
, "ORG_ID"
, "REFERENCE1"
, "REFERENCE2"
, "REFERENCE3"
, "REFERENCE4"
, "REFERENCE5"
, "REFERENCE6"
, "REFERENCE7"
, "REFERENCE8"
, "REFERENCE9"
, "REFERENCE10"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "PROGRAM_UPDATE_DATE"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "REQUEST_ID"
FROM PSB_AE_LINES_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)

Columns