QP_PB_PUBLICATIONS_VL

Details

• Schema: FUSION

• Object owner: QP

• Object type: VIEW

Columns

Name
PB_PUBLICATION_ID NAME DESCRIPTION PRICE_BOOK_ID PUBLICATION_DATE PUBLICATION_FORMAT DIMENSION_CRITERIA PRODUCT_CRITERIA PRICE_BOOK_REQUEST_ID DOCUMENT_ID STATUS_CODE CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER CREATION_METHOD LAST_UPDATE_METHOD

Query

SQL_Statement

SELECT QP_PB_PUBLICATIONS_B.PB_PUBLICATION_ID PB_PUBLICATION_ID, QP_PB_PUBLICATIONS_TL.NAME NAME, QP_PB_PUBLICATIONS_TL.DESCRIPTION DESCRIPTION, QP_PB_PUBLICATIONS_B.PRICE_BOOK_ID PRICE_BOOK_ID, QP_PB_PUBLICATIONS_B.PUBLICATION_DATE PUBLICATION_DATE, QP_PB_PUBLICATIONS_B.PUBLICATION_FORMAT PUBLICATION_FORMAT, QP_PB_PUBLICATIONS_B.DIMENSION_CRITERIA DIMENSION_CRITERIA, QP_PB_PUBLICATIONS_B.PRODUCT_CRITERIA PRODUCT_CRITERIA, QP_PB_PUBLICATIONS_B.PRICE_BOOK_REQUEST_ID PRICE_BOOK_REQUEST_ID, QP_PB_PUBLICATIONS_B.DOCUMENT_ID DOCUMENT_ID, QP_PB_PUBLICATIONS_B.STATUS_CODE STATUS_CODE, QP_PB_PUBLICATIONS_B.CREATION_DATE CREATION_DATE, QP_PB_PUBLICATIONS_B.CREATED_BY CREATED_BY, QP_PB_PUBLICATIONS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_PB_PUBLICATIONS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_PB_PUBLICATIONS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_PB_PUBLICATIONS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_PB_PUBLICATIONS_B.CREATION_METHOD CREATION_METHOD, QP_PB_PUBLICATIONS_B.LAST_UPDATE_METHOD LAST_UPDATE_METHOD FROM QP_PB_PUBLICATIONS_B, QP_PB_PUBLICATIONS_TL WHERE QP_PB_PUBLICATIONS_B.PB_PUBLICATION_ID = QP_PB_PUBLICATIONS_TL.PB_PUBLICATION_ID AND QP_PB_PUBLICATIONS_TL.LANGUAGE = USERENV('LANG')