[Home] [Help]
View: OKC_REL_OBJ_QUOTE_LINES_V
View Text
SELECT QL.LINE_NUMBER LINE_NUMBER
, QL.QUOTE_HEADER_ID QUOTE_HEADER_ID
, SI.DESCRIPTION DESCRIPTION
, QL.QUANTITY QUANTITY
, QL.LINE_QUOTE_PRICE AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.CHR_ID CHR_ID
, SI.NAME ITEM_NAME
, QL.CURRENCY_CODE CURRENCY
FROM OKC_K_LINES_V KL
, OKX_QUOTE_LINES_V QL
, OKC_K_REL_OBJS_V REL
, OKX_SYSTEM_ITEMS_V SI
WHERE QL.ID1 = REL.OBJECT1_ID1
AND (QL.INVENTORY_ITEM_ID = SI.ID1
AND QL.ORGANIZATION_ID = SI.ID2)
AND REL.JTOT_OBJECT1_CODE = 'OKX_QUOTELINE'
AND REL.CLE_ID = KL.ID
AND ( KL.CONFIG_ITEM_TYPE <> 'TOP_MODEL_LINE' OR NOT EXISTS (SELECT 'X'
FROM OKC_K_LINES_V CH
WHERE KL.ID = CH.CLE_ID ))
Columns
Name |
LINE_NUMBER |
QUOTE_HEADER_ID |
DESCRIPTION |
QUANTITY |
AMOUNT |
OBJECT1_ID1 |
CHR_ID |
ITEM_NAME |
CURRENCY |