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

VIEW: APPS.DDR_TIME_BSNS_WK_V

Object Details
Object Name: DDR_TIME_BSNS_WK_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
MFG_ORG_CD VARCHAR2 (30) Yes
ORG_CD VARCHAR2 (30) Yes
CLNDR_CD VARCHAR2 (30) Yes
CLNDR_DESC VARCHAR2 (240)
WK_ID NUMBER
Yes
WK_CD VARCHAR2 (30) Yes
WK_NBR NUMBER
Yes
WK_DESC VARCHAR2 (40) Yes
WK_STRT_DT DATE
Yes
WK_END_DT DATE
Yes
WK_TIMESPN NUMBER
Yes
MNTH_ID NUMBER
Yes
MNTH_CD VARCHAR2 (30) Yes
MNTH_NBR NUMBER
Yes
MNTH_DESC VARCHAR2 (40) Yes
MNTH_STRT_DT DATE
Yes
MNTH_END_DT DATE
Yes
MNTH_TIMESPN NUMBER
Yes
QTR_ID NUMBER
Yes
QTR_CD VARCHAR2 (30) Yes
QTR_NBR NUMBER
Yes
QTR_DESC VARCHAR2 (40) Yes
QTR_STRT_DT DATE
Yes
QTR_END_DT DATE
Yes
QTR_TIMESPN NUMBER
Yes
YR_ID NUMBER
Yes
YR_CD VARCHAR2 (30) Yes
YR_NBR NUMBER
Yes
YR_DESC VARCHAR2 (40) Yes
YR_STRT_DT DATE
Yes
YR_END_DT DATE
Yes
YR_TIMESPN NUMBER
Yes
Query Text

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


SELECT MFG_ORG_CD
,      ORG_CD
,      CLNDR_CD
,      CLNDR_DESC
,      WK_ID
,      WK_CD
,      WK_NBR
,      WK_DESC
,      WK_STRT_DT
,      WK_END_DT
,      WK_TIMESPN
,      MNTH_ID
,      MNTH_CD
,      MNTH_NBR
,      MNTH_DESC
,      MNTH_STRT_DT
,      MNTH_END_DT
,      MNTH_TIMESPN
,      QTR_ID
,      QTR_CD
,      QTR_NBR
,      QTR_DESC
,      QTR_STRT_DT
,      QTR_END_DT
,      QTR_TIMESPN
,      YR_ID
,      YR_CD
,      YR_NBR
,      YR_DESC
,      YR_STRT_DT
,      YR_END_DT
,      YR_TIMESPN
FROM APPS.DDR_TIME_BSNS_WK_V;

Dependencies

[top of page]

APPS.DDR_TIME_BSNS_WK_V references the following:

SchemaAPPS
SynonymDDR_R_BSNS_MNTH
SynonymDDR_R_BSNS_QTR
SynonymDDR_R_BSNS_WK
SynonymDDR_R_BSNS_YR
SynonymDDR_R_CLNDR
APPS.DDR_TIME_BSNS_WK_V is referenced by following:

SchemaAPPS
Package BodyDDR_TIME_TRANSFORM_PKG - show dependent code