DBA Data[Home] [Help]

VIEW: APPS.OZF_X_AGING_BUCKET_LNS

Source

View Text - Preformatted

SELECT B.AGING_BUCKET_LINE_ID , B.last_update_date , B.last_updated_by , B.last_update_login , B.creation_date , B.created_by , B.AGING_BUCKET_ID , B.BUCKET_SEQUENCE_NUM , B.DAYS_START , B.DAYS_TO , B.TYPE , T.REPORT_HEADING1 , T.REPORT_HEADING2 , B.attribute_category , B.attribute1 , B.attribute2 , B.attribute3 , B.attribute4 , B.attribute5 , B.attribute6 , B.attribute7 , B.attribute8 , B.attribute9 , B.attribute10 , B.attribute11 , B.attribute12 , B.attribute13 , B.attribute14 , B.attribute15 from AR_AGING_BUCKET_LINES_B B , AR_AGING_BUCKET_LINES_TL T WHERE B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID and T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.AGING_BUCKET_LINE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, B.AGING_BUCKET_ID
, B.BUCKET_SEQUENCE_NUM
, B.DAYS_START
, B.DAYS_TO
, B.TYPE
, T.REPORT_HEADING1
, T.REPORT_HEADING2
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
FROM AR_AGING_BUCKET_LINES_B B
, AR_AGING_BUCKET_LINES_TL T
WHERE B.AGING_BUCKET_LINE_ID = T.AGING_BUCKET_LINE_ID
AND T.LANGUAGE = USERENV('LANG')