View: OKC_USER_BINS_V

Product:	OKC - Contracts Core
Description:	View for Table OKC_USER_BINS
Implementation/DBA Data:	APPS.OKC_USER_BINS_V

View Text

SELECT UBN.ROWID ROW_ID
, UBN.ID ID
, UBN.CONTRACT_ID CONTRACT_ID
, UBN.CONTRACT_NUMBER CONTRACT_NUMBER
, UBN.BIN_TYPE BIN_TYPE
, UBN.CONTRACT_TYPE CONTRACT_TYPE
, UBN.PROGRAM_NAME PROGRAM_NAME
, UBN.CREATED_BY CREATED_BY
, UBN.CREATION_DATE CREATION_DATE
, UBN.CONTRACT_NUMBER_MODIFIER CONTRACT_NUMBER_MODIFIER
, CHRT.SHORT_DESCRIPTION SHORT_DESCRIPTION
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, CHRB.ORG_ID ORG_ID
, HR.NAME OPERATING_UNIT
FROM OKC_USER_BINS UBN
, OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, HR_ALL_ORGANIZATION_UNITS_TL HR
WHERE UBN.CONTRACT_ID = CHRB.ID
AND CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND HR.ORGANIZATION_ID = CHRB.ORG_ID
AND HR.LANGUAGE = USERENV('LANG')

Columns