[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MRP_RECOMMENDATIONS# |
|---|---|
| Object Type: | VIEW |
| Owner: | MRP |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTION_ID | NUMBER | 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 | |
| NEW_SCHEDULE_DATE | DATE | Yes | ||
| OLD_SCHEDULE_DATE | DATE | |||
| NEW_WIP_START_DATE | DATE | |||
| OLD_WIP_START_DATE | DATE | |||
| DISPOSITION_ID | NUMBER | |||
| DISPOSITION_STATUS_TYPE | NUMBER | Yes | ||
| ORDER_TYPE | NUMBER | Yes | ||
| VENDOR_ID | NUMBER | |||
| VENDOR_SITE_ID | NUMBER | |||
| NEW_ORDER_QUANTITY | NUMBER | Yes | ||
| OLD_ORDER_QUANTITY | NUMBER | |||
| NEW_ORDER_PLACEMENT_DATE | DATE | |||
| OLD_ORDER_PLACEMENT_DATE | DATE | |||
| FIRM_PLANNED_TYPE | NUMBER | Yes | ||
| RESCHEDULED_FLAG | NUMBER | |||
| SCHEDULE_COMPRESSION_DAYS | NUMBER | |||
| NEW_PROCESSING_DAYS | NUMBER | |||
| IMPLEMENTED_QUANTITY | NUMBER | |||
| PURCH_LINE_NUM | NUMBER | |||
| REVISION | VARCHAR2 | (3) | ||
| LAST_UNIT_COMPLETION_DATE | DATE | |||
| FIRST_UNIT_START_DATE | DATE | |||
| LAST_UNIT_START_DATE | DATE | |||
| DAILY_RATE | NUMBER | |||
| OLD_DOCK_DATE | DATE | |||
| NEW_DOCK_DATE | DATE | |||
| SUPPLY_AVAIL_DATE | DATE | |||
| RESCHEDULE_DAYS | NUMBER | |||
| REQUEST_ID | NUMBER | |||
| PROGRAM_APPLICATION_ID | NUMBER | |||
| PROGRAM_ID | NUMBER | |||
| PROGRAM_UPDATE_DATE | DATE | |||
| QUANTITY_IN_PROCESS | NUMBER | |||
| FIRM_QUANTITY | NUMBER | |||
| FIRM_DATE | DATE | |||
| NETTING_DATE | DATE | |||
| PLANNING_MAKE_BUY_CODE | NUMBER | |||
| UPDATED | NUMBER | |||
| STATUS | NUMBER | |||
| APPLIED | NUMBER | |||
| IMPLEMENT_DEMAND_CLASS | VARCHAR2 | (30) | ||
| IMPLEMENT_DATE | DATE | |||
| IMPLEMENT_QUANTITY | NUMBER | |||
| IMPLEMENT_FIRM | NUMBER | |||
| IMPLEMENT_WIP_CLASS_CODE | VARCHAR2 | (10) | ||
| IMPLEMENT_JOB_NAME | VARCHAR2 | (240) | ||
| IMPLEMENT_DOCK_DATE | DATE | |||
| IMPLEMENT_STATUS_CODE | NUMBER | |||
| IMPLEMENT_EMPLOYEE_ID | NUMBER | |||
| IMPLEMENT_UOM_CODE | VARCHAR2 | (3) | ||
| IMPLEMENT_LOCATION_ID | NUMBER | |||
| IMPLEMENT_SOURCE_ORG_ID | NUMBER | |||
| IMPLEMENT_VENDOR_ID | NUMBER | |||
| IMPLEMENT_VENDOR_SITE_ID | NUMBER | |||
| RELEASE_STATUS | NUMBER | |||
| LOAD_TYPE | NUMBER | |||
| IMPLEMENT_AS | NUMBER | (22) | ||
| DEMAND_CLASS | VARCHAR2 | (30) | ||
| ALTERNATE_BOM_DESIGNATOR | VARCHAR2 | (10) | ||
| ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | ||
| LINE_ID | NUMBER | |||
| SOURCE | NUMBER | |||
| BY_PRODUCT_USING_ASSY_ID | NUMBER | |||
| SOURCE_ORGANIZATION_ID | NUMBER | |||
| SOURCE_VENDOR_SITE_ID | NUMBER | |||
| SOURCE_VENDOR_ID | NUMBER | |||
| SOURCE_SUPPLY_SCHEDULE_NAME | VARCHAR2 | (10) | ||
| NEW_SHIP_DATE | DATE | |||
| PROJECT_ID | NUMBER | (15) | ||
| TASK_ID | NUMBER | (15) | ||
| PLANNING_GROUP | VARCHAR2 | (30) | ||
| IMPLEMENT_PROJECT_ID | NUMBER | |||
| IMPLEMENT_TASK_ID | NUMBER | |||
| IMPLEMENT_SCHEDULE_GROUP_ID | NUMBER | |||
| IMPLEMENT_BUILD_SEQUENCE | NUMBER | |||
| IMPLEMENT_ALTERNATE_BOM | VARCHAR2 | (10) | ||
| IMPLEMENT_ALTERNATE_ROUTING | VARCHAR2 | (10) | ||
| IMPLEMENT_LINE_ID | NUMBER | |||
| SOURCE_ITEM_ID | NUMBER | |||
| RELEASE_ERRORS | VARCHAR2 | (2000) | ||
| NUMBER1 | NUMBER | |||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
| IMPLEMENT_END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, NEW_SCHEDULE_DATE
, OLD_SCHEDULE_DATE
, NEW_WIP_START_DATE
, OLD_WIP_START_DATE
, DISPOSITION_ID
, DISPOSITION_STATUS_TYPE
, ORDER_TYPE
, VENDOR_ID
, VENDOR_SITE_ID
, NEW_ORDER_QUANTITY
, OLD_ORDER_QUANTITY
, NEW_ORDER_PLACEMENT_DATE
, OLD_ORDER_PLACEMENT_DATE
, FIRM_PLANNED_TYPE
, RESCHEDULED_FLAG
, SCHEDULE_COMPRESSION_DAYS
, NEW_PROCESSING_DAYS
, IMPLEMENTED_QUANTITY
, PURCH_LINE_NUM
, REVISION
, LAST_UNIT_COMPLETION_DATE
, FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE
, DAILY_RATE
, OLD_DOCK_DATE
, NEW_DOCK_DATE
, SUPPLY_AVAIL_DATE
, RESCHEDULE_DAYS
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUANTITY_IN_PROCESS
, FIRM_QUANTITY
, FIRM_DATE
, NETTING_DATE
, PLANNING_MAKE_BUY_CODE
, UPDATED
, STATUS
, APPLIED
, IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE
, IMPLEMENT_QUANTITY
, IMPLEMENT_FIRM
, IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_JOB_NAME
, IMPLEMENT_DOCK_DATE
, IMPLEMENT_STATUS_CODE
, IMPLEMENT_EMPLOYEE_ID
, IMPLEMENT_UOM_CODE
, IMPLEMENT_LOCATION_ID
, IMPLEMENT_SOURCE_ORG_ID
, IMPLEMENT_VENDOR_ID
, IMPLEMENT_VENDOR_SITE_ID
, RELEASE_STATUS
, LOAD_TYPE
, IMPLEMENT_AS
, DEMAND_CLASS
, ALTERNATE_BOM_DESIGNATOR
, ALTERNATE_ROUTING_DESIGNATOR
, LINE_ID
, SOURCE
, BY_PRODUCT_USING_ASSY_ID
, SOURCE_ORGANIZATION_ID
, SOURCE_VENDOR_SITE_ID
, SOURCE_VENDOR_ID
, SOURCE_SUPPLY_SCHEDULE_NAME
, NEW_SHIP_DATE
, PROJECT_ID
, TASK_ID
, PLANNING_GROUP
, IMPLEMENT_PROJECT_ID
, IMPLEMENT_TASK_ID
, IMPLEMENT_SCHEDULE_GROUP_ID
, IMPLEMENT_BUILD_SEQUENCE
, IMPLEMENT_ALTERNATE_BOM
, IMPLEMENT_ALTERNATE_ROUTING
, IMPLEMENT_LINE_ID
, SOURCE_ITEM_ID
, RELEASE_ERRORS
, NUMBER1
, END_ITEM_UNIT_NUMBER
, IMPLEMENT_END_ITEM_UNIT_NUMBER
FROM MRP.MRP_RECOMMENDATIONS#;
MRP
MRP_RECOMMENDATIONS
APPS
MRP_RECOMMENDATIONS
|
|
|
|