[Home] [Help] [Dependency Information]

VIEW: APPS.IC_MOVE_ORDER_LINES_V

Object Details

Object Name:	IC_MOVE_ORDER_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMI.IC_MOVE_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

A public view which may be useful for custom reporting or other data
requirements.

This view is used in the OPM Pick Lots form (ICPCKLOT.fmb), and gives the Move Order Lines information for the form.

[View Source]

Columns

Query Text

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

SELECT INVENTORY_ITEM_ID
,      ITEM_ID
,      DUALUM_IND
,      NONINV_IND
,      LOT_INDIVISIBLE
,      ITEM_NO
,      ITEM_DESC1
,      ORGANIZATION_ID
,      WHSE_CODE
,      WHSE_NAME
,      UOM_CODE
,      SECONDARY_UOM_CODE
,      QUANTITY
,      SECONDARY_QUANTITY
,      QUANTITY_DETAILED
,      SECONDARY_QUANTITY_DETAILED
,      QUANTITY_DELIVERED
,      SECONDARY_QUANTITY_DELIVERED
,      TXN_SOURCE_LINE_ID
,      LINE_ID
,      LINE_STATUS
FROM APPS.IC_MOVE_ORDER_LINES_V;

Dependencies

[top of page]

APPS

IC_ITEM_MST

IC_TXN_REQUEST_LINES

IC_WHSE_MST

MTL_SYSTEM_ITEMS

APPS.IC_MOVE_ORDER_LINES_V is not referenced by any database object