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_AP_ITEM_CATEGORIES_V

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT MIC.INVENTORY_ITEM_ID
, MIC.ORGANIZATION_ID
, MIC.CATEGORY_SET_ID
, MIC.CATEGORY_ID
, MCBK.CONCATENATED_SEGMENTS CATEGORY_NAME
, MCT.DESCRIPTION
, MCBK.DISABLE_DATE
, MCBK.SUMMARY_FLAG
, MCBK.ENABLED_FLAG
, MCBK.START_DATE_ACTIVE
, MCBK.END_DATE_ACTIVE
, MCT.LANGUAGE
, MC.RN RN4
, MIC.RN RN3
, MSIK.RN RN2
, MP.RN RN1
FROM MTL_CATEGORIES_TL MCT
, MTL_CATEGORIES_KFV MCBK
, MRP_AP_CATG_SN MC
, MRP_AP_SYS_ITEMS_SN MSIK
, MRP_AP_MRP_PARAS_SN MP
, MRP_AP_ITEM_CATGS_SN MIC
WHERE MCBK.CATEGORY_ID= MIC.CATEGORY_ID
AND MCT.CATEGORY_ID = MIC.CATEGORY_ID
AND MC.CATEGORY_ID= MIC.CATEGORY_ID
AND MIC.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND MIC.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND MIC.ORGANIZATION_ID= MP.ORGANIZATION_ID

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
CATEGORY_SET_ID
CATEGORY_ID
CATEGORY_NAME
DESCRIPTION
DISABLE_DATE
SUMMARY_FLAG
ENABLED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
LANGUAGE
RN4
RN3
RN2
RN1