View: OKL_UBB_USAGE_ITEMS_UV

Product:	OKL - Leasing and Finance Management
Description:	User Interface view for usage line definition page
Implementation/DBA Data:	APPS.OKL_UBB_USAGE_ITEMS_UV

View Text

SELECT OKX_USAGE.NAME USAGE_NAME
, OKX_USAGE.DESCRIPTION USAGE_DESCRIPTION
, OKX_PRICE.NAME PRICE_NAME
, OKX_PRICE.DESCRIPTION PRICE_DESCRIPTION
, RUL.RULE_INFORMATION1 MINIMUM_QUANTITY
, RUL.RULE_INFORMATION2 DEFAULT_QUANTITY
, RUL.DNZ_CHR_ID CHR_ID
, RG.CLE_ID LINE_ID
, OKX_USAGE.ORGANIZATION_ID USAGE_ORGANIZATION_ID
, RUL.RGP_ID RGP_ID
, RUL.ID RULE_ID
FROM OKC_RULES_B RUL
, OKC_RULE_GROUPS_B RG
, OKX_SYSTEM_ITEMS_V OKX_USAGE
, OKX_LIST_HEADERS_V OKX_PRICE
, OKC_K_LINES_B CLE
, OKC_LINE_STYLES_B LSE
WHERE RULE_INFORMATION_CATEGORY = 'LAUSBB'
AND RUL.RGP_ID = RG.ID
AND RG.RGD_CODE = 'LAUSBB'
AND OKX_USAGE.USAGE_ITEM_FLAG = 'Y'
AND OKX_USAGE.ID1 = RUL.OBJECT1_ID1
AND TO_CHAR(OKX_USAGE.ID2) = RUL.OBJECT1_ID2
AND OKX_PRICE.LIST_TYPE_CODE = 'PRL'
AND OKX_PRICE.ID1 = RUL.OBJECT2_ID1
AND OKX_PRICE.ID2 = RUL.OBJECT2_ID2
AND CLE.ID = RG.CLE_ID
AND CLE.DNZ_CHR_ID = RG.DNZ_CHR_ID
AND CLE.LSE_ID = LSE.ID
AND LSE.LTY_CODE = 'USAGE'
AND CLE.STS_CODE <> 'ABANDONED'

Columns