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

Object Details

Object Name:	IBE_ORDER_DETAIL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBE.IBE_ORDER_DETAIL_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	Order System Generated Line Identifier.
HEADER_ID	NUMBER		Yes	Order Header Identifier
LINE_NUMBER	NUMBER		Yes	Line sequence number within the order
ORDER_QUANTITY_UOM	VARCHAR2	(3)		Return order quantity Unit of measure
ORDERED_QUANTITY	NUMBER			Quantity ordered
ITEM_NUMBER	VARCHAR2	(40)		Part number of the item
ITEM_DESCRIPTION	VARCHAR2	(240)		Product Description
BOM_ITEM_TYPE	NUMBER		Yes	Identifying the type of BOM Item
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Descriptive flexfield attribute
LICENSING_UNIT	VARCHAR2	(40)		Flex field
PRICING_ATTRIBUTE10	VARCHAR2	(240)
UNIT_SELLING_PRICE	NUMBER			Actual price charged to customer
UNIT_LIST_PRICE	NUMBER			List price for the item
TOTAL_LIST_PRICE	NUMBER
EXTENDED_PRICE	NUMBER			Total order amount
LINES_TOTAL	NUMBER			Total amount for all the line items
UNIT_NET_PRICE	NUMBER
TAXES_TOTAL	NUMBER			Total taxes for all the lines
CHARGES_TOTAL	NUMBER			Total charges for all the lines
SCHEDULE_SHIP_DATE	DATE			Date Scheduled to ship item
SHIPPED_QUANTITY	NUMBER			Shipped Quantity
CANCELLED_QUANTITY	NUMBER			Cancelled Quantity
REQUEST_DATE	DATE			Ordered Item Request date
LINE_CURRENCY_CODE	VARCHAR2	(0)		Transaction currency for the line
ITEM_TYPE_CODE	VARCHAR2	(30)		Type of item
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
ATO_LINE_ID	NUMBER			System-generated identifier if ATO
PROMISE_DATE	DATE			Date promised to customer to receive item
FLOW_STATUS_CODE	VARCHAR2	(30)		Workflow status for the line
LINE_STATUS	VARCHAR2	(80)	Yes	Meaning for Workflow status for the line from oe_lookups
UOM_NAME	VARCHAR2	(25)	Yes	Translation for Return order quantity Unit of measure
SHIPMENT_NUMBER	NUMBER		Yes	System generated identifier of a shipment within a line
OPTION_NUMBER	NUMBER			System generated identifier for an option or a class within a model
COMPONENT_NUMBER	NUMBER			System Generated Identifier of the included item within a model or a class
SERVICE_NUMBER	NUMBER			Unique number to identify the service lines.
SHIPPABLE_FLAG	VARCHAR2	(1)		Flag to determine whether the item is shippable or not
LINE_RETURNABLE_FLAG	VARCHAR2	(1)		Based on inventory attribute and the line status , determines whether the order line is returnable. (Y/N)
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Indicates whether the line is regular(order) or return
LINE_TYPE_DESC	VARCHAR2	(30)	Yes
ORDER_CURR_CODE	VARCHAR2	(15)		Transactional Currency 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.
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)
CHARGE_PERIODICITY_DESC	VARCHAR2	(25)
MACD_LINE_FLAG	CHAR	(1)
CONFIG_INSTANCE_NAME	VARCHAR2	(255)
CONTAINER_ITEM_FLAG	VARCHAR2	(1)
MODEL_CONTAINER_FLAG	VARCHAR2	(1)
CONFIG_DELTA_FLAG	NUMBER
EXT_ACTIVATED_FLAG	VARCHAR2	(1)
ORG_ID	NUMBER

Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      LINE_NUMBER
,      ORDER_QUANTITY_UOM
,      ORDERED_QUANTITY
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      BOM_ITEM_TYPE
,      PRODUCT_DESCRIPTION
,      LICENSING_UNIT
,      PRICING_ATTRIBUTE10
,      UNIT_SELLING_PRICE
,      UNIT_LIST_PRICE
,      TOTAL_LIST_PRICE
,      EXTENDED_PRICE
,      LINES_TOTAL
,      UNIT_NET_PRICE
,      TAXES_TOTAL
,      CHARGES_TOTAL
,      SCHEDULE_SHIP_DATE
,      SHIPPED_QUANTITY
,      CANCELLED_QUANTITY
,      REQUEST_DATE
,      LINE_CURRENCY_CODE
,      ITEM_TYPE_CODE
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      PROMISE_DATE
,      FLOW_STATUS_CODE
,      LINE_STATUS
,      UOM_NAME
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      SERVICE_NUMBER
,      SHIPPABLE_FLAG
,      LINE_RETURNABLE_FLAG
,      LINE_CATEGORY_CODE
,      LINE_TYPE_DESC
,      ORDER_CURR_CODE
,      SERVICE_REFERENCE_TYPE_CODE
,      SERVICE_REFERENCE_LINE_ID
,      SERVICE_REFERENCE_SYSTEM_ID
,      CHARGE_PERIODICITY_CODE
,      CHARGE_PERIODICITY_DESC
,      MACD_LINE_FLAG
,      CONFIG_INSTANCE_NAME
,      CONTAINER_ITEM_FLAG
,      MODEL_CONTAINER_FLAG
,      CONFIG_DELTA_FLAG
,      EXT_ACTIVATED_FLAG
,      ORG_ID
FROM APPS.IBE_ORDER_DETAIL_V;

Dependencies

[top of page]

APPS.IBE_ORDER_DETAIL_V references the following:

APPS: CZ_CONFIG_DETAILS_V; CZ_UTILS - show dependent code; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE_TL; OE_LOOKUPS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_PROFILE - show dependent code; OE_TOTALS_GRP - show dependent code; OE_TRANSACTION_TYPES_TL

APPS.IBE_ORDER_DETAIL_V is referenced by following:

APPS: IBE_WORKFLOW_PVT - show dependent code