eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[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