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

TABLE: AHL.AHL_DEPT_RESOURCE_CAPACITY

Object Details
Object Name: AHL_DEPT_RESOURCE_CAPACITY
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_DEPT_RESOURCE_CAPACITY
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_DEPT_RESOURCE_CAPACITY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnDEPARTMENT_ID
ColumnRESOURCE_ID
ColumnAVAILABLE_DATE
Columns
Name Datatype Length Mandatory Comments
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
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
SOURCE_APPLICATION VARCHAR2 (3) Yes Application Id
ORGANIZATION_ID NUMBER
Yes Organization Id
DEPARTMENT_ID NUMBER
Yes Department Id
RESOURCE_ID NUMBER
Yes Resource Id
AVAILABLE_DATE DATE
Yes Available Date
CAPACITY_UNITS NUMBER
Yes Number of Units
UOM_CODE VARCHAR2 (3)
UOM Code
ASCP_PLAN_DATE DATE
Yes Plan Date
ASCP_PLAN_ID NUMBER
Yes Plan Id defined in and populated by ASCP
ASCP_PLAN_NAME VARCHAR2 (240) Yes Plan Name for collecting data from ASCP
BOM_SIMULATION_SET_ID NUMBER

Simulation Set Id
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_APPLICATION
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      AVAILABLE_DATE
,      CAPACITY_UNITS
,      UOM_CODE
,      ASCP_PLAN_DATE
,      ASCP_PLAN_ID
,      ASCP_PLAN_NAME
,      BOM_SIMULATION_SET_ID
FROM AHL.AHL_DEPT_RESOURCE_CAPACITY;

Dependencies

[top of page]

AHL.AHL_DEPT_RESOURCE_CAPACITY does not reference any database object

AHL.AHL_DEPT_RESOURCE_CAPACITY is referenced by following:

SchemaAHL
ViewAHL_DEPT_RESOURCE_CAPACITY#