FND Design Data [Home] [Help]

View: OKC_ITEM_PARTYS_V

Product: OKC - Contracts Core
Description: View for table OKC_ITEM_PARTYS_B
Implementation/DBA Data: ViewAPPS.OKC_ITEM_PARTYS_V
View Text

SELECT IPYB.ROWID ROW_ID
, IPYB.ID ID
, IPYB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, IPYT.SFWT_FLAG SFWT_FLAG
, IPYB.CIM_ID CIM_ID
, IPYB.CPL_ID CPL_ID
, IPYB.DNZ_CHR_ID DNZ_CHR_ID
, IPYT.ALIAS ALIAS
, IPYT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, IPYT.DESCRIPTION DESCRIPTION
, IPYT.COMMENTS COMMENTS
, IPYB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, IPYB.ATTRIBUTE1 ATTRIBUTE1
, IPYB.ATTRIBUTE2 ATTRIBUTE2
, IPYB.ATTRIBUTE3 ATTRIBUTE3
, IPYB.ATTRIBUTE4 ATTRIBUTE4
, IPYB.ATTRIBUTE5 ATTRIBUTE5
, IPYB.ATTRIBUTE6 ATTRIBUTE6
, IPYB.ATTRIBUTE7 ATTRIBUTE7
, IPYB.ATTRIBUTE8 ATTRIBUTE8
, IPYB.ATTRIBUTE9 ATTRIBUTE9
, IPYB.ATTRIBUTE10 ATTRIBUTE10
, IPYB.ATTRIBUTE11 ATTRIBUTE11
, IPYB.ATTRIBUTE12 ATTRIBUTE12
, IPYB.ATTRIBUTE13 ATTRIBUTE13
, IPYB.ATTRIBUTE14 ATTRIBUTE14
, IPYB.ATTRIBUTE15 ATTRIBUTE15
, IPYB.CREATED_BY CREATED_BY
, IPYB.CREATION_DATE CREATION_DATE
, IPYB.LAST_UPDATED_BY LAST_UPDATED_BY
, IPYB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPYB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKC_ITEM_PARTYS_B IPYB
, OKC_ITEM_PARTYS_TL IPYT
WHERE IPYB.ID = IPYT.ID
AND IPYT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
CIM_ID
CPL_ID
DNZ_CHR_ID
ALIAS
SHORT_DESCRIPTION
DESCRIPTION
COMMENTS
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN