[Home] [Help] [Dependency Information]
Object Name: | PMI_ONHAND_SALE_SUM# |
---|---|
Object Type: | VIEW |
Owner: | PMI |
Subobject Name: | |
Status: | VALID |
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_ONHAND_QTY | NUMBER | |||
WHSE_ONHAND_CONV | NUMBER | |||
WHSE_ONHAND_VALUE | NUMBER | |||
WHSE_SALE_QTY | NUMBER | |||
WHSE_SALE_CONV | NUMBER | |||
WHSE_SALE_VALUE | NUMBER | |||
WHSE_RTRN_QTY | NUMBER | |||
WHSE_RTRN_CONV | NUMBER | |||
WHSE_RTRN_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_END_DATE | DATE | |||
GL_PERIOD_START_DATE | DATE | |||
MISS_CONV_FACT_CNT | NUMBER | |||
GL_FISCAL_YEAR | NUMBER | (15) |
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_ONHAND_QTY
, WHSE_ONHAND_CONV
, WHSE_ONHAND_VALUE
, WHSE_SALE_QTY
, WHSE_SALE_CONV
, WHSE_SALE_VALUE
, WHSE_RTRN_QTY
, WHSE_RTRN_CONV
, WHSE_RTRN_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_END_DATE
, GL_PERIOD_START_DATE
, MISS_CONV_FACT_CNT
, GL_FISCAL_YEAR
FROM PMI.PMI_ONHAND_SALE_SUM#;
|
|
|