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

VIEW: APPS.IC_PERD_BAL_VW1

Object Details
Object Name: IC_PERD_BAL_VW1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMI.IC_PERD_BAL_VW1
Subobject Name:
Status: VALID

View Type

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


Period balance view for Item Usage Detail report.


[View Source]

Columns
Name Datatype Length Mandatory Comments
FISCAL_YEAR VARCHAR2 (4) Yes Code for the year.
PERIOD NUMBER (5) Yes Code for the inventory period.
ITEM_ID NUMBER (10) Yes Surrogate key identifying an item.
WHSE_CODE VARCHAR2 (4) Yes Code for the warehouse.
ENDING_BAL NUMBER

Onhand balance of the item in the warehouse, at the end of the period.
Query Text

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


SELECT FISCAL_YEAR
,      PERIOD
,      ITEM_ID
,      WHSE_CODE
,      ENDING_BAL
FROM APPS.IC_PERD_BAL_VW1;

Dependencies

[top of page]

APPS.IC_PERD_BAL_VW1 references the following:

SchemaAPPS
SynonymIC_PERD_BAL

APPS.IC_PERD_BAL_VW1 is not referenced by any database object