[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OE_ORDER_LINES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | ONT |
| FND Design Data: |  ONT.OE_ORDER_LINES_ALL
|
| Subobject Name: | |
| Status: | VALID |
OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OE_ORDER_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LINE_ID
|
| OE_ORDER_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
HEADER_ID
|
| OE_ORDER_LINES_N10 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TOP_MODEL_LINE_ID
|
| OE_ORDER_LINES_N11 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ORDER_SOURCE_ID
ORIG_SYS_DOCUMENT_REF
ORIG_SYS_LINE_REF
ORIG_SYS_SHIPMENT_REF
|
| OE_ORDER_LINES_N12 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ARRIVAL_SET_ID
|
| OE_ORDER_LINES_N13 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_SET_ID
|
| OE_ORDER_LINES_N14 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINK_TO_LINE_ID
|
| OE_ORDER_LINES_N15 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OPEN_FLAG
|
| OE_ORDER_LINES_N16 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CUST_PO_NUMBER
|
| OE_ORDER_LINES_N17 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ATO_LINE_ID
|
| OE_ORDER_LINES_N18 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COMMITMENT_ID
|
| OE_ORDER_LINES_N19 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BLANKET_NUMBER
BLANKET_LINE_NUMBER
|
| OE_ORDER_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SHIP_TO_ORG_ID
ORDERED_ITEM_ID
|
| OE_ORDER_LINES_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
INVENTORY_ITEM_ID
OPEN_FLAG
|
| OE_ORDER_LINES_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| OE_ORDER_LINES_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
REFERENCE_LINE_ID
|
| OE_ORDER_LINES_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LINE_SET_ID
|
| OE_ORDER_LINES_N9 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SERVICE_REFERENCE_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LINE_ID | NUMBER | Yes | System Generated Line Identifier. | |
| ORG_ID | NUMBER | Operating Unit which performed this transaction. | ||
| HEADER_ID | NUMBER | Yes | Foreign key refernence to OE_ORDER_HEADERS_ALL; the order to which this line belongs. | |
| LINE_TYPE_ID | NUMBER | Yes | Line Transaction Type Identifier | |
| LINE_NUMBER | NUMBER | Yes | Line sequence number within the order | |
| ORDERED_ITEM | VARCHAR2 | (2000) | Stores name of Ordered Item | |
| 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) | It will decide the tax handling for the order line. Possible values can be S - Standard, E - Exempt, R - Required | |
| TAX_EXEMPT_NUMBER | VARCHAR2 | (80) | The 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 | ||
| 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 | ||
| 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) | Doc code | |
| 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 | Yes | Inventory Item ID | |
| TAX_DATE | DATE | It will store the date for tax calculation | ||
| TAX_CODE | VARCHAR2 | (50) | Tax code for the line | |
| TAX_RATE | NUMBER | The tax rate in percentage | ||
| INVOICE_INTERFACE_STATUS_CODE | VARCHAR2 | (30) | To indicate whether the invoicing activity is complete | |
| 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 | Yes | 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 for the order line. | |
| FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight Terms, specifying the responsibility for Freight charges | |
| FOB_POINT_CODE | VARCHAR2 | (30) | FOB Point Code | |
| TAX_POINT_CODE | VARCHAR2 | (30) | For Future release | |
| PAYMENT_TERM_ID | NUMBER | (15) | Payment Terms | |
| INVOICING_RULE_ID | NUMBER | (15) | Invoicing rule used by AR for generating Invoice | |
| ACCOUNTING_RULE_ID | NUMBER | (15) | 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) | Identifier of line from a source system outside of Oracle Order Management | |
| SOURCE_DOCUMENT_LINE_ID | NUMBER | Source Order Line Id | ||
| REFERENCE_LINE_ID | NUMBER | This column stores the sales order line id this return line references | ||
| REFERENCE_TYPE | VARCHAR2 | (30) | This column is now obsolete | |
| REFERENCE_HEADER_ID | NUMBER | This column stores the sales order header id this return line references | ||
| ITEM_REVISION | VARCHAR2 | (3) | This column stores the item revision for a return line | |
| UNIT_SELLING_PRICE | NUMBER | Actual price chaged to customer | ||
| UNIT_LIST_PRICE | NUMBER | Price List price for the item | ||
| TAX_VALUE | NUMBER | The Tax amount in order currency, including the tax on Freight Charges if any | ||
| 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 | Yes | Standard Who column | |
| CREATED_BY | NUMBER | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | Yes | 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 | ||
| TOP_MODEL_LINE_ID | NUMBER | System-generated identifier of configuration top parent line | ||
| 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) | No longer used | |
| DEP_PLAN_REQUIRED_FLAG | VARCHAR2 | (1) | Departure Planning Required Flag possible values Y/N | |
| VISIBLE_DEMAND_FLAG | VARCHAR2 | (1) | Indicated line is visible to planning as demand | |
| LINE_CATEGORY_CODE | VARCHAR2 | (30) | Yes | Indicates whether the line is regular or return |
| ACTUAL_SHIPMENT_DATE | DATE | Actual Shipment Date of the line | ||
| CUSTOMER_TRX_LINE_ID | NUMBER | Currently not being used. | ||
| 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 | |
| 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 | Currently 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) | |
| CANCELLED_FLAG | VARCHAR2 | (1) | Indicates whether line is completely cancelled | |
| OPEN_FLAG | VARCHAR2 | (1) | Yes | Indicates whether the line has been closed (N) or not (Y) |
| BOOKED_FLAG | VARCHAR2 | (1) | Yes | Indicates whether order line is booked (Y) or not (N) |
| SALESREP_ID | NUMBER | (15) | Sales person identifier | |
| RETURN_REASON_CODE | VARCHAR2 | (30) | This column stores return reason code for a return line, and is required for a return line | |
| ARRIVAL_SET_ID | NUMBER | Arrival Set Identifier | ||
| SHIP_SET_ID | NUMBER | Ship Set Id; if the line belongs to a ship set | ||
| SPLIT_FROM_LINE_ID | NUMBER | System generated identifier of original line which was split | ||
| 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. | |
| OVER_SHIP_REASON_CODE | VARCHAR2 | (30) | Overshipment Reason Code | |
| OVER_SHIP_RESOLVED_FLAG | VARCHAR2 | (1) | Overshipment Resolved Flag | |
| ORDERED_ITEM_ID | NUMBER | Stores Id of Ordered Item | ||
| ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | To distinguish different types of items (internal, customer. and generic items) | |
| CONFIGURATION_ID | NUMBER | Not Used | ||
| COMMITMENT_ID | NUMBER | Commitment to apply line against | ||
| SHIPPING_INTERFACED_FLAG | VARCHAR2 | (1) | Shipping Interfaced Flag to indicate whether a line has been interfaced to shipping or not | |
| CREDIT_INVOICE_LINE_ID | NUMBER | This column stores the invoice line id this return line applies credit to | ||
| FIRST_ACK_CODE | VARCHAR2 | (30) | Initial acknowledgment code for oubound EDI transaction | |
| FIRST_ACK_DATE | DATE | Initial acknowledgment date 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 | ||
| 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 order change. | |
| DROP_SHIP_FLAG | VARCHAR2 | (1) | Not 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. | ||
| FULFILLED_FLAG | VARCHAR2 | (1) | Fulfilled Flag to indicate whether the line has been fulfilled. | |
| 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 | |
| CONFIG_HEADER_ID | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| CONFIG_REV_NBR | NUMBER | System-generated identifier for Oracle Configurator reference | ||
| MFG_COMPONENT_SEQUENCE_ID | NUMBER | Not used | ||
| SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Shipping Instructions for Line | |
| PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Packing Instructions for Line | |
| INVOICED_QUANTITY | NUMBER | To indicate whether the invoicing activity is complete or not. | ||
| REFERENCE_CUSTOMER_TRX_LINE_ID | NUMBER | This column stores the invoice line id this return line references | ||
| SPLIT_BY | VARCHAR2 | (30) | Indicates whether the line is system or user level split | |
| LINE_SET_ID | NUMBER | Line Set id | ||
| SERVICE_TXN_REASON_CODE | VARCHAR2 | (30) | To store service transaction reason. | |
| SERVICE_TXN_COMMENTS | VARCHAR2 | (2000) | Placeholder for service comments. | |
| SERVICE_DURATION | NUMBER | Internal use only | ||
| SERVICE_START_DATE | DATE | Start date for the service | ||
| SERVICE_END_DATE | DATE | Internal use only | ||
| SERVICE_COTERMINATE_FLAG | VARCHAR2 | (1) | To identify whether the service can be coterminated. | |
| UNIT_LIST_PERCENT | NUMBER | Price list percent of the item (percent-based pricing only) | ||
| UNIT_SELLING_PERCENT | NUMBER | Percent actually charged to customer (percent based pricing only) | ||
| UNIT_PERCENT_BASE_PRICE | NUMBER | Based price used for percent based pricing | ||
| SERVICE_NUMBER | NUMBER | Unique number to identify the service lines. | ||
| SERVICE_PERIOD | VARCHAR2 | (3) | Period for which service is offered. | |
| SHIPPABLE_FLAG | VARCHAR2 | (1) | A flag to indicate whether a line is shippale or not. | |
| MODEL_REMNANT_FLAG | VARCHAR2 | (1) | Indicates whether model has partially shipped components | |
| 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 | |
| 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 | |
| MARKETING_SOURCE_CODE_ID | NUMBER | Marketing source code identifier. Foreign key reference to CRM table AMS_SOURCE_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. | ||
| CALCULATE_PRICE_FLAG | VARCHAR2 | (1) | Controls repricing of order lines | |
| UPGRADED_FLAG | VARCHAR2 | (1) | Denotes if this column is upgraded into R11i or is newly created in R11i version. | |
| 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) | Ordered Quantity unit of measure | |
| SHIPPING_QUANTITY2 | NUMBER | Shipping quantity in secondary shipping unit of measure | ||
| CANCELLED_QUANTITY2 | NUMBER | Cancelled Quantity | ||
| SHIPPED_QUANTITY2 | NUMBER | Shipped quantity in ordered_quantity_uom2 | ||
| SHIPPING_QUANTITY_UOM2 | VARCHAR2 | (3) | Secondary unit of measure the item is shipped | |
| FULFILLED_QUANTITY2 | NUMBER | Fulfilled quantity in ordered_quantity_uom2 | ||
| MFG_LEAD_TIME | NUMBER | This column stores the Manufacturing Lead time for ATO Options. | ||
| LOCK_CONTROL | NUMBER | Internal use only. | ||
| SUBINVENTORY | VARCHAR2 | (10) | Subinventory | |
| UNIT_LIST_PRICE_PER_PQTY | NUMBER | Unit list price per pricing quantity. | ||
| UNIT_SELLING_PRICE_PER_PQTY | NUMBER | Unit selling price per pricing quantity. | ||
| PRICE_REQUEST_CODE | VARCHAR2 | (240) | Code identifies pricing transaction applied to Order Line | |
| ORIGINAL_INVENTORY_ITEM_ID | NUMBER | Stores the Original Inventory Item when there is a substitution. | ||
| ORIGINAL_ORDERED_ITEM_ID | NUMBER | Stores the Original Ordered Item when there is a substitution. | ||
| ORIGINAL_ORDERED_ITEM | VARCHAR2 | (2000) | Stores the Original Ordered Item when there is a substitution. | |
| ORIGINAL_ITEM_IDENTIFIER_TYPE | VARCHAR2 | (30) | Stores the Original Item Identifier Type when there is a substitution. | |
| 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. | |
| OVERRIDE_ATP_DATE_CODE | VARCHAR2 | (30) | By setting this code, User can force a 'Schedule Ship Date' , even if the supply is not available. | |
| 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. | ||
| 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. | |
| UNIT_COST | NUMBER | Unit Cost for the gross margin analysis | ||
| ITEM_RELATIONSHIP_TYPE | NUMBER | Stores the Item Releationship Type | ||
| BLANKET_LINE_NUMBER | NUMBER | Reference to a Sales Agreement Line | ||
| BLANKET_NUMBER | NUMBER | Reference to Sales Agreement | ||
| BLANKET_VERSION_NUMBER | NUMBER | Reference to a Sales Agreement Version | ||
| SALES_DOCUMENT_TYPE_CODE | VARCHAR2 | (30) | For Future Release | |
| FIRM_DEMAND_FLAG | VARCHAR2 | (1) | FIRM_DEMAND_FLAG | |
| EARLIEST_SHIP_DATE | DATE | This will be used to store the earliest Shipping Date , passed by Planning. | ||
| TRANSACTION_PHASE_CODE | VARCHAR2 | (30) | Indicates if Transaction is in negotitation or fulfillment phase | |
| SOURCE_DOCUMENT_VERSION_NUMBER | NUMBER | Internal Use Only. | ||
| PAYMENT_TYPE_CODE | VARCHAR2 | (30) | Stores Payment type entered at the Line Level | |
| MINISITE_ID | NUMBER | iStore minisite ID - Foreign Key reference to IBE_MSITES_B | ||
| 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 | |
| RETROBILL_REQUEST_ID | NUMBER | Retrobill Request ID - Foreign key reference to OE_RETROBILL_REQUESTS | ||
| ORIGINAL_LIST_PRICE | NUMBER | Value of Original List Price | ||
| 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 | |
| BYPASS_SCH_FLAG | VARCHAR2 | (1) | Is scheduling on the line to be bypassed? | |
| PRE_EXPLODED_FLAG | VARCHAR2 | (1) | Is this a pre-exploded component in a BOM structure? | |
| INST_ID | NUMBER | used in RAC INSTANCE AFFINITY for context setting | ||
| TAX_LINE_VALUE | NUMBER | The Tax amount in order currency, excluding the tax on Freight Charges if any | ||
| 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 | |
| FULFILLMENT_BASE | VARCHAR2 | (1) | The column will store fulfillment base value |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, ORG_ID
, HEADER_ID
, LINE_TYPE_ID
, LINE_NUMBER
, ORDERED_ITEM
, 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
, INTMED_SHIP_TO_ORG_ID
, INTMED_SHIP_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
, INVOICE_INTERFACE_STATUS_CODE
, 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
, TOP_MODEL_LINE_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
, 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
, CANCELLED_FLAG
, OPEN_FLAG
, BOOKED_FLAG
, SALESREP_ID
, RETURN_REASON_CODE
, ARRIVAL_SET_ID
, SHIP_SET_ID
, SPLIT_FROM_LINE_ID
, CUST_PRODUCTION_SEQ_NUM
, AUTHORIZED_TO_SHIP_FLAG
, OVER_SHIP_REASON_CODE
, OVER_SHIP_RESOLVED_FLAG
, ORDERED_ITEM_ID
, ITEM_IDENTIFIER_TYPE
, CONFIGURATION_ID
, COMMITMENT_ID
, SHIPPING_INTERFACED_FLAG
, CREDIT_INVOICE_LINE_ID
, FIRST_ACK_CODE
, FIRST_ACK_DATE
, LAST_ACK_CODE
, LAST_ACK_DATE
, PLANNING_PRIORITY
, 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
, FULFILLED_FLAG
, END_ITEM_UNIT_NUMBER
, CONFIG_HEADER_ID
, CONFIG_REV_NBR
, MFG_COMPONENT_SEQUENCE_ID
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, INVOICED_QUANTITY
, REFERENCE_CUSTOMER_TRX_LINE_ID
, SPLIT_BY
, LINE_SET_ID
, SERVICE_TXN_REASON_CODE
, SERVICE_TXN_COMMENTS
, SERVICE_DURATION
, SERVICE_START_DATE
, SERVICE_END_DATE
, SERVICE_COTERMINATE_FLAG
, UNIT_LIST_PERCENT
, UNIT_SELLING_PERCENT
, UNIT_PERCENT_BASE_PRICE
, SERVICE_NUMBER
, SERVICE_PERIOD
, SHIPPABLE_FLAG
, MODEL_REMNANT_FLAG
, RE_SOURCE_FLAG
, FLOW_STATUS_CODE
, 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
, MARKETING_SOURCE_CODE_ID
, SERVICE_REFERENCE_TYPE_CODE
, SERVICE_REFERENCE_LINE_ID
, SERVICE_REFERENCE_SYSTEM_ID
, CALCULATE_PRICE_FLAG
, UPGRADED_FLAG
, REVENUE_AMOUNT
, FULFILLMENT_DATE
, PREFERRED_GRADE
, ORDERED_QUANTITY2
, ORDERED_QUANTITY_UOM2
, SHIPPING_QUANTITY2
, CANCELLED_QUANTITY2
, SHIPPED_QUANTITY2
, SHIPPING_QUANTITY_UOM2
, FULFILLED_QUANTITY2
, MFG_LEAD_TIME
, LOCK_CONTROL
, SUBINVENTORY
, UNIT_LIST_PRICE_PER_PQTY
, UNIT_SELLING_PRICE_PER_PQTY
, PRICE_REQUEST_CODE
, ORIGINAL_INVENTORY_ITEM_ID
, ORIGINAL_ORDERED_ITEM_ID
, ORIGINAL_ORDERED_ITEM
, ORIGINAL_ITEM_IDENTIFIER_TYPE
, ITEM_SUBSTITUTION_TYPE_CODE
, OVERRIDE_ATP_DATE_CODE
, LATE_DEMAND_PENALTY_FACTOR
, ACCOUNTING_RULE_DURATION
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, USER_ITEM_DESCRIPTION
, UNIT_COST
, ITEM_RELATIONSHIP_TYPE
, BLANKET_LINE_NUMBER
, BLANKET_NUMBER
, BLANKET_VERSION_NUMBER
, SALES_DOCUMENT_TYPE_CODE
, FIRM_DEMAND_FLAG
, EARLIEST_SHIP_DATE
, TRANSACTION_PHASE_CODE
, SOURCE_DOCUMENT_VERSION_NUMBER
, PAYMENT_TYPE_CODE
, MINISITE_ID
, END_CUSTOMER_ID
, END_CUSTOMER_CONTACT_ID
, END_CUSTOMER_SITE_USE_ID
, IB_OWNER
, IB_CURRENT_LOCATION
, IB_INSTALLED_AT_LOCATION
, RETROBILL_REQUEST_ID
, ORIGINAL_LIST_PRICE
, 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
, BYPASS_SCH_FLAG
, PRE_EXPLODED_FLAG
, INST_ID
, TAX_LINE_VALUE
, 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
, FULFILLMENT_BASE
FROM ONT.OE_ORDER_LINES_ALL;
ONT.OE_ORDER_LINES_ALL does not reference any database object
ONT.OE_ORDER_LINES_ALL is referenced by following:
ONT
OE_ORDER_LINES_ALL#
|
|
|
|