VIEW: APPS.OKL_BPD_CNTR_PRICE_LIST_UV

Source

View Text - Preformatted

SELECT OKX_PRICE.ID1 PRICE_LIST_ID1, 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 FROM OKC_RULES_B RUL,OKC_RULE_GROUPS_B RG,OKX_SYSTEM_ITEMS_V OKX_USAGE,OKX_LIST_HEADERS_V OKX_PRICE WHERE RG.RGD_CODE = 'LAUSBB' AND RULE_INFORMATION_CATEGORY = 'LAUSBB' AND RUL.RGP_ID = RG.ID 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

View Text - HTML Formatted

SELECT OKX_PRICE.ID1 PRICE_LIST_ID1
, 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
FROM OKC_RULES_B RUL
, OKC_RULE_GROUPS_B RG
, OKX_SYSTEM_ITEMS_V OKX_USAGE
, OKX_LIST_HEADERS_V OKX_PRICE
WHERE RG.RGD_CODE = 'LAUSBB'
AND RULE_INFORMATION_CATEGORY = 'LAUSBB'
AND RUL.RGP_ID = RG.ID
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