PO_CO_TEMPLATES_VL
Details
-
Schema: FUSION
-
Object owner: PO
-
Object type: VIEW
Columns
Name |
---|
TEMPLATE_ID OBJECT_VERSION_NUMBER LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATION_DATE CREATED_BY TYPE_LOOKUP_CODE SEEDED_TEMPLATE_ID STATUS DESCRIPTION TEMPLATE_NAME CO_TEMPLATE_CODE |
Query
SQL_Statement |
---|
SELECT B.TEMPLATE_ID TEMPLATE_ID, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.CREATION_DATE CREATION_DATE, B.CREATED_BY CREATED_BY, B.TYPE_LOOKUP_CODE TYPE_LOOKUP_CODE, B.SEEDED_TEMPLATE_ID SEEDED_TEMPLATE_ID, B.STATUS STATUS, T.DESCRIPTION DESCRIPTION, T.TEMPLATE_NAME TEMPLATE_NAME, B.CO_TEMPLATE_CODE CO_TEMPLATE_CODE FROM PO_CO_TEMPLATES_B B, PO_CO_TEMPLATES_TL T WHERE B.TEMPLATE_ID = T.TEMPLATE_ID AND T.LANGUAGE = USERENV('LANG') |