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_RETURNABLE_SERIAL_V

Object Details

Object Name:	IBE_RETURNABLE_SERIAL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IBE.IBE_RETURNABLE_SERIAL_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.
ORDER_NUMBER	NUMBER		Yes	User-visible number of the order
LINE_NUMBER	NUMBER		Yes	Line sequence number within the order
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 configuration top model line
ORG_ID	NUMBER			Operating Unit which performed this transaction
ORDER_CATEGORY_CODE	VARCHAR2	(30)	Yes	Order Category Code like Order, Mixed or Return
ORDER_FLOW_STATUS_CODE	VARCHAR2	(30)		Order Header workflow status code
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes	Indicates whether the line is regular(order) or return
LINE_FLOW_STATUS_CODE	VARCHAR2	(30)		Order Line workflow status code
CURRENCY_CODE	VARCHAR2	(15)		Currency for the order
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory Item ID
ITEM_TYPE_CODE	VARCHAR2	(30)		Type of item. Ex: standard
ITEM_NUMBER	VARCHAR2	(40)		Part number
ITEM_DESCRIPTION	VARCHAR2	(240)		Product Description
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Product Description
ORDER_QUANTITY_UOM	VARCHAR2	(3)		Order quantity Unit of measure
UOM_NAME	VARCHAR2	(25)	Yes	Translation for order quantity Unit of measure
ORDERED_QUANTITY	NUMBER			Quantity ordered
SHIPPED_QUANTITY	NUMBER			Shipped Quantity
CANCELLED_QUANTITY	NUMBER			Cancelled Quantity
UNIT_LIST_PRICE	NUMBER			List price for the item
UNIT_SELLING_PRICE	NUMBER			Actual price charged to customer
SCHEDULE_SHIP_DATE	DATE			Date Scheduled to ship item
REQUEST_DATE	DATE			Ordered Item Request date
PROMISE_DATE	DATE			Date promised to customer to receive item
SHIPMENT_NUMBER	NUMBER		Yes	System generated identifier of a shipment within a line
OPTION_NUMBER	NUMBER			System generated identifer 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.
LINE_RETURNABLE_FLAG	VARCHAR2	(1)		Based on inventory attribute and the line status , determines whether the order line is returnable. (Y/N)
CUST_ACCOUNT_ID	NUMBER			Sold to org id for order header
CREATED_BY	NUMBER		Yes	Standard Who column
LINE_BOOKED_FLAG	VARCHAR2	(1)	Yes	Indicates whether order line is booked (Y) or not (N)
LINE_CANCELLED_FLAG	VARCHAR2	(1)		Indicates whether line is completely cancelled
SERIAL_NUMBER	VARCHAR2	(30)	Yes	Serial number for an item
SERIAL_NUMBER1	VARCHAR2	(30)	Yes

Query Text

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


SELECT LINE_ID
,      HEADER_ID
,      ORDER_NUMBER
,      LINE_NUMBER
,      TOP_MODEL_LINE_ID
,      LINK_TO_LINE_ID
,      ATO_LINE_ID
,      ORG_ID
,      ORDER_CATEGORY_CODE
,      ORDER_FLOW_STATUS_CODE
,      LINE_CATEGORY_CODE
,      LINE_FLOW_STATUS_CODE
,      CURRENCY_CODE
,      INVENTORY_ITEM_ID
,      ITEM_TYPE_CODE
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      PRODUCT_DESCRIPTION
,      ORDER_QUANTITY_UOM
,      UOM_NAME
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      CANCELLED_QUANTITY
,      UNIT_LIST_PRICE
,      UNIT_SELLING_PRICE
,      SCHEDULE_SHIP_DATE
,      REQUEST_DATE
,      PROMISE_DATE
,      SHIPMENT_NUMBER
,      OPTION_NUMBER
,      COMPONENT_NUMBER
,      SERVICE_NUMBER
,      LINE_RETURNABLE_FLAG
,      CUST_ACCOUNT_ID
,      CREATED_BY
,      LINE_BOOKED_FLAG
,      LINE_CANCELLED_FLAG
,      SERIAL_NUMBER
,      SERIAL_NUMBER1
FROM APPS.IBE_RETURNABLE_SERIAL_V;

Dependencies

[top of page]

APPS.IBE_RETURNABLE_SERIAL_V references the following:

APPS: MTL_MATERIAL_TRANSACTIONS; MTL_SERIAL_NUMBERS; MTL_SYSTEM_ITEMS_VL; MTL_UNITS_OF_MEASURE_TL; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_PROFILE - show dependent code

APPS.IBE_RETURNABLE_SERIAL_V is not referenced by any database object