[Home] [Help] [Dependency Information]
Object Name: | PMI_REP_LATE_BATCHES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMI_REP_LATE_BATCHES_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPANY_ID | VARCHAR2 | (4) | Yes | Key to map Process Manufacturing Company PMF Dimension Value |
ORGANIZATION_ID | VARCHAR2 | (4) | Yes | Key to map Process Manufacturing Organization PMF Dimension Value |
YEAR_ID | VARCHAR2 | (31) | Key to map Year Level PMF Time Dimension Value | |
QUARTER_ID | VARCHAR2 | (31) | Key to map Quarter Level PMF Time Dimension Value | |
PERIOD_ID | VARCHAR2 | (31) | Key to map Period Level PMF Time Dimension Value | |
TOT_NO_BTCHS | NUMBER | This column will have 1 as its value | ||
LATE_BTCHS | NUMBER | This column will have 1 as its value batch is late |
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_ID
, ORGANIZATION_ID
, YEAR_ID
, QUARTER_ID
, PERIOD_ID
, TOT_NO_BTCHS
, LATE_BTCHS
FROM APPS.PMI_REP_LATE_BATCHES_V;
APPS.PMI_REP_LATE_BATCHES_V is not referenced by any database object
|
|
|