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.

[Home] [Help]

VIEW: OE.SO_LINES_INTERFACE_ALL#

Source

View Text - Preformatted


select CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, UNIT_CODE UNIT_CODE, ORDERED_QUANTITY ORDERED_QUANTITY, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT, LIST_PRICE LIST_PRICE, SELLING_PRICE SELLING_PRICE, LIST_PERCENT LIST_PERCENT, SELLING_PERCENT SELLING_PERCENT, INVENTORY_ITEM_SEGMENT1 INVENTORY_ITEM_SEGMENT1, INVENTORY_ITEM_SEGMENT2 INVENTORY_ITEM_SEGMENT2, INVENTORY_ITEM_SEGMENT3 INVENTORY_ITEM_SEGMENT3, INVENTORY_ITEM_SEGMENT4 INVENTORY_ITEM_SEGMENT4, INVENTORY_ITEM_SEGMENT5 INVENTORY_ITEM_SEGMENT5, INVENTORY_ITEM_SEGMENT6 INVENTORY_ITEM_SEGMENT6, INVENTORY_ITEM_SEGMENT7 INVENTORY_ITEM_SEGMENT7, INVENTORY_ITEM_SEGMENT8 INVENTORY_ITEM_SEGMENT8, INVENTORY_ITEM_SEGMENT9 INVENTORY_ITEM_SEGMENT9, INVENTORY_ITEM_SEGMENT10 INVENTORY_ITEM_SEGMENT10, INVENTORY_ITEM_SEGMENT11 INVENTORY_ITEM_SEGMENT11, INVENTORY_ITEM_SEGMENT12 INVENTORY_ITEM_SEGMENT12, INVENTORY_ITEM_SEGMENT13 INVENTORY_ITEM_SEGMENT13, INVENTORY_ITEM_SEGMENT14 INVENTORY_ITEM_SEGMENT14, INVENTORY_ITEM_SEGMENT15 INVENTORY_ITEM_SEGMENT15, INVENTORY_ITEM_SEGMENT16 INVENTORY_ITEM_SEGMENT16, INVENTORY_ITEM_SEGMENT17 INVENTORY_ITEM_SEGMENT17, INVENTORY_ITEM_SEGMENT18 INVENTORY_ITEM_SEGMENT18, INVENTORY_ITEM_SEGMENT19 INVENTORY_ITEM_SEGMENT19, INVENTORY_ITEM_SEGMENT20 INVENTORY_ITEM_SEGMENT20, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SHIPPED_QUANTITY SHIPPED_QUANTITY, SCHEDULED_SHIPMENT_DATE SCHEDULED_SHIPMENT_DATE, LINK_TO_LINE_REF LINK_TO_LINE_REF, PARENT_LINE_REF PARENT_LINE_REF, SHIPMENT_SCHEDULE_LINE_REF SHIPMENT_SCHEDULE_LINE_REF, SHIP_SET_NUMBER SHIP_SET_NUMBER, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIP_METHOD_CODE SHIP_METHOD_CODE, PRICE_LIST_ID PRICE_LIST_ID, TERMS_ID TERMS_ID, WAREHOUSE_ID WAREHOUSE_ID, SERVICED_SEGMENT1 SERVICED_SEGMENT1, SERVICED_SEGMENT2 SERVICED_SEGMENT2, SERVICED_SEGMENT3 SERVICED_SEGMENT3, SERVICED_SEGMENT4 SERVICED_SEGMENT4, SERVICED_SEGMENT5 SERVICED_SEGMENT5, SERVICED_SEGMENT6 SERVICED_SEGMENT6, SERVICED_SEGMENT7 SERVICED_SEGMENT7, SERVICED_SEGMENT8 SERVICED_SEGMENT8, SERVICED_SEGMENT9 SERVICED_SEGMENT9, SERVICED_SEGMENT10 SERVICED_SEGMENT10, SERVICED_SEGMENT11 SERVICED_SEGMENT11, SERVICED_SEGMENT12 SERVICED_SEGMENT12, SERVICED_SEGMENT13 SERVICED_SEGMENT13, SERVICED_SEGMENT14 SERVICED_SEGMENT14, SERVICED_SEGMENT15 SERVICED_SEGMENT15, SERVICED_SEGMENT16 SERVICED_SEGMENT16, SERVICED_SEGMENT17 SERVICED_SEGMENT17, SERVICED_SEGMENT18 SERVICED_SEGMENT18, SERVICED_SEGMENT19 SERVICED_SEGMENT19, SERVICED_SEGMENT20 SERVICED_SEGMENT20, SERVICED_ITEM_ID SERVICED_ITEM_ID, SERVICED_LIST_PRICE SERVICED_LIST_PRICE, SERVICE_START_DATE_ACTIVE SERVICE_START_DATE_ACTIVE, SERVICE_END_DATE_ACTIVE SERVICE_END_DATE_ACTIVE, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID, CP_SERVICE_ID CP_SERVICE_ID, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE, SERVICE_DURATION_QUANTITY SERVICE_DURATION_QUANTITY, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE, TRANSACTION_COMMENTS TRANSACTION_COMMENTS, SERVICE_MASS_TXN_TEMP_ID SERVICE_MASS_TXN_TEMP_ID, AGREEMENT_NAME AGREEMENT_NAME, AGREEMENT_ID AGREEMENT_ID, ACCOUNTING_RULE ACCOUNTING_RULE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, INVOICING_RULE_ID INVOICING_RULE_ID, SERVICED_UNIT_CODE SERVICED_UNIT_CODE, SERVICED_PRICING_ATTRIBUTE1 SERVICED_PRICING_ATTRIBUTE1, SERVICED_PRICING_ATTRIBUTE2 SERVICED_PRICING_ATTRIBUTE2, SERVICED_PRICING_ATTRIBUTE3 SERVICED_PRICING_ATTRIBUTE3, SERVICED_PRICING_ATTRIBUTE4 SERVICED_PRICING_ATTRIBUTE4, SERVICED_PRICING_ATTRIBUTE5 SERVICED_PRICING_ATTRIBUTE5, SERVICED_PRICING_ATTRIBUTE6 SERVICED_PRICING_ATTRIBUTE6, SERVICED_PRICING_ATTRIBUTE7 SERVICED_PRICING_ATTRIBUTE7, SERVICED_PRICING_ATTRIBUTE8 SERVICED_PRICING_ATTRIBUTE8, SERVICED_PRICING_ATTRIBUTE9 SERVICED_PRICING_ATTRIBUTE9, SERVICED_PRICING_ATTRIBUTE10 SERVICED_PRICING_ATTRIBUTE10, SERVICED_PRICING_ATTRIBUTE11 SERVICED_PRICING_ATTRIBUTE11, SERVICED_PRICING_ATTRIBUTE12 SERVICED_PRICING_ATTRIBUTE12, SERVICED_PRICING_ATTRIBUTE13 SERVICED_PRICING_ATTRIBUTE13, SERVICED_PRICING_ATTRIBUTE14 SERVICED_PRICING_ATTRIBUTE14, SERVICED_PRICING_ATTRIBUTE15 SERVICED_PRICING_ATTRIBUTE15, SERVICED_PRICING_CONTEXT SERVICED_PRICING_CONTEXT, ORDER_CATEGORY ORDER_CATEGORY, ENTERED_STATE ENTERED_STATE, ENTERED_STATE_DATE ENTERED_STATE_DATE, COMPLETE_FLAG COMPLETE_FLAG, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, CALCULATE_PRICE CALCULATE_PRICE, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10, PRICING_ATTRIBUTE11 PRICING_ATTRIBUTE11, PRICING_ATTRIBUTE12 PRICING_ATTRIBUTE12, PRICING_ATTRIBUTE13 PRICING_ATTRIBUTE13, PRICING_ATTRIBUTE14 PRICING_ATTRIBUTE14, PRICING_ATTRIBUTE15 PRICING_ATTRIBUTE15, PRICING_CONTEXT PRICING_CONTEXT, PRICING_METHOD_CODE PRICING_METHOD_CODE, COMPONENT_CODE COMPONENT_CODE, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_SORT_CODE COMPONENT_SORT_CODE, ERROR_FLAG ERROR_FLAG, INTERFACE_STATUS INTERFACE_STATUS, ITEM_TYPE_CODE ITEM_TYPE_CODE, LEVEL_CODE LEVEL_CODE, OPTION_FLAG OPTION_FLAG, ORDER_SOURCE_ID ORDER_SOURCE_ID, SHIP_ADDRESS1 SHIP_ADDRESS1, SHIP_ADDRESS2 SHIP_ADDRESS2, SHIP_ADDRESS3 SHIP_ADDRESS3, SHIP_ADDRESS4 SHIP_ADDRESS4, SHIP_ADDRESS_ID SHIP_ADDRESS_ID, SHIP_CITY SHIP_CITY, SHIP_COUNTRY SHIP_COUNTRY, SHIP_COUNTY SHIP_COUNTY, SHIP_POSTAL_CODE SHIP_POSTAL_CODE, SHIP_STATE SHIP_STATE, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, TERMS_NAME TERMS_NAME, GROUP_ID GROUP_ID, PERCENT_BASE_PRICE PERCENT_BASE_PRICE, OPERATION_CODE OPERATION_CODE, COMMITMENT_ID COMMITMENT_ID, INVOICING_RULE INVOICING_RULE, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, PRICING_DATE PRICING_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, SERVICE_PARENT_LINE_REF SERVICE_PARENT_LINE_REF, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG, SERVICE_PERIOD_CONVERSION_RATE SERVICE_PERIOD_CONVERSION_RATE, TAX_CODE TAX_CODE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, PROMISE_DATE PROMISE_DATE, ORG_ID ORG_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, DEMAND_STREAM_ID DEMAND_STREAM_ID, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, PLANNING_PROD_SEQ_NUMBER PLANNING_PROD_SEQ_NUMBER, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, CUSTOMER_JOB CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, CUSTOMER_MODEL_SERIAL_NUMBER CUSTOMER_MODEL_SERIAL_NUMBER, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, SOURCE_TYPE_NAME SOURCE_TYPE_NAME, PLANNING_PRIORITY PLANNING_PRIORITY, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER from "OE"."SO_LINES_INTERFACE_ALL"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, ORIGINAL_SYSTEM_REFERENCE ORIGINAL_SYSTEM_REFERENCE
, ORIGINAL_SYSTEM_LINE_REFERENCE ORIGINAL_SYSTEM_LINE_REFERENCE
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, UNIT_CODE UNIT_CODE
, ORDERED_QUANTITY ORDERED_QUANTITY
, DATE_REQUESTED_CURRENT DATE_REQUESTED_CURRENT
, LIST_PRICE LIST_PRICE
, SELLING_PRICE SELLING_PRICE
, LIST_PERCENT LIST_PERCENT
, SELLING_PERCENT SELLING_PERCENT
, INVENTORY_ITEM_SEGMENT1 INVENTORY_ITEM_SEGMENT1
, INVENTORY_ITEM_SEGMENT2 INVENTORY_ITEM_SEGMENT2
, INVENTORY_ITEM_SEGMENT3 INVENTORY_ITEM_SEGMENT3
, INVENTORY_ITEM_SEGMENT4 INVENTORY_ITEM_SEGMENT4
, INVENTORY_ITEM_SEGMENT5 INVENTORY_ITEM_SEGMENT5
, INVENTORY_ITEM_SEGMENT6 INVENTORY_ITEM_SEGMENT6
, INVENTORY_ITEM_SEGMENT7 INVENTORY_ITEM_SEGMENT7
, INVENTORY_ITEM_SEGMENT8 INVENTORY_ITEM_SEGMENT8
, INVENTORY_ITEM_SEGMENT9 INVENTORY_ITEM_SEGMENT9
, INVENTORY_ITEM_SEGMENT10 INVENTORY_ITEM_SEGMENT10
, INVENTORY_ITEM_SEGMENT11 INVENTORY_ITEM_SEGMENT11
, INVENTORY_ITEM_SEGMENT12 INVENTORY_ITEM_SEGMENT12
, INVENTORY_ITEM_SEGMENT13 INVENTORY_ITEM_SEGMENT13
, INVENTORY_ITEM_SEGMENT14 INVENTORY_ITEM_SEGMENT14
, INVENTORY_ITEM_SEGMENT15 INVENTORY_ITEM_SEGMENT15
, INVENTORY_ITEM_SEGMENT16 INVENTORY_ITEM_SEGMENT16
, INVENTORY_ITEM_SEGMENT17 INVENTORY_ITEM_SEGMENT17
, INVENTORY_ITEM_SEGMENT18 INVENTORY_ITEM_SEGMENT18
, INVENTORY_ITEM_SEGMENT19 INVENTORY_ITEM_SEGMENT19
, INVENTORY_ITEM_SEGMENT20 INVENTORY_ITEM_SEGMENT20
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, SCHEDULED_SHIPMENT_DATE SCHEDULED_SHIPMENT_DATE
, LINK_TO_LINE_REF LINK_TO_LINE_REF
, PARENT_LINE_REF PARENT_LINE_REF
, SHIPMENT_SCHEDULE_LINE_REF SHIPMENT_SCHEDULE_LINE_REF
, SHIP_SET_NUMBER SHIP_SET_NUMBER
, SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, PRICE_LIST_ID PRICE_LIST_ID
, TERMS_ID TERMS_ID
, WAREHOUSE_ID WAREHOUSE_ID
, SERVICED_SEGMENT1 SERVICED_SEGMENT1
, SERVICED_SEGMENT2 SERVICED_SEGMENT2
, SERVICED_SEGMENT3 SERVICED_SEGMENT3
, SERVICED_SEGMENT4 SERVICED_SEGMENT4
, SERVICED_SEGMENT5 SERVICED_SEGMENT5
, SERVICED_SEGMENT6 SERVICED_SEGMENT6
, SERVICED_SEGMENT7 SERVICED_SEGMENT7
, SERVICED_SEGMENT8 SERVICED_SEGMENT8
, SERVICED_SEGMENT9 SERVICED_SEGMENT9
, SERVICED_SEGMENT10 SERVICED_SEGMENT10
, SERVICED_SEGMENT11 SERVICED_SEGMENT11
, SERVICED_SEGMENT12 SERVICED_SEGMENT12
, SERVICED_SEGMENT13 SERVICED_SEGMENT13
, SERVICED_SEGMENT14 SERVICED_SEGMENT14
, SERVICED_SEGMENT15 SERVICED_SEGMENT15
, SERVICED_SEGMENT16 SERVICED_SEGMENT16
, SERVICED_SEGMENT17 SERVICED_SEGMENT17
, SERVICED_SEGMENT18 SERVICED_SEGMENT18
, SERVICED_SEGMENT19 SERVICED_SEGMENT19
, SERVICED_SEGMENT20 SERVICED_SEGMENT20
, SERVICED_ITEM_ID SERVICED_ITEM_ID
, SERVICED_LIST_PRICE SERVICED_LIST_PRICE
, SERVICE_START_DATE_ACTIVE SERVICE_START_DATE_ACTIVE
, SERVICE_END_DATE_ACTIVE SERVICE_END_DATE_ACTIVE
, CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, CP_SERVICE_ID CP_SERVICE_ID
, TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, SERVICE_DURATION_QUANTITY SERVICE_DURATION_QUANTITY
, TRANSACTION_REASON_CODE TRANSACTION_REASON_CODE
, TRANSACTION_COMMENTS TRANSACTION_COMMENTS
, SERVICE_MASS_TXN_TEMP_ID SERVICE_MASS_TXN_TEMP_ID
, AGREEMENT_NAME AGREEMENT_NAME
, AGREEMENT_ID AGREEMENT_ID
, ACCOUNTING_RULE ACCOUNTING_RULE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, SERVICED_UNIT_CODE SERVICED_UNIT_CODE
, SERVICED_PRICING_ATTRIBUTE1 SERVICED_PRICING_ATTRIBUTE1
, SERVICED_PRICING_ATTRIBUTE2 SERVICED_PRICING_ATTRIBUTE2
, SERVICED_PRICING_ATTRIBUTE3 SERVICED_PRICING_ATTRIBUTE3
, SERVICED_PRICING_ATTRIBUTE4 SERVICED_PRICING_ATTRIBUTE4
, SERVICED_PRICING_ATTRIBUTE5 SERVICED_PRICING_ATTRIBUTE5
, SERVICED_PRICING_ATTRIBUTE6 SERVICED_PRICING_ATTRIBUTE6
, SERVICED_PRICING_ATTRIBUTE7 SERVICED_PRICING_ATTRIBUTE7
, SERVICED_PRICING_ATTRIBUTE8 SERVICED_PRICING_ATTRIBUTE8
, SERVICED_PRICING_ATTRIBUTE9 SERVICED_PRICING_ATTRIBUTE9
, SERVICED_PRICING_ATTRIBUTE10 SERVICED_PRICING_ATTRIBUTE10
, SERVICED_PRICING_ATTRIBUTE11 SERVICED_PRICING_ATTRIBUTE11
, SERVICED_PRICING_ATTRIBUTE12 SERVICED_PRICING_ATTRIBUTE12
, SERVICED_PRICING_ATTRIBUTE13 SERVICED_PRICING_ATTRIBUTE13
, SERVICED_PRICING_ATTRIBUTE14 SERVICED_PRICING_ATTRIBUTE14
, SERVICED_PRICING_ATTRIBUTE15 SERVICED_PRICING_ATTRIBUTE15
, SERVICED_PRICING_CONTEXT SERVICED_PRICING_CONTEXT
, ORDER_CATEGORY ORDER_CATEGORY
, ENTERED_STATE ENTERED_STATE
, ENTERED_STATE_DATE ENTERED_STATE_DATE
, COMPLETE_FLAG COMPLETE_FLAG
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, CALCULATE_PRICE CALCULATE_PRICE
, PRICING_ATTRIBUTE1 PRICING_ATTRIBUTE1
, PRICING_ATTRIBUTE2 PRICING_ATTRIBUTE2
, PRICING_ATTRIBUTE3 PRICING_ATTRIBUTE3
, PRICING_ATTRIBUTE4 PRICING_ATTRIBUTE4
, PRICING_ATTRIBUTE5 PRICING_ATTRIBUTE5
, PRICING_ATTRIBUTE6 PRICING_ATTRIBUTE6
, PRICING_ATTRIBUTE7 PRICING_ATTRIBUTE7
, PRICING_ATTRIBUTE8 PRICING_ATTRIBUTE8
, PRICING_ATTRIBUTE9 PRICING_ATTRIBUTE9
, PRICING_ATTRIBUTE10 PRICING_ATTRIBUTE10
, PRICING_ATTRIBUTE11 PRICING_ATTRIBUTE11
, PRICING_ATTRIBUTE12 PRICING_ATTRIBUTE12
, PRICING_ATTRIBUTE13 PRICING_ATTRIBUTE13
, PRICING_ATTRIBUTE14 PRICING_ATTRIBUTE14
, PRICING_ATTRIBUTE15 PRICING_ATTRIBUTE15
, PRICING_CONTEXT PRICING_CONTEXT
, PRICING_METHOD_CODE PRICING_METHOD_CODE
, COMPONENT_CODE COMPONENT_CODE
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_SORT_CODE COMPONENT_SORT_CODE
, ERROR_FLAG ERROR_FLAG
, INTERFACE_STATUS INTERFACE_STATUS
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, LEVEL_CODE LEVEL_CODE
, OPTION_FLAG OPTION_FLAG
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, SHIP_ADDRESS1 SHIP_ADDRESS1
, SHIP_ADDRESS2 SHIP_ADDRESS2
, SHIP_ADDRESS3 SHIP_ADDRESS3
, SHIP_ADDRESS4 SHIP_ADDRESS4
, SHIP_ADDRESS_ID SHIP_ADDRESS_ID
, SHIP_CITY SHIP_CITY
, SHIP_COUNTRY SHIP_COUNTRY
, SHIP_COUNTY SHIP_COUNTY
, SHIP_POSTAL_CODE SHIP_POSTAL_CODE
, SHIP_STATE SHIP_STATE
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, TERMS_NAME TERMS_NAME
, GROUP_ID GROUP_ID
, PERCENT_BASE_PRICE PERCENT_BASE_PRICE
, OPERATION_CODE OPERATION_CODE
, COMMITMENT_ID COMMITMENT_ID
, INVOICING_RULE INVOICING_RULE
, SHIP_TO_CUSTOMER SHIP_TO_CUSTOMER
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, PRICING_DATE PRICING_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, SERVICE_PARENT_LINE_REF SERVICE_PARENT_LINE_REF
, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, SERVICE_PERIOD_CONVERSION_RATE SERVICE_PERIOD_CONVERSION_RATE
, TAX_CODE TAX_CODE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, PROMISE_DATE PROMISE_DATE
, ORG_ID ORG_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, DEMAND_STREAM_ID DEMAND_STREAM_ID
, INTERMEDIATE_SHIP_TO_ID INTERMEDIATE_SHIP_TO_ID
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, PLANNING_PROD_SEQ_NUMBER PLANNING_PROD_SEQ_NUMBER
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, CUSTOMER_JOB CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, CUSTOMER_MODEL_SERIAL_NUMBER CUSTOMER_MODEL_SERIAL_NUMBER
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SOURCE_TYPE_NAME SOURCE_TYPE_NAME
, PLANNING_PRIORITY PLANNING_PRIORITY
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
FROM "OE"."SO_LINES_INTERFACE_ALL"