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


TABLE: ONT.OE_ORDER_LINES_ALL

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


OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OE_ORDER_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_ID
OE_ORDER_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHEADER_ID
OE_ORDER_LINES_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTOP_MODEL_LINE_ID
OE_ORDER_LINES_N11 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_SOURCE_ID
ColumnORIG_SYS_DOCUMENT_REF
ColumnORIG_SYS_LINE_REF
ColumnORIG_SYS_SHIPMENT_REF
OE_ORDER_LINES_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnARRIVAL_SET_ID
OE_ORDER_LINES_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_SET_ID
OE_ORDER_LINES_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINK_TO_LINE_ID
OE_ORDER_LINES_N15 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOPEN_FLAG
OE_ORDER_LINES_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_PO_NUMBER
OE_ORDER_LINES_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATO_LINE_ID
OE_ORDER_LINES_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMMITMENT_ID
OE_ORDER_LINES_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBLANKET_NUMBER
ColumnBLANKET_LINE_NUMBER
OE_ORDER_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSHIP_TO_ORG_ID
ColumnORDERED_ITEM_ID
OE_ORDER_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVENTORY_ITEM_ID
ColumnOPEN_FLAG
OE_ORDER_LINES_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROJECT_ID
ColumnTASK_ID
OE_ORDER_LINES_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE_LINE_ID
OE_ORDER_LINES_N7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLINE_SET_ID
OE_ORDER_LINES_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSERVICE_REFERENCE_LINE_ID
Columns
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
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
,      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;

Dependencies

[top of page]

ONT.OE_ORDER_LINES_ALL does not reference any database object

ONT.OE_ORDER_LINES_ALL is referenced by following:

SchemaONT
ViewOE_ORDER_LINES_ALL#