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

TABLE: MRP.MRP_WORKBENCH_BUCKET_DATES

Object Details
Object Name: MRP_WORKBENCH_BUCKET_DATES
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_WORKBENCH_BUCKET_DATES
Subobject Name:
Status: VALID


MRP_WORKBENCH_BUCKET_DATES is a table that stores the start date of
buckets for the Planner Workbench Horizontal Plan. This table is
populated by the Planner Workbench and has a row for every bucket type
and plan name.
This table is used by the Horizontal plan window to bucket the supply
and demand information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_WORKBENCH_BUCKET_DATES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
ColumnBUCKET_TYPE
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
PLANNED_ORGANIZATION NUMBER

Planned Organization
BUCKET_TYPE NUMBER
Yes Bucket type
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
DATE1 DATE

Bucket start date
DATE2 DATE

Bucket start date
DATE3 DATE

Bucket start date
DATE4 DATE

Bucket start date
DATE5 DATE

Bucket start date
DATE6 DATE

Bucket start date
DATE7 DATE

Bucket start date
DATE8 DATE

Bucket start date
DATE9 DATE

Bucket start date
DATE10 DATE

Bucket start date
DATE11 DATE

Bucket start date
DATE12 DATE

Bucket start date
DATE13 DATE

Bucket start date
DATE14 DATE

Bucket start date
DATE15 DATE

Bucket start date
DATE16 DATE

Bucket start date
DATE17 DATE

Bucket start date
DATE18 DATE

Bucket start date
DATE19 DATE

Bucket start date
DATE20 DATE

Bucket start date
DATE21 DATE

Bucket start date
DATE22 DATE

Bucket start date
DATE23 DATE

Bucket start date
DATE24 DATE

Bucket start date
DATE25 DATE

Bucket start date
DATE26 DATE

Bucket start date
DATE27 DATE

Bucket start date
DATE28 DATE

Bucket start date
DATE29 DATE

Bucket start date
DATE30 DATE

Bucket start date
DATE31 DATE

Bucket start date
DATE32 DATE

Bucket start date
DATE33 DATE

Bucket start date
DATE34 DATE

Bucket start date
DATE35 DATE

Bucket start date
DATE36 DATE

Bucket start date
DATE37 DATE

Bucket start date
Query Text

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


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      PLANNED_ORGANIZATION
,      BUCKET_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      DATE8
,      DATE9
,      DATE10
,      DATE11
,      DATE12
,      DATE13
,      DATE14
,      DATE15
,      DATE16
,      DATE17
,      DATE18
,      DATE19
,      DATE20
,      DATE21
,      DATE22
,      DATE23
,      DATE24
,      DATE25
,      DATE26
,      DATE27
,      DATE28
,      DATE29
,      DATE30
,      DATE31
,      DATE32
,      DATE33
,      DATE34
,      DATE35
,      DATE36
,      DATE37
FROM MRP.MRP_WORKBENCH_BUCKET_DATES;

Dependencies

[top of page]

MRP.MRP_WORKBENCH_BUCKET_DATES does not reference any database object

MRP.MRP_WORKBENCH_BUCKET_DATES is referenced by following:

SchemaAPPS
SynonymMRP_WORKBENCH_BUCKET_DATES