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: MTL_CATEGORIES_B

Product:	INV - Inventory
Description:	Code combinations table for Item Category
Implementation/DBA Data:	INV.MTL_CATEGORIES_B

Primary Key: MTL_CATEGORIES_B_PK

CATEGORY_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
AR_REVENUE_ADJUSTMENTS_ALL	MTL_CATEGORIES_B	AR_REVENUE_ADJUSTMENTS_ALL.FROM_CATEGORY_ID
AR_REVENUE_ADJUSTMENTS_ALL	MTL_CATEGORIES_B	AR_REVENUE_ADJUSTMENTS_ALL.TO_CATEGORY_ID
AS_AP_TRACKING_OBJECTIVES	MTL_CATEGORIES_B	AS_AP_TRACKING_OBJECTIVES.PRODUCT_CATEGORY_ID
AS_INTEREST_CODES_B	MTL_CATEGORIES_B	AS_INTEREST_CODES_B.CATEGORY_ID
CSI_I_EXTENDED_ATTRIBS	MTL_CATEGORIES_B	CSI_I_EXTENDED_ATTRIBS.ITEM_CATEGORY_ID
CSP_EXCESS_RULES_B	MTL_CATEGORIES_B	CSP_EXCESS_RULES_B.CATEGORY_ID
CSP_PLANNING_PARAMETERS	MTL_CATEGORIES_B	CSP_PLANNING_PARAMETERS.CATEGORY_ID
CSS_DEF_CAT_PROD_DENORM	MTL_CATEGORIES_B	CSS_DEF_CAT_PROD_DENORM.CATEGORY_ID
CSS_DEF_PROD_CAT_HRCHY	MTL_CATEGORIES_B	CSS_DEF_PROD_CAT_HRCHY.CATEGORY_ID
CSS_DEF_PROD_CAT_HRCHY	MTL_CATEGORIES_B	CSS_DEF_PROD_CAT_HRCHY.PARENT_CATEGORY_ID
CST_COST_TYPE_HISTORY	MTL_CATEGORIES_B	CST_COST_TYPE_HISTORY.CATEGORY_ID
CST_COST_UPDATES	MTL_CATEGORIES_B	CST_COST_UPDATES.CATEGORY_ID
CST_ITEM_OVERHEAD_DEFAULTS	MTL_CATEGORIES_B	CST_ITEM_OVERHEAD_DEFAULTS.CATEGORY_ID
CS_INCIDENTS_ALL_B	MTL_CATEGORIES_B	CS_INCIDENTS_ALL_B.CATEGORY_ID
CS_SR_PROB_CODE_MAPPING	MTL_CATEGORIES_B	CS_SR_PROB_CODE_MAPPING.CATEGORY_ID
CS_SR_PROB_CODE_MAPPING_DETAIL	MTL_CATEGORIES_B	CS_SR_PROB_CODE_MAPPING_DETAIL.CATEGORY_ID
CS_SR_RES_CODE_MAPPING	MTL_CATEGORIES_B	CS_SR_RES_CODE_MAPPING.CATEGORY_ID
CS_SR_RES_CODE_MAPPING_DETAIL	MTL_CATEGORIES_B	CS_SR_RES_CODE_MAPPING_DETAIL.CATEGORY_ID
HZ_CREDIT_PROFILES	MTL_CATEGORIES_B	HZ_CREDIT_PROFILES.ITEM_CATEGORY_ID
IBE_CT_IMEDIA_SEARCH	MTL_CATEGORIES_B	IBE_CT_IMEDIA_SEARCH.CATEGORY_ID
IBE_CT_RELATION_RULES	MTL_CATEGORIES_B	IBE_CT_RELATION_RULES.ORIGIN_OBJECT_ID
IBE_CT_RELATION_RULES	MTL_CATEGORIES_B	IBE_CT_RELATION_RULES.DEST_OBJECT_ID
IBE_DSP_OBJ_LGL_CTNT	MTL_CATEGORIES_B	IBE_DSP_OBJ_LGL_CTNT.OBJECT_ID
IBE_DSP_TPL_CTG	MTL_CATEGORIES_B	IBE_DSP_TPL_CTG.CATEGORY_ID
%	MTL_CATEGORIES_B
ICX_RELATED_CATEGORIES	MTL_CATEGORIES_B	ICX_RELATED_CATEGORIES.CATEGORY_ID
ICX_RELATED_CATEGORIES	MTL_CATEGORIES_B	ICX_RELATED_CATEGORIES.RELATED_CATEGORY_ID
%	MTL_CATEGORIES_B
IGR_EPU_CATEGORY_UPG	MTL_CATEGORIES_B	IGR_EPU_CATEGORY_UPG.PRODUCT_CATEGORY_ID
IGR_IS_I_LINES	MTL_CATEGORIES_B	IGR_IS_I_LINES.PRODUCT_CATEGORY_ID
IGR_I_LINES_INT	MTL_CATEGORIES_B	IGR_I_LINES_INT.PRODUCT_CATEGORY_ID
IGR_I_PKGITM_ASSIGN	MTL_CATEGORIES_B	IGR_I_PKGITM_ASSIGN.PRODUCT_CATEGORY_ID
JTF_DSP_OBJ_LGL_CTNT	MTL_CATEGORIES_B	JTF_DSP_OBJ_LGL_CTNT.OBJECT_ID
JTF_DSP_TPL_CTG	MTL_CATEGORIES_B	JTF_DSP_TPL_CTG.CATEGORY_ID
MRP_SR_ASSIGNMENTS	MTL_CATEGORIES_B	MRP_SR_ASSIGNMENTS.CATEGORY_ID
MRP_SYSTEM_ITEMS	MTL_CATEGORIES_B	MRP_SYSTEM_ITEMS.CATEGORY_ID
FTE_LANE_COMMODITIES	MTL_CATEGORIES_B	FTE_LANE_COMMODITIES.COMMODITY_CATG_ID
MTL_CATEGORIES_TL	MTL_CATEGORIES_B	MTL_CATEGORIES_TL.CATEGORY_ID
MTL_CATEGORY_ACCOUNTS	MTL_CATEGORIES_B	MTL_CATEGORY_ACCOUNTS.CATEGORY_ID
MTL_CATEGORY_SETS_B	MTL_CATEGORIES_B	MTL_CATEGORY_SETS_B.DEFAULT_CATEGORY_ID
MTL_CATEGORY_SET_VALID_CATS	MTL_CATEGORIES_B	MTL_CATEGORY_SET_VALID_CATS.CATEGORY_ID
MTL_FISCAL_CAT_ACCOUNTS	MTL_CATEGORIES_B	MTL_FISCAL_CAT_ACCOUNTS.CATEGORY_ID
MTL_ICG_CATEGORIES	MTL_CATEGORIES_B	MTL_ICG_CATEGORIES.CATEGORY_ID
MTL_SUPPLY	MTL_CATEGORIES_B	MTL_SUPPLY.CATEGORY_ID
PA_RESOURCE_ASSIGNMENTS	MTL_CATEGORIES_B	PA_RESOURCE_ASSIGNMENTS.ITEM_CATEGORY_ID
PA_RESOURCE_LIST_MEMBERS	MTL_CATEGORIES_B	PA_RESOURCE_LIST_MEMBERS.ITEM_CATEGORY_ID
PJM_DEFAULT_TASKS	MTL_CATEGORIES_B	PJM_DEFAULT_TASKS.CATEGORY_ID
PON_AUCTION_ITEM_PRICES_ALL	MTL_CATEGORIES_B	PON_AUCTION_ITEM_PRICES_ALL.CATEGORY_ID
PON_AUCTION_TEMPLATES	MTL_CATEGORIES_B	PON_AUCTION_TEMPLATES.CATEGORY_ID
PON_AUC_ITEMS_INTERFACE	MTL_CATEGORIES_B	PON_AUC_ITEMS_INTERFACE.CATEGORY_ID
PO_AGENTS	MTL_CATEGORIES_B	PO_AGENTS.CATEGORY_ID
PO_COMMODITY_CATEGORIES	MTL_CATEGORIES_B	PO_COMMODITY_CATEGORIES.CATEGORY_ID
PO_LINES_ARCHIVE_ALL	MTL_CATEGORIES_B	PO_LINES_ARCHIVE_ALL.CATEGORY_ID
PO_LINES_ALL	MTL_CATEGORIES_B	PO_LINES_ALL.CATEGORY_ID
PO_LINE_TYPES_B	MTL_CATEGORIES_B	PO_LINE_TYPES_B.CATEGORY_ID
PO_REQEXPRESS_LINES_ALL	MTL_CATEGORIES_B	PO_REQEXPRESS_LINES_ALL.CATEGORY_ID
PO_REQUISITIONS_INTERFACE_ALL	MTL_CATEGORIES_B	PO_REQUISITIONS_INTERFACE_ALL.CATEGORY_ID
PO_REQUISITION_LINES_ALL	MTL_CATEGORIES_B	PO_REQUISITION_LINES_ALL.CATEGORY_ID
RCV_SHIPMENT_LINES	MTL_CATEGORIES_B	RCV_SHIPMENT_LINES.CATEGORY_ID