eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	ONT.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:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

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
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

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
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:

APPS: JAI_OE_OLA_ARIUD_T1; JAI_OE_OLA_BRIUD_T1; OE_ORDER_LINES; OE_ORDER_LINES_ALL