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

TABLE: AHL.AHL_SCHEDULE_MATERIALS

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


This table stores information about materials scheduled in MRP


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_SCHEDULE_MATERIALS_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCHEDULED_MATERIAL_ID
AHL_SCHEDULE_MATERIALS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVISIT_TASK_ID
ColumnRT_OPER_MATERIAL_ID
ColumnINVENTORY_ITEM_ID
ColumnVISIT_ID
AHL_SCHEDULE_MATERIALS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnVISIT_TASK_ID
ColumnSCHEDULED_MATERIAL_ID
ColumnVISIT_ID
AHL_SCHEDULE_MATERIALS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUNIT_EFFECTIVITY_ID
Columns
Name Datatype Length Mandatory Comments
SCHEDULED_MATERIAL_ID NUMBER
Yes Primary Key, Unique identifier for schedule material ID
OBJECT_VERSION_NUMBER NUMBER
Yes Stores locking sequence number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
INVENTORY_ITEM_ID NUMBER

Identifier for inventory item ID, Foreign key to MTL_SYSTEM_ITEMS_B
SCHEDULE_DESIGNATOR VARCHAR2 (30)
OBSOLETE.Identifier for schedule designator, Foreign key to MRP_SCHEDULE_DESIGNATORS table
VISIT_ID NUMBER

Identifer for visit ID
VISIT_START_DATE DATE

Identifier for visit start date
VISIT_TASK_ID NUMBER

Identifier for visit task ID, Foreign key to AHL_VISIT_TASKS_B table.
ORGANIZATION_ID NUMBER

Identifier for organization ID
SCHEDULED_DATE DATE

Identifier for Scheduled Date
REQUEST_ID NUMBER

Identifier for Request ID
REQUESTED_DATE DATE
Yes Identifier for Requested Date
SCHEDULED_QUANTITY NUMBER

Identifier for Scheduled Quantity
PROCESS_STATUS NUMBER

Obsolete.Identifier for Process Status
ERROR_MESSAGE VARCHAR2 (120)
Obsolete.Identifer for Error Message
TRANSACTION_ID NUMBER

Obsolete.Identifier for Transaction ID
SECURITY_GROUP_ID NUMBER

Used in application hosting
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
UOM VARCHAR2 (30)
Obsolete.Identifier for UOM
RT_OPER_MATERIAL_ID NUMBER

Identifier for Route operation material ID, Foreign key to AHL_RT_OPER_MATERIALS table
OPERATION_CODE VARCHAR2 (80)
Obsolete.Identifier for Operation code
OPERATION_SEQUENCE NUMBER

Identifier for Operation Sequence
ITEM_GROUP_ID NUMBER

Identifier for Item Group ID, used to retrieve alternate items
REQUESTED_QUANTITY NUMBER
Yes Identifier for Requested Quantity
PROGRAM_ID NUMBER

Obsolete.Identifier for Program ID
PROGRAM_UPDATE_DATE DATE

Obsolete.Identifier for Program Update Date
LAST_UPDATED_DATE DATE

Identifier for Last Update Date
WORKORDER_OPERATION_ID NUMBER

Identifier for workorder operation id
POSITION_PATH_ID NUMBER

Identifier for mc path position
RELATIONSHIP_ID NUMBER

Identifier for mc subconfiguration
UNIT_EFFECTIVITY_ID NUMBER

Identifier for unit effectivity
MR_ROUTE_ID NUMBER

Identifier for mr route
MATERIAL_REQUEST_TYPE VARCHAR2 (30)
Identifier for material type
COMPLETED_QUANTITY NUMBER

Identifier for completed quantity
STATUS VARCHAR2 (30)
Identifier for item status
ATP_FLAG VARCHAR2 (1)
Material will be collected into GOP if flag set to Y.
MC_HEADER_ID NUMBER

Master Configuration Header Identifier
POSITION_KEY NUMBER

Master Configuration Position Key
AOG_FLAG VARCHAR2 (1)
AOG Flag
Query Text

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


SELECT SCHEDULED_MATERIAL_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      SCHEDULE_DESIGNATOR
,      VISIT_ID
,      VISIT_START_DATE
,      VISIT_TASK_ID
,      ORGANIZATION_ID
,      SCHEDULED_DATE
,      REQUEST_ID
,      REQUESTED_DATE
,      SCHEDULED_QUANTITY
,      PROCESS_STATUS
,      ERROR_MESSAGE
,      TRANSACTION_ID
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UOM
,      RT_OPER_MATERIAL_ID
,      OPERATION_CODE
,      OPERATION_SEQUENCE
,      ITEM_GROUP_ID
,      REQUESTED_QUANTITY
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATED_DATE
,      WORKORDER_OPERATION_ID
,      POSITION_PATH_ID
,      RELATIONSHIP_ID
,      UNIT_EFFECTIVITY_ID
,      MR_ROUTE_ID
,      MATERIAL_REQUEST_TYPE
,      COMPLETED_QUANTITY
,      STATUS
,      ATP_FLAG
,      MC_HEADER_ID
,      POSITION_KEY
,      AOG_FLAG
FROM AHL.AHL_SCHEDULE_MATERIALS;

Dependencies

[top of page]

AHL.AHL_SCHEDULE_MATERIALS does not reference any database object

AHL.AHL_SCHEDULE_MATERIALS is referenced by following:

SchemaAHL
ViewAHL_SCHEDULE_MATERIALS#