DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.ICX_EDM_INV_ONHAND_BAL_V

Object Details
Object Name: ICX_EDM_INV_ONHAND_BAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_EDM_INV_ONHAND_BAL_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The ICX_EDM_INV_ONHAND_BAL_V view returns inventory onhand quantity
balance by project, item, and inventory organization.
.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROJECT_ID NUMBER (15)
Project / Seiban unique identifier
TASK_ID NUMBER (15)
Task unique identifier
PROJECT_NUMBER VARCHAR2 (25)
Project / Seiban number
TASK_NUMBER VARCHAR2 (25)
Task number
ORGANIZATION_NAME VARCHAR2 (240) Yes Inventory organization name
ORGANIZATION_CODE VARCHAR2 (3)
Inventory organization code
ITEM VARCHAR2 (40)
Inventory item number
ITEM_DESCRIPTION VARCHAR2 (240)
Inventory item description
ITEM_URL VARCHAR2 (240)
Inventory item information URL
SUBINVENTORY VARCHAR2 (10) Yes Subinventory inventory code
LOCATOR CHAR (1)
Stock locator
TOTAL_ONHAND_QUANTITY NUMBER

Total onhand quantity
PRIMARY_UOM VARCHAR2 (3)
Primary unit of measure
ORGANIZATION_ID NUMBER
Yes Inventory organization unique identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item unique identifier
Query Text

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


SELECT PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      ORGANIZATION_NAME
,      ORGANIZATION_CODE
,      ITEM
,      ITEM_DESCRIPTION
,      ITEM_URL
,      SUBINVENTORY
,      LOCATOR
,      TOTAL_ONHAND_QUANTITY
,      PRIMARY_UOM
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
FROM APPS.ICX_EDM_INV_ONHAND_BAL_V;

Dependencies

[top of page]

APPS.ICX_EDM_INV_ONHAND_BAL_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_ITEM_LOCATIONS
ViewMTL_ITEM_LOCATIONS_KFV
ViewMTL_ONHAND_QUANTITIES
SynonymMTL_PARAMETERS
SynonymMTL_SECONDARY_INVENTORIES
SynonymMTL_SYSTEM_ITEMS_KFV
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
PL/SQL PackagePA_PROJECT_UTILS - show dependent code
PL/SQL PackagePA_SECURITY - show dependent code
SynonymPA_TASKS
ViewPJM_PROJECTS_V

APPS.ICX_EDM_INV_ONHAND_BAL_V is not referenced by any database object