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.

VIEW: APPS.OKE_DD250_HEADERS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'