PJF_RATE_SCHEDULES_VL

Details

• Schema: FUSION

• Object owner: PJF

• Object type: VIEW

Columns

Name
RATE_SCHEDULE_NAME DESCRIPTION RATE_SCHEDULE_ID LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN SCHEDULE_TYPE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 JOB_SET_ID CURRENCY_CODE SET_ID OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT PJF_RATE_SCHEDULES_TL.RATE_SCHEDULE_NAME RATE_SCHEDULE_NAME, PJF_RATE_SCHEDULES_TL.DESCRIPTION DESCRIPTION, PJF_RATE_SCHEDULES_B.RATE_SCHEDULE_ID RATE_SCHEDULE_ID, PJF_RATE_SCHEDULES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJF_RATE_SCHEDULES_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJF_RATE_SCHEDULES_B.CREATION_DATE CREATION_DATE, PJF_RATE_SCHEDULES_B.CREATED_BY CREATED_BY, PJF_RATE_SCHEDULES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJF_RATE_SCHEDULES_B.SCHEDULE_TYPE SCHEDULE_TYPE, PJF_RATE_SCHEDULES_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, PJF_RATE_SCHEDULES_B.ATTRIBUTE1 ATTRIBUTE1, PJF_RATE_SCHEDULES_B.ATTRIBUTE2 ATTRIBUTE2, PJF_RATE_SCHEDULES_B.ATTRIBUTE3 ATTRIBUTE3, PJF_RATE_SCHEDULES_B.ATTRIBUTE4 ATTRIBUTE4, PJF_RATE_SCHEDULES_B.ATTRIBUTE5 ATTRIBUTE5, PJF_RATE_SCHEDULES_B.ATTRIBUTE6 ATTRIBUTE6, PJF_RATE_SCHEDULES_B.ATTRIBUTE7 ATTRIBUTE7, PJF_RATE_SCHEDULES_B.ATTRIBUTE8 ATTRIBUTE8, PJF_RATE_SCHEDULES_B.ATTRIBUTE9 ATTRIBUTE9, PJF_RATE_SCHEDULES_B.ATTRIBUTE10 ATTRIBUTE10, PJF_RATE_SCHEDULES_B.ATTRIBUTE11 ATTRIBUTE11, PJF_RATE_SCHEDULES_B.ATTRIBUTE12 ATTRIBUTE12, PJF_RATE_SCHEDULES_B.ATTRIBUTE13 ATTRIBUTE13, PJF_RATE_SCHEDULES_B.ATTRIBUTE14 ATTRIBUTE14, PJF_RATE_SCHEDULES_B.ATTRIBUTE15 ATTRIBUTE15, PJF_RATE_SCHEDULES_B.JOB_SET_ID JOB_SET_ID, PJF_RATE_SCHEDULES_B.CURRENCY_CODE CURRENCY_CODE, PJF_RATE_SCHEDULES_B.SET_ID SET_ID, PJF_RATE_SCHEDULES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM PJF_RATE_SCHEDULES_TL PJF_RATE_SCHEDULES_TL, PJF_RATE_SCHEDULES_B PJF_RATE_SCHEDULES_B WHERE PJF_RATE_SCHEDULES_TL.RATE_SCHEDULE_ID = PJF_RATE_SCHEDULES_B.RATE_SCHEDULE_ID AND PJF_RATE_SCHEDULES_TL.LANGUAGE = USERENV('LANG')