DBA Data[Home] [Help] [Dependency Information]


TABLE: ONT.OE_ORDER_LINES_HISTORY

Object Details
Object Name: OE_ORDER_LINES_HISTORY
Object Type: TABLE
Owner: ONT
FND Design Data: TableONT.OE_ORDER_LINES_HISTORY
Subobject Name:
Status: VALID


Stores history of attribute change for Order Lines.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_ORDER_LINES_HISTORY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnLINE_ID
ColumnHIST_TYPE_CODE
OE_ORDER_LINES_HISTORY_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnHIST_CREATION_DATE
OE_ORDER_LINES_HISTORY_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnHEADER_ID
ColumnVERSION_NUMBER
OE_ORDER_LINES_HISTORY_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTOP_MODEL_LINE_ID
Columns
Name Datatype Length Mandatory Comments
LINE_ID NUMBER

Line
ORG_ID NUMBER

Operating Unit which performed this transaction.
HEADER_ID NUMBER

Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs.
LINE_TYPE_ID NUMBER

Line Transaction Type Identifier
LINE_NUMBER NUMBER

Line sequence number within the order
REQUEST_DATE DATE

Ordered Item Request date
PROMISE_DATE DATE

Date promised to customer to receive item
SCHEDULE_SHIP_DATE DATE

Date Scheduled to ship item
ORDER_QUANTITY_UOM VARCHAR2 (3)
Ordered quantity Unit of measure
PRICING_QUANTITY NUMBER

Quantity based on pricing unit of measure
PRICING_QUANTITY_UOM VARCHAR2 (3)
Unit of measure used for pricing
CANCELLED_QUANTITY NUMBER

Cancelled Quantity
SHIPPED_QUANTITY NUMBER

Shipped Quantity
ORDERED_QUANTITY NUMBER

Quantity Ordered
FULFILLED_QUANTITY NUMBER

Fulfilled Quantity
SHIPPING_QUANTITY NUMBER

Shipping Quantity
SHIPPING_QUANTITY_UOM VARCHAR2 (3)
Shipping Quantity UOM
DELIVERY_LEAD_TIME NUMBER

Deliver Lead time
TAX_EXEMPT_FLAG VARCHAR2 (1)
indicates tax exemption
TAX_EXEMPT_NUMBER VARCHAR2 (80)
Tax exemption number
TAX_EXEMPT_REASON_CODE VARCHAR2 (30)
The reason code for Tax exemption
SHIP_FROM_ORG_ID NUMBER

Ship from organization id -warehouse
SHIP_TO_ORG_ID NUMBER

Ship to Organization Id
INVOICE_TO_ORG_ID NUMBER

Invoice To Organization ID
DELIVER_TO_ORG_ID NUMBER

Deliver to Organization Id
SHIP_TO_CONTACT_ID NUMBER

Person to which line is to be shipped
DELIVER_TO_CONTACT_ID NUMBER

Deliver to Contact Id
INVOICE_TO_CONTACT_ID NUMBER

Invoice To Contact ID
SOLD_FROM_ORG_ID NUMBER

Selling organization
SOLD_TO_ORG_ID NUMBER

Customer to whom the item is sold to
CUST_PO_NUMBER VARCHAR2 (50)
Customer Purchase Order Number
SHIP_TOLERANCE_ABOVE NUMBER

Over Shipment/Return Tolerance
SHIP_TOLERANCE_BELOW NUMBER

Under Shipment/Return Tolerance
DEMAND_BUCKET_TYPE_CODE VARCHAR2 (30)
Bucket Type designator (e.g, discrete, weekly, monthly) associated with the order line.
VEH_CUS_ITEM_CUM_KEY_ID NUMBER

Customer Item cum key unique identifier. Updated at the time of shipment.
RLA_SCHEDULE_TYPE_CODE VARCHAR2 (30)
Source to determine replacement eligibility and hierarchy for the netting logic.
CUSTOMER_DOCK_CODE VARCHAR2 (50)
A specific delivery location at the ship-to destination
CUSTOMER_JOB VARCHAR2 (50)
Customer Job number
CUSTOMER_PRODUCTION_LINE VARCHAR2 (50)
Customer Production Line .
CUST_MODEL_SERIAL_NUMBER VARCHAR2 (50)
Vehicle Id Number (VIN)
PROJECT_ID NUMBER

Project associated with this transaction
TASK_ID NUMBER

Task associated with this transaction
INVENTORY_ITEM_ID NUMBER

