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]

Table: SY_UOMS_MST

Product:	GMA - Process Manufacturing Systems
Description:	Unit of measure master for Oracle Process Manufacturing. Synchronized with MTL_UNITS_OF_MEASURE and associated tables when Oracle Financials is used.
Implementation/DBA Data:	Not implemented in this database

Primary Key: SY_UOMS_MST_PK

UM_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
SY_UOMS_MST	SY_TEXT_HDR	SY_UOMS_MST.TEXT_CODE
SY_UOMS_MST	SY_UOMS_TYP	SY_UOMS_MST.UM_TYPE
CM_ADJS_DTL	SY_UOMS_MST	CM_ADJS_DTL.ADJUST_QTY_UM
CM_BRDN_DTL	SY_UOMS_MST	CM_BRDN_DTL.BURDEN_UM
CM_BRDN_DTL	SY_UOMS_MST	CM_BRDN_DTL.ITEM_UM
CM_RSRC_DTL	SY_UOMS_MST	CM_RSRC_DTL.USAGE_UM
CM_SCST_LED	SY_UOMS_MST	CM_SCST_LED.FORM_PROD_UM
CM_SCST_LED	SY_UOMS_MST	CM_SCST_LED.ITEM_FMQTY_UM
CM_SCST_LED	SY_UOMS_MST	CM_SCST_LED.USAGE_UM
CR_RSRC_DTL	SY_UOMS_MST	CR_RSRC_DTL.USAGE_UM
CR_RSRC_MST	SY_UOMS_MST	CR_RSRC_MST.STD_USAGE_UM
FM_FORM_EFF	SY_UOMS_MST	FM_FORM_EFF.ITEM_UM
FM_MATL_DTL	SY_UOMS_MST	FM_MATL_DTL.ITEM_UM
FM_OPRN_DTL	SY_UOMS_MST	FM_OPRN_DTL.USAGE_UM
FM_OPRN_MST	SY_UOMS_MST	FM_OPRN_MST.PROCESS_QTY_UM
FM_ROUT_HDR	SY_UOMS_MST	FM_ROUT_HDR.ITEM_UM
GL_ACCT_MST	SY_UOMS_MST	GL_ACCT_MST.QUANTITY_UM
GL_SUBR_LED	SY_UOMS_MST	GL_SUBR_LED.QUANTITY_UM
GL_SUBR_TST	SY_UOMS_MST	GL_SUBR_TST.QUANTITY_UM
GMP_ITEM_APS	SY_UOMS_MST	GMP_ITEM_APS.ITEM_UM
IC_ADJS_JNL	SY_UOMS_MST	IC_ADJS_JNL.ITEM_UM
IC_ADJS_JNL	SY_UOMS_MST	IC_ADJS_JNL.ITEM_UM2
IC_CYCL_ADT	SY_UOMS_MST	IC_CYCL_ADT.UOM1
IC_CYCL_ADT	SY_UOMS_MST	IC_CYCL_ADT.UOM2
IC_INVN_CLS	SY_UOMS_MST	IC_INVN_CLS.REPORTING_UOM
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.ITEM_UM
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.ITEM_UM2
IC_ITEM_MST	SY_UOMS_MST	IC_ITEM_MST.FILL_UM
IC_LOCT_MST	SY_UOMS_MST	IC_LOCT_MST.CAPACITY_UM
IC_PKGS_MST	SY_UOMS_MST	IC_PKGS_MST.FILL_UM
IC_PKGS_MST	SY_UOMS_MST	IC_PKGS_MST.TARE_UM
IC_SALE_CLS	SY_UOMS_MST	IC_SALE_CLS.REPORTING_UOM
IC_TRAN_ARC	SY_UOMS_MST	IC_TRAN_ARC.TRANS_UM
IC_TRAN_ARC	SY_UOMS_MST	IC_TRAN_ARC.TRANS_UM2
IC_TRAN_CMP	SY_UOMS_MST	IC_TRAN_CMP.TRANS_UM
IC_TRAN_CMP	SY_UOMS_MST	IC_TRAN_CMP.TRANS_UM2
IC_TRAN_PND	SY_UOMS_MST	IC_TRAN_PND.TRANS_UM2
IC_TRAN_PND	SY_UOMS_MST	IC_TRAN_PND.TRANS_UM
IC_XFER_MST	SY_UOMS_MST	IC_XFER_MST.RELEASE_UOM1
IC_XFER_MST	SY_UOMS_MST	IC_XFER_MST.RELEASE_UOM2
LM_FORM_DTL	SY_UOMS_MST	LM_FORM_DTL.ITEM_UM
LM_SPRD_DTL	SY_UOMS_MST	LM_SPRD_DTL.ITEM_UM
MR_TRAN_TBL	SY_UOMS_MST	MR_TRAN_TBL.TRANS_UM
OP_BILL_LAD	SY_UOMS_MST	OP_BILL_LAD.BOL_UM
OP_CHRG_MST	SY_UOMS_MST	OP_CHRG_MST.CHARGE_UOM
OP_CNTR_DTL	SY_UOMS_MST	OP_CNTR_DTL.PRICE_UM
OP_ORDR_DTL	SY_UOMS_MST	OP_ORDR_DTL.ORDER_UM1
OP_ORDR_DTL	SY_UOMS_MST	OP_ORDR_DTL.ORDER_UM2
OP_ORDR_DTL	SY_UOMS_MST	OP_ORDR_DTL.SHIPWT_UM
OP_ORDR_DTL	SY_UOMS_MST	OP_ORDR_DTL.SHIPVOLUME_UM
OP_ORDR_DTL	SY_UOMS_MST	OP_ORDR_DTL.PRICE_UM
OP_PRCE_ITM	SY_UOMS_MST	OP_PRCE_ITM.PRICE_UM
OP_PRSL_DTL	SY_UOMS_MST	OP_PRSL_DTL.ORDER_UM1
OP_PRSL_DTL	SY_UOMS_MST	OP_PRSL_DTL.ORDER_UM2
OP_RELS_SCH	SY_UOMS_MST	OP_RELS_SCH.ORDER_UM1
OP_RELS_SCH	SY_UOMS_MST	OP_RELS_SCH.ORDER_UM2
PC_TRAN_PND	SY_UOMS_MST	PC_TRAN_PND.TRANS_UM
PM_MATL_DTL	SY_UOMS_MST	PM_MATL_DTL.ITEM_UM
PM_MATL_DTL	SY_UOMS_MST	PM_MATL_DTL.ITEM_UM2
PM_OPRN_DTL	SY_UOMS_MST	PM_OPRN_DTL.USAGE_UM
PM_OPRN_WIP	SY_UOMS_MST	PM_OPRN_WIP.TRANS_UM
PM_ROUT_DEP	SY_UOMS_MST	PM_ROUT_DEP.TRANSFER_UM
PO_BPOS_DTL	SY_UOMS_MST	PO_BPOS_DTL.ITEM_UM
PO_DIST_DTL	SY_UOMS_MST	PO_DIST_DTL.QUANTITY_UM
PO_ORDR_DTL	SY_UOMS_MST	PO_ORDR_DTL.ORDER_UM1
PO_ORDR_DTL	SY_UOMS_MST	PO_ORDR_DTL.ORDER_UM2
PO_ORDR_DTL	SY_UOMS_MST	PO_ORDR_DTL.PRICE_UM
PO_RECV_DTL	SY_UOMS_MST	PO_RECV_DTL.RECV_UM1
PO_RECV_DTL	SY_UOMS_MST	PO_RECV_DTL.RECV_UM2
PO_RECV_DTL	SY_UOMS_MST	PO_RECV_DTL.PRICE_UM
PO_RECV_HDR	SY_UOMS_MST	PO_RECV_HDR.BOL_UM
PO_RECV_HST	SY_UOMS_MST	PO_RECV_HST.PRICE_UM
PO_RELS_SCH	SY_UOMS_MST	PO_RELS_SCH.ORDER_UM1
PO_RELS_SCH	SY_UOMS_MST	PO_RELS_SCH.ORDER_UM2
PO_RTRN_DTL	SY_UOMS_MST	PO_RTRN_DTL.RETURN_UM1
PO_RTRN_DTL	SY_UOMS_MST	PO_RTRN_DTL.RETURN_UM2
PS_PLNG_CLS	SY_UOMS_MST	PS_PLNG_CLS.REPORTING_UOM
SY_UOMS_STD	SY_UOMS_MST	SY_UOMS_STD.UM_CODE