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


TABLE: APPS.DDR_R_PRD_DRTN_DN_MV

Object Details
Object Name: DDR_R_PRD_DRTN_DN_MV
Object Type: TABLE
Owner: APPS
FND Design Data: TableFND.DDR_R_PRD_DRTN_DN_MV
Subobject Name:
Status: VALID
Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30)
CLNDR_CD VARCHAR2 (30)
PRD_CD VARCHAR2 (30)
PRD_ID NUMBER

PRD_TYP NUMBER

PRD_DRTN NUMBER

PRD_DRTN_YTD NUMBER

CNT_PRD_DRTN_YTD NUMBER

CNT_TOTAL NUMBER

PRD_ROWID ROWID (10)
Query Text

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


SELECT MFG_ORG_CD
,      CLNDR_CD
,      PRD_CD
,      PRD_ID
,      PRD_TYP
,      PRD_DRTN
,      PRD_DRTN_YTD
,      CNT_PRD_DRTN_YTD
,      CNT_TOTAL
,      PRD_ROWID
FROM APPS.DDR_R_PRD_DRTN_DN_MV;

Dependencies

[top of page]

APPS.DDR_R_PRD_DRTN_DN_MV does not reference any database object

APPS.DDR_R_PRD_DRTN_DN_MV is referenced by following:

SchemaAPPS
Materialized ViewDDR_R_PRD_DRTN_DN_MV