[Home] [Help]
View: OKC_REL_OBJ_OPP_LINES_V
View Text
SELECT OL.ID1 LINE_NUMBER
, OL.OPP_HEADER_ID OPP_HEADER_ID
, SI.DESCRIPTION DESCRIPTION
, OL.QUANTITY QUANTITY
, OL.TOTAL_AMOUNT AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.CHR_ID CHR_ID
, SI.NAME ITEM_NAME
FROM OKX_OPP_LINES_V OL
, OKC_K_REL_OBJS_V REL
, OKX_SYSTEM_ITEMS_V SI
WHERE OL.ID1 = REL.OBJECT1_ID1
AND (OL.INVENTORY_ITEM_ID = SI.ID1
AND OL.ORGANIZATION_ID = SI.ID2)AND REL.JTOT_OBJECT1_CODE = 'OKX_OPPLINES'
Columns
| Name |
| LINE_NUMBER |
| OPP_HEADER_ID |
| DESCRIPTION |
| QUANTITY |
| AMOUNT |
| OBJECT1_ID1 |
| CHR_ID |
| ITEM_NAME |
APPS.OKC_REL_OBJ_OPP_LINES_V