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

Source

View Text - Preformatted


select COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, CHANGE_NOTICE CHANGE_NOTICE, USING_ASSEMBLY_ID USING_ASSEMBLY_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, 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, REVISION REVISION, EFFECTIVITY_DATE EFFECTIVITY_DATE, SUGGESTED_EFFECTIVITY_DATE SUGGESTED_EFFECTIVITY_DATE, USE_UP_CODE USE_UP_CODE, USAGE_QUANTITY USAGE_QUANTITY, OPERATION_OFFSET_PERCENT OPERATION_OFFSET_PERCENT, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, DRIVING_ITEM_ID DRIVING_ITEM_ID, OPTIONAL_COMPONENT OPTIONAL_COMPONENT, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR, OLD_EFFECTIVITY_DATE OLD_EFFECTIVITY_DATE, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE, DISABLE_DATE DISABLE_DATE, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER from "MRP"."MRP_BOM_COMPONENTS"

View Text - HTML Formatted

SELECT COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, CHANGE_NOTICE CHANGE_NOTICE
, USING_ASSEMBLY_ID USING_ASSEMBLY_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, 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
, REVISION REVISION
, EFFECTIVITY_DATE EFFECTIVITY_DATE
, SUGGESTED_EFFECTIVITY_DATE SUGGESTED_EFFECTIVITY_DATE
, USE_UP_CODE USE_UP_CODE
, USAGE_QUANTITY USAGE_QUANTITY
, OPERATION_OFFSET_PERCENT OPERATION_OFFSET_PERCENT
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, DRIVING_ITEM_ID DRIVING_ITEM_ID
, OPTIONAL_COMPONENT OPTIONAL_COMPONENT
, ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, OLD_EFFECTIVITY_DATE OLD_EFFECTIVITY_DATE
, WIP_SUPPLY_TYPE WIP_SUPPLY_TYPE
, DISABLE_DATE DISABLE_DATE
, FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_BOM_COMPONENTS"