DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKE_DD250_LINES_V

Object Details
Object Name: OKE_DD250_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKE.OKE_DD250_LINES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


OKE_DD250_LINES_V view gives line information of a DD250 form.
Lines information consists of block 15 to 20 of DD250, including item number (CLIN number), part number and national stock number, quantity, unit of measure, unit price, and amount.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FORM_HEADER_ID NUMBER
Yes Print form header unique identifier
FORM_HEADER_NUMBER VARCHAR2 (80) Yes Print form header number (same as shipment number)
FORM_LINE_NUMBER VARCHAR2 (80) Yes Print form line number
FORM_DATE DATE
Yes Print form date
STATUS_CODE VARCHAR2 (30) Yes Print form line status
K_HEADER_ID NUMBER
Yes Contract header unique identifier
K_LINE_ID NUMBER

Contract line unique identifier
DELIVERABLE_ID NUMBER

Contract deliverable unique identifier
CONTRACT_NUMBER VARCHAR2 (2000)
Contract number
ORDER_NUMBER VARCHAR2 (2000)
Order number
SHIPMENT_NUMBER VARCHAR2 (2000)
Shipment number
LINE_NUMBER VARCHAR2 (2000)
Contract line number (Block 15)
PART_NUMBER VARCHAR2 (2000)
Contractor's part number (for Block 16)
NATIONAL_STOCK_NUMBER VARCHAR2 (2000)
National stock number (for Block 16)
ITEM_DESCRIPTION VARCHAR2 (2000)
Item description (for Block 16)
LINE_DESCRIPTION VARCHAR2 (2000)
Contract line item description (for Block 16)
LINE_COMMENTS VARCHAR2 (2000)
Contract line additional comments (for Block 16)
SHIPMENT_QUANTITY NUMBER

Shipment quantity (Block 17)
UOM_CODE VARCHAR2 (2000)
Unit of measure of shipment quantity (Block 18)
UNIT_PRICE NUMBER

Unit price (Block 19)
AMOUNT NUMBER

Monetary amount of shipment (Block 20)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.OKE_DD250_LINES_V;

Dependencies

[top of page]

APPS.OKE_DD250_LINES_V references the following:

SchemaAPPS
ViewOKE_DD250_HEADERS_V
SynonymOKE_K_FORM_LINES

APPS.OKE_DD250_LINES_V is not referenced by any database object