[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 |