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]

VIEW: APPS.ASO_I_ORDER_LINES_V

Object Details

Object Name:	ASO_I_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ASO.ASO_I_ORDER_LINES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_ID	NUMBER		Yes	unique identifier of an order line
HEADER_ID	NUMBER		Yes	Foreign key reference to oe_order_headers. the header to which this line belongs
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes	line category
LINE_NUMBER	NUMBER		Yes	user visible line identifier
ORDER_QUANTITY_UOM	VARCHAR2	(3)		unit of measure of the ordered quantity
ORDERED_QUANTITY	NUMBER			quantity ordered
INVENTORY_ITEM_ID	NUMBER		Yes	inventory item
SHIPMENT_NUMBER	NUMBER		Yes	shipment number
UNIT_SELLING_PRICE	NUMBER			Actual price charged to a customer
UNIT_LIST_PRICE	NUMBER			Price list price of the item
SHIPPABLE_FLAG	VARCHAR2	(1)		Indicates whether or not the item is shippable
SCHEDULE_SHIP_DATE	DATE			Date planned to ship item
SCHEDULE_ARRIVAL_DATE	DATE			Date of planned arrival
ACTUAL_SHIPMENT_DATE	DATE			Date the item was actually shipped
ACTUAL_ARRIVAL_DATE	DATE			actual arrival date of the item
SHIPPED_QUANTITY	NUMBER			shipped quantity.
SHIP_TO_CONTACT_ID	NUMBER			id for ship to contact
CUST_MODEL_SERIAL_NUMBER	VARCHAR2	(50)		serial number (e.g., vehicle ID number - VIN)
MODEL_GROUP_NUMBER	NUMBER			model group number
TOP_MODEL_LINE_ID	NUMBER			Order line id of the top model of the configuration
LINK_TO_LINE_ID	NUMBER			Order line id of immediate parent component line
CANCELLED_FLAG	VARCHAR2	(1)		Indicates whether order line is cancelled('Y') or not ('N')
OPEN_FLAG	VARCHAR2	(1)	Yes	Indicates whether order line is closed('Y') or not ('N')
BOOKED_FLAG	VARCHAR2	(1)	Yes	Indicates whether order line is booked('Y') or not ('N')
OPTION_NUMBER	NUMBER			option number
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)		unit of measure of the shipping quantity
CANCELLED_QUANTITY	NUMBER			cancelled quantity
PROMISE_DATE	DATE			Date promised to customer to receive an item
REQUEST_DATE	DATE			Date requested by customer to receive an item
SHIPPING_METHOD_CODE	VARCHAR2	(30)		ship method code
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)		Shipment priority
LINE_TYPE_ID	NUMBER		Yes	Line type
PRICING_QUANTITY	NUMBER			quantity that was priced
PRICING_QUANTITY_UOM	VARCHAR2	(3)		unit of measure of pricing quantity
FULFILLED_QUANTITY	NUMBER			quantity fulfilled
SHIPPING_QUANTITY	NUMBER			shipping quantity. It is the ordered quantity less the cancelled quantity
ORDER_SOURCE_ID	NUMBER			source from where the order originated
MARKETING_SOURCE_CODE_ID	NUMBER			Campaign that is applied to this order
INVOICE_TO_ORG_ID	NUMBER			invoice to customer/address information
SHIP_TO_ORG_ID	NUMBER			ship to customer/address information
ATO_LINE_ID	NUMBER			Line id of the ATO configuration top model line
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
ITEM_NAME	VARCHAR2	(40)		name of the item
ITEM_DESCRIPTION	VARCHAR2	(240)		full description of the item being sold
PRICE_LIST_ID	NUMBER			price list for this line
PRICE_LIST_NAME	VARCHAR2	(240)		name of the price list
CURRENCY_CODE	VARCHAR2	(30)		currency for the line
SHIP_FROM_ORG_ID	NUMBER			ship from organization id - warehouse

Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      LINE_CATEGORY_CODE
,      LINE_NUMBER
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      INVENTORY_ITEM_ID
,      SHIPMENT_NUMBER
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      SHIPPABLE_FLAG
,      SCHEDULE_SHIP_DATE
,      SCHEDULE_ARRIVAL_DATE
,      ACTUAL_SHIPMENT_DATE
,      ACTUAL_ARRIVAL_DATE
,      SHIPPED_QUANTITY
,      SHIP_TO_CONTACT_ID
,      CUST_MODEL_SERIAL_NUMBER
,      MODEL_GROUP_NUMBER
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      CANCELLED_FLAG
,      OPEN_FLAG
,      BOOKED_FLAG
,      OPTION_NUMBER
,      SHIPPING_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      PROMISE_DATE
,      REQUEST_DATE
,      SHIPPING_METHOD_CODE
,      SHIPMENT_PRIORITY_CODE
,      LINE_TYPE_ID
,      PRICING_QUANTITY
,      PRICING_QUANTITY_UOM
,      FULFILLED_QUANTITY
,      SHIPPING_QUANTITY
,      ORDER_SOURCE_ID
,      MARKETING_SOURCE_CODE_ID
,      INVOICE_TO_ORG_ID
,      SHIP_TO_ORG_ID
,      ATO_LINE_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      PRICE_LIST_ID
,      PRICE_LIST_NAME
,      CURRENCY_CODE
,      SHIP_FROM_ORG_ID
FROM APPS.ASO_I_ORDER_LINES_V;

Dependencies

[top of page]

APPS.ASO_I_ORDER_LINES_V references the following:

APPS: MTL_SYSTEM_ITEMS_VL; OE_ORDER_LINES; OE_PROFILE - show dependent code; QP_PRICE_LISTS_V; QP_PRICE_LIST_PVT - show dependent code

APPS.ASO_I_ORDER_LINES_V is referenced by following:

APPS: ASO_RETURNS_V; BIM_FCTV_ORDER_OFFERS