[Home] [Help]
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
Name |
K_HEADER_ID |
K_NUMBER |
AUTHORING_ORG_ID |
AUTHORING_ORG |
OWNING_ORGANIZATION_ID |
OWNING_ORGANIZATION |
PROGRAM_ID |
PROGRAM_NAME |
PROGRAM_NUMBER |
PRODUCT_LINE_CODE |
PRODUCT_LINE |
SHORT_DESCRIPTION |