View: OKX_AGING_BUCKETS_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	APPS.OKX_AGING_BUCKETS_V

View Text

SELECT B.AGING_BUCKET_ID AGING_BUCKET_ID
, B.BUCKET_NAME BUCKET_NAME
, B.STATUS STATUS
, B.AGING_TYPE AGING_TYPE
, B.DESCRIPTION DESCRIPTION
, B.ATTRIBUTE_CATEGORY B_ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1 B_ATTRIBUTE1
, B.ATTRIBUTE2 B_ATTRIBUTE2
, B.ATTRIBUTE3 B_ATTRIBUTE3
, B.ATTRIBUTE4 B_ATTRIBUTE4
, B.ATTRIBUTE5 B_ATTRIBUTE5
, B.ATTRIBUTE6 B_ATTRIBUTE6
, B.ATTRIBUTE7 B_ATTRIBUTE7
, B.ATTRIBUTE8 B_ATTRIBUTE8
, B.ATTRIBUTE9 B_ATTRIBUTE9
, B.ATTRIBUTE10 B_ATTRIBUTE10
, B.ATTRIBUTE11 B_ATTRIBUTE11
, B.ATTRIBUTE12 B_ATTRIBUTE12
, B.ATTRIBUTE13 B_ATTRIBUTE13
, B.ATTRIBUTE14 B_ATTRIBUTE14
, B.ATTRIBUTE15 B_ATTRIBUTE15
, L.AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, L.LAST_UPDATED_BY LAST_UPDATED_BY
, L.LAST_UPDATE_DATE LAST_UPDATE_DATE
, L.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, L.CREATED_BY CREATED_BY
, L.CREATION_DATE CREATION_DATE
, L.BUCKET_SEQUENCE_NUM BUCKET_SEQUENCE_NUM
, L.DAYS_START DAYS_START
, L.DAYS_TO DAYS_TO
, L.TYPE TYPE
, L.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, L.ATTRIBUTE1 ATTRIBUTE1
, L.ATTRIBUTE2 ATTRIBUTE2
, L.ATTRIBUTE3 ATTRIBUTE3
, L.ATTRIBUTE4 ATTRIBUTE4
, L.ATTRIBUTE5 ATTRIBUTE5
, L.ATTRIBUTE6 ATTRIBUTE6
, L.ATTRIBUTE7 ATTRIBUTE7
, L.ATTRIBUTE8 ATTRIBUTE8
, L.ATTRIBUTE9 ATTRIBUTE9
, L.ATTRIBUTE10 ATTRIBUTE10
, L.ATTRIBUTE11 ATTRIBUTE11
, L.ATTRIBUTE12 ATTRIBUTE12
, L.ATTRIBUTE13 ATTRIBUTE13
, L.ATTRIBUTE14 ATTRIBUTE14
, L.ATTRIBUTE15 ATTRIBUTE15
FROM AR_AGING_BUCKETS B
, AR_AGING_BUCKET_LINES_B L
WHERE B.AGING_BUCKET_ID = L.AGING_BUCKET_ID
AND B.STATUS = 'A'

Columns