PJF_IND_RATE_SCH

Details

Schema: FUSION
Object owner: PJF
Object type: VIEW

Columns

Name
IND_SCH_NAME DESCRIPTION IND_RATE_SCH_ID START_DATE_ACTIVE END_DATE_ACTIVE LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN IND_STRUCTURE_NAME IND_RATE_SCHEDULE_TYPE PROJECT_ID TASK_ID COST_OVR_SCH_FLAG START_ORGANIZATION_ID OBJECT_VERSION_NUMBER TREE_VERSION_ID TREE_CODE TREE_STRUCTURE_CODE RECOST_TXN_FLAG AWARD_ID AWARD_PROJECT_ID AWARD_TASK_ID

Name

IND_SCH_NAME

DESCRIPTION

IND_RATE_SCH_ID

START_DATE_ACTIVE

END_DATE_ACTIVE

LAST_UPDATED_BY

LAST_UPDATE_DATE

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

IND_STRUCTURE_NAME

IND_RATE_SCHEDULE_TYPE

PROJECT_ID

TASK_ID

COST_OVR_SCH_FLAG

START_ORGANIZATION_ID

OBJECT_VERSION_NUMBER

TREE_VERSION_ID

TREE_CODE

TREE_STRUCTURE_CODE

RECOST_TXN_FLAG

AWARD_ID

AWARD_PROJECT_ID

AWARD_TASK_ID

Query

SQL_Statement
SELECT PJF_IND_RATE_SCH_TL.IND_SCH_NAME IND_SCH_NAME, PJF_IND_RATE_SCH_TL.DESCRIPTION DESCRIPTION, PJF_IND_RATE_SCH_B.IND_RATE_SCH_ID IND_RATE_SCH_ID, PJF_IND_RATE_SCH_B.START_DATE_ACTIVE START_DATE_ACTIVE, PJF_IND_RATE_SCH_B.END_DATE_ACTIVE END_DATE_ACTIVE, PJF_IND_RATE_SCH_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJF_IND_RATE_SCH_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJF_IND_RATE_SCH_B.CREATION_DATE CREATION_DATE, PJF_IND_RATE_SCH_B.CREATED_BY CREATED_BY, PJF_IND_RATE_SCH_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJF_IND_RATE_SCH_B.IND_STRUCTURE_NAME IND_STRUCTURE_NAME, PJF_IND_RATE_SCH_B.IND_RATE_SCHEDULE_TYPE IND_RATE_SCHEDULE_TYPE, PJF_IND_RATE_SCH_B.PROJECT_ID PROJECT_ID, PJF_IND_RATE_SCH_B.TASK_ID TASK_ID, PJF_IND_RATE_SCH_B.COST_OVR_SCH_FLAG COST_OVR_SCH_FLAG, PJF_IND_RATE_SCH_B.START_ORGANIZATION_ID START_ORGANIZATION_ID, PJF_IND_RATE_SCH_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJF_IND_RATE_SCH_B.TREE_VERSION_ID TREE_VERSION_ID, PJF_IND_RATE_SCH_B.TREE_CODE TREE_CODE, PJF_IND_RATE_SCH_B.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE, PJF_IND_RATE_SCH_B.RECOST_TXN_FLAG RECOST_TXN_FLAG, PJF_IND_RATE_SCH_B.AWARD_ID AWARD_ID, PJF_IND_RATE_SCH_B.AWARD_PROJECT_ID AWARD_PROJECT_ID, PJF_IND_RATE_SCH_B.AWARD_TASK_ID AWARD_TASK_ID FROM PJF_IND_RATE_SCH_TL, PJF_IND_RATE_SCH_B WHERE PJF_IND_RATE_SCH_TL.IND_RATE_SCH_ID = PJF_IND_RATE_SCH_B.IND_RATE_SCH_ID AND PJF_IND_RATE_SCH_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PJF_IND_RATE_SCH_TL.IND_SCH_NAME IND_SCH_NAME,

PJF_IND_RATE_SCH_TL.DESCRIPTION DESCRIPTION,

PJF_IND_RATE_SCH_B.IND_RATE_SCH_ID IND_RATE_SCH_ID,

PJF_IND_RATE_SCH_B.START_DATE_ACTIVE START_DATE_ACTIVE,

PJF_IND_RATE_SCH_B.END_DATE_ACTIVE END_DATE_ACTIVE,

PJF_IND_RATE_SCH_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJF_IND_RATE_SCH_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJF_IND_RATE_SCH_B.CREATION_DATE CREATION_DATE,

PJF_IND_RATE_SCH_B.CREATED_BY CREATED_BY,

PJF_IND_RATE_SCH_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJF_IND_RATE_SCH_B.IND_STRUCTURE_NAME IND_STRUCTURE_NAME,

PJF_IND_RATE_SCH_B.IND_RATE_SCHEDULE_TYPE IND_RATE_SCHEDULE_TYPE,

PJF_IND_RATE_SCH_B.PROJECT_ID PROJECT_ID,

PJF_IND_RATE_SCH_B.TASK_ID TASK_ID,

PJF_IND_RATE_SCH_B.COST_OVR_SCH_FLAG COST_OVR_SCH_FLAG,

PJF_IND_RATE_SCH_B.START_ORGANIZATION_ID START_ORGANIZATION_ID,

PJF_IND_RATE_SCH_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJF_IND_RATE_SCH_B.TREE_VERSION_ID TREE_VERSION_ID,

PJF_IND_RATE_SCH_B.TREE_CODE TREE_CODE,

PJF_IND_RATE_SCH_B.TREE_STRUCTURE_CODE TREE_STRUCTURE_CODE,

PJF_IND_RATE_SCH_B.RECOST_TXN_FLAG RECOST_TXN_FLAG,

PJF_IND_RATE_SCH_B.AWARD_ID AWARD_ID,

PJF_IND_RATE_SCH_B.AWARD_PROJECT_ID AWARD_PROJECT_ID,

PJF_IND_RATE_SCH_B.AWARD_TASK_ID AWARD_TASK_ID

FROM

PJF_IND_RATE_SCH_TL,

PJF_IND_RATE_SCH_B

WHERE

PJF_IND_RATE_SCH_TL.IND_RATE_SCH_ID = PJF_IND_RATE_SCH_B.IND_RATE_SCH_ID AND PJF_IND_RATE_SCH_TL.LANGUAGE = USERENV('LANG')