POR_MAP_SET_HEADERS_ALL

Details

Schema: FUSION
Object owner: POR
Object type: VIEW

Columns

Name
MAP_SET_ID PRC_BU_ID DEFAULT_MAP_SET_FLAG MAP_SET_NAME DESCRIPTION CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Name

MAP_SET_ID

PRC_BU_ID

DEFAULT_MAP_SET_FLAG

MAP_SET_NAME

DESCRIPTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

Query

SQL_Statement
SELECT POR_MAP_SET_HEADERS_ALL_B.MAP_SET_ID MAP_SET_ID, POR_MAP_SET_HEADERS_ALL_B.PRC_BU_ID PRC_BU_ID, POR_MAP_SET_HEADERS_ALL_B.DEFAULT_MAP_SET_FLAG DEFAULT_MAP_SET_FLAG, POR_MAP_SET_HEADERS_ALL_TL.MAP_SET_NAME MAP_SET_NAME, POR_MAP_SET_HEADERS_ALL_TL.DESCRIPTION DESCRIPTION, POR_MAP_SET_HEADERS_ALL_B.CREATED_BY CREATED_BY, POR_MAP_SET_HEADERS_ALL_B.CREATION_DATE CREATION_DATE, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POR_MAP_SET_HEADERS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM POR_MAP_SET_HEADERS_ALL_B, POR_MAP_SET_HEADERS_ALL_TL WHERE POR_MAP_SET_HEADERS_ALL_TL.MAP_SET_ID = POR_MAP_SET_HEADERS_ALL_B.MAP_SET_ID and POR_MAP_SET_HEADERS_ALL_TL.LANGUAGE= userenv('LANG')

SQL_Statement

SELECT POR_MAP_SET_HEADERS_ALL_B.MAP_SET_ID MAP_SET_ID, POR_MAP_SET_HEADERS_ALL_B.PRC_BU_ID PRC_BU_ID, POR_MAP_SET_HEADERS_ALL_B.DEFAULT_MAP_SET_FLAG DEFAULT_MAP_SET_FLAG, POR_MAP_SET_HEADERS_ALL_TL.MAP_SET_NAME MAP_SET_NAME, POR_MAP_SET_HEADERS_ALL_TL.DESCRIPTION DESCRIPTION, POR_MAP_SET_HEADERS_ALL_B.CREATED_BY CREATED_BY, POR_MAP_SET_HEADERS_ALL_B.CREATION_DATE CREATION_DATE, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATED_BY LAST_UPDATED_BY, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, POR_MAP_SET_HEADERS_ALL_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, POR_MAP_SET_HEADERS_ALL_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER FROM POR_MAP_SET_HEADERS_ALL_B, POR_MAP_SET_HEADERS_ALL_TL WHERE POR_MAP_SET_HEADERS_ALL_TL.MAP_SET_ID = POR_MAP_SET_HEADERS_ALL_B.MAP_SET_ID and POR_MAP_SET_HEADERS_ALL_TL.LANGUAGE= userenv('LANG')