VIEW: APPS.OKL_UBB_USAGE_ITEMS_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'