VIEW: ONT.OE_LINES_IFACE_ALL#

Source

View Text - Preformatted

select ORDER_SOURCE_ID ORDER_SOURCE_ID, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF, CHANGE_SEQUENCE CHANGE_SEQUENCE, CHANGE_REQUEST_CODE CHANGE_REQUEST_CODE, ORG_ID ORG_ID, LINE_NUMBER LINE_NUMBER, SHIPMENT_NUMBER SHIPMENT_NUMBER, LINE_ID LINE_ID, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID, LINE_TYPE_ID LINE_TYPE_ID, LINE_TYPE LINE_TYPE, ITEM_TYPE_CODE ITEM_TYPE_CODE, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM INVENTORY_ITEM, TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF, LINK_TO_LINE_REF LINK_TO_LINE_REF, EXPLOSION_DATE EXPLOSION_DATE, ATO_LINE_ID ATO_LINE_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, COMPONENT_CODE COMPONENT_CODE, SORT_ORDER SORT_ORDER, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER, OPTION_NUMBER OPTION_NUMBER, OPTION_FLAG OPTION_FLAG, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG, SOURCE_TYPE_CODE SOURCE_TYPE_CODE, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE, PROMISE_DATE PROMISE_DATE, SCHEDULE_DATE SCHEDULE_DATE, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME, DELIVERY_ID DELIVERY_ID, ORDERED_QUANTITY ORDERED_QUANTITY, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM, SHIPPING_QUANTITY SHIPPING_QUANTITY, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM, SHIPPED_QUANTITY SHIPPED_QUANTITY, CANCELLED_QUANTITY CANCELLED_QUANTITY, FULFILLED_QUANTITY FULFILLED_QUANTITY, PRICING_QUANTITY PRICING_QUANTITY, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM, SOLD_TO_ORG_ID SOLD_TO_ORG_ID, SOLD_TO_ORG SOLD_TO_ORG, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID, SHIP_FROM_ORG SHIP_FROM_ORG, SHIP_TO_ORG_ID SHIP_TO_ORG_ID, SHIP_TO_ORG SHIP_TO_ORG, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID, DELIVER_TO_ORG DELIVER_TO_ORG, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID, INVOICE_TO_ORG INVOICE_TO_ORG, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4, SHIP_TO_CITY SHIP_TO_CITY, SHIP_TO_COUNTY SHIP_TO_COUNTY, SHIP_TO_STATE SHIP_TO_STATE, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE, SHIP_TO_COUNTRY SHIP_TO_COUNTRY, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE, SHIP_TO_CONTACT_AREA_CODE1 SHIP_TO_CONTACT_AREA_CODE1, SHIP_TO_CONTACT_AREA_CODE2 SHIP_TO_CONTACT_AREA_CODE2, SHIP_TO_CONTACT_AREA_CODE3 SHIP_TO_CONTACT_AREA_CODE3, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID, SHIP_TO_CONTACT SHIP_TO_CONTACT, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID, DELIVER_TO_CONTACT DELIVER_TO_CONTACT, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID, INVOICE_TO_CONTACT INVOICE_TO_CONTACT, DROP_SHIP_FLAG DROP_SHIP_FLAG, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW, SHIP_SET_ID SHIP_SET_ID, SHIP_SET_NAME SHIP_SET_NAME, ARRIVAL_SET_ID ARRIVAL_SET_ID, ARRIVAL_SET_NAME ARRIVAL_SET_NAME, INVOICE_SET_ID INVOICE_SET_ID, INVOICE_SET_NAME INVOICE_SET_NAME, FULFILLMENT_SET_ID FULFILLMENT_SET_ID, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME, PRICE_LIST_ID PRICE_LIST_ID, PRICE_LIST PRICE_LIST, PRICING_DATE PRICING_DATE, UNIT_LIST_PRICE UNIT_LIST_PRICE, UNIT_SELLING_PRICE UNIT_SELLING_PRICE, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG, TAX_CODE TAX_CODE, TAX TAX, TAX_VALUE TAX_VALUE, TAX_DATE TAX_DATE, TAX_POINT_CODE TAX_POINT_CODE, TAX_POINT TAX_POINT, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE, TAX_EXEMPT_REASON TAX_EXEMPT_REASON, AGREEMENT_ID AGREEMENT_ID, AGREEMENT AGREEMENT, INVOICING_RULE_ID INVOICING_RULE_ID, INVOICING_RULE INVOICING_RULE, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID, ACCOUNTING_RULE ACCOUNTING_RULE, PAYMENT_TERM_ID PAYMENT_TERM_ID, PAYMENT_TERM PAYMENT_TERM, DEMAND_CLASS_CODE DEMAND_CLASS_CODE, DEMAND_CLASS DEMAND_CLASS, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE, SHIPMENT_PRIORITY SHIPMENT_PRIORITY, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE, SHIPPING_METHOD SHIPPING_METHOD, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, FREIGHT_TERMS FREIGHT_TERMS, FOB_POINT_CODE FOB_POINT_CODE, FOB_POINT FOB_POINT, SALESREP_ID SALESREP_ID, SALESREP SALESREP, RETURN_REASON_CODE RETURN_REASON_CODE, REFERENCE_TYPE REFERENCE_TYPE, REFERENCE_HEADER_ID REFERENCE_HEADER_ID, REFERENCE_HEADER REFERENCE_HEADER, REFERENCE_LINE_ID REFERENCE_LINE_ID, REFERENCE_LINE REFERENCE_LINE, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, CUSTOMER_ITEM_ID_TYPE CUSTOMER_ITEM_ID_TYPE, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE, DEMAND_BUCKET_TYPE DEMAND_BUCKET_TYPE, SCHEDULE_ITEM_DETAIL SCHEDULE_ITEM_DETAIL, DEMAND_STREAM DEMAND_STREAM, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE, CUSTOMER_DOCK CUSTOMER_DOCK, CUSTOMER_JOB CUSTOMER_JOB, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER, PROJECT_ID PROJECT_ID, PROJECT PROJECT, TASK_ID TASK_ID, TASK TASK, ITEM_REVISION ITEM_REVISION, CLOSED_FLAG CLOSED_FLAG, CANCELLED_FLAG CANCELLED_FLAG, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER, LINE_PO_CONTEXT LINE_PO_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, 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_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13, 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, 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, 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, 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, INVENTORY_ITEM_SEGMENT_1 INVENTORY_ITEM_SEGMENT_1, INVENTORY_ITEM_SEGMENT_2 INVENTORY_ITEM_SEGMENT_2, INVENTORY_ITEM_SEGMENT_3 INVENTORY_ITEM_SEGMENT_3, INVENTORY_ITEM_SEGMENT_4 INVENTORY_ITEM_SEGMENT_4, INVENTORY_ITEM_SEGMENT_5 INVENTORY_ITEM_SEGMENT_5, INVENTORY_ITEM_SEGMENT_6 INVENTORY_ITEM_SEGMENT_6, INVENTORY_ITEM_SEGMENT_7 INVENTORY_ITEM_SEGMENT_7, INVENTORY_ITEM_SEGMENT_8 INVENTORY_ITEM_SEGMENT_8, INVENTORY_ITEM_SEGMENT_9 INVENTORY_ITEM_SEGMENT_9, INVENTORY_ITEM_SEGMENT_10 INVENTORY_ITEM_SEGMENT_10, INVENTORY_ITEM_SEGMENT_11 INVENTORY_ITEM_SEGMENT_11, INVENTORY_ITEM_SEGMENT_12 INVENTORY_ITEM_SEGMENT_12, INVENTORY_ITEM_SEGMENT_13 INVENTORY_ITEM_SEGMENT_13, INVENTORY_ITEM_SEGMENT_14 INVENTORY_ITEM_SEGMENT_14, INVENTORY_ITEM_SEGMENT_15 INVENTORY_ITEM_SEGMENT_15, INVENTORY_ITEM_SEGMENT_16 INVENTORY_ITEM_SEGMENT_16, INVENTORY_ITEM_SEGMENT_17 INVENTORY_ITEM_SEGMENT_17, INVENTORY_ITEM_SEGMENT_18 INVENTORY_ITEM_SEGMENT_18, INVENTORY_ITEM_SEGMENT_19 INVENTORY_ITEM_SEGMENT_19, INVENTORY_ITEM_SEGMENT_20 INVENTORY_ITEM_SEGMENT_20, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, 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, OPERATION_CODE OPERATION_CODE, ERROR_FLAG ERROR_FLAG, STATUS_FLAG STATUS_FLAG, INTERFACE_STATUS INTERFACE_STATUS, CHANGE_REASON CHANGE_REASON, CHANGE_COMMENTS CHANGE_COMMENTS, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, FULFILLED_FLAG FULFILLED_FLAG, REQUEST_DATE REQUEST_DATE, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID, SOLD_FROM_ORG SOLD_FROM_ORG, REJECTED_FLAG REJECTED_FLAG, 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_SELLING_PERCENT UNIT_SELLING_PERCENT, UNIT_LIST_PERCENT UNIT_LIST_PERCENT, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE, SERVICE_NUMBER SERVICE_NUMBER, SERVICED_LINE_ID SERVICED_LINE_ID, SERVICE_CONTEXT SERVICE_CONTEXT, SERVICE_ATTRIBUTE1 SERVICE_ATTRIBUTE1, SERVICE_ATTRIBUTE2 SERVICE_ATTRIBUTE2, SERVICE_ATTRIBUTE3 SERVICE_ATTRIBUTE3, SERVICE_ATTRIBUTE4 SERVICE_ATTRIBUTE4, SERVICE_ATTRIBUTE5 SERVICE_ATTRIBUTE5, SERVICE_ATTRIBUTE6 SERVICE_ATTRIBUTE6, SERVICE_ATTRIBUTE7 SERVICE_ATTRIBUTE7, SERVICE_ATTRIBUTE8 SERVICE_ATTRIBUTE8, SERVICE_ATTRIBUTE9 SERVICE_ATTRIBUTE9, SERVICE_ATTRIBUTE10 SERVICE_ATTRIBUTE10, SERVICE_ATTRIBUTE11 SERVICE_ATTRIBUTE11, SERVICE_ATTRIBUTE12 SERVICE_ATTRIBUTE12, SERVICE_ATTRIBUTE13 SERVICE_ATTRIBUTE13, SERVICE_ATTRIBUTE14 SERVICE_ATTRIBUTE14, SERVICE_ATTRIBUTE15 SERVICE_ATTRIBUTE15, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME, SERVICE_PERIOD SERVICE_PERIOD, 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, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE, SERVICE_REFERENCE_ORDER SERVICE_REFERENCE_ORDER, SERVICE_REFERENCE_LINE SERVICE_REFERENCE_LINE, SERVICE_REFERENCE_SYSTEM SERVICE_REFERENCE_SYSTEM, PREFERRED_GRADE PREFERRED_GRADE, ORDERED_QUANTITY2 ORDERED_QUANTITY2, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2, COMMITMENT_ID COMMITMENT_ID, COMMITMENT COMMITMENT, SUBINVENTORY SUBINVENTORY, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY, CONTEXT CONTEXT, RETURN_CONTEXT RETURN_CONTEXT, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE, INVOICE_TO_ADDRESS1 INVOICE_TO_ADDRESS1, INVOICE_TO_ADDRESS2 INVOICE_TO_ADDRESS2, INVOICE_TO_ADDRESS3 INVOICE_TO_ADDRESS3, INVOICE_TO_ADDRESS4 INVOICE_TO_ADDRESS4, INVOICE_TO_CITY INVOICE_TO_CITY, INVOICE_TO_COUNTY INVOICE_TO_COUNTY, INVOICE_TO_STATE INVOICE_TO_STATE, INVOICE_TO_POSTAL_CODE INVOICE_TO_POSTAL_CODE, INVOICE_TO_COUNTRY INVOICE_TO_COUNTRY, SPLIT_FROM_LINE_REF SPLIT_FROM_LINE_REF, PRICE_REQUEST_CODE PRICE_REQUEST_CODE, ORIG_SHIP_ADDRESS_REF ORIG_SHIP_ADDRESS_REF, ORIG_BILL_ADDRESS_REF ORIG_BILL_ADDRESS_REF, ORIG_DELIVER_ADDRESS_REF ORIG_DELIVER_ADDRESS_REF, SHIP_TO_CONTACT_REF SHIP_TO_CONTACT_REF, BILL_TO_CONTACT_REF BILL_TO_CONTACT_REF, DELIVER_TO_CONTACT_REF DELIVER_TO_CONTACT_REF, SPLIT_FROM_SHIPMENT_REF SPLIT_FROM_SHIPMENT_REF, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4, DELIVER_TO_CITY DELIVER_TO_CITY, DELIVER_TO_COUNTY DELIVER_TO_COUNTY, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY, DELIVER_TO_STATE DELIVER_TO_STATE, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE, ATTRIBUTE_STATUS ATTRIBUTE_STATUS, CONFIGURATION_ID CONFIGURATION_ID, CONFIG_HEADER_ID CONFIG_HEADER_ID, CONFIG_REV_NBR CONFIG_REV_NBR, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME, INVOICE_TO_CUSTOMER_NUMBER INVOICE_TO_CUSTOMER_NUMBER, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION, OVERRIDE_ATP_DATE_CODE OVERRIDE_ATP_DATE_CODE, LATE_DEMAND_PENALTY_FACTOR LATE_DEMAND_PENALTY_FACTOR, LINE_CATEGORY_CODE LINE_CATEGORY_CODE, XML_TRANSACTION_TYPE_CODE XML_TRANSACTION_TYPE_CODE, BLANKET_NUMBER BLANKET_NUMBER, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE, PLANNING_PRIORITY PLANNING_PRIORITY, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID, SHIP_TO_PARTY_SITE_USE_ID SHIP_TO_PARTY_SITE_USE_ID, DELIVER_TO_PARTY_ID DELIVER_TO_PARTY_ID, DELIVER_TO_PARTY_SITE_ID DELIVER_TO_PARTY_SITE_ID, DELIVER_TO_PARTY_SITE_USE_ID DELIVER_TO_PARTY_SITE_USE_ID, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_SITE_USE_ID INVOICE_TO_PARTY_SITE_USE_ID, SHIP_TO_ORG_CONTACT_ID SHIP_TO_ORG_CONTACT_ID, DELIVER_TO_ORG_CONTACT_ID DELIVER_TO_ORG_CONTACT_ID, INVOICE_TO_ORG_CONTACT_ID INVOICE_TO_ORG_CONTACT_ID, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER, END_CUSTOMER_NAME END_CUSTOMER_NAME, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER, END_CUSTOMER_ID END_CUSTOMER_ID, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID, END_CUSTOMER_ORG_CONTACT_ID END_CUSTOMER_ORG_CONTACT_ID, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT, END_CUSTOMER_LOCATION END_CUSTOMER_LOCATION, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID, END_CUSTOMER_PARTY_SITE_USE_ID END_CUSTOMER_PARTY_SITE_USE_ID, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4, END_CUSTOMER_CITY END_CUSTOMER_CITY, END_CUSTOMER_STATE END_CUSTOMER_STATE, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY, IB_OWNER IB_OWNER, IB_CURRENT_LOCATION IB_CURRENT_LOCATION, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION, ORDER_FIRMED_DATE ORDER_FIRMED_DATE, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE, IB_OWNER_CODE IB_OWNER_CODE, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE, INST_ID INST_ID, SHIP_TO_PROVINCE SHIP_TO_PROVINCE, INVOICE_TO_PROVINCE INVOICE_TO_PROVINCE, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID, SERVICE_BILLING_PROFILE SERVICE_BILLING_PROFILE, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID, SERVICE_COVERAGE_TEMPLATE SERVICE_COVERAGE_TEMPLATE, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID, SERVICE_SUBSCRIPTION_TEMPLATE SERVICE_SUBSCRIPTION_TEMPLATE, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG from "ONT"."OE_LINES_IFACE_ALL"