Inventory Item ID
TAX_DATE DATE

Tax Date
TAX_CODE VARCHAR2 (50)
Tax Code
TAX_RATE NUMBER

Tax Rate
DEMAND_CLASS_CODE VARCHAR2 (30)
Demand Class
PRICE_LIST_ID NUMBER

Price List
PRICING_DATE DATE

Determines effective list and price modifiers
SHIPMENT_NUMBER NUMBER

System generated identifer of a shipment within a line
AGREEMENT_ID NUMBER

Internal use only
SHIPMENT_PRIORITY_CODE VARCHAR2 (30)
Shipment Priority Code
SHIPPING_METHOD_CODE VARCHAR2 (30)
Shipping method
FREIGHT_CARRIER_CODE VARCHAR2 (30)
Freight Carrier code
FREIGHT_TERMS_CODE VARCHAR2 (30)
Freight Terms
FOB_POINT_CODE VARCHAR2 (30)
FOB Point Code
TAX_POINT_CODE VARCHAR2 (30)
Tax point
PAYMENT_TERM_ID NUMBER

Payment Terms
INVOICING_RULE_ID NUMBER

Invoicing rule used by AR for generating Invoice
ACCOUNTING_RULE_ID NUMBER

Accounting rule used by AR for generating Invoice
SOURCE_DOCUMENT_TYPE_ID NUMBER

Indicates the source of the order
ORIG_SYS_DOCUMENT_REF VARCHAR2 (50)
Original document reference for the order in external system
SOURCE_DOCUMENT_ID NUMBER

Source Order Header Id
ORIG_SYS_LINE_REF VARCHAR2 (50)
Original line information for the line of the order in external system
SOURCE_DOCUMENT_LINE_ID NUMBER

Source Order Line Id
REFERENCE_LINE_ID NUMBER

Reference Line
REFERENCE_TYPE VARCHAR2 (30)
Refernce Type
REFERENCE_HEADER_ID NUMBER

Reference Order
ITEM_REVISION VARCHAR2 (3)
Item Revision
UNIT_SELLING_PRICE NUMBER

Actual price chaged to customer
UNIT_LIST_PRICE NUMBER

Price List price for the item
TAX_VALUE NUMBER

Tax Value
CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE1 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE2 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE3 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE4 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE5 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE6 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE7 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE8 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE9 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE10 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE11 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE12 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE13 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE14 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE15 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE16 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE17 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE18 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE19 VARCHAR2 (240)
Reserved for country-specific functionality.
GLOBAL_ATTRIBUTE20 VARCHAR2 (240)
Reserved for country-specific functionality.
PRICING_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
PRICING_ATTRIBUTE1 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE2 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE3 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE4 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE5 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE6 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE7 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE8 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE9 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
PRICING_ATTRIBUTE10 VARCHAR2 (240)
Pricing Related Descriptive Flexfield segment
INDUSTRY_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE1 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE2 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE3 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE4 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE5 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE6 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE7 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE8 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE9 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE10 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE11 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE13 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE12 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE14 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE15 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE16 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE17 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE18 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE19 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE20 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE21 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE22 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE23 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE24 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE25 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE26 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE27 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE28 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE29 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
INDUSTRY_ATTRIBUTE30 VARCHAR2 (240)
Industry specific Descriptive Flexfield segment
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Application of concurrent program that last updated row.
PROGRAM_ID NUMBER

Concurrent program that last updated row.
PROGRAM_UPDATE_DATE DATE

Last date changed by concurrent program
REQUEST_ID NUMBER

Concurrent request that last changed row
CONFIGURATION_ID NUMBER

Configuration
LINK_TO_LINE_ID NUMBER

System-generated identifier of immediate parent component line
COMPONENT_SEQUENCE_ID NUMBER

Bill of materials component (option) or bill (top model)
COMPONENT_CODE VARCHAR2 (1000)
Identifier of component within an exploded bill
CONFIG_DISPLAY_SEQUENCE NUMBER

Not used
SORT_ORDER VARCHAR2 (2000)
Sorting sequence for a component within ordered bill
ITEM_TYPE_CODE VARCHAR2 (30)
Type of item
OPTION_NUMBER NUMBER

System generated identifer for an option or a class within a model
OPTION_FLAG VARCHAR2 (1)
Not used
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
Departure Planning Required Flag
VISIBLE_DEMAND_FLAG VARCHAR2 (1)
Indicated line is visible to planning as demand
LINE_CATEGORY_CODE VARCHAR2 (30)
Indicates whether the line is regular or return
ACTUAL_SHIPMENT_DATE DATE

