DBA Data[Home] [Help]

VIEW: APPS.PJM_TASK_WIP_ACCT_CLASSES_V

Source

View Text - Preformatted

SELECT P.ROWID , P.ORGANIZATION_ID , P.PROJECT_ID , P.TASK_ID , T.TASK_NUMBER , T.TASK_NAME , P.CREATION_DATE , P.CREATED_BY , P.LAST_UPDATE_DATE , P.LAST_UPDATED_BY , P.LAST_UPDATE_LOGIN , P.WIP_ACCT_CLASS_CODE , P.EAM_ACCT_CLASS_CODE FROM PJM_TASK_WIP_ACCT_CLASSES P , PA_TASKS T WHERE T.TASK_ID = P.TASK_ID
View Text - HTML Formatted

SELECT P.ROWID
, P.ORGANIZATION_ID
, P.PROJECT_ID
, P.TASK_ID
, T.TASK_NUMBER
, T.TASK_NAME
, P.CREATION_DATE
, P.CREATED_BY
, P.LAST_UPDATE_DATE
, P.LAST_UPDATED_BY
, P.LAST_UPDATE_LOGIN
, P.WIP_ACCT_CLASS_CODE
, P.EAM_ACCT_CLASS_CODE
FROM PJM_TASK_WIP_ACCT_CLASSES P
, PA_TASKS T
WHERE T.TASK_ID = P.TASK_ID