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: OKX_PO_LINES_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT POL.PO_LINE_ID ID1
, '#' ID2
, NULL NAME
, NULL DESCRIPTION
, POL.PO_HEADER_ID PO_HEADER_ID
, POL.LINE_TYPE_ID LINE_TYPE_ID
, POL.LINE_NUM LINE_NUM
, POL.ITEM_ID ITEM_ID
, POL.ITEM_REVISION ITEM_REVISION
, POL.CATEGORY_ID CATEGORY_ID
, POL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE UNIT_MEAS_LOOKUP_CODE
, POL.LIST_PRICE_PER_UNIT LIST_PRICE_PER_UNIT
, POL.UNIT_PRICE UNIT_PRICE
, POL.QUANTITY QUANTITY
, POL.UNORDERED_FLAG UNORDERED_FLAG
, POL.CLOSED_FLAG CLOSED_FLAG
, POL.USER_HOLD_FLAG USER_HOLD_FLAG
, POL.CANCEL_FLAG CANCEL_FLAG
, POL.CANCEL_DATE CANCEL_DATE
, POL.CLOSED_DATE CLOSED_DATE
, POL.ORG_ID ORG_ID
FROM PO_LINES_ALL POL

Columns

Name
ID1
ID2
NAME
DESCRIPTION
PO_HEADER_ID
LINE_TYPE_ID
LINE_NUM
ITEM_ID
ITEM_REVISION
CATEGORY_ID
ITEM_DESCRIPTION
UNIT_MEAS_LOOKUP_CODE
LIST_PRICE_PER_UNIT
UNIT_PRICE
QUANTITY
UNORDERED_FLAG
CLOSED_FLAG
USER_HOLD_FLAG
CANCEL_FLAG
CANCEL_DATE
CLOSED_DATE
ORG_ID