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

VIEW: APPS.PMI_REP_ONHAND_SALES_V

Object Details
Object Name: PMI_REP_ONHAND_SALES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMI_REP_ONHAND_SALES_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_ID VARCHAR2 (4)
OPM Company Code
ORGANIZATION_ID VARCHAR2 (4) Yes OPM Organization Code
WAREHOUSE_ID VARCHAR2 (4) Yes OPM Warehouse Code
YEAR_ID VARCHAR2 (31)
Year ID is combination (concatenated Period Set Name and Year name separated with a plus sign) Key used to Identify unique GL Year
QUARTER_ID VARCHAR2 (31)
Quarter ID is combination (concatenated Period Set Name and Quarter name separated with a plus sign) Key used to Identify unique GL Quarter
PERIOD_ID VARCHAR2 (31)
Period ID is combination Key (concatenated Period Set Name and period name separated with a plus sign) used to Identify unique GL Period
ITEM_ID NUMBER (10) Yes Item ID
UOM VARCHAR2 (4)
PMI Global UOM
WHSE_ONHAND_QTY NUMBER

WHSE_ONHAND_CONV NUMBER

WHSE_ONHAND_VALUE NUMBER

WHSE_SALE_QTY NUMBER

WHSE_SALE_CONV NUMBER

WHSE_SALE_VALUE NUMBER

PERIOD_NAME VARCHAR2 (40)
S_DATE DATE
Yes GL Period Start Date
E_DATE DATE
Yes GL Period End Date
Query Text

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


SELECT COMPANY_ID
,      ORGANIZATION_ID
,      WAREHOUSE_ID
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
,      ITEM_ID
,      UOM
,      WHSE_ONHAND_QTY
,      WHSE_ONHAND_CONV
,      WHSE_ONHAND_VALUE
,      WHSE_SALE_QTY
,      WHSE_SALE_CONV
,      WHSE_SALE_VALUE
,      PERIOD_NAME
,      S_DATE
,      E_DATE
FROM APPS.PMI_REP_ONHAND_SALES_V;

Dependencies

[top of page]

APPS.PMI_REP_ONHAND_SALES_V references the following:

SchemaAPPS
SynonymGL_PLCY_MST
SynonymIC_ITEM_MST
ViewPMI_GL_TIME_V
SynonymPMI_ONHAND_SALE_SUM
PL/SQL PackagePMI_SECURITY_PKG - show dependent code

APPS.PMI_REP_ONHAND_SALES_V is not referenced by any database object