VIEW: APPS.OKS_BILL_SUBLINE_DTLS_V

Source

View Text - Preformatted

SELECT BSDB.rowid ROW_ID, BSDB.ID ID, BSDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BSDB.BSL_ID BSL_ID, BSDB.BSL_ID_AVERAGED BSL_ID_AVERAGED, BSDB.BSD_ID BSD_ID, BSDB.BSD_ID_APPLIED BSD_ID_APPLIED, BSDB.UNIT_OF_MEASURE UNIT_OF_MEASURE, BSDB.FIXED FIXED, BSDB.ACTUAL ACTUAL, BSDB.DEFAULT_DEFAULT DEFAULT_DEFAULT, BSDB.AMCV_YN AMCV_YN, BSDB.ADJUSTMENT_LEVEL ADJUSTMENT_LEVEL, BSDB.ADJUSTMENT_MINIMUM ADJUSTMENT_MINIMUM, BSDB.RESULT RESULT, BSDB.AMOUNT AMOUNT, BSDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, BSDB.ATTRIBUTE1 ATTRIBUTE1, BSDB.ATTRIBUTE2 ATTRIBUTE2, BSDB.ATTRIBUTE3 ATTRIBUTE3, BSDB.ATTRIBUTE4 ATTRIBUTE4, BSDB.ATTRIBUTE5 ATTRIBUTE5, BSDB.ATTRIBUTE6 ATTRIBUTE6, BSDB.ATTRIBUTE7 ATTRIBUTE7, BSDB.ATTRIBUTE8 ATTRIBUTE8, BSDB.ATTRIBUTE9 ATTRIBUTE9, BSDB.ATTRIBUTE10 ATTRIBUTE10, BSDB.ATTRIBUTE11 ATTRIBUTE11, BSDB.ATTRIBUTE12 ATTRIBUTE12, BSDB.ATTRIBUTE13 ATTRIBUTE13, BSDB.ATTRIBUTE14 ATTRIBUTE14, BSDB.ATTRIBUTE15 ATTRIBUTE15, BSDB.CREATED_BY CREATED_BY, BSDB.CREATION_DATE CREATION_DATE, BSDB.LAST_UPDATED_BY LAST_UPDATED_BY, BSDB.LAST_UPDATE_DATE LAST_UPDATE_DATE, BSDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BSDB.START_READING START_READING, BSDB.END_READING END_READING, BSDB.CCR_ID CCR_ID, BSDB.CGR_ID CGR_ID, BSDB.ESTIMATED_QUANTITY , BSDB.BASE_READING BASE_READING FROM OKS_BILL_SUB_LINE_DTLS BSDB

View Text - HTML Formatted

SELECT BSDB.ROWID ROW_ID
, BSDB.ID ID
, BSDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BSDB.BSL_ID BSL_ID
, BSDB.BSL_ID_AVERAGED BSL_ID_AVERAGED
, BSDB.BSD_ID BSD_ID
, BSDB.BSD_ID_APPLIED BSD_ID_APPLIED
, BSDB.UNIT_OF_MEASURE UNIT_OF_MEASURE
, BSDB.FIXED FIXED
, BSDB.ACTUAL ACTUAL
, BSDB.DEFAULT_DEFAULT DEFAULT_DEFAULT
, BSDB.AMCV_YN AMCV_YN
, BSDB.ADJUSTMENT_LEVEL ADJUSTMENT_LEVEL
, BSDB.ADJUSTMENT_MINIMUM ADJUSTMENT_MINIMUM
, BSDB.RESULT RESULT
, BSDB.AMOUNT AMOUNT
, BSDB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BSDB.ATTRIBUTE1 ATTRIBUTE1
, BSDB.ATTRIBUTE2 ATTRIBUTE2
, BSDB.ATTRIBUTE3 ATTRIBUTE3
, BSDB.ATTRIBUTE4 ATTRIBUTE4
, BSDB.ATTRIBUTE5 ATTRIBUTE5
, BSDB.ATTRIBUTE6 ATTRIBUTE6
, BSDB.ATTRIBUTE7 ATTRIBUTE7
, BSDB.ATTRIBUTE8 ATTRIBUTE8
, BSDB.ATTRIBUTE9 ATTRIBUTE9
, BSDB.ATTRIBUTE10 ATTRIBUTE10
, BSDB.ATTRIBUTE11 ATTRIBUTE11
, BSDB.ATTRIBUTE12 ATTRIBUTE12
, BSDB.ATTRIBUTE13 ATTRIBUTE13
, BSDB.ATTRIBUTE14 ATTRIBUTE14
, BSDB.ATTRIBUTE15 ATTRIBUTE15
, BSDB.CREATED_BY CREATED_BY
, BSDB.CREATION_DATE CREATION_DATE
, BSDB.LAST_UPDATED_BY LAST_UPDATED_BY
, BSDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BSDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BSDB.START_READING START_READING
, BSDB.END_READING END_READING
, BSDB.CCR_ID CCR_ID
, BSDB.CGR_ID CGR_ID
, BSDB.ESTIMATED_QUANTITY
, BSDB.BASE_READING BASE_READING
FROM OKS_BILL_SUB_LINE_DTLS BSDB