View Text - HTML Formatted

SELECT ORDER_SOURCE_ID ORDER_SOURCE_ID
, ORIG_SYS_DOCUMENT_REF ORIG_SYS_DOCUMENT_REF
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_SHIPMENT_REF ORIG_SYS_SHIPMENT_REF
, CHANGE_SEQUENCE CHANGE_SEQUENCE
, CHANGE_REQUEST_CODE CHANGE_REQUEST_CODE
, ORG_ID ORG_ID
, LINE_NUMBER LINE_NUMBER
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, LINE_ID LINE_ID
, SPLIT_FROM_LINE_ID SPLIT_FROM_LINE_ID
, LINE_TYPE_ID LINE_TYPE_ID
, LINE_TYPE LINE_TYPE
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM INVENTORY_ITEM
, TOP_MODEL_LINE_REF TOP_MODEL_LINE_REF
, LINK_TO_LINE_REF LINK_TO_LINE_REF
, EXPLOSION_DATE EXPLOSION_DATE
, ATO_LINE_ID ATO_LINE_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, COMPONENT_CODE COMPONENT_CODE
, SORT_ORDER SORT_ORDER
, MODEL_GROUP_NUMBER MODEL_GROUP_NUMBER
, OPTION_NUMBER OPTION_NUMBER
, OPTION_FLAG OPTION_FLAG
, SHIP_MODEL_COMPLETE_FLAG SHIP_MODEL_COMPLETE_FLAG
, SOURCE_TYPE_CODE SOURCE_TYPE_CODE
, SCHEDULE_STATUS_CODE SCHEDULE_STATUS_CODE
, SCHEDULE_SHIP_DATE SCHEDULE_SHIP_DATE
, SCHEDULE_ARRIVAL_DATE SCHEDULE_ARRIVAL_DATE
, ACTUAL_ARRIVAL_DATE ACTUAL_ARRIVAL_DATE
, PROMISE_DATE PROMISE_DATE
, SCHEDULE_DATE SCHEDULE_DATE
, DELIVERY_LEAD_TIME DELIVERY_LEAD_TIME
, DELIVERY_ID DELIVERY_ID
, ORDERED_QUANTITY ORDERED_QUANTITY
, ORDER_QUANTITY_UOM ORDER_QUANTITY_UOM
, SHIPPING_QUANTITY SHIPPING_QUANTITY
, SHIPPING_QUANTITY_UOM SHIPPING_QUANTITY_UOM
, SHIPPED_QUANTITY SHIPPED_QUANTITY
, CANCELLED_QUANTITY CANCELLED_QUANTITY
, FULFILLED_QUANTITY FULFILLED_QUANTITY
, PRICING_QUANTITY PRICING_QUANTITY
, PRICING_QUANTITY_UOM PRICING_QUANTITY_UOM
, SOLD_TO_ORG_ID SOLD_TO_ORG_ID
, SOLD_TO_ORG SOLD_TO_ORG
, SHIP_FROM_ORG_ID SHIP_FROM_ORG_ID
, SHIP_FROM_ORG SHIP_FROM_ORG
, SHIP_TO_ORG_ID SHIP_TO_ORG_ID
, SHIP_TO_ORG SHIP_TO_ORG
, DELIVER_TO_ORG_ID DELIVER_TO_ORG_ID
, DELIVER_TO_ORG DELIVER_TO_ORG
, INVOICE_TO_ORG_ID INVOICE_TO_ORG_ID
, INVOICE_TO_ORG INVOICE_TO_ORG
, SHIP_TO_ADDRESS1 SHIP_TO_ADDRESS1
, SHIP_TO_ADDRESS2 SHIP_TO_ADDRESS2
, SHIP_TO_ADDRESS3 SHIP_TO_ADDRESS3
, SHIP_TO_ADDRESS4 SHIP_TO_ADDRESS4
, SHIP_TO_CITY SHIP_TO_CITY
, SHIP_TO_COUNTY SHIP_TO_COUNTY
, SHIP_TO_STATE SHIP_TO_STATE
, SHIP_TO_POSTAL_CODE SHIP_TO_POSTAL_CODE
, SHIP_TO_COUNTRY SHIP_TO_COUNTRY
, SHIP_TO_CONTACT_FIRST_NAME SHIP_TO_CONTACT_FIRST_NAME
, SHIP_TO_CONTACT_LAST_NAME SHIP_TO_CONTACT_LAST_NAME
, SHIP_TO_CONTACT_JOB_TITLE SHIP_TO_CONTACT_JOB_TITLE
, SHIP_TO_CONTACT_AREA_CODE1 SHIP_TO_CONTACT_AREA_CODE1
, SHIP_TO_CONTACT_AREA_CODE2 SHIP_TO_CONTACT_AREA_CODE2
, SHIP_TO_CONTACT_AREA_CODE3 SHIP_TO_CONTACT_AREA_CODE3
, SHIP_TO_CONTACT_ID SHIP_TO_CONTACT_ID
, SHIP_TO_CONTACT SHIP_TO_CONTACT
, DELIVER_TO_CONTACT_ID DELIVER_TO_CONTACT_ID
, DELIVER_TO_CONTACT DELIVER_TO_CONTACT
, INVOICE_TO_CONTACT_ID INVOICE_TO_CONTACT_ID
, INVOICE_TO_CONTACT INVOICE_TO_CONTACT
, DROP_SHIP_FLAG DROP_SHIP_FLAG
, VEH_CUS_ITEM_CUM_KEY_ID VEH_CUS_ITEM_CUM_KEY_ID
, CUST_PRODUCTION_SEQ_NUM CUST_PRODUCTION_SEQ_NUM
, LOAD_SEQ_NUMBER LOAD_SEQ_NUMBER
, OVER_SHIP_REASON_CODE OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG OVER_SHIP_RESOLVED_FLAG
, AUTHORIZED_TO_SHIP_FLAG AUTHORIZED_TO_SHIP_FLAG
, SHIP_TOLERANCE_ABOVE SHIP_TOLERANCE_ABOVE
, SHIP_TOLERANCE_BELOW SHIP_TOLERANCE_BELOW
, SHIP_SET_ID SHIP_SET_ID
, SHIP_SET_NAME SHIP_SET_NAME
, ARRIVAL_SET_ID ARRIVAL_SET_ID
, ARRIVAL_SET_NAME ARRIVAL_SET_NAME
, INVOICE_SET_ID INVOICE_SET_ID
, INVOICE_SET_NAME INVOICE_SET_NAME
, FULFILLMENT_SET_ID FULFILLMENT_SET_ID
, FULFILLMENT_SET_NAME FULFILLMENT_SET_NAME
, PRICE_LIST_ID PRICE_LIST_ID
, PRICE_LIST PRICE_LIST
, PRICING_DATE PRICING_DATE
, UNIT_LIST_PRICE UNIT_LIST_PRICE
, UNIT_SELLING_PRICE UNIT_SELLING_PRICE
, CALCULATE_PRICE_FLAG CALCULATE_PRICE_FLAG
, TAX_CODE TAX_CODE
, TAX TAX
, TAX_VALUE TAX_VALUE
, TAX_DATE TAX_DATE
, TAX_POINT_CODE TAX_POINT_CODE
, TAX_POINT TAX_POINT
, TAX_EXEMPT_FLAG TAX_EXEMPT_FLAG
, TAX_EXEMPT_NUMBER TAX_EXEMPT_NUMBER
, TAX_EXEMPT_REASON_CODE TAX_EXEMPT_REASON_CODE
, TAX_EXEMPT_REASON TAX_EXEMPT_REASON
, AGREEMENT_ID AGREEMENT_ID
, AGREEMENT AGREEMENT
, INVOICING_RULE_ID INVOICING_RULE_ID
, INVOICING_RULE INVOICING_RULE
, ACCOUNTING_RULE_ID ACCOUNTING_RULE_ID
, ACCOUNTING_RULE ACCOUNTING_RULE
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PAYMENT_TERM PAYMENT_TERM
, DEMAND_CLASS_CODE DEMAND_CLASS_CODE
, DEMAND_CLASS DEMAND_CLASS
, SHIPMENT_PRIORITY_CODE SHIPMENT_PRIORITY_CODE
, SHIPMENT_PRIORITY SHIPMENT_PRIORITY
, SHIPPING_METHOD_CODE SHIPPING_METHOD_CODE
, SHIPPING_METHOD SHIPPING_METHOD
, FREIGHT_CARRIER_CODE FREIGHT_CARRIER_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, FREIGHT_TERMS FREIGHT_TERMS
, FOB_POINT_CODE FOB_POINT_CODE
, FOB_POINT FOB_POINT
, SALESREP_ID SALESREP_ID
, SALESREP SALESREP
, RETURN_REASON_CODE RETURN_REASON_CODE
, REFERENCE_TYPE REFERENCE_TYPE
, REFERENCE_HEADER_ID REFERENCE_HEADER_ID
, REFERENCE_HEADER REFERENCE_HEADER
, REFERENCE_LINE_ID REFERENCE_LINE_ID
, REFERENCE_LINE REFERENCE_LINE
, CREDIT_INVOICE_LINE_ID CREDIT_INVOICE_LINE_ID
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, CUSTOMER_LINE_NUMBER CUSTOMER_LINE_NUMBER
, CUSTOMER_SHIPMENT_NUMBER CUSTOMER_SHIPMENT_NUMBER
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, CUSTOMER_ITEM_ID_TYPE CUSTOMER_ITEM_ID_TYPE
, CUSTOMER_ITEM_REVISION CUSTOMER_ITEM_REVISION
, CUSTOMER_ITEM_NET_PRICE CUSTOMER_ITEM_NET_PRICE
, CUSTOMER_PAYMENT_TERM_ID CUSTOMER_PAYMENT_TERM_ID
, CUSTOMER_PAYMENT_TERM CUSTOMER_PAYMENT_TERM
, DEMAND_BUCKET_TYPE_CODE DEMAND_BUCKET_TYPE_CODE
, DEMAND_BUCKET_TYPE DEMAND_BUCKET_TYPE
, SCHEDULE_ITEM_DETAIL SCHEDULE_ITEM_DETAIL
, DEMAND_STREAM DEMAND_STREAM
, CUSTOMER_DOCK_CODE CUSTOMER_DOCK_CODE
, CUSTOMER_DOCK CUSTOMER_DOCK
, CUSTOMER_JOB CUSTOMER_JOB
, CUSTOMER_PRODUCTION_LINE CUSTOMER_PRODUCTION_LINE
, CUST_MODEL_SERIAL_NUMBER CUST_MODEL_SERIAL_NUMBER
, PROJECT_ID PROJECT_ID
, PROJECT PROJECT
, TASK_ID TASK_ID
, TASK TASK
, ITEM_REVISION ITEM_REVISION
, CLOSED_FLAG CLOSED_FLAG
, CANCELLED_FLAG CANCELLED_FLAG
, CONTRACT_PO_NUMBER CONTRACT_PO_NUMBER
, LINE_PO_CONTEXT LINE_PO_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
, 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_ATTRIBUTE12 INDUSTRY_ATTRIBUTE12
, INDUSTRY_ATTRIBUTE13 INDUSTRY_ATTRIBUTE13
, 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
, 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
, 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
, 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
, INVENTORY_ITEM_SEGMENT_1 INVENTORY_ITEM_SEGMENT_1
, INVENTORY_ITEM_SEGMENT_2 INVENTORY_ITEM_SEGMENT_2
, INVENTORY_ITEM_SEGMENT_3 INVENTORY_ITEM_SEGMENT_3
, INVENTORY_ITEM_SEGMENT_4 INVENTORY_ITEM_SEGMENT_4
, INVENTORY_ITEM_SEGMENT_5 INVENTORY_ITEM_SEGMENT_5
, INVENTORY_ITEM_SEGMENT_6 INVENTORY_ITEM_SEGMENT_6
, INVENTORY_ITEM_SEGMENT_7 INVENTORY_ITEM_SEGMENT_7
, INVENTORY_ITEM_SEGMENT_8 INVENTORY_ITEM_SEGMENT_8
, INVENTORY_ITEM_SEGMENT_9 INVENTORY_ITEM_SEGMENT_9
, INVENTORY_ITEM_SEGMENT_10 INVENTORY_ITEM_SEGMENT_10
, INVENTORY_ITEM_SEGMENT_11 INVENTORY_ITEM_SEGMENT_11
, INVENTORY_ITEM_SEGMENT_12 INVENTORY_ITEM_SEGMENT_12
, INVENTORY_ITEM_SEGMENT_13 INVENTORY_ITEM_SEGMENT_13
, INVENTORY_ITEM_SEGMENT_14 INVENTORY_ITEM_SEGMENT_14
, INVENTORY_ITEM_SEGMENT_15 INVENTORY_ITEM_SEGMENT_15
, INVENTORY_ITEM_SEGMENT_16 INVENTORY_ITEM_SEGMENT_16
, INVENTORY_ITEM_SEGMENT_17 INVENTORY_ITEM_SEGMENT_17
, INVENTORY_ITEM_SEGMENT_18 INVENTORY_ITEM_SEGMENT_18
, INVENTORY_ITEM_SEGMENT_19 INVENTORY_ITEM_SEGMENT_19
, INVENTORY_ITEM_SEGMENT_20 INVENTORY_ITEM_SEGMENT_20
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, 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
, OPERATION_CODE OPERATION_CODE
, ERROR_FLAG ERROR_FLAG
, STATUS_FLAG STATUS_FLAG
, INTERFACE_STATUS INTERFACE_STATUS
, CHANGE_REASON CHANGE_REASON
, CHANGE_COMMENTS CHANGE_COMMENTS
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, FULFILLED_FLAG FULFILLED_FLAG
, REQUEST_DATE REQUEST_DATE
, SHIPPING_INSTRUCTIONS SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS PACKING_INSTRUCTIONS
, SOLD_FROM_ORG_ID SOLD_FROM_ORG_ID
, SOLD_FROM_ORG SOLD_FROM_ORG
, REJECTED_FLAG REJECTED_FLAG
, 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_SELLING_PERCENT UNIT_SELLING_PERCENT
, UNIT_LIST_PERCENT UNIT_LIST_PERCENT
, UNIT_PERCENT_BASE_PRICE UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER SERVICE_NUMBER
, SERVICED_LINE_ID SERVICED_LINE_ID
, SERVICE_CONTEXT SERVICE_CONTEXT
, SERVICE_ATTRIBUTE1 SERVICE_ATTRIBUTE1
, SERVICE_ATTRIBUTE2 SERVICE_ATTRIBUTE2
, SERVICE_ATTRIBUTE3 SERVICE_ATTRIBUTE3
, SERVICE_ATTRIBUTE4 SERVICE_ATTRIBUTE4
, SERVICE_ATTRIBUTE5 SERVICE_ATTRIBUTE5
, SERVICE_ATTRIBUTE6 SERVICE_ATTRIBUTE6
, SERVICE_ATTRIBUTE7 SERVICE_ATTRIBUTE7
, SERVICE_ATTRIBUTE8 SERVICE_ATTRIBUTE8
, SERVICE_ATTRIBUTE9 SERVICE_ATTRIBUTE9
, SERVICE_ATTRIBUTE10 SERVICE_ATTRIBUTE10
, SERVICE_ATTRIBUTE11 SERVICE_ATTRIBUTE11
, SERVICE_ATTRIBUTE12 SERVICE_ATTRIBUTE12
, SERVICE_ATTRIBUTE13 SERVICE_ATTRIBUTE13
, SERVICE_ATTRIBUTE14 SERVICE_ATTRIBUTE14
, SERVICE_ATTRIBUTE15 SERVICE_ATTRIBUTE15
, CUSTOMER_ITEM_NAME CUSTOMER_ITEM_NAME
, SERVICE_PERIOD SERVICE_PERIOD
, 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
, SERVICE_REFERENCE_TYPE_CODE SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_ORDER SERVICE_REFERENCE_ORDER
, SERVICE_REFERENCE_LINE SERVICE_REFERENCE_LINE
, SERVICE_REFERENCE_SYSTEM SERVICE_REFERENCE_SYSTEM
, PREFERRED_GRADE PREFERRED_GRADE
, ORDERED_QUANTITY2 ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2 ORDERED_QUANTITY_UOM2
, SHIPPED_QUANTITY2 SHIPPED_QUANTITY2
, CANCELLED_QUANTITY2 CANCELLED_QUANTITY2
, SHIPPING_QUANTITY2 SHIPPING_QUANTITY2
, SHIPPING_QUANTITY_UOM2 SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2 FULFILLED_QUANTITY2
, COMMITMENT_ID COMMITMENT_ID
, COMMITMENT COMMITMENT
, SUBINVENTORY SUBINVENTORY
, UNIT_LIST_PRICE_PER_PQTY UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PER_PQTY UNIT_SELLING_PRICE_PER_PQTY
, CONTEXT CONTEXT
, RETURN_CONTEXT RETURN_CONTEXT
, EARLIEST_ACCEPTABLE_DATE EARLIEST_ACCEPTABLE_DATE
, LATEST_ACCEPTABLE_DATE LATEST_ACCEPTABLE_DATE
, INVOICE_TO_ADDRESS1 INVOICE_TO_ADDRESS1
, INVOICE_TO_ADDRESS2 INVOICE_TO_ADDRESS2
, INVOICE_TO_ADDRESS3 INVOICE_TO_ADDRESS3
, INVOICE_TO_ADDRESS4 INVOICE_TO_ADDRESS4
, INVOICE_TO_CITY INVOICE_TO_CITY
, INVOICE_TO_COUNTY INVOICE_TO_COUNTY
, INVOICE_TO_STATE INVOICE_TO_STATE
, INVOICE_TO_POSTAL_CODE INVOICE_TO_POSTAL_CODE
, INVOICE_TO_COUNTRY INVOICE_TO_COUNTRY
, SPLIT_FROM_LINE_REF SPLIT_FROM_LINE_REF
, PRICE_REQUEST_CODE PRICE_REQUEST_CODE
, ORIG_SHIP_ADDRESS_REF ORIG_SHIP_ADDRESS_REF
, ORIG_BILL_ADDRESS_REF ORIG_BILL_ADDRESS_REF
, ORIG_DELIVER_ADDRESS_REF ORIG_DELIVER_ADDRESS_REF
, SHIP_TO_CONTACT_REF SHIP_TO_CONTACT_REF
, BILL_TO_CONTACT_REF BILL_TO_CONTACT_REF
, DELIVER_TO_CONTACT_REF DELIVER_TO_CONTACT_REF
, SPLIT_FROM_SHIPMENT_REF SPLIT_FROM_SHIPMENT_REF
, DELIVER_TO_ADDRESS1 DELIVER_TO_ADDRESS1
, DELIVER_TO_ADDRESS2 DELIVER_TO_ADDRESS2
, DELIVER_TO_ADDRESS3 DELIVER_TO_ADDRESS3
, DELIVER_TO_ADDRESS4 DELIVER_TO_ADDRESS4
, DELIVER_TO_CITY DELIVER_TO_CITY
, DELIVER_TO_COUNTY DELIVER_TO_COUNTY
, DELIVER_TO_COUNTRY DELIVER_TO_COUNTRY
, DELIVER_TO_STATE DELIVER_TO_STATE
, DELIVER_TO_PROVINCE DELIVER_TO_PROVINCE
, DELIVER_TO_POSTAL_CODE DELIVER_TO_POSTAL_CODE
, ATTRIBUTE_STATUS ATTRIBUTE_STATUS
, CONFIGURATION_ID CONFIGURATION_ID
, CONFIG_HEADER_ID CONFIG_HEADER_ID
, CONFIG_REV_NBR CONFIG_REV_NBR
, SHIP_TO_CUSTOMER_ID SHIP_TO_CUSTOMER_ID
, INVOICE_TO_CUSTOMER_ID INVOICE_TO_CUSTOMER_ID
, DELIVER_TO_CUSTOMER_ID DELIVER_TO_CUSTOMER_ID
, SHIP_TO_CUSTOMER_NAME SHIP_TO_CUSTOMER_NAME
, SHIP_TO_CUSTOMER_NUMBER SHIP_TO_CUSTOMER_NUMBER
, INVOICE_TO_CUSTOMER_NAME INVOICE_TO_CUSTOMER_NAME
, INVOICE_TO_CUSTOMER_NUMBER INVOICE_TO_CUSTOMER_NUMBER
, DELIVER_TO_CUSTOMER_NAME DELIVER_TO_CUSTOMER_NAME
, DELIVER_TO_CUSTOMER_NUMBER DELIVER_TO_CUSTOMER_NUMBER
, ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_DURATION
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, USER_ITEM_DESCRIPTION USER_ITEM_DESCRIPTION
, OVERRIDE_ATP_DATE_CODE OVERRIDE_ATP_DATE_CODE
, LATE_DEMAND_PENALTY_FACTOR LATE_DEMAND_PENALTY_FACTOR
, LINE_CATEGORY_CODE LINE_CATEGORY_CODE
, XML_TRANSACTION_TYPE_CODE XML_TRANSACTION_TYPE_CODE
, BLANKET_NUMBER BLANKET_NUMBER
, BLANKET_LINE_NUMBER BLANKET_LINE_NUMBER
, ACTUAL_SHIPMENT_DATE ACTUAL_SHIPMENT_DATE
, PLANNING_PRIORITY PLANNING_PRIORITY
, SHIP_TO_PARTY_ID SHIP_TO_PARTY_ID
, SHIP_TO_PARTY_SITE_ID SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_SITE_USE_ID SHIP_TO_PARTY_SITE_USE_ID
, DELIVER_TO_PARTY_ID DELIVER_TO_PARTY_ID
, DELIVER_TO_PARTY_SITE_ID DELIVER_TO_PARTY_SITE_ID
, DELIVER_TO_PARTY_SITE_USE_ID DELIVER_TO_PARTY_SITE_USE_ID
, INVOICE_TO_PARTY_ID INVOICE_TO_PARTY_ID
, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_SITE_USE_ID INVOICE_TO_PARTY_SITE_USE_ID
, SHIP_TO_ORG_CONTACT_ID SHIP_TO_ORG_CONTACT_ID
, DELIVER_TO_ORG_CONTACT_ID DELIVER_TO_ORG_CONTACT_ID
, INVOICE_TO_ORG_CONTACT_ID INVOICE_TO_ORG_CONTACT_ID
, SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NUMBER
, INVOICE_TO_PARTY_NUMBER INVOICE_TO_PARTY_NUMBER
, DELIVER_TO_PARTY_NUMBER DELIVER_TO_PARTY_NUMBER
, END_CUSTOMER_NAME END_CUSTOMER_NAME
, END_CUSTOMER_NUMBER END_CUSTOMER_NUMBER
, END_CUSTOMER_PARTY_NUMBER END_CUSTOMER_PARTY_NUMBER
, END_CUSTOMER_ID END_CUSTOMER_ID
, END_CUSTOMER_PARTY_ID END_CUSTOMER_PARTY_ID
, END_CUSTOMER_ORG_CONTACT_ID END_CUSTOMER_ORG_CONTACT_ID
, END_CUSTOMER_CONTACT_ID END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_CONTACT END_CUSTOMER_CONTACT
, END_CUSTOMER_LOCATION END_CUSTOMER_LOCATION
, END_CUSTOMER_SITE_USE_ID END_CUSTOMER_SITE_USE_ID
, END_CUSTOMER_PARTY_SITE_ID END_CUSTOMER_PARTY_SITE_ID
, END_CUSTOMER_PARTY_SITE_USE_ID END_CUSTOMER_PARTY_SITE_USE_ID
, END_CUSTOMER_ADDRESS1 END_CUSTOMER_ADDRESS1
, END_CUSTOMER_ADDRESS2 END_CUSTOMER_ADDRESS2
, END_CUSTOMER_ADDRESS3 END_CUSTOMER_ADDRESS3
, END_CUSTOMER_ADDRESS4 END_CUSTOMER_ADDRESS4
, END_CUSTOMER_CITY END_CUSTOMER_CITY
, END_CUSTOMER_STATE END_CUSTOMER_STATE
, END_CUSTOMER_POSTAL_CODE END_CUSTOMER_POSTAL_CODE
, END_CUSTOMER_COUNTRY END_CUSTOMER_COUNTRY
, END_CUSTOMER_PROVINCE END_CUSTOMER_PROVINCE
, END_CUSTOMER_COUNTY END_CUSTOMER_COUNTY
, IB_OWNER IB_OWNER
, IB_CURRENT_LOCATION IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION IB_INSTALLED_AT_LOCATION
, ORDER_FIRMED_DATE ORDER_FIRMED_DATE
, ACTUAL_FULFILLMENT_DATE ACTUAL_FULFILLMENT_DATE
, IB_OWNER_CODE IB_OWNER_CODE
, IB_INSTALLED_AT_LOCATION_CODE IB_INSTALLED_AT_LOCATION_CODE
, IB_CURRENT_LOCATION_CODE IB_CURRENT_LOCATION_CODE
, INST_ID INST_ID
, SHIP_TO_PROVINCE SHIP_TO_PROVINCE
, INVOICE_TO_PROVINCE INVOICE_TO_PROVINCE
, SERVICE_BILL_PROFILE_ID SERVICE_BILL_PROFILE_ID
, SERVICE_BILLING_PROFILE SERVICE_BILLING_PROFILE
, SERVICE_COV_TEMPLATE_ID SERVICE_COV_TEMPLATE_ID
, SERVICE_COVERAGE_TEMPLATE SERVICE_COVERAGE_TEMPLATE
, SERVICE_SUBS_TEMPLATE_ID SERVICE_SUBS_TEMPLATE_ID
, SERVICE_SUBSCRIPTION_TEMPLATE SERVICE_SUBSCRIPTION_TEMPLATE
, SERVICE_BILL_OPTION_CODE SERVICE_BILL_OPTION_CODE
, SUBSCRIPTION_ENABLE_FLAG SUBSCRIPTION_ENABLE_FLAG
FROM "ONT"."OE_LINES_IFACE_ALL"