VIEW: APPS.OKE_HOLD_LINES_V

Source

View Text - Preformatted

SELECT CL.ROWID , CL.DNZ_CHR_ID , CL.ID , CL.LINE_NUMBER , CL.START_DATE , CL.CREATED_BY , CL.CREATION_DATE , CL.LAST_UPDATED_BY , CL.LAST_UPDATE_LOGIN , CL.LAST_UPDATE_DATE , CLT.ITEM_DESCRIPTION FROM OKC_K_LINES_B CL , OKE_K_LINES EL , OKC_K_LINES_TL CLT WHERE CL.ID = EL.K_LINE_ID AND CL.ID = CLT.ID AND CLT.LANGUAGE = USERENV('LANG') AND OKE_CHECK_HOLD_PKG.is_hold('LINE',CL.DNZ_CHR_ID,CL.ID,NULL) = 0

View Text - HTML Formatted

SELECT CL.ROWID
, CL.DNZ_CHR_ID
, CL.ID
, CL.LINE_NUMBER
, CL.START_DATE
, CL.CREATED_BY
, CL.CREATION_DATE
, CL.LAST_UPDATED_BY
, CL.LAST_UPDATE_LOGIN
, CL.LAST_UPDATE_DATE
, CLT.ITEM_DESCRIPTION
FROM OKC_K_LINES_B CL
, OKE_K_LINES EL
, OKC_K_LINES_TL CLT
WHERE CL.ID = EL.K_LINE_ID
AND CL.ID = CLT.ID
AND CLT.LANGUAGE = USERENV('LANG')
AND OKE_CHECK_HOLD_PKG.IS_HOLD('LINE'
, CL.DNZ_CHR_ID
, CL.ID
, NULL) = 0