VIEW: APPS.CE_FORECAST_HEADERS_V

Source

View Text - Preformatted

SELECT H.ROWID ROW_ID , H.FORECAST_HEADER_ID FORECAST_HEADER_ID , H.NAME NAME , H.DESCRIPTION DESCRIPTION , H.AGING_TYPE AGING_TYPE , L1.MEANING AGING_TYPE_DSP , H.OVERDUE_TRANSACTIONS OVERDUE_TRANSACTIONS , H.CUTOFF_PERIOD CUTOFF_PERIOD , H.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID , GLTC.NAME TRANSACTION_CALENDAR_NAME , H.CREATED_BY CREATED_BY , H.CREATION_DATE CREATION_DATE , H.LAST_UPDATED_BY LAST_UPDATED_BY , H.LAST_UPDATE_DATE LAST_UPDATE_DATE , H.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , H.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , H.ATTRIBUTE1 ATTRIBUTE1 , H.ATTRIBUTE2 ATTRIBUTE2 , H.ATTRIBUTE3 ATTRIBUTE3 , H.ATTRIBUTE4 ATTRIBUTE4 , H.ATTRIBUTE5 ATTRIBUTE5 , H.ATTRIBUTE6 ATTRIBUTE6 , H.ATTRIBUTE7 ATTRIBUTE7 , H.ATTRIBUTE8 ATTRIBUTE8 , H.ATTRIBUTE9 ATTRIBUTE9 , H.ATTRIBUTE10 ATTRIBUTE10 , H.ATTRIBUTE11 ATTRIBUTE11 , H.ATTRIBUTE12 ATTRIBUTE12 , H.ATTRIBUTE13 ATTRIBUTE13 , H.ATTRIBUTE14 ATTRIBUTE14 , H.ATTRIBUTE15 ATTRIBUTE15 , H.START_PROJECT_ID , H.END_PROJECT_ID , P1.SEGMENT1 START_PROJECT_NUMBER , P2.SEGMENT1 END_PROJECT_NUMBER , H.TREASURY_TEMPLATE FROM CE_FORECAST_HEADERS H, CE_LOOKUPS L1, GL_TRANSACTION_CALENDAR GLTC, PA_PROJECTS_ALL P1, PA_PROJECTS_ALL P2 WHERE L1.LOOKUP_TYPE = 'FORECAST_AGING_TYPE' AND L1.LOOKUP_CODE = H.AGING_TYPE AND GLTC.TRANSACTION_CALENDAR_ID (+) = H.TRANSACTION_CALENDAR_ID AND P1.PROJECT_ID(+) =H.START_PROJECT_ID AND P2.PROJECT_ID(+) =H.END_PROJECT_ID

View Text - HTML Formatted

SELECT H.ROWID ROW_ID
, H.FORECAST_HEADER_ID FORECAST_HEADER_ID
, H.NAME NAME
, H.DESCRIPTION DESCRIPTION
, H.AGING_TYPE AGING_TYPE
, L1.MEANING AGING_TYPE_DSP
, H.OVERDUE_TRANSACTIONS OVERDUE_TRANSACTIONS
, H.CUTOFF_PERIOD CUTOFF_PERIOD
, H.TRANSACTION_CALENDAR_ID TRANSACTION_CALENDAR_ID
, GLTC.NAME TRANSACTION_CALENDAR_NAME
, H.CREATED_BY CREATED_BY
, H.CREATION_DATE CREATION_DATE
, H.LAST_UPDATED_BY LAST_UPDATED_BY
, H.LAST_UPDATE_DATE LAST_UPDATE_DATE
, H.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, H.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, H.ATTRIBUTE1 ATTRIBUTE1
, H.ATTRIBUTE2 ATTRIBUTE2
, H.ATTRIBUTE3 ATTRIBUTE3
, H.ATTRIBUTE4 ATTRIBUTE4
, H.ATTRIBUTE5 ATTRIBUTE5
, H.ATTRIBUTE6 ATTRIBUTE6
, H.ATTRIBUTE7 ATTRIBUTE7
, H.ATTRIBUTE8 ATTRIBUTE8
, H.ATTRIBUTE9 ATTRIBUTE9
, H.ATTRIBUTE10 ATTRIBUTE10
, H.ATTRIBUTE11 ATTRIBUTE11
, H.ATTRIBUTE12 ATTRIBUTE12
, H.ATTRIBUTE13 ATTRIBUTE13
, H.ATTRIBUTE14 ATTRIBUTE14
, H.ATTRIBUTE15 ATTRIBUTE15
, H.START_PROJECT_ID
, H.END_PROJECT_ID
, P1.SEGMENT1 START_PROJECT_NUMBER
, P2.SEGMENT1 END_PROJECT_NUMBER
, H.TREASURY_TEMPLATE
FROM CE_FORECAST_HEADERS H
, CE_LOOKUPS L1
, GL_TRANSACTION_CALENDAR GLTC
, PA_PROJECTS_ALL P1
, PA_PROJECTS_ALL P2
WHERE L1.LOOKUP_TYPE = 'FORECAST_AGING_TYPE'
AND L1.LOOKUP_CODE = H.AGING_TYPE
AND GLTC.TRANSACTION_CALENDAR_ID (+) = H.TRANSACTION_CALENDAR_ID
AND P1.PROJECT_ID(+) =H.START_PROJECT_ID
AND P2.PROJECT_ID(+) =H.END_PROJECT_ID