View: OKE_K_HEADERS_ORGNZR_V

Product:	OKE - Project Contracts
Description:	Contract listing view for Contract Organizer tree
Implementation/DBA Data:	APPS.OKE_K_HEADERS_ORGNZR_V

View Text

SELECT EH.K_HEADER_ID
, EH.K_NUMBER_DISP
, CH.AUTHORING_ORG_ID
, ORG.NAME
, EH.OWNING_ORGANIZATION_ID
, OORG.NAME
, PG.PROGRAM_ID
, PG.PROGRAM_NAME
, PG.PROGRAM_NUMBER
, FL.LOOKUP_CODE
, FL.MEANING
, CL.SHORT_DESCRIPTION
FROM OKC_K_HEADERS_B CH
, OKE_K_HEADERS EH
, OKE_PROGRAMS PG
, FND_LOOKUP_VALUES_VL FL
, HR_ALL_ORGANIZATION_UNITS_TL ORG
, HR_ALL_ORGANIZATION_UNITS_TL OORG
, OKE_K_ALL_ACCESS_BASIC_V ACC
, OKC_K_HEADERS_TL CL
WHERE CH.ID = EH.K_HEADER_ID
AND ACC.K_HEADER_ID = EH.K_HEADER_ID
AND ACC.PERSON_ID = FND_GLOBAL.EMPLOYEE_ID
AND ( OKE_UTILS.CROSS_ORG_ACCESS = 'Y' OR NVL(CH.AUTHORING_ORG_ID
, -99) = OKE_UTILS.ORG_ID )
AND ORG.ORGANIZATION_ID (+) = CH.AUTHORING_ORG_ID
AND ORG.LANGUAGE (+) = USERENV('LANG')
AND OORG.ORGANIZATION_ID (+) = EH.OWNING_ORGANIZATION_ID
AND OORG.LANGUAGE (+) = USERENV('LANG')
AND PG.PROGRAM_ID (+) = EH.PROGRAM_ID
AND FL.VIEW_APPLICATION_ID (+) = 777
AND FL.LOOKUP_TYPE (+) = 'PRODUCT_LINE'
AND FL.LOOKUP_CODE (+) = EH.PRODUCT_LINE_CODE
AND CH.ID = CL.ID
AND CL.LANGUAGE = USERENV('LANG')

Columns