[Home] [Help]
View: OKL_BPD_CNTR_PRICE_LIST_UV
View Text
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
Columns
Name |
PRICE_LIST_ID1 |
USAGE_NAME |
USAGE_DESCRIPTION |
PRICE_NAME |
PRICE_DESCRIPTION |
MINIMUM_QUANTITY |
DEFAULT_QUANTITY |
CHR_ID |
LINE_ID |
USAGE_ORGANIZATION_ID |