VIEW: ONT.OE_ORDER_LINES_ALL#

Source

View Text - Preformatted

select LINE_ID LINE_ID, ORG_ID ORG_ID, HEADER_ID HEADER_ID, LINE_TYPE_ID LINE_TYPE_ID, LINE_NUMBER LINE_NUMBER, ORDERED_ITEM ORDERED_ITEM, REQUEST_DATE REQUEST_DATE, PROMISE_DATE PROMISE_DATE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM, PRICING_QUANTITY PRICING_QUANTITY, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM, CANCELLED_QUANTITY CANCELLED_QUANTITY, SHIPPED_QUANTITY SHIPPED_QUANTITY, ORDERED_QUANTITY ORDERED_QUANTITY, FULFILLED_QUANTITY FULFILLED_QUANTITY, SHIPPING_QUANTITY SHIPPING_QUANTITY, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, CUST_PO_NUMBER CUST_PO_NUMBER, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID, RLA_SCHEDULE_TYPE_CODE RLA_SCHEDULE_TYPE_CODE, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, CUSTOMER_JOB CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TAX_DATE TAX_DATE, TAX_CODE TAX_CODE, TAX_RATE TAX_RATE, INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, PRICE_LIST_ID PRICE_LIST_ID, PRICING_DATE PRICING_DATE, SHIPMENT_NUMBER SHIPMENT_NUMBER, AGREEMENT_ID AGREEMENT_ID, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FOB_POINT_CODE FOB_POINT_CODE, TAX_POINT_CODE TAX_POINT_CODE, PAYMENT_TERM_ID PAYMENT_TERM_ID, INVOICING_RULE_ID INVOICING_RULE_ID, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID, REFERENCE_LINE_ID REFERENCE_LINE_ID, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_HEADER_ID REFERENCE_HEADER_ID, ITEM_REVISION ITEM_REVISION, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, UNIT_LIST_PRICE UNIT_LIST_PRICE, TAX_VALUE TAX_VALUE, 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, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20, PRICING_CONTEXT PRICING_CONTEXT, 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, INDUSTRY_CONTEXT INDUSTRY_CONTEXT, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15, INDUSTRY_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30, 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, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID, LINK_TO_LINE_ID LINK_TO_LINE_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE, SORT_ORDER SORT_ORDER, ITEM_TYPE_CODE ITEM_TYPE_CODE, OPTION_NUMBER OPTION_NUMBER, OPTION_FLAG OPTION_FLAG, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG, VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG, LINE_CATEGORY_CODE LINE_CATEGORY_CODE, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID, RETURN_CONTEXT RETURN_CONTEXT, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE, ATO_LINE_ID ATO_LINE_ID, AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY, COMPONENT_NUMBER COMPONENT_NUMBER, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE, EXPLOSION_DATE EXPLOSION_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, CANCELLED_FLAG CANCELLED_FLAG, OPEN_FLAG OPEN_FLAG, BOOKED_FLAG BOOKED_FLAG, SALESREP_ID SALESREP_ID, RETURN_REASON_CODE RETURN_REASON_CODE, ARRIVAL_SET_ID ARRIVAL_SET_ID, SHIP_SET_ID SHIP_SET_ID, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG, ORDERED_ITEM_ID ORDERED_ITEM_ID, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE, CONFIGURATION_ID CONFIGURATION_ID, COMMITMENT_ID COMMITMENT_ID, SHIPPING_INTERFACED_FLAG SHIPPING_INTERFACED_FLAG, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID, FIRST_ACK_CODE FIRST_ACK_CODE, FIRST_ACK_DATE FIRST_ACK_DATE, LAST_ACK_CODE LAST_ACK_CODE, LAST_ACK_DATE LAST_ACK_DATE, PLANNING_PRIORITY PLANNING_PRIORITY, ORDER_SOURCE_ID ORDER_SOURCE_ID, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, CHANGE_SEQUENCE CHANGE_SEQUENCE, DROP_SHIP_FLAG DROP_SHIP_FLAG, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, FULFILLED_FLAG FULFILLED_FLAG, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REV_NBR CONFIG_REV_NBR, MFG_COMPONENT_SEQUENCE_ID MFG_COMPONENT_SEQUENCE_ID, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, INVOICED_QUANTITY INVOICED_QUANTITY, REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID, SPLIT_BY SPLIT_BY, LINE_SET_ID LINE_SET_ID, SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE, SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENTS, SERVICE_DURATION SERVICE_DURATION, SERVICE_START_DATE SERVICE_START_DATE, SERVICE_END_DATE SERVICE_END_DATE, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG, UNIT_LIST_PERCENT UNIT_LIST_PERCENT, UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE, SERVICE_NUMBER SERVICE_NUMBER, SERVICE_PERIOD SERVICE_PERIOD, SHIPPABLE_FLAG SHIPPABLE_FLAG, MODEL_REMNANT_FLAG MODEL_REMNANT_FLAG, RE_SOURCE_FLAG RE_SOURCE_FLAG, FLOW_STATUS_CODE FLOW_STATUS_CODE, TP_CONTEXT TP_CONTEXT, TP_ATTRIBUTE1 TP_ATTRIBUTE1, TP_ATTRIBUTE2 TP_ATTRIBUTE2, TP_ATTRIBUTE3 TP_ATTRIBUTE3, TP_ATTRIBUTE4 TP_ATTRIBUTE4, TP_ATTRIBUTE5 TP_ATTRIBUTE5, TP_ATTRIBUTE6 TP_ATTRIBUTE6, TP_ATTRIBUTE7 TP_ATTRIBUTE7, TP_ATTRIBUTE8 TP_ATTRIBUTE8, TP_ATTRIBUTE9 TP_ATTRIBUTE9, TP_ATTRIBUTE10 TP_ATTRIBUTE10, TP_ATTRIBUTE11 TP_ATTRIBUTE11, TP_ATTRIBUTE12 TP_ATTRIBUTE12, TP_ATTRIBUTE13 TP_ATTRIBUTE13, TP_ATTRIBUTE14 TP_ATTRIBUTE14, TP_ATTRIBUTE15 TP_ATTRIBUTE15, FULFILLMENT_METHOD_CODE FULFILLMENT_METHOD_CODE, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE, SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID, SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG, UPGRADED_FLAG UPGRADED_FLAG, REVENUE_AMOUNT REVENUE_AMOUNT, FULFILLMENT_DATE FULFILLMENT_DATE, PREFERRED_GRADE PREFERRED_GRADE, ORDERED_QUANTITY2 ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2, MFG_LEAD_TIME MFG_LEAD_TIME, LOCK_CONTROL LOCK_CONTROL, SUBINVENTORY SUBINVENTORY, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY, PRICE_REQUEST_CODE PRICE_REQUEST_CODE, ORIGINAL_INVENTORY_ITEM_ID ORIGINAL_INVENTORY_ITEM_ID, ORIGINAL_ORDERED_ITEM_ID ORIGINAL_ORDERED_ITEM_ID, ORIGINAL_ORDERED_ITEM ORIGINAL_ORDERED_ITEM, ORIGINAL_ITEM_IDENTIFIER_TYPE ORIGINAL_ITEM_IDENTIFIER_TYPE, ITEM_SUBSTITUTION_TYPE_CODE ITEM_SUBSTITUTION_TYPE_CODE, OVERRIDE_ATP_DATE_CODE OVERRIDE_ATP_DATE_CODE, LATE_DEMAND_PENALTY_FACTOR LATE_DEMAND_PENALTY_FACTOR, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION, UNIT_COST UNIT_COST, ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER, BLANKET_NUMBER BLANKET_NUMBER, BLANKET_VERSION_NUMBER BLANKET_VERSION_NUMBER, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE, FIRM_DEMAND_FLAG FIRM_DEMAND_FLAG, EARLIEST_SHIP_DATE EARLIEST_SHIP_DATE, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE, SOURCE_DOCUMENT_VERSION_NUMBER SOURCE_DOCUMENT_VERSION_NUMBER, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE, MINISITE_ID MINISITE_ID, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, IB_OWNER IB_OWNER, IB_CURRENT_LOCATION IB_CURRENT_LOCATION, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION, RETROBILL_REQUEST_ID RETROBILL_REQUEST_ID, ORIGINAL_LIST_PRICE ORIGINAL_LIST_PRICE, SERVICE_CREDIT_ELIGIBLE_CODE SERVICE_CREDIT_ELIGIBLE_CODE, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE, CONTINGENCY_ID CONTINGENCY_ID, REVREC_EVENT_CODE REVREC_EVENT_CODE, REVREC_EXPIRATION_DAYS REVREC_EXPIRATION_DAYS, ACCEPTED_QUANTITY ACCEPTED_QUANTITY, ACCEPTED_BY ACCEPTED_BY, REVREC_COMMENTS REVREC_COMMENTS, REVREC_REFERENCE_DOCUMENT REVREC_REFERENCE_DOCUMENT, REVREC_SIGNATURE REVREC_SIGNATURE, REVREC_SIGNATURE_DATE REVREC_SIGNATURE_DATE, REVREC_IMPLICIT_FLAG REVREC_IMPLICIT_FLAG, BYPASS_SCH_FLAG BYPASS_SCH_FLAG, PRE_EXPLODED_FLAG PRE_EXPLODED_FLAG, INST_ID INST_ID, TAX_LINE_VALUE TAX_LINE_VALUE, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE, SERVICE_FIRST_PERIOD_AMOUNT SERVICE_FIRST_PERIOD_AMOUNT, SERVICE_FIRST_PERIOD_ENDDATE SERVICE_FIRST_PERIOD_ENDDATE, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG, FULFILLMENT_BASE FULFILLMENT_BASE from "ONT"."OE_ORDER_LINES_ALL"

