VIEW: APPS.OKC_USER_BINS_V

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')