VIEW: APPS.OKC_REL_OBJ_QUOTE_LINES_V

Source

View Text - Preformatted

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 ))

View Text - HTML Formatted

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 ))