[Home] [Help]
View: OKC_REL_OBJ_PO_LINES_V
Product: | OKC - Contracts Core |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT POL.LINE_NUM LINE_NUMBER
, POL.PO_HEADER_ID PO_HEADER_ID
, SI.DESCRIPTION DESCRIPTION
, POL.QUANTITY QUANTITY
, POL.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, POL.UNIT_PRICE UNIT_PRICE
, POL.UNIT_PRICE*POL.QUANTITY AMOUNT
, REL.OBJECT1_ID1 OBJECT1_ID1
, REL.CHR_ID CHR_ID
, SI.NAME ITEM_NAME
FROM OKC_K_REL_OBJS_V REL
, OKX_SYSTEM_ITEMS_V SI
, OKX_PO_LINES_V POL
WHERE POL.ID1 = REL.OBJECT1_ID1
AND REL.RTY_CODE = 'CONTRACTCREATESPO'
AND (POL.ITEM_ID = SI.ID1
AND POL.ORG_ID = SI.ID2)
AND REL.JTOT_OBJECT1_CODE = 'OKX_PO_LINES'
Columns
Name |
LINE_NUMBER |
PO_HEADER_ID |
DESCRIPTION |
QUANTITY |
LIST_PRICE_PER_UNIT |
UNIT_PRICE |
AMOUNT |
OBJECT1_ID1 |
CHR_ID |
ITEM_NAME |