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

VIEW: GMI.IC_PERD_BAL#

Object Details
Object Name: IC_PERD_BAL#
Object Type: VIEW
Owner: GMI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PERIOD_ID NUMBER (10) Yes
LOT_ID NUMBER (10) Yes
WHSE_CODE VARCHAR2 (4) Yes
LOCATION VARCHAR2 (16) Yes
ITEM_ID NUMBER (10) Yes
FISCAL_YEAR VARCHAR2 (4) Yes
PERIOD NUMBER (5) Yes
LOCT_ONHAND NUMBER
Yes
LOCT_ONHAND2 NUMBER

LOCT_USAGE NUMBER
Yes
LOCT_USAGE2 NUMBER

LOCT_YIELD NUMBER
Yes
LOCT_YIELD2 NUMBER

LOCT_VALUE NUMBER
Yes
LOT_STATUS VARCHAR2 (4)
QCHOLD_RES_CODE VARCHAR2 (4)
LOG_END_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
GL_POSTED_IND NUMBER (5)
PERD_BAL_ID NUMBER (15)
MIGRATED_IND NUMBER (5)
PERIOD_BALANCE_ID NUMBER (15)
Query Text

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


SELECT PERIOD_ID
,      LOT_ID
,      WHSE_CODE
,      LOCATION
,      ITEM_ID
,      FISCAL_YEAR
,      PERIOD
,      LOCT_ONHAND
,      LOCT_ONHAND2
,      LOCT_USAGE
,      LOCT_USAGE2
,      LOCT_YIELD
,      LOCT_YIELD2
,      LOCT_VALUE
,      LOT_STATUS
,      QCHOLD_RES_CODE
,      LOG_END_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      GL_POSTED_IND
,      PERD_BAL_ID
,      MIGRATED_IND
,      PERIOD_BALANCE_ID
FROM GMI.IC_PERD_BAL#;

Dependencies

[top of page]

GMI.IC_PERD_BAL# references the following:

SchemaGMI
TableIC_PERD_BAL
GMI.IC_PERD_BAL# is referenced by following:

SchemaAPPS
SynonymIC_PERD_BAL