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

VIEW: GMI.IC_SUMM_INV_BAK#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
SUMM_INV_ID NUMBER (15) Yes
ITEM_ID NUMBER (10) Yes
WHSE_CODE VARCHAR2 (4) Yes
QC_GRADE VARCHAR2 (4)
ONHAND_QTY NUMBER
Yes
ONHAND_QTY2 NUMBER

ONHAND_PROD_QTY NUMBER
Yes
ONHAND_PROD_QTY2 NUMBER

ONHAND_ORDER_QTY NUMBER
Yes
ONHAND_ORDER_QTY2 NUMBER

ONHAND_SHIP_QTY NUMBER
Yes
ONHAND_SHIP_QTY2 NUMBER

ONPURCH_QTY NUMBER
Yes
ONPURCH_QTY2 NUMBER

ONPROD_QTY NUMBER
Yes
ONPROD_QTY2 NUMBER

COMMITTEDSALES_QTY NUMBER
Yes
COMMITTEDSALES_QTY2 NUMBER

COMMITTEDPROD_QTY NUMBER
Yes
COMMITTEDPROD_QTY2 NUMBER

INTRANSIT_QTY NUMBER
Yes
INTRANSIT_QTY2 NUMBER

LAST_UPDATED_BY NUMBER (15) Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER (15)
Query Text

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


SELECT SUMM_INV_ID
,      ITEM_ID
,      WHSE_CODE
,      QC_GRADE
,      ONHAND_QTY
,      ONHAND_QTY2
,      ONHAND_PROD_QTY
,      ONHAND_PROD_QTY2
,      ONHAND_ORDER_QTY
,      ONHAND_ORDER_QTY2
,      ONHAND_SHIP_QTY
,      ONHAND_SHIP_QTY2
,      ONPURCH_QTY
,      ONPURCH_QTY2
,      ONPROD_QTY
,      ONPROD_QTY2
,      COMMITTEDSALES_QTY
,      COMMITTEDSALES_QTY2
,      COMMITTEDPROD_QTY
,      COMMITTEDPROD_QTY2
,      INTRANSIT_QTY
,      INTRANSIT_QTY2
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM GMI.IC_SUMM_INV_BAK#;

Dependencies

[top of page]

GMI.IC_SUMM_INV_BAK# references the following:

SchemaGMI
TableIC_SUMM_INV_BAK
GMI.IC_SUMM_INV_BAK# is referenced by following:

SchemaAPPS
SynonymIC_SUMM_INV_BAK