[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKE_DD250_HEADERS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  OKE.OKE_DD250_HEADERS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
OKE_DD250_HEADERS_V view gives header information of a US Department of Defense DD250 form.
Header information consists of blocks 1 to 14, 21 and 23 of DD250, including contract number (and order number, if applicable), shipment number, shipment date, ship-to / mark for / paid-from locations and addressed (and corresponding CAGE/DoDAAD codes), and so on.
| 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_DATE | DATE | Yes | Print form date | |
| STATUS_CODE | VARCHAR2 | (30) | Yes | Print form 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 (Block 1) | |
| ORDER_NUMBER | VARCHAR2 | (2000) | Order number (Block 1) | |
| SHIPMENT_NUMBER | VARCHAR2 | (2000) | Shipment number (Block 2) | |
| SHIPMENT_DATE | DATE | Shipment date (Block 3) | ||
| BILL_OF_LADING_NUMBER | VARCHAR2 | (2000) | Bill of lading number (Block 4) | |
| TRANSPORT_CONTROL_NUM | VARCHAR2 | (2000) | Transportation control number (Block 4) | |
| SHIP_METHOD | VARCHAR2 | (2000) | Shipment Method (Block 4) | |
| DISCOUNT_TERMS | VARCHAR2 | (2000) | Discounted terms (Block 5) | |
| INVOICE_DATE | DATE | Invoice date (Block 6) | ||
| ACCEPTANCE_POINT | VARCHAR2 | (2000) | Acceptance point (Block 8) | |
| ACCEPTANCE_METHOD | VARCHAR2 | (2000) | Acceptance Method | |
| INSPECTION_POINT | VARCHAR2 | (2000) | Inspection Point (Block21 CQA) | |
| PRIME_CONTRACTOR_NAME | VARCHAR2 | (80) | Prime contractor name (Block 9) | |
| PRIME_CONTRACTOR_ADDRESS1 | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_ADDRESS2 | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_ADDRESS3 | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_ADDRESS4 | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_CITY | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_STATE | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_ZIP | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_COUNTRY | VARCHAR2 | (80) | Prime contractor address (Block 9) | |
| PRIME_CONTRACTOR_CODE | VARCHAR2 | (2000) | CAGE code of prime contractor (Block 9) | |
| ADMIN_BY_NAME | VARCHAR2 | (80) | Contract Administration Office name (Block 10) | |
| ADMIN_BY_ADDRESS1 | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_ADDRESS2 | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_ADDRESS3 | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_ADDRESS4 | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_CITY | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_STATE | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_ZIP | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_COUNTRY | VARCHAR2 | (80) | Contract Administration Office address (Block 10) | |
| ADMIN_BY_CODE | VARCHAR2 | (2000) | CAGE/DODAAD code of Contract Administration Office (Block 10) | |
| SHIPPED_FROM_NAME | VARCHAR2 | (80) | Shipped from location (Block 11) | |
| SHIPPED_FROM_ADDRESS1 | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_ADDRESS2 | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_ADDRESS3 | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_ADDRESS4 | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_CITY | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_STATE | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_ZIP | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_COUNTRY | VARCHAR2 | (80) | Shipped from location address (Block 11) | |
| SHIPPED_FROM_CODE | VARCHAR2 | (2000) | CAGE code of shipped from location (Block 11) | |
| FOB | VARCHAR2 | (2000) | Freight on board (Block 11) | |
| PAID_BY_NAME | VARCHAR2 | (80) | Payment office name (Block 12) | |
| PAID_BY_ADDRESS1 | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_ADDRESS2 | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_ADDRESS3 | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_ADDRESS4 | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_CITY | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_STATE | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_ZIP | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_COUNTRY | VARCHAR2 | (80) | Payment office address (Block 12) | |
| PAID_BY_CODE | VARCHAR2 | (2000) | CAGE/DODAAD code of payment office (Block 12) | |
| SHIPPED_TO_NAME | VARCHAR2 | (80) | Shipped to location (Block 13) | |
| SHIPPED_TO_ADDRESS1 | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_ADDRESS2 | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_ADDRESS3 | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_ADDRESS4 | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_CITY | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_STATE | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_ZIP | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_COUNTRY | VARCHAR2 | (80) | Shipped to address (Block 13) | |
| SHIPPED_TO_CODE | VARCHAR2 | (2000) | CASE/DODAAD code of shipped to address (Block 13) | |
| MARKED_FOR_NAME | VARCHAR2 | (80) | Mark For / final destination name (Block 14) | |
| MARKED_FOR_ADDRESS1 | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_ADDRESS2 | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_ADDRESS3 | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_ADDRESS4 | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_CITY | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_STATE | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_ZIP | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_COUNTRY | VARCHAR2 | (80) | Mark For / final destination address (Block 14) | |
| MARKED_FOR_CODE | VARCHAR2 | (2000) | CASE/DODAAD code of final destination (Block 14) | |
| GROSS_WEIGHT | NUMBER | Gross weight of shipment (Block 16) | ||
| NET_WEIGHT | NUMBER | Net weight of shipment | ||
| WEIGHT_UOM_CODE | VARCHAR2 | (2000) | Weight unit of measure | |
| VOLUME | NUMBER | Volume of shipment (Block 16) | ||
| VOLUME_UOM_CODE | VARCHAR2 | (2000) | Volume unit of measure | |
| NUMBER_OF_CONTAINERS | NUMBER | Number of containers (Block 16) | ||
| COMMENTS | VARCHAR2 | (2000) | Contractor's comments (Block 23) |
Cut, paste (and edit) the following text to query this object:
SELECT FORM_HEADER_ID
, FORM_HEADER_NUMBER
, FORM_DATE
, STATUS_CODE
, K_HEADER_ID
, K_LINE_ID
, DELIVERABLE_ID
, CONTRACT_NUMBER
, ORDER_NUMBER
, SHIPMENT_NUMBER
, SHIPMENT_DATE
, BILL_OF_LADING_NUMBER
, TRANSPORT_CONTROL_NUM
, SHIP_METHOD
, DISCOUNT_TERMS
, INVOICE_DATE
, ACCEPTANCE_POINT
, ACCEPTANCE_METHOD
, INSPECTION_POINT
, PRIME_CONTRACTOR_NAME
, PRIME_CONTRACTOR_ADDRESS1
, PRIME_CONTRACTOR_ADDRESS2
, PRIME_CONTRACTOR_ADDRESS3
, PRIME_CONTRACTOR_ADDRESS4
, PRIME_CONTRACTOR_CITY
, PRIME_CONTRACTOR_STATE
, PRIME_CONTRACTOR_ZIP
, PRIME_CONTRACTOR_COUNTRY
, PRIME_CONTRACTOR_CODE
, ADMIN_BY_NAME
, ADMIN_BY_ADDRESS1
, ADMIN_BY_ADDRESS2
, ADMIN_BY_ADDRESS3
, ADMIN_BY_ADDRESS4
, ADMIN_BY_CITY
, ADMIN_BY_STATE
, ADMIN_BY_ZIP
, ADMIN_BY_COUNTRY
, ADMIN_BY_CODE
, SHIPPED_FROM_NAME
, SHIPPED_FROM_ADDRESS1
, SHIPPED_FROM_ADDRESS2
, SHIPPED_FROM_ADDRESS3
, SHIPPED_FROM_ADDRESS4
, SHIPPED_FROM_CITY
, SHIPPED_FROM_STATE
, SHIPPED_FROM_ZIP
, SHIPPED_FROM_COUNTRY
, SHIPPED_FROM_CODE
, FOB
, PAID_BY_NAME
, PAID_BY_ADDRESS1
, PAID_BY_ADDRESS2
, PAID_BY_ADDRESS3
, PAID_BY_ADDRESS4
, PAID_BY_CITY
, PAID_BY_STATE
, PAID_BY_ZIP
, PAID_BY_COUNTRY
, PAID_BY_CODE
, SHIPPED_TO_NAME
, SHIPPED_TO_ADDRESS1
, SHIPPED_TO_ADDRESS2
, SHIPPED_TO_ADDRESS3
, SHIPPED_TO_ADDRESS4
, SHIPPED_TO_CITY
, SHIPPED_TO_STATE
, SHIPPED_TO_ZIP
, SHIPPED_TO_COUNTRY
, SHIPPED_TO_CODE
, MARKED_FOR_NAME
, MARKED_FOR_ADDRESS1
, MARKED_FOR_ADDRESS2
, MARKED_FOR_ADDRESS3
, MARKED_FOR_ADDRESS4
, MARKED_FOR_CITY
, MARKED_FOR_STATE
, MARKED_FOR_ZIP
, MARKED_FOR_COUNTRY
, MARKED_FOR_CODE
, GROSS_WEIGHT
, NET_WEIGHT
, WEIGHT_UOM_CODE
, VOLUME
, VOLUME_UOM_CODE
, NUMBER_OF_CONTAINERS
, COMMENTS
FROM APPS.OKE_DD250_HEADERS_V;
APPS
OKE_K_FORM_HEADERS
APPS
OKE_DD250_LINES_V
|
|
|
|