View: OKE_DD250_HEADERS_V

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

View Text

SELECT FORM_HEADER_ID
, FORM_HEADER_NUMBER
, FORM_DATE
, STATUS_CODE
, K_HEADER_ID
, K_LINE_ID
, DELIVERABLE_ID
, TEXT01 CONTRACT_NUMBER
, TEXT02 ORDER_NUMBER
, TEXT03 SHIPMENT_NUMBER
, DATE01 SHIPMENT_DATE
, TEXT04 BILL_OF_LADING_NUMBER
, TEXT05 TRANSPORT_CONTROL_NUM
, TEXT26 SHIP_METHOD
, TEXT06 DISCOUNT_TERMS
, DATE02 INVOICE_DATE
, TEXT07 ACCEPTANCE_POINT
, TEXT21 ACCEPTANCE_METHOD
, TEXT22 INSPECTION_POINT
, RTRIM( SUBSTR(TEXT08
, 1
, 80) ) PRIME_CONTRACTOR_NAME
, RTRIM( SUBSTR(TEXT08
, 81
, 80) ) PRIME_CONTRACTOR_ADDRESS1
, RTRIM( SUBSTR(TEXT08
, 161
, 80) ) PRIME_CONTRACTOR_ADDRESS2
, RTRIM( SUBSTR(TEXT08
, 241
, 80) ) PRIME_CONTRACTOR_ADDRESS3
, RTRIM( SUBSTR(TEXT08
, 321
, 80) ) PRIME_CONTRACTOR_ADDRESS4
, RTRIM( SUBSTR(TEXT08
, 401
, 80) ) PRIME_CONTRACTOR_CITY
, RTRIM( SUBSTR(TEXT08
, 561
, 80) ) PRIME_CONTRACTOR_STATE
, RTRIM( SUBSTR(TEXT08
, 721
, 80) ) PRIME_CONTRACTOR_ZIP
, RTRIM( SUBSTR(TEXT08
, 801
, 80) ) PRIME_CONTRACTOR_COUNTRY
, TEXT09 PRIME_CONTRACTOR_CODE
, RTRIM( SUBSTR(TEXT10
, 1
, 80) ) ADMIN_BY_NAME
, RTRIM( SUBSTR(TEXT10
, 81
, 80) ) ADMIN_BY_ADDRESS1
, RTRIM( SUBSTR(TEXT10
, 161
, 80) ) ADMIN_BY_ADDRESS2
, RTRIM( SUBSTR(TEXT10
, 241
, 80) ) ADMIN_BY_ADDRESS3
, RTRIM( SUBSTR(TEXT10
, 321
, 80) ) ADMIN_BY_ADDRESS4
, RTRIM( SUBSTR(TEXT10
, 401
, 80) ) ADMIN_BY_CITY
, RTRIM( SUBSTR(TEXT10
, 561
, 80) ) ADMIN_BY_STATE
, RTRIM( SUBSTR(TEXT10
, 721
, 80) ) ADMIN_BY_ZIP
, RTRIM( SUBSTR(TEXT10
, 801
, 80) ) ADMIN_BY_COUNTRY
, TEXT11 ADMIN_BY_CODE
, RTRIM( SUBSTR(TEXT12
, 1
, 80) ) SHIPPED_FROM_NAME
, RTRIM( SUBSTR(TEXT12
, 81
, 80) ) SHIPPED_FROM_ADDRESS1
, RTRIM( SUBSTR(TEXT12
, 161
, 80) ) SHIPPED_FROM_ADDRESS2
, RTRIM( SUBSTR(TEXT12
, 241
, 80) ) SHIPPED_FROM_ADDRESS3
, RTRIM( SUBSTR(TEXT12
, 321
, 80) ) SHIPPED_FROM_ADDRESS4
, RTRIM( SUBSTR(TEXT12
, 401
, 80) ) SHIPPED_FROM_CITY
, RTRIM( SUBSTR(TEXT12
, 561
, 80) ) SHIPPED_FROM_STATE
, RTRIM( SUBSTR(TEXT12
, 721
, 80) ) SHIPPED_FROM_ZIP
, RTRIM( SUBSTR(TEXT12
, 801
, 80) ) SHIPPED_FROM_COUNTRY
, TEXT13 SHIPPED_FROM_CODE
, TEXT14 FOB
, RTRIM( SUBSTR(TEXT15
, 1
, 80) ) PAID_BY_NAME
, RTRIM( SUBSTR(TEXT15
, 81
, 80) ) PAID_BY_ADDRESS1
, RTRIM( SUBSTR(TEXT15
, 161
, 80) ) PAID_BY_ADDRESS2
, RTRIM( SUBSTR(TEXT15
, 241
, 80) ) PAID_BY_ADDRESS3
, RTRIM( SUBSTR(TEXT15
, 321
, 80) ) PAID_BY_ADDRESS4
, RTRIM( SUBSTR(TEXT15
, 401
, 80) ) PAID_BY_CITY
, RTRIM( SUBSTR(TEXT15
, 561
, 80) ) PAID_BY_STATE
, RTRIM( SUBSTR(TEXT15
, 721
, 80) ) PAID_BY_ZIP
, RTRIM( SUBSTR(TEXT15
, 801
, 80) ) PAID_BY_COUNTRY
, TEXT16 PAID_BY_CODE
, RTRIM( SUBSTR(TEXT17
, 1
, 80) ) SHIPPED_TO_NAME
, RTRIM( SUBSTR(TEXT17
, 81
, 80) ) SHIPPED_TO_ADDRESS1
, RTRIM( SUBSTR(TEXT17
, 161
, 80) ) SHIPPED_TO_ADDRESS2
, RTRIM( SUBSTR(TEXT17
, 241
, 80) ) SHIPPED_TO_ADDRESS3
, RTRIM( SUBSTR(TEXT17
, 321
, 80) ) SHIPPED_TO_ADDRESS4
, RTRIM( SUBSTR(TEXT17
, 401
, 80) ) SHIPPED_TO_CITY
, RTRIM( SUBSTR(TEXT17
, 561
, 80) ) SHIPPED_TO_STATE
, RTRIM( SUBSTR(TEXT17
, 721
, 80) ) SHIPPED_TO_ZIP
, RTRIM( SUBSTR(TEXT17
, 801
, 80) ) SHIPPED_TO_COUNTRY
, TEXT18 SHIPPED_TO_CODE
, RTRIM( SUBSTR(TEXT19
, 1
, 80) ) MARKED_FOR_NAME
, RTRIM( SUBSTR(TEXT19
, 81
, 80) ) MARKED_FOR_ADDRESS1
, RTRIM( SUBSTR(TEXT19
, 161
, 80) ) MARKED_FOR_ADDRESS2
, RTRIM( SUBSTR(TEXT19
, 241
, 80) ) MARKED_FOR_ADDRESS3
, RTRIM( SUBSTR(TEXT19
, 321
, 80) ) MARKED_FOR_ADDRESS4
, RTRIM( SUBSTR(TEXT19
, 401
, 80) ) MARKED_FOR_CITY
, RTRIM( SUBSTR(TEXT19
, 561
, 80) ) MARKED_FOR_STATE
, RTRIM( SUBSTR(TEXT19
, 721
, 80) ) MARKED_FOR_ZIP
, RTRIM( SUBSTR(TEXT19
, 801
, 80) ) MARKED_FOR_COUNTRY
, TEXT20 MARKED_FOR_CODE
, NUMBER01 GROSS_WEIGHT
, NUMBER02 NET_WEIGHT
, TEXT23 WEIGHT_UOM_CODE
, NUMBER03 VOLUME
, TEXT24 VOLUME_UOM_CODE
, NUMBER04 NUMBER_OF_CONTAINERS
, TEXT25 COMMENTS
FROM OKE_K_FORM_HEADERS
WHERE PRINT_FORM_CODE = 'DD250'

Columns