PJR_RESOURCE_CONDITIONS

Details

Schema: FUSION
Object owner: PJR
Object type: VIEW

Columns

Name
CONDITION_ID ENTERPRISE_ID DISPLAY_NAME DESCRIPTION PERSON_TYPE_CODE JOB_BASED_FLAG SCHEDULING_FLAG PROCESS_ORDER CALENDAR_ID PROJECT_ROLE_ID COST_RATE_CURRENCY_CODE BILL_RATE_CURRENCY_CODE COST_RATE BILL_RATE UNIT_OF_MEASURE LAST_UPDATE_DATE LAST_UPDATED_BY CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER POOL_ID BUSINESS_UNIT_ID ORGANIZATION_ID ENABLE_CONDITION_FLAG INCLUDE_ORG_HIERARCHY TREE_STRUCTURE_CODE TREE_CODE POSITION_ID LOCATION_ID

Name

CONDITION_ID

ENTERPRISE_ID

DISPLAY_NAME

DESCRIPTION

PERSON_TYPE_CODE

JOB_BASED_FLAG

SCHEDULING_FLAG

PROCESS_ORDER

CALENDAR_ID

PROJECT_ROLE_ID

COST_RATE_CURRENCY_CODE

BILL_RATE_CURRENCY_CODE

COST_RATE

BILL_RATE

UNIT_OF_MEASURE

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

POOL_ID

BUSINESS_UNIT_ID

ORGANIZATION_ID

ENABLE_CONDITION_FLAG

INCLUDE_ORG_HIERARCHY

TREE_STRUCTURE_CODE

TREE_CODE

POSITION_ID

LOCATION_ID

Query

SQL_Statement
SELECT PJR_RESOURCE_CONDITIONS_B.CONDITION_ID, PJR_RESOURCE_CONDITIONS_B.ENTERPRISE_ID, PJR_RESOURCE_CONDITIONS_TL.DISPLAY_NAME, PJR_RESOURCE_CONDITIONS_TL.DESCRIPTION, PJR_RESOURCE_CONDITIONS_B.PERSON_TYPE_CODE, PJR_RESOURCE_CONDITIONS_B.JOB_BASED_FLAG, PJR_RESOURCE_CONDITIONS_B.SCHEDULING_FLAG, PJR_RESOURCE_CONDITIONS_B.PROCESS_ORDER, PJR_RESOURCE_CONDITIONS_B.CALENDAR_ID, PJR_RESOURCE_CONDITIONS_B.PROJECT_ROLE_ID, PJR_RESOURCE_CONDITIONS_B.COST_RATE_CURRENCY_CODE, PJR_RESOURCE_CONDITIONS_B.BILL_RATE_CURRENCY_CODE, PJR_RESOURCE_CONDITIONS_B.COST_RATE, PJR_RESOURCE_CONDITIONS_B.BILL_RATE, PJR_RESOURCE_CONDITIONS_B.UNIT_OF_MEASURE, PJR_RESOURCE_CONDITIONS_B.LAST_UPDATE_DATE, PJR_RESOURCE_CONDITIONS_B.LAST_UPDATED_BY, PJR_RESOURCE_CONDITIONS_B.CREATION_DATE, PJR_RESOURCE_CONDITIONS_B.CREATED_BY, PJR_RESOURCE_CONDITIONS_B.LAST_UPDATE_LOGIN, PJR_RESOURCE_CONDITIONS_B.OBJECT_VERSION_NUMBER, PJR_RESOURCE_CONDITIONS_B.POOL_ID, PJR_RESOURCE_CONDITIONS_B.BUSINESS_UNIT_ID, PJR_RESOURCE_CONDITIONS_B.ORGANIZATION_ID, PJR_RESOURCE_CONDITIONS_B.ENABLE_CONDITION_FLAG, PJR_RESOURCE_CONDITIONS_B.INCLUDE_ORG_HIERARCHY, PJR_RESOURCE_CONDITIONS_B.TREE_STRUCTURE_CODE, PJR_RESOURCE_CONDITIONS_B.TREE_CODE, PJR_RESOURCE_CONDITIONS_B.POSITION_ID, PJR_RESOURCE_CONDITIONS_B.LOCATION_ID FROM PJR_RESOURCE_CONDITIONS_TL PJR_RESOURCE_CONDITIONS_TL, PJR_RESOURCE_CONDITIONS_B PJR_RESOURCE_CONDITIONS_B WHERE PJR_RESOURCE_CONDITIONS_B.CONDITION_ID = PJR_RESOURCE_CONDITIONS_TL.CONDITION_ID AND PJR_RESOURCE_CONDITIONS_TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PJR_RESOURCE_CONDITIONS_B.CONDITION_ID,

PJR_RESOURCE_CONDITIONS_B.ENTERPRISE_ID,

PJR_RESOURCE_CONDITIONS_TL.DISPLAY_NAME,

PJR_RESOURCE_CONDITIONS_TL.DESCRIPTION,

PJR_RESOURCE_CONDITIONS_B.PERSON_TYPE_CODE,

PJR_RESOURCE_CONDITIONS_B.JOB_BASED_FLAG,

PJR_RESOURCE_CONDITIONS_B.SCHEDULING_FLAG,

PJR_RESOURCE_CONDITIONS_B.PROCESS_ORDER,

PJR_RESOURCE_CONDITIONS_B.CALENDAR_ID,

PJR_RESOURCE_CONDITIONS_B.PROJECT_ROLE_ID,

PJR_RESOURCE_CONDITIONS_B.COST_RATE_CURRENCY_CODE,

PJR_RESOURCE_CONDITIONS_B.BILL_RATE_CURRENCY_CODE,

PJR_RESOURCE_CONDITIONS_B.COST_RATE,

PJR_RESOURCE_CONDITIONS_B.BILL_RATE,

PJR_RESOURCE_CONDITIONS_B.UNIT_OF_MEASURE,

PJR_RESOURCE_CONDITIONS_B.LAST_UPDATE_DATE,

PJR_RESOURCE_CONDITIONS_B.LAST_UPDATED_BY,

PJR_RESOURCE_CONDITIONS_B.CREATION_DATE,

PJR_RESOURCE_CONDITIONS_B.CREATED_BY,

PJR_RESOURCE_CONDITIONS_B.LAST_UPDATE_LOGIN,

PJR_RESOURCE_CONDITIONS_B.OBJECT_VERSION_NUMBER,

PJR_RESOURCE_CONDITIONS_B.POOL_ID,

PJR_RESOURCE_CONDITIONS_B.BUSINESS_UNIT_ID,

PJR_RESOURCE_CONDITIONS_B.ORGANIZATION_ID,

PJR_RESOURCE_CONDITIONS_B.ENABLE_CONDITION_FLAG,

PJR_RESOURCE_CONDITIONS_B.INCLUDE_ORG_HIERARCHY,

PJR_RESOURCE_CONDITIONS_B.TREE_STRUCTURE_CODE,

PJR_RESOURCE_CONDITIONS_B.TREE_CODE,

PJR_RESOURCE_CONDITIONS_B.POSITION_ID,

PJR_RESOURCE_CONDITIONS_B.LOCATION_ID

FROM

PJR_RESOURCE_CONDITIONS_TL PJR_RESOURCE_CONDITIONS_TL,

PJR_RESOURCE_CONDITIONS_B PJR_RESOURCE_CONDITIONS_B

WHERE

PJR_RESOURCE_CONDITIONS_B.CONDITION_ID = PJR_RESOURCE_CONDITIONS_TL.CONDITION_ID AND PJR_RESOURCE_CONDITIONS_TL.LANGUAGE = USERENV('LANG')