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.

VIEW: BOM.CST_WIP_OPERATION_TXN_COSTS#

Source

View Text - Preformatted


select TXN_COST_ID TXN_COST_ID, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE, WIP_ENTITY_ID WIP_ENTITY_ID, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID, OPERATION_SEQ_NUM OPERATION_SEQ_NUM, COST_ELEMENT_ID COST_ELEMENT_ID, LEVEL_TYPE LEVEL_TYPE, TRANSACTION_DATE TRANSACTION_DATE, COMPONENT_ITEM_ID COMPONENT_ITEM_ID, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID, RESOURCE_ID RESOURCE_ID, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM, BASIS_TYPE BASIS_TYPE, PRIOR_APPLIED_UNITS PRIOR_APPLIED_UNITS, NEW_APPLIED_UNITS NEW_APPLIED_UNITS, PRIOR_APPLIED_VALUE PRIOR_APPLIED_VALUE, NEW_APPLIED_VALUE NEW_APPLIED_VALUE, PRIOR_RELIEVED_SCRAP_UNITS PRIOR_RELIEVED_SCRAP_UNITS, NEW_RELIEVED_SCRAP_UNITS NEW_RELIEVED_SCRAP_UNITS, PRIOR_RELIEVED_SCRAP_VALUE PRIOR_RELIEVED_SCRAP_VALUE, NEW_RELIEVED_SCRAP_VALUE NEW_RELIEVED_SCRAP_VALUE, PRIOR_RELIEVED_VAR_VALUE PRIOR_RELIEVED_VAR_VALUE, NEW_RELIEVED_VAR_VALUE NEW_RELIEVED_VAR_VALUE, PRIOR_RELIEVED_FINAL_UNITS PRIOR_RELIEVED_FINAL_UNITS, NEW_RELIEVED_FINAL_UNITS NEW_RELIEVED_FINAL_UNITS, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ORGANIZATION_ID ORGANIZATION_ID, PRIOR_RELIEVED_COMP_UNITS PRIOR_RELIEVED_COMP_UNITS, NEW_RELIEVED_COMP_UNITS NEW_RELIEVED_COMP_UNITS, PRIOR_RELIEVED_COMP_VALUE PRIOR_RELIEVED_COMP_VALUE, NEW_RELIEVED_COMP_VALUE NEW_RELIEVED_COMP_VALUE from "BOM"."CST_WIP_OPERATION_TXN_COSTS"

View Text - HTML Formatted

SELECT TXN_COST_ID TXN_COST_ID
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_SOURCE_CODE TRANSACTION_SOURCE_CODE
, WIP_ENTITY_ID WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID REPETITIVE_SCHEDULE_ID
, OPERATION_SEQ_NUM OPERATION_SEQ_NUM
, COST_ELEMENT_ID COST_ELEMENT_ID
, LEVEL_TYPE LEVEL_TYPE
, TRANSACTION_DATE TRANSACTION_DATE
, COMPONENT_ITEM_ID COMPONENT_ITEM_ID
, COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, RESOURCE_ID RESOURCE_ID
, RESOURCE_SEQ_NUM RESOURCE_SEQ_NUM
, BASIS_TYPE BASIS_TYPE
, PRIOR_APPLIED_UNITS PRIOR_APPLIED_UNITS
, NEW_APPLIED_UNITS NEW_APPLIED_UNITS
, PRIOR_APPLIED_VALUE PRIOR_APPLIED_VALUE
, NEW_APPLIED_VALUE NEW_APPLIED_VALUE
, PRIOR_RELIEVED_SCRAP_UNITS PRIOR_RELIEVED_SCRAP_UNITS
, NEW_RELIEVED_SCRAP_UNITS NEW_RELIEVED_SCRAP_UNITS
, PRIOR_RELIEVED_SCRAP_VALUE PRIOR_RELIEVED_SCRAP_VALUE
, NEW_RELIEVED_SCRAP_VALUE NEW_RELIEVED_SCRAP_VALUE
, PRIOR_RELIEVED_VAR_VALUE PRIOR_RELIEVED_VAR_VALUE
, NEW_RELIEVED_VAR_VALUE NEW_RELIEVED_VAR_VALUE
, PRIOR_RELIEVED_FINAL_UNITS PRIOR_RELIEVED_FINAL_UNITS
, NEW_RELIEVED_FINAL_UNITS NEW_RELIEVED_FINAL_UNITS
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ORGANIZATION_ID ORGANIZATION_ID
, PRIOR_RELIEVED_COMP_UNITS PRIOR_RELIEVED_COMP_UNITS
, NEW_RELIEVED_COMP_UNITS NEW_RELIEVED_COMP_UNITS
, PRIOR_RELIEVED_COMP_VALUE PRIOR_RELIEVED_COMP_VALUE
, NEW_RELIEVED_COMP_VALUE NEW_RELIEVED_COMP_VALUE
FROM "BOM"."CST_WIP_OPERATION_TXN_COSTS"