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

Product:	OKE - Project Contracts
Description:	Form DD250 stored line information view
Implementation/DBA Data:	APPS.OKE_DD250_LINES_V

View Text

SELECT L.FORM_HEADER_ID
, H.FORM_HEADER_NUMBER
, L.FORM_LINE_NUMBER
, H.FORM_DATE
, H.STATUS_CODE
, H.K_HEADER_ID
, H.K_LINE_ID
, H.DELIVERABLE_ID
, H.CONTRACT_NUMBER
, H.ORDER_NUMBER
, H.SHIPMENT_NUMBER
, L.TEXT01
, L.TEXT02
, L.TEXT04
, L.TEXT05
, L.TEXT06
, L.TEXT07
, L.NUMBER01
, L.TEXT03
, L.NUMBER02
, L.NUMBER03
FROM OKE_K_FORM_LINES L
, OKE_DD250_HEADERS_V H
WHERE L.FORM_HEADER_ID = H.FORM_HEADER_ID

Columns

Name
FORM_HEADER_ID
FORM_HEADER_NUMBER
FORM_LINE_NUMBER
FORM_DATE
STATUS_CODE
K_HEADER_ID
K_LINE_ID
DELIVERABLE_ID
CONTRACT_NUMBER
ORDER_NUMBER
SHIPMENT_NUMBER
LINE_NUMBER
PART_NUMBER
NATIONAL_STOCK_NUMBER
ITEM_DESCRIPTION
LINE_DESCRIPTION
LINE_COMMENTS
SHIPMENT_QUANTITY
UOM_CODE
UNIT_PRICE
AMOUNT