View Text - HTML Formatted

SELECT LINE_ID LINE_ID
, ORG_ID ORG_ID
, HEADER_ID HEADER_ID
, LINE_TYPE_ID LINE_TYPE_ID
, LINE_NUMBER LINE_NUMBER
, ORDERED_ITEM ORDERED_ITEM
, REQUEST_DATE REQUEST_DATE
, PROMISE_DATE PROMISE_DATE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM
, PRICING_QUANTITY PRICING_QUANTITY
, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, ORDERED_QUANTITY ORDERED_QUANTITY
, FULFILLED_QUANTITY FULFILLED_QUANTITY
, SHIPPING_QUANTITY SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INTMED_SHIP_TO_ORG_ID INTMED_SHIP_TO_ORG_ID
, INTMED_SHIP_TO_CONTACT_ID INTMED_SHIP_TO_CONTACT_ID
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, CUST_PO_NUMBER CUST_PO_NUMBER
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE
, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID
, RLA_SCHEDULE_TYPE_CODE RLA_SCHEDULE_TYPE_CODE
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, CUSTOMER_JOB CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TAX_DATE TAX_DATE
, TAX_CODE TAX_CODE
, TAX_RATE TAX_RATE
, INVOICE_INTERFACE_STATUS_CODE INVOICE_INTERFACE_STATUS_CODE
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, PRICE_LIST_ID PRICE_LIST_ID
, PRICING_DATE PRICING_DATE
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, AGREEMENT_ID AGREEMENT_ID
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FOB_POINT_CODE FOB_POINT_CODE
, TAX_POINT_CODE TAX_POINT_CODE
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, INVOICING_RULE_ID INVOICING_RULE_ID
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, SOURCE_DOCUMENT_TYPE_ID SOURCE_DOCUMENT_TYPE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, SOURCE_DOCUMENT_ID SOURCE_DOCUMENT_ID
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, SOURCE_DOCUMENT_LINE_ID SOURCE_DOCUMENT_LINE_ID
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_HEADER_ID REFERENCE_HEADER_ID
, ITEM_REVISION ITEM_REVISION
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, UNIT_LIST_PRICE UNIT_LIST_PRICE
, TAX_VALUE TAX_VALUE
, 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
, GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
, PRICING_CONTEXT PRICING_CONTEXT
, 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
, INDUSTRY_CONTEXT INDUSTRY_CONTEXT
, INDUSTRY_ATTRIBUTE1 INDUSTRY_ATTRIBUTE1
, INDUSTRY_ATTRIBUTE2 INDUSTRY_ATTRIBUTE2
, INDUSTRY_ATTRIBUTE3 INDUSTRY_ATTRIBUTE3
, INDUSTRY_ATTRIBUTE4 INDUSTRY_ATTRIBUTE4
, INDUSTRY_ATTRIBUTE5 INDUSTRY_ATTRIBUTE5
, INDUSTRY_ATTRIBUTE6 INDUSTRY_ATTRIBUTE6
, INDUSTRY_ATTRIBUTE7 INDUSTRY_ATTRIBUTE7
, INDUSTRY_ATTRIBUTE8 INDUSTRY_ATTRIBUTE8
, INDUSTRY_ATTRIBUTE9 INDUSTRY_ATTRIBUTE9
, INDUSTRY_ATTRIBUTE10 INDUSTRY_ATTRIBUTE10
, INDUSTRY_ATTRIBUTE11 INDUSTRY_ATTRIBUTE11
, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13
, INDUSTRY_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE14 INDUSTRY_ATTRIBUTE14
, INDUSTRY_ATTRIBUTE15 INDUSTRY_ATTRIBUTE15
, INDUSTRY_ATTRIBUTE16 INDUSTRY_ATTRIBUTE16
, INDUSTRY_ATTRIBUTE17 INDUSTRY_ATTRIBUTE17
, INDUSTRY_ATTRIBUTE18 INDUSTRY_ATTRIBUTE18
, INDUSTRY_ATTRIBUTE19 INDUSTRY_ATTRIBUTE19
, INDUSTRY_ATTRIBUTE20 INDUSTRY_ATTRIBUTE20
, INDUSTRY_ATTRIBUTE21 INDUSTRY_ATTRIBUTE21
, INDUSTRY_ATTRIBUTE22 INDUSTRY_ATTRIBUTE22
, INDUSTRY_ATTRIBUTE23 INDUSTRY_ATTRIBUTE23
, INDUSTRY_ATTRIBUTE24 INDUSTRY_ATTRIBUTE24
, INDUSTRY_ATTRIBUTE25 INDUSTRY_ATTRIBUTE25
, INDUSTRY_ATTRIBUTE26 INDUSTRY_ATTRIBUTE26
, INDUSTRY_ATTRIBUTE27 INDUSTRY_ATTRIBUTE27
, INDUSTRY_ATTRIBUTE28 INDUSTRY_ATTRIBUTE28
, INDUSTRY_ATTRIBUTE29 INDUSTRY_ATTRIBUTE29
, INDUSTRY_ATTRIBUTE30 INDUSTRY_ATTRIBUTE30
, 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
, TOP_MODEL_LINE_ID TOP_MODEL_LINE_ID
, LINK_TO_LINE_ID LINK_TO_LINE_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, CONFIG_DISPLAY_SEQUENCE CONFIG_DISPLAY_SEQUENCE
, SORT_ORDER SORT_ORDER
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, OPTION_NUMBER OPTION_NUMBER
, OPTION_FLAG OPTION_FLAG
, DEP_PLAN_REQUIRED_FLAG DEP_PLAN_REQUIRED_FLAG
, VISIBLE_DEMAND_FLAG VISIBLE_DEMAND_FLAG
, LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE
, CUSTOMER_TRX_LINE_ID CUSTOMER_TRX_LINE_ID
, RETURN_CONTEXT RETURN_CONTEXT
, RETURN_ATTRIBUTE1 RETURN_ATTRIBUTE1
, RETURN_ATTRIBUTE2 RETURN_ATTRIBUTE2
, RETURN_ATTRIBUTE3 RETURN_ATTRIBUTE3
, RETURN_ATTRIBUTE4 RETURN_ATTRIBUTE4
, RETURN_ATTRIBUTE5 RETURN_ATTRIBUTE5
, RETURN_ATTRIBUTE6 RETURN_ATTRIBUTE6
, RETURN_ATTRIBUTE7 RETURN_ATTRIBUTE7
, RETURN_ATTRIBUTE8 RETURN_ATTRIBUTE8
, RETURN_ATTRIBUTE9 RETURN_ATTRIBUTE9
, RETURN_ATTRIBUTE10 RETURN_ATTRIBUTE10
, RETURN_ATTRIBUTE11 RETURN_ATTRIBUTE11
, RETURN_ATTRIBUTE12 RETURN_ATTRIBUTE12
, RETURN_ATTRIBUTE13 RETURN_ATTRIBUTE13
, RETURN_ATTRIBUTE14 RETURN_ATTRIBUTE14
, RETURN_ATTRIBUTE15 RETURN_ATTRIBUTE15
, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE
, ATO_LINE_ID ATO_LINE_ID
, AUTO_SELECTED_QUANTITY AUTO_SELECTED_QUANTITY
, COMPONENT_NUMBER COMPONENT_NUMBER
, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE
, EXPLOSION_DATE EXPLOSION_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, CANCELLED_FLAG CANCELLED_FLAG
, OPEN_FLAG OPEN_FLAG
, BOOKED_FLAG BOOKED_FLAG
, SALESREP_ID SALESREP_ID
, RETURN_REASON_CODE RETURN_REASON_CODE
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, SHIP_SET_ID SHIP_SET_ID
, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM
, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG
, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG
, ORDERED_ITEM_ID ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE ITEM_IDENTIFIER_TYPE
, CONFIGURATION_ID CONFIGURATION_ID
, COMMITMENT_ID COMMITMENT_ID
, SHIPPING_INTERFACED_FLAG SHIPPING_INTERFACED_FLAG
, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID
, FIRST_ACK_CODE FIRST_ACK_CODE
, FIRST_ACK_DATE FIRST_ACK_DATE
, LAST_ACK_CODE LAST_ACK_CODE
, LAST_ACK_DATE LAST_ACK_DATE
, PLANNING_PRIORITY PLANNING_PRIORITY
, ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, FULFILLED_FLAG FULFILLED_FLAG
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REV_NBR CONFIG_REV_NBR
, MFG_COMPONENT_SEQUENCE_ID MFG_COMPONENT_SEQUENCE_ID
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, INVOICED_QUANTITY INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY SPLIT_BY
, LINE_SET_ID LINE_SET_ID
, SERVICE_TXN_REASON_CODE SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS SERVICE_TXN_COMMENTS
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_START_DATE SERVICE_START_DATE
, SERVICE_END_DATE SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER SERVICE_NUMBER
, SERVICE_PERIOD SERVICE_PERIOD
, SHIPPABLE_FLAG SHIPPABLE_FLAG
, MODEL_REMNANT_FLAG MODEL_REMNANT_FLAG
, RE_SOURCE_FLAG RE_SOURCE_FLAG
, FLOW_STATUS_CODE FLOW_STATUS_CODE
, TP_CONTEXT TP_CONTEXT
, TP_ATTRIBUTE1 TP_ATTRIBUTE1
, TP_ATTRIBUTE2 TP_ATTRIBUTE2
, TP_ATTRIBUTE3 TP_ATTRIBUTE3
, TP_ATTRIBUTE4 TP_ATTRIBUTE4
, TP_ATTRIBUTE5 TP_ATTRIBUTE5
, TP_ATTRIBUTE6 TP_ATTRIBUTE6
, TP_ATTRIBUTE7 TP_ATTRIBUTE7
, TP_ATTRIBUTE8 TP_ATTRIBUTE8
, TP_ATTRIBUTE9 TP_ATTRIBUTE9
, TP_ATTRIBUTE10 TP_ATTRIBUTE10
, TP_ATTRIBUTE11 TP_ATTRIBUTE11
, TP_ATTRIBUTE12 TP_ATTRIBUTE12
, TP_ATTRIBUTE13 TP_ATTRIBUTE13
, TP_ATTRIBUTE14 TP_ATTRIBUTE14
, TP_ATTRIBUTE15 TP_ATTRIBUTE15
, FULFILLMENT_METHOD_CODE FULFILLMENT_METHOD_CODE
, MARKETING_SOURCE_CODE_ID MARKETING_SOURCE_CODE_ID
, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID SERVICE_REFERENCE_SYSTEM_ID
, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG
, UPGRADED_FLAG UPGRADED_FLAG
, REVENUE_AMOUNT REVENUE_AMOUNT
, FULFILLMENT_DATE FULFILLMENT_DATE
, PREFERRED_GRADE PREFERRED_GRADE
, ORDERED_QUANTITY2 ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2
, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2
, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2
, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2
, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2
, MFG_LEAD_TIME MFG_LEAD_TIME
, LOCK_CONTROL LOCK_CONTROL
, SUBINVENTORY SUBINVENTORY
, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY
, PRICE_REQUEST_CODE PRICE_REQUEST_CODE
, ORIGINAL_INVENTORY_ITEM_ID ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ORDERED_ITEM_ID ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM ORIGINAL_ORDERED_ITEM
, ORIGINAL_ITEM_IDENTIFIER_TYPE ORIGINAL_ITEM_IDENTIFIER_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE ITEM_SUBSTITUTION_TYPE_CODE
, OVERRIDE_ATP_DATE_CODE OVERRIDE_ATP_DATE_CODE
, LATE_DEMAND_PENALTY_FACTOR LATE_DEMAND_PENALTY_FACTOR
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION
, UNIT_COST UNIT_COST
, ITEM_RELATIONSHIP_TYPE ITEM_RELATIONSHIP_TYPE
, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER
, BLANKET_NUMBER BLANKET_NUMBER
, BLANKET_VERSION_NUMBER BLANKET_VERSION_NUMBER
, SALES_DOCUMENT_TYPE_CODE SALES_DOCUMENT_TYPE_CODE
, FIRM_DEMAND_FLAG FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE EARLIEST_SHIP_DATE
, TRANSACTION_PHASE_CODE TRANSACTION_PHASE_CODE
, SOURCE_DOCUMENT_VERSION_NUMBER SOURCE_DOCUMENT_VERSION_NUMBER
, PAYMENT_TYPE_CODE PAYMENT_TYPE_CODE
, MINISITE_ID MINISITE_ID
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, IB_OWNER IB_OWNER
, IB_CURRENT_LOCATION IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION
, RETROBILL_REQUEST_ID RETROBILL_REQUEST_ID
, ORIGINAL_LIST_PRICE ORIGINAL_LIST_PRICE
, SERVICE_CREDIT_ELIGIBLE_CODE SERVICE_CREDIT_ELIGIBLE_CODE
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE
, CHARGE_PERIODICITY_CODE CHARGE_PERIODICITY_CODE
, CONTINGENCY_ID CONTINGENCY_ID
, REVREC_EVENT_CODE REVREC_EVENT_CODE
, REVREC_EXPIRATION_DAYS REVREC_EXPIRATION_DAYS
, ACCEPTED_QUANTITY ACCEPTED_QUANTITY
, ACCEPTED_BY ACCEPTED_BY
, REVREC_COMMENTS REVREC_COMMENTS
, REVREC_REFERENCE_DOCUMENT REVREC_REFERENCE_DOCUMENT
, REVREC_SIGNATURE REVREC_SIGNATURE
, REVREC_SIGNATURE_DATE REVREC_SIGNATURE_DATE
, REVREC_IMPLICIT_FLAG REVREC_IMPLICIT_FLAG
, BYPASS_SCH_FLAG BYPASS_SCH_FLAG
, PRE_EXPLODED_FLAG PRE_EXPLODED_FLAG
, INST_ID INST_ID
, TAX_LINE_VALUE TAX_LINE_VALUE
, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID
, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID
, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID
, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE
, SERVICE_FIRST_PERIOD_AMOUNT SERVICE_FIRST_PERIOD_AMOUNT
, SERVICE_FIRST_PERIOD_ENDDATE SERVICE_FIRST_PERIOD_ENDDATE
, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG
, FULFILLMENT_BASE FULFILLMENT_BASE
FROM "ONT"."OE_ORDER_LINES_ALL"