POQ_ACTION_PLANS_VL
Details
-
Schema: FUSION
-
Object owner: POQ
-
Object type: VIEW
Columns
Name |
---|
ACTION_PLAN_ID TITLE DESCRIPTION PLAN_STATUS_CODE TEMPLATE_FLAG PRC_BU_ID OWNER_PERSON_ID QUALIFICATION_ID TASK_STATUS_CHNG_NOTIF_FLAG PLAN_TEMPLATE_ID PLAN_DUE_DATE SUPPLIER_ID SUPPLIER_SITE_ID OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN |
Query
SQL_Statement |
---|
SELECT B.ACTION_PLAN_ID, T.TITLE, T.DESCRIPTION, B.PLAN_STATUS_CODE, B.TEMPLATE_FLAG, B.PRC_BU_ID, B.OWNER_PERSON_ID, B.QUALIFICATION_ID, B.TASK_STATUS_CHNG_NOTIF_FLAG, B.PLAN_TEMPLATE_ID, B.PLAN_DUE_DATE, B.SUPPLIER_ID, B.SUPPLIER_SITE_ID, B.OBJECT_VERSION_NUMBER, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM POQ_ACTION_PLANS_B B, POQ_ACTION_PLANS_TL T WHERE T.ACTION_PLAN_ID = B.ACTION_PLAN_ID AND T.LANGUAGE = USERENV('LANG') |