eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: MRP.MRP_SUGG_REP_SCHEDULES#

Source

View Text - Preformatted


select TRANSACTION_ID TRANSACTION_ID, REPETITIVE_LINE REPETITIVE_LINE, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE, LAST_UNIT_START_DATE LAST_UNIT_START_DATE, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE, PROCESSING_DAYS PROCESSING_DAYS, DAILY_RATE DAILY_RATE, FIRM_PLANNED_STATUS_TYPE FIRM_PLANNED_STATUS_TYPE, LOAD_FACTOR_RATE LOAD_FACTOR_RATE, UPDATED UPDATED, STATUS STATUS, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS, IMPLEMENT_DATE IMPLEMENT_DATE, IMPLEMENT_DAILY_RATE IMPLEMENT_DAILY_RATE, IMPLEMENT_FIRM IMPLEMENT_FIRM, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID, RELEASE_STATUS RELEASE_STATUS, LOAD_TYPE LOAD_TYPE, SOURCE_ITEM_ID SOURCE_ITEM_ID, RELEASE_ERRORS RELEASE_ERRORS from "MRP"."MRP_SUGG_REP_SCHEDULES"

View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, REPETITIVE_LINE REPETITIVE_LINE
, FIRST_UNIT_COMPLETION_DATE FIRST_UNIT_COMPLETION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, FIRST_UNIT_START_DATE FIRST_UNIT_START_DATE
, LAST_UNIT_START_DATE LAST_UNIT_START_DATE
, LAST_UNIT_COMPLETION_DATE LAST_UNIT_COMPLETION_DATE
, PROCESSING_DAYS PROCESSING_DAYS
, DAILY_RATE DAILY_RATE
, FIRM_PLANNED_STATUS_TYPE FIRM_PLANNED_STATUS_TYPE
, LOAD_FACTOR_RATE LOAD_FACTOR_RATE
, UPDATED UPDATED
, STATUS STATUS
, IMPLEMENT_DEMAND_CLASS IMPLEMENT_DEMAND_CLASS
, IMPLEMENT_DATE IMPLEMENT_DATE
, IMPLEMENT_DAILY_RATE IMPLEMENT_DAILY_RATE
, IMPLEMENT_FIRM IMPLEMENT_FIRM
, IMPLEMENT_PROCESSING_DAYS IMPLEMENT_PROCESSING_DAYS
, IMPLEMENT_WIP_CLASS_CODE IMPLEMENT_WIP_CLASS_CODE
, IMPLEMENT_LINE_ID IMPLEMENT_LINE_ID
, RELEASE_STATUS RELEASE_STATUS
, LOAD_TYPE LOAD_TYPE
, SOURCE_ITEM_ID SOURCE_ITEM_ID
, RELEASE_ERRORS RELEASE_ERRORS
FROM "MRP"."MRP_SUGG_REP_SCHEDULES"