[Home] [Help] [Dependency Information]
Object Name: | MRP_SUGG_REP_SCHEDULES# |
---|---|
Object Type: | VIEW |
Owner: | MRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | ||
REPETITIVE_LINE | NUMBER | Yes | ||
FIRST_UNIT_COMPLETION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | Yes | ||
ORGANIZATION_ID | NUMBER | Yes | ||
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | |
FIRST_UNIT_START_DATE | DATE | Yes | ||
LAST_UNIT_START_DATE | DATE | Yes | ||
LAST_UNIT_COMPLETION_DATE | DATE | Yes | ||
PROCESSING_DAYS | NUMBER | Yes | ||
DAILY_RATE | NUMBER | Yes | ||
FIRM_PLANNED_STATUS_TYPE | NUMBER | Yes | ||
LOAD_FACTOR_RATE | NUMBER | |||
UPDATED | NUMBER | |||
STATUS | NUMBER | |||
IMPLEMENT_DEMAND_CLASS | VARCHAR2 | (30) | ||
IMPLEMENT_DATE | DATE | |||
IMPLEMENT_DAILY_RATE | NUMBER | |||
IMPLEMENT_FIRM | NUMBER | |||
IMPLEMENT_PROCESSING_DAYS | NUMBER | |||
IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | (10) | ||
IMPLEMENT_LINE_ID | NUMBER | |||
RELEASE_STATUS | NUMBER | |||
LOAD_TYPE | NUMBER | |||
SOURCE_ITEM_ID | NUMBER | |||
RELEASE_ERRORS | VARCHAR2 | (2000) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, REPETITIVE_LINE
, FIRST_UNIT_COMPLETION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE
, PROCESSING_DAYS
, DAILY_RATE
, FIRM_PLANNED_STATUS_TYPE
, LOAD_FACTOR_RATE
, UPDATED
, STATUS
, IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE
, IMPLEMENT_DAILY_RATE
, IMPLEMENT_FIRM
, IMPLEMENT_PROCESSING_DAYS
, IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_LINE_ID
, RELEASE_STATUS
, LOAD_TYPE
, SOURCE_ITEM_ID
, RELEASE_ERRORS
FROM MRP.MRP_SUGG_REP_SCHEDULES#;
|
|
|