VIEW: APPS.OKE_K_HEADERS_ORGNZR_V

Source

View Text - Preformatted

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 , ( SELECT K_HEADER_ID K_HDR_ID , OKE_K_SECURITY_PKG.GET_K_ACCESS( K_HEADER_ID ) K_ACCESS FROM OKE_K_HEADERS ) ACC , OKC_K_HEADERS_TL CL WHERE CH.ID = EH.K_HEADER_ID AND ACC.K_HDR_ID = CH.ID AND ACC.K_ACCESS IN ( 'EDIT' , 'VIEW' ) 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')

View Text - HTML Formatted

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
, ( SELECT K_HEADER_ID K_HDR_ID
, OKE_K_SECURITY_PKG.GET_K_ACCESS( K_HEADER_ID ) K_ACCESS
FROM OKE_K_HEADERS ) ACC
, OKC_K_HEADERS_TL CL
WHERE CH.ID = EH.K_HEADER_ID
AND ACC.K_HDR_ID = CH.ID
AND ACC.K_ACCESS IN ( 'EDIT'
, 'VIEW' )
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')