Actual Shipment Date
CUSTOMER_TRX_LINE_ID NUMBER

Customer transaction Line
RETURN_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
RETURN_ATTRIBUTE1 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE2 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE3 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE4 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE5 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE6 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE7 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE8 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE9 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE10 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE11 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE12 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE13 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE14 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
RETURN_ATTRIBUTE15 VARCHAR2 (240)
Returns specific descriptive Flexfield segment
INTMED_SHIP_TO_ORG_ID NUMBER

Intermediate ship to organization id for the line
INTMED_SHIP_TO_CONTACT_ID NUMBER

Intermediate ship to contact id for the Line
ACTUAL_ARRIVAL_DATE DATE

Date the item actually arrived at customer's site
ATO_LINE_ID NUMBER

System-generated identifier if ATO configuration top model line
AUTO_SELECTED_QUANTITY NUMBER

Not used
COMPONENT_NUMBER NUMBER

System Generated Identifier of the included item within a model or a class
EARLIEST_ACCEPTABLE_DATE DATE

Earliest Date the item is acceptable.
EXPLOSION_DATE DATE

Date when the included items were exploded and frozen
LATEST_ACCEPTABLE_DATE DATE

Latest Date the item is acceptable.
MODEL_GROUP_NUMBER NUMBER

Not used
SCHEDULE_ARRIVAL_DATE DATE

Date Scheduled for the item to arrive at the customer site
SHIP_MODEL_COMPLETE_FLAG VARCHAR2 (1)
Indicates whether line is in ship-complete configuration
SCHEDULE_STATUS_CODE VARCHAR2 (30)
Indicates if the line is scheduled
SOURCE_TYPE_CODE VARCHAR2 (30)
Sourcing indicator (internal or external)
TOP_MODEL_LINE_ID NUMBER

System-generated identifier of configuration top parent line
BOOKED_FLAG VARCHAR2 (1)
Booking Status
CANCELLED_FLAG VARCHAR2 (1)
Indicates whether line is completely cancelled
OPEN_FLAG VARCHAR2 (1)
Line Open Status
LOAD_SEQ_NUMBER NUMBER

Load Sequence
DELIVERY_ID NUMBER

Delivery
SALESREP_ID NUMBER (15)
Sales person identifier
RETURN_REASON_CODE VARCHAR2 (30)
Return Reason
WF_ACTIVITY_CODE VARCHAR2 (50)
No longer used
WF_RESULT_CODE VARCHAR2 (50)
No longer used
REASON_CODE VARCHAR2 (30)
Stores reason for attribute change
HIST_COMMENTS VARCHAR2 (2000)
Stores comments for attribute change.
HIST_TYPE_CODE VARCHAR2 (30) Yes Indicates which action resulted in history(Cancel/Split)
HIST_CREATION_DATE DATE

Date on which a change is done.
HIST_CREATED_BY NUMBER

Standard Who column
CUST_PRODUCTION_SEQ_NUM VARCHAR2 (50)
Unique production sequence that indicates how the customer transmitted the demand lines.
AUTHORIZED_TO_SHIP_FLAG VARCHAR2 (1)
Field to identify whether the demand lines are authorized to ship.
SPLIT_FROM_LINE_ID NUMBER

System generated identifier of original line which was split
OVER_SHIP_REASON_CODE VARCHAR2 (30)
Overshipment Reason Code
OVER_SHIP_RESOLVED_FLAG VARCHAR2 (1)
Overshipment Resolved Flag
ITEM_IDENTIFIER_TYPE VARCHAR2 (25)
To distinguish different types of items (internal, customer. and generic items)
ARRIVAL_SET_ID NUMBER

Arrival Set
SHIP_SET_ID NUMBER

Ship Set Id; if the line belongs to a ship set
COMMITMENT_ID NUMBER

Commitment to apply line against
SHIPPING_INTERFACED_FLAG VARCHAR2 (1)
Shipping Interfaced Flag
CREDIT_INVOICE_LINE_ID NUMBER

Used for return lines
MFG_COMPONENT_SEQUENCE_ID NUMBER

