[Home] [Help] [Dependency Information]
Object Name: | MRP_FLOW_DEMANDS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_FLOW_DEMANDS |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_FLOW_DEMANDS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WIP_ENTITY_ID |
MRP_FLOW_DEMANDS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BILL_SEQUENCE_ID |
MRP_FLOW_DEMANDS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RN |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Organization identifier | ||
PLANNED_QUANTITY | NUMBER | Planned quantity | ||
PRIMARY_ITEM_ID | NUMBER | Item identifier | ||
QUANTITY_COMPLETED | NUMBER | Quantity completed | ||
SCHEDULED_COMPLETION_DATE | DATE | Scheduled completion date | ||
SCHEDULED_START_DATE | DATE | Scheduled start date | ||
WIP_ENTITY_ID | NUMBER | WIP job identifier | ||
PLAN_LEVEL | NUMBER | Plan level | ||
WIP_SUPPLY_TYPE | NUMBER | WIP supply type | ||
BILL_SEQUENCE_ID | NUMBER | Bill sequence identifier | ||
STATUS | NUMBER | Status | ||
RN | NUMBER | Refresh number |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, PLANNED_QUANTITY
, PRIMARY_ITEM_ID
, QUANTITY_COMPLETED
, SCHEDULED_COMPLETION_DATE
, SCHEDULED_START_DATE
, WIP_ENTITY_ID
, PLAN_LEVEL
, WIP_SUPPLY_TYPE
, BILL_SEQUENCE_ID
, STATUS
, RN
FROM MRP.MRP_FLOW_DEMANDS;
MRP.MRP_FLOW_DEMANDS does not reference any database object
MRP.MRP_FLOW_DEMANDS is referenced by following:
|
|
|