Product: | PV - Partner Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PV_GE_QSNR_ELEMENTS_VL |
SELECT B.ROWID ROW_ID
, B.QSNR_ELEMENT_ID
, B.OBJECT_VERSION_NUMBER
, B.ARC_USED_BY_ENTITY_CODE
, B.USED_BY_ENTITY_ID
, B.ENTITY_ATTR_ID
, B.QSNR_ELMT_SEQ_NUM
, B.QSNR_ELMT_TYPE
, B.QSNR_ELMT_PAGE_NUM
, B.IS_REQUIRED_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, T.ELMT_CONTENT
FROM PV_GE_QSNR_ELEMENTS_B B
, PV_GE_QSNR_ELEMENTS_TL T
WHERE B.QSNR_ELEMENT_ID =T.QSNR_ELEMENT_ID
AND T.LANGUAGE = USERENV('LANG')