Not used
TP_CONTEXT VARCHAR2 (30)
Descriptive Flexfield segment
TP_ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
TP_ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
FULFILLMENT_METHOD_CODE VARCHAR2 (30)
Fulfillment Method Code
SERVICE_REFERENCE_TYPE_CODE VARCHAR2 (30)
To identify the service reference type. Typical values are Order and Customer Product
SERVICE_REFERENCE_LINE_ID NUMBER

Identifies the immediate parent line to which the service is attached.
SERVICE_REFERENCE_SYSTEM_ID NUMBER

To store system id for either reference type like order or customer product.
INVOICE_INTERFACE_STATUS_CODE VARCHAR2 (30)
Code to indicate invoice interface status
ORDERED_ITEM VARCHAR2 (2000)
Item Display Value
ORDERED_ITEM_ID NUMBER

Ordered Item Identifier
SERVICE_NUMBER NUMBER

Unique number to identify the service line/s.
SERVICED_LINE_ID NUMBER

Serviced Line/Item
SERVICE_DURATION NUMBER

Field to store the duration for which service is ordered.
SERVICE_START_DATE DATE

Start date for the service
RE_SOURCE_FLAG VARCHAR2 (1)
Indicates whether user entered the warehouse or the system did
FLOW_STATUS_CODE VARCHAR2 (30)
Workflow status for the line
SERVICE_END_DATE DATE

End date for the service
SERVICE_COTERMINATE_FLAG VARCHAR2 (1)
To identify whether the service can be coterminated.
SHIPPABLE_FLAG VARCHAR2 (1)
flag to indicate line is Shippable
ORDER_SOURCE_ID NUMBER

Source of order line
ORIG_SYS_SHIPMENT_REF VARCHAR2 (50)
Original shipment information for the line of the order in external system
CHANGE_SEQUENCE VARCHAR2 (50)
It is sequence number in which changes will be applied. It will make sure that later changes are not over-written by previous line change.
DROP_SHIP_FLAG VARCHAR2 (1)
No longer used
CUSTOMER_LINE_NUMBER VARCHAR2 (50)
Reference Information. Contains customers line number, if specified while importing an order. Customers who have an alphanumeric line number can store their line number information in this field.
CUSTOMER_SHIPMENT_NUMBER VARCHAR2 (50)
Reference Information. Contains Customers Shipment number, if specified while importing an order. Customers who have an alphanumeric shipment number can store their shipment number information in this field.
CUSTOMER_ITEM_NET_PRICE NUMBER

Reference Information. Contains Customers net price, if specified while importing an order.
CUSTOMER_PAYMENT_TERM_ID NUMBER

Reference Information. Contains Customers payment term, if specified while importing an order.
FIRST_ACK_DATE DATE

Initial acknowledgment date for oubound EDI transaction
FIRST_ACK_CODE VARCHAR2 (30)
Initial acknowledgment code for oubound EDI transaction
LAST_ACK_CODE VARCHAR2 (30)
Latest acknowledgment code for oubound EDI transaction
LAST_ACK_DATE DATE

Latest acknowledgment date for oubound EDI transaction
PLANNING_PRIORITY NUMBER

Planning Priority
SERVICE_TXN_COMMENTS VARCHAR2 (2000)
Placeholder for service comments.
SERVICE_PERIOD VARCHAR2 (3)
Period for which service is offered.
UNIT_SELLING_PERCENT NUMBER

Percent actually charged to customer (percent based pricing only)
UNIT_LIST_PERCENT NUMBER

Price list percent of the item (percent-based pricing only)
UNIT_PERCENT_BASE_PRICE NUMBER

Based price used for percent based pricing
MODEL_REMNANT_FLAG VARCHAR2 (1)
Indicates whether model has partially shipped components
SERVICE_TXN_REASON_CODE VARCHAR2 (30)
To store service transaction reason.
CALCULATE_PRICE_FLAG VARCHAR2 (1)
Controls repricing of order lines
ITEM_INPUT VARCHAR2 (2000)
Stores name of ordered item
CUSTOMER_ITEM_ID NUMBER

Customer Item
CUSTOMER_ITEM_REVISION VARCHAR2 (50)
Customer Item Revision
ITEM_ID NUMBER

Stores Id of Ordered Item
INVOICE_COMPLETE_FLAG VARCHAR2 (1)
To indicate whether the invoicing activity is complete
END_ITEM_UNIT_NUMBER VARCHAR2 (30)
Uniquely identifies which bill of material to be used for building a specific Model/Unit Number effectivity controlled item
FULFILLED_FLAG VARCHAR2 (1)
Fulfilled Flag
CONFIG_HEADER_ID NUMBER

System-generated identifier for Oracle Configurator reference
CONFIG_REV_NBR NUMBER

System-generated identifier for Oracle Configurator reference
SHIPPING_INSTRUCTIONS VARCHAR2 (2000)
Shipping Instructions
PACKING_INSTRUCTIONS VARCHAR2 (2000)
Packing Instructions
INVOICED_QUANTITY NUMBER

Stores quantity to Invoice
REFERENCE_CUSTOMER_TRX_LINE_ID NUMBER

Reference customer transaction line identifier
SPLIT_BY VARCHAR2 (30)
Indicates whether the line is system or user level split
LINE_SET_ID NUMBER

Line Set id
REVENUE_AMOUNT NUMBER

For future use
FULFILLMENT_DATE DATE

Fulfillment Date for the Line
PREFERRED_GRADE VARCHAR2 (150)
Grade requested by the customer
ORDERED_QUANTITY2 NUMBER

Ordered quantity in secondary inventory unit of measure
ORDERED_QUANTITY_UOM2 VARCHAR2 (3)
Secondary invenetory unit of measure, display only
SHIPPED_QUANTITY2 NUMBER

Shipped quantity in ordered_quantity_uom2
CANCELLED_QUANTITY2 NUMBER

Cancelled quantity in ordered_quantity_uom2
SHIPPING_QUANTITY2 NUMBER

Shipping quantity in secondary shipping unit of measure
SHIPPING_QUANTITY_UOM2 VARCHAR2 (3)
Secondary unit of measure the item is shipped
FULFILLED_QUANTITY2 NUMBER

Fulfilled quantity in ordered_quantity_uom2
SUBINVENTORY VARCHAR2 (10)
Subinventory
RESPONSIBILITY_ID NUMBER

Responsibility id.
UNIT_LIST_PRICE_PER_PQTY NUMBER

Unit list price per pricing quantity.
UNIT_SELLING_PRICE_PER_PQTY NUMBER

Unit selling price per pricing quantity.
LATEST_CANCELLED_QUANTITY NUMBER

Latest Cancelled quanitity
PRICE_REQUEST_CODE VARCHAR2 (240)
Code identifies pricing transaction applied to Order Line
LATE_DEMAND_PENALTY_FACTOR NUMBER

This column can be used to specify the 'Penalty Factor for Late Demand' on the sales order line. This value is used in Planning.
OVERRIDE_ATP_DATE_CODE VARCHAR2 (30)
By setting this code, User can force a Schedule Ship Date , even if the supply is not available.
ITEM_SUBSTITUTION_TYPE_CODE VARCHAR2 (30)
Used to store the Item Substitution Type. It can be used to override the preferences specified in Item Substitution setup. It can also be used to turn-off substitution for the line.
ORIGINAL_ITEM_IDENTIFIER_TYPE VARCHAR2 (30)
Stores the Original Item Identifier Type when there is a substitution.
ORIGINAL_ORDERED_ITEM VARCHAR2 (2000)
Stores the Original Ordered Item when there is a substitution.
ORIGINAL_ORDERED_ITEM_ID NUMBER

Stores the Original Ordered Item when there is a substitution.
ORIGINAL_INVENTORY_ITEM_ID NUMBER

Stores the Original Inventory Item when there is a substitution.
ACCOUNTING_RULE_DURATION NUMBER (15)
Number of accounting periods, across which revenue is recognized.
ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield segment
USER_ITEM_DESCRIPTION VARCHAR2 (1000)
To store user entered item description.
ITEM_RELATIONSHIP_TYPE NUMBER

Stores the Item Relationship Type
BLANKET_NUMBER NUMBER

Reference to a Sales Agreement
BLANKET_LINE_NUMBER NUMBER

Reference to a Sales Agreement Line
BLANKET_VERSION_NUMBER NUMBER

Reference to a Sales Agreement Version
VERSION_NUMBER NUMBER

For future use
SALES_DOCUMENT_TYPE_CODE VARCHAR2 (30)
For Future Release
TRANSACTION_PHASE_CODE VARCHAR2 (30)
Indicates if Transaction is in negotitation or fulfillment phase
SOURCE_DOCUMENT_VERSION_NUMBER NUMBER

Internal Use Only.
END_CUSTOMER_ID NUMBER

Customer ID of End Customer
END_CUSTOMER_CONTACT_ID NUMBER

Contact ID of End Customer
END_CUSTOMER_SITE_USE_ID NUMBER

Site Use ID of End Customer
IB_OWNER VARCHAR2 (60)
Owner
IB_CURRENT_LOCATION VARCHAR2 (60)
Current Location
IB_INSTALLED_AT_LOCATION VARCHAR2 (60)
Installed at Location
AUDIT_FLAG VARCHAR2 (1)
It will be set for Audit records
VERSION_FLAG VARCHAR2 (1)
It will be set for Version records
PHASE_CHANGE_FLAG VARCHAR2 (1)
When the transaction phase changes from Negotiation to Fulfillment, this attribute will get set to Y
REASON_ID NUMBER

Foreign key reference to OE_REASONS
RETROBILL_REQUEST_ID NUMBER

Retrobill Request ID - Foreign key reference to OE_RETROBILL_REQUESTS
ORIGINAL_LIST_PRICE NUMBER

Value of Original List Price
MINISITE_ID NUMBER

Mini site Id for sales order lines
PAYMENT_TYPE_CODE VARCHAR2 (30)
Line level code for payment type
FIRM_DEMAND_FLAG VARCHAR2 (1)
Flag to indicate firm_demand or not
EARLIEST_SHIP_DATE DATE

Earliest possible date of Shipping
SERVICE_CREDIT_ELIGIBLE_CODE VARCHAR2 (30)
Flag to indicate whether a return of service is eligible for credit.
ORDER_FIRMED_DATE DATE

Order Firm Date
ACTUAL_FULFILLMENT_DATE DATE

Actual Fulfillment Date
CHARGE_PERIODICITY_CODE VARCHAR2 (3)
This column is used to determine the price for an order line with a recurring charge item
CONTINGENCY_ID NUMBER

Foreign key to AR_DEFERRAL_REASONS.CONTINGENCY_ID
REVREC_EVENT_CODE VARCHAR2 (30)
Revenue deferral event such as Invoicing, Acceptance.
REVREC_EXPIRATION_DAYS NUMBER

To expire this # of days after revenue recognition acceptance expiration event attribute.
ACCEPTED_QUANTITY NUMBER

If accepted for revenue recognition, the quantity = fulfilled quantity.If rejected for revenue recognition, the quantity = 0
ACCEPTED_BY NUMBER

User ID of the person performing the revenue recognition acceptance
REVREC_COMMENTS VARCHAR2 (2000)
Free form comments for revenue recognition acceptance or rejection
REVREC_REFERENCE_DOCUMENT VARCHAR2 (240)
Free form text area for entering information about the document that was received to confirm the revenue recognition acceptance or rejection.
REVREC_SIGNATURE VARCHAR2 (240)
Name of the customer who accepted or rejected for revenue recognition.
REVREC_SIGNATURE_DATE DATE

The date that the customer accepted or rejected for revenue recognition.
REVREC_IMPLICIT_FLAG VARCHAR2 (1)
Yes = Implicit Revenue Recognition AcceptanceNo or NULL = Explicit Revenue Recognition Acceptance
INST_ID NUMBER

used in RAC INSTANCE AFFINITY for context setting
SERVICE_BILL_PROFILE_ID NUMBER

Stores the Billing Profile value for Service Lines
SERVICE_COV_TEMPLATE_ID NUMBER

Stores Service Coverage Template ID for Extended Warranty Lines
SERVICE_SUBS_TEMPLATE_ID NUMBER

Stores Subscription Template ID for Subscription Service Lines
SERVICE_BILL_OPTION_CODE VARCHAR2 (10)
Stores the Serivce Billing Option Code that specifies how the Service Lines should be billed, should they be billed completly from Order Management, completely from Service Contracts, or first period from OM and subsequent periods from Service Contracts
SERVICE_FIRST_PERIOD_AMOUNT NUMBER

Stores the value for which the Service Line would get billed from Order Management in case of first period billing from Order Management
SERVICE_FIRST_PERIOD_ENDDATE DATE

Stores First Period Bill End Date when Service Lines are partially Billed from OM
SUBSCRIPTION_ENABLE_FLAG VARCHAR2 (1)
Stores a value of either 'Y' or 'N' to indicate if the Line has to be treated as Subscription Service Line or a Standard Line
Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

ONT.OE_ORDER_LINES_HISTORY does not reference any database object

ONT.OE_ORDER_LINES_HISTORY is referenced by following:

SchemaONT
ViewOE_ORDER_LINES_HISTORY#