[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_ORDER_LINES_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_ORDER_LINES_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
Stores history of attribute change for Order Lines.
| Tablespace: |  APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_ORDER_LINES_HISTORY_N1 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
 LINE_ID
HIST_TYPE_CODE
|
| OE_ORDER_LINES_HISTORY_N2 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
HIST_CREATION_DATE
|
| OE_ORDER_LINES_HISTORY_N4 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
HEADER_ID
VERSION_NUMBER
|
| OE_ORDER_LINES_HISTORY_N5 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
TOP_MODEL_LINE_ID
|
| 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 |
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;
ONT.OE_ORDER_LINES_HISTORY does not reference any database object
ONT.OE_ORDER_LINES_HISTORY is referenced by following:
ONT
OE_ORDER_LINES_HISTORY#
|
|
|
|