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

MATERIALIZED VIEW: APPS.OPI_CURR_PROD_DEL_001_MV

Object Details
Object Name: OPI_CURR_PROD_DEL_001_MV
Object Type: MATERIALIZED VIEW
Owner: APPS
Subobject Name:
Status: VALID
M-View Details
Container: OPI_CURR_PROD_DEL_001_MV
Updatable: N
Rewrite Enabled: N
Rewrite Capability: GENERAL
Refresh Mode: DEMAND
Refresh Method: COMPLETE
Build Mode: DEFERRED
Fast Refreshable: NO
MV Log Dependencies:

ENI_OLTP_ITEM_STAR

[View Source Query]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

Inventory Organization Identifier.
SOURCE NUMBER
Yes Data source. 1 = OPI,2 = OPM.
ASSEMBLY_ITEM_ID NUMBER

Top level item identifier
UOM_CODE VARCHAR2 (3)
Primary UOM Code.
ITEM_ORG_ID VARCHAR2 (81)
Inventory Item Organization Identifier.
INV_CATEGORY_ID NUMBER

Inventory Category Identifier.
ITEM_CAT_FLAG NUMBER

Item Category Flag.
LATE_JOBS_CNT NUMBER

Count column.
LATE_JOBS_QTY NUMBER

Quantity of items for the jobs that passed scheduled completion date
LATE_JOBS_VAL_B NUMBER

Value of items for the jobs that passed scheduled completion date
LATE_JOBS_VAL_G NUMBER

Item value for this job which has passed scheduled completetion date in primary global currency
LATE_JOBS_VAL_SG NUMBER

Item value for this job which has passed scheduled completetion date in secondary global currency
OPEN_JOBS_CNT NUMBER

Count column.
OPEN_JOBS_QTY NUMBER

Item quantity for the job which is still open
OPEN_JOBS_VAL_B NUMBER

Item value in functional currency for the job which is still open
OPEN_JOBS_VAL_G NUMBER

Item value in global currency for the job which is still open
OPEN_JOBS_VAL_SG NUMBER

Item value in secondary global currency for the job which is still open
Query Text

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


SELECT ORGANIZATION_ID
,      SOURCE
,      ASSEMBLY_ITEM_ID
,      UOM_CODE
,      ITEM_ORG_ID
,      INV_CATEGORY_ID
,      ITEM_CAT_FLAG
,      LATE_JOBS_CNT
,      LATE_JOBS_QTY
,      LATE_JOBS_VAL_B
,      LATE_JOBS_VAL_G
,      LATE_JOBS_VAL_SG
,      OPEN_JOBS_CNT
,      OPEN_JOBS_QTY
,      OPEN_JOBS_VAL_B
,      OPEN_JOBS_VAL_G
,      OPEN_JOBS_VAL_SG
FROM APPS.OPI_CURR_PROD_DEL_001_MV;

Dependencies

[top of page]

APPS.OPI_CURR_PROD_DEL_001_MV references the following:

SchemaAPPS
TableOPI_CURR_PROD_DEL_001_MV
SchemaENI
TableENI_OLTP_ITEM_STAR
SchemaOPI
TableOPI_DBI_JOBS_F
TableOPI_DBI_RUN_LOG_CURR

APPS.OPI_CURR_PROD_DEL_001_MV is not referenced by any database object