PJT_PROJ_REF_OBJECT

Details

Schema: FUSION
Object owner: PJT
Object type: VIEW

Columns

Name
REF_OBJECT_ID REF_OBJECT_TYPE REF_PROJECT_ID OPPORTUNITY_ID OPPORTUNITY_NUMBER OPPORTUNITY_ALT_NUMBER OPPORTUNITY_CUSTOMER_NUMBER OPPORTUNITY_CUSTOMER_ID OPPORTUNITY_AMOUNT OPPORTUNITY_CURRENCY_CODE OPPORTUNITY_WIN_CONF_PERCENT OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OPPORTUNITY_NAME OPPORTUNITY_DESCRIPTION OPPORTUNITY_CUSTOMER_NAME OPPORTUNITY_STATUS

Name

REF_OBJECT_ID

REF_OBJECT_TYPE

REF_PROJECT_ID

OPPORTUNITY_ID

OPPORTUNITY_NUMBER

OPPORTUNITY_ALT_NUMBER

OPPORTUNITY_CUSTOMER_NUMBER

OPPORTUNITY_CUSTOMER_ID

OPPORTUNITY_AMOUNT

OPPORTUNITY_CURRENCY_CODE

OPPORTUNITY_WIN_CONF_PERCENT

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OPPORTUNITY_NAME

OPPORTUNITY_DESCRIPTION

OPPORTUNITY_CUSTOMER_NAME

OPPORTUNITY_STATUS

Query

SQL_Statement
SELECT PJT_PROJ_REF_OBJECT_B.REF_OBJECT_ID REF_OBJECT_ID, PJT_PROJ_REF_OBJECT_B.REF_OBJECT_TYPE REF_OBJECT_TYPE, PJT_PROJ_REF_OBJECT_B.REF_PROJECT_ID REF_PROJECT_ID, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_ID OPPORTUNITY_ID, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_NUMBER OPPORTUNITY_NUMBER, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_ALT_NUMBER OPPORTUNITY_ALT_NUMBER, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CUSTOMER_NUMBER OPPORTUNITY_CUSTOMER_NUMBER, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CUSTOMER_ID OPPORTUNITY_CUSTOMER_ID, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_AMOUNT OPPORTUNITY_AMOUNT, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CURRENCY_CODE OPPORTUNITY_CURRENCY_CODE, PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_WIN_CONF_PERCENT OPPORTUNITY_WIN_CONF_PERCENT, PJT_PROJ_REF_OBJECT_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, PJT_PROJ_REF_OBJECT_B.CREATED_BY CREATED_BY, PJT_PROJ_REF_OBJECT_B.CREATION_DATE CREATION_DATE, PJT_PROJ_REF_OBJECT_B.LAST_UPDATED_BY LAST_UPDATED_BY, PJT_PROJ_REF_OBJECT_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, PJT_PROJ_REF_OBJECT_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_NAME OPPORTUNITY_NAME, PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_DESCRIPTION OPPORTUNITY_DESCRIPTION, PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_CUSTOMER_NAME OPPORTUNITY_CUSTOMER_NAME, PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_STATUS OPPORTUNITY_STATUS FROM PJT_PROJ_REF_OBJECT_B, PJT_PROJ_REF_OBJECT_TL WHERE PJT_PROJ_REF_OBJECT_B.REF_OBJECT_ID = PJT_PROJ_REF_OBJECT_TL.REF_OBJECT_ID AND LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

PJT_PROJ_REF_OBJECT_B.REF_OBJECT_ID REF_OBJECT_ID,

PJT_PROJ_REF_OBJECT_B.REF_OBJECT_TYPE REF_OBJECT_TYPE,

PJT_PROJ_REF_OBJECT_B.REF_PROJECT_ID REF_PROJECT_ID,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_ID OPPORTUNITY_ID,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_NUMBER OPPORTUNITY_NUMBER,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_ALT_NUMBER OPPORTUNITY_ALT_NUMBER,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CUSTOMER_NUMBER OPPORTUNITY_CUSTOMER_NUMBER,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CUSTOMER_ID OPPORTUNITY_CUSTOMER_ID,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_AMOUNT OPPORTUNITY_AMOUNT,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_CURRENCY_CODE OPPORTUNITY_CURRENCY_CODE,

PJT_PROJ_REF_OBJECT_B.OPPORTUNITY_WIN_CONF_PERCENT OPPORTUNITY_WIN_CONF_PERCENT,

PJT_PROJ_REF_OBJECT_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

PJT_PROJ_REF_OBJECT_B.CREATED_BY CREATED_BY,

PJT_PROJ_REF_OBJECT_B.CREATION_DATE CREATION_DATE,

PJT_PROJ_REF_OBJECT_B.LAST_UPDATED_BY LAST_UPDATED_BY,

PJT_PROJ_REF_OBJECT_B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

PJT_PROJ_REF_OBJECT_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_NAME OPPORTUNITY_NAME,

PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_DESCRIPTION OPPORTUNITY_DESCRIPTION,

PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_CUSTOMER_NAME OPPORTUNITY_CUSTOMER_NAME,

PJT_PROJ_REF_OBJECT_TL.OPPORTUNITY_STATUS OPPORTUNITY_STATUS

FROM

PJT_PROJ_REF_OBJECT_B,

PJT_PROJ_REF_OBJECT_TL

WHERE

PJT_PROJ_REF_OBJECT_B.REF_OBJECT_ID = PJT_PROJ_REF_OBJECT_TL.REF_OBJECT_ID AND LANGUAGE = USERENV('LANG')