Product: | CE - Cash Management |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CE_FORECAST_HEADERS_V |
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