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_PENDING_ENG_CHANGES#

Source

View Text - Preformatted


select ECN_ID ECN_ID, 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, CHANGE_NOTICE CHANGE_NOTICE, ENG_CHANGE_USING_ASSY_ID ENG_CHANGE_USING_ASSY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, ENGINEERING_CHANGE_TYPE ENGINEERING_CHANGE_TYPE, REVISION REVISION, OPTIONAL_COMPONENT OPTIONAL_COMPONENT, EFFECTIVITY_DATE EFFECTIVITY_DATE, SUGGESTED_EFFECTIVITY_DATE SUGGESTED_EFFECTIVITY_DATE, OLD_EFFECTIVITY_DATE OLD_EFFECTIVITY_DATE, DRIVING_ITEM_ID DRIVING_ITEM_ID, USE_UP_CODE USE_UP_CODE, REMAINING_IMPL_UNITS REMAINING_IMPL_UNITS, ABSOLUTE_QUANTITY ABSOLUTE_QUANTITY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, OPERATION_OFFSET_PERCENT OPERATION_OFFSET_PERCENT from "MRP"."MRP_PENDING_ENG_CHANGES"

View Text - HTML Formatted

SELECT ECN_ID ECN_ID
, 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
, CHANGE_NOTICE CHANGE_NOTICE
, ENG_CHANGE_USING_ASSY_ID ENG_CHANGE_USING_ASSY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, ENGINEERING_CHANGE_TYPE ENGINEERING_CHANGE_TYPE
, REVISION REVISION
, OPTIONAL_COMPONENT OPTIONAL_COMPONENT
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, SUGGESTED_EFFECTIVITY_DATE SUGGESTED_EFFECTIVITY_DATE
, OLD_EFFECTIVITY_DATE OLD_EFFECTIVITY_DATE
, DRIVING_ITEM_ID DRIVING_ITEM_ID
, USE_UP_CODE USE_UP_CODE
, REMAINING_IMPL_UNITS REMAINING_IMPL_UNITS
, ABSOLUTE_QUANTITY ABSOLUTE_QUANTITY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, OPERATION_OFFSET_PERCENT OPERATION_OFFSET_PERCENT
FROM "MRP"."MRP_PENDING_ENG_CHANGES"