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

VIEW: PMI.PMI_PROD_SUM#

Object Details
Object Name: PMI_PROD_SUM#
Object Type: VIEW
Owner: PMI
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FISCAL_YEAR VARCHAR2 (4) Yes
CO_CODE VARCHAR2 (4)
ORGN_CODE VARCHAR2 (4) Yes
WHSE_CODE VARCHAR2 (4) Yes
PERIOD_ID NUMBER (10) Yes
QUARTER NUMBER (15)
PERIOD NUMBER (15)
CONVERTIBLE_UOM VARCHAR2 (4)
ITEM_ID NUMBER (10) Yes
ITEM_NO VARCHAR2 (32)
ITEM_UM VARCHAR2 (4)
WHSE_USAGE_QTY NUMBER

WHSE_USAGE_CONV NUMBER

WHSE_USAGE_VALUE NUMBER

WHSE_YIELD_QTY NUMBER

WHSE_YIELD_CONV NUMBER

WHSE_YIELD_VALUE NUMBER

LOG_END_DATE DATE

PERIOD_IND NUMBER

WHSE_NAME VARCHAR2 (40)
ORGN_NAME VARCHAR2 (40)
PERIOD_NAME VARCHAR2 (40)
QUARTER_NAME VARCHAR2 (40)
PERIOD_SET_NAME VARCHAR2 (40)
GL_PERIOD_YEAR NUMBER (15)
GL_FISCAL_YEAR_NAME VARCHAR2 (15)
GL_PERIOD_START_DATE DATE

GL_PERIOD_END_DATE DATE

MISS_CONV_FACT_CNT NUMBER

GL_FISCAL_YEAR NUMBER (15)
Query Text

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


SELECT FISCAL_YEAR
,      CO_CODE
,      ORGN_CODE
,      WHSE_CODE
,      PERIOD_ID
,      QUARTER
,      PERIOD
,      CONVERTIBLE_UOM
,      ITEM_ID
,      ITEM_NO
,      ITEM_UM
,      WHSE_USAGE_QTY
,      WHSE_USAGE_CONV
,      WHSE_USAGE_VALUE
,      WHSE_YIELD_QTY
,      WHSE_YIELD_CONV
,      WHSE_YIELD_VALUE
,      LOG_END_DATE
,      PERIOD_IND
,      WHSE_NAME
,      ORGN_NAME
,      PERIOD_NAME
,      QUARTER_NAME
,      PERIOD_SET_NAME
,      GL_PERIOD_YEAR
,      GL_FISCAL_YEAR_NAME
,      GL_PERIOD_START_DATE
,      GL_PERIOD_END_DATE
,      MISS_CONV_FACT_CNT
,      GL_FISCAL_YEAR
FROM PMI.PMI_PROD_SUM#;

Dependencies

[top of page]

PMI.PMI_PROD_SUM# references the following:

SchemaPMI
TablePMI_PROD_SUM
PMI.PMI_PROD_SUM# is referenced by following:

SchemaAPPS
SynonymPMI_PROD_SUM