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

VIEW: APPS.PMI_REP_PROD_STATUS_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPANY_ID VARCHAR2 (4) Yes OPM Company Code
ORGANIZATION_ID VARCHAR2 (4) Yes OPM Organization 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
PND_BATCHES NUMBER

Number of Pending Batches
PND_VALUE NUMBER

Value of Pending Batches
WIP_BATCHES NUMBER

Number of WIP Batches
WIP_VALUE NUMBER

Value of WIP Batches
CMP_BATCHES NUMBER

Number of Completed Batches
CMP_VALUE NUMBER

Value of Completed Batches
Query Text

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


SELECT COMPANY_ID
,      ORGANIZATION_ID
,      YEAR_ID
,      QUARTER_ID
,      PERIOD_ID
,      PND_BATCHES
,      PND_VALUE
,      WIP_BATCHES
,      WIP_VALUE
,      CMP_BATCHES
,      CMP_VALUE
FROM APPS.PMI_REP_PROD_STATUS_V;

Dependencies

[top of page]

APPS.PMI_REP_PROD_STATUS_V references the following:

SchemaAPPS
SynonymGL_PLCY_MST
SynonymGME_BATCH_HEADER
SynonymGME_MATERIAL_DETAILS
SynonymIC_TRAN_PND
PL/SQL PackagePMI_COMMON_PKG - show dependent code
ViewPMI_GL_TIME_V
PL/SQL PackagePMI_SECURITY_PKG - show dependent code
SynonymSY_ORGN_MST

APPS.PMI_REP_PROD_STATUS_V is not referenced by any database object