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')