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: APPS.MSC_ITEM_EXCEPTION_V2

Source

View Text - Preformatted


SELECT mie.EXCEPTION_TYPE, mie.exception_group, 2, mie.plan_id , mie.ORGANIZATION_ID , mie.sr_instance_id , mie.PROJECT_ID , mie.TASK_ID , mie.VERSION , mie.EXCEPTION_COUNT, mie.INVENTORY_ITEM_ID , mie.PLANNING_GROUP, mie.DEPARTMENT_ID , mie.RESOURCE_ID, mie.DISPLAY , rowidtochar(mie.rowid) , mie.supplier_id , mie.supplier_site_id, to_date(null), mic.category_set_id, mic.sr_category_id, mic.category_name, NVL(msi.product_family_id,msi.base_item_id), nvl(mie.new_exception_count, mie.exception_count) FROM msc_item_exceptions mie, msc_system_items msi, msc_item_categories mic WHERE NVL(mie.DISPLAY,1)=1 and mie.INVENTORY_ITEM_ID = mic.INVENTORY_ITEM_ID AND mie.sr_instance_id = mic.sr_instance_id AND mie.ORGANIZATION_ID = mic.ORGANIZATION_ID AND mie.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID AND mie.sr_instance_id = msi.sr_instance_id AND mie.ORGANIZATION_ID = msi.ORGANIZATION_ID AND mie.plan_id = msi.plan_id AND mie.inventory_item_id <> -1 UNION ALL select mie.EXCEPTION_TYPE, mie.exception_group, 2, mie.plan_id , mie.ORGANIZATION_ID , mie.sr_instance_id , mie.PROJECT_ID , mie.TASK_ID , mie.VERSION , mie.EXCEPTION_COUNT, mie.INVENTORY_ITEM_ID , mie.PLANNING_GROUP, mie.DEPARTMENT_ID , mie.RESOURCE_ID, mie.DISPLAY , rowidtochar(mie.rowid) , mie.supplier_id , mie.supplier_site_id, to_date(null), to_number(null), to_number(null), null, to_number(null), nvl(mie.new_exception_count, mie.exception_count) FROM msc_item_exceptions mie WHERE NVL(mie.DISPLAY,1)=1 and mie.INVENTORY_ITEM_ID = -1 UNION ALL SELECT /*+ FIRST_ROWS */ msc_get_name.implement_as(s.order_type, s.organization_id,s.source_organization_id,s.source_supplier_id,i.build_in_wip_flag,i.planning_make_buy_code,i.purchasing_enabled_flag,s.cfm_routing_flag), 10, 2, s.plan_id, s.ORGANIZATION_ID, s.sr_instance_id, s.project_id, s.task_id, to_number(NULL), 1, s.inventory_item_id, s.planning_group, to_number(null), to_number(null), 1, null, s.source_supplier_id, s.source_supplier_site_id, s.new_order_placement_date, ic.category_set_id, ic.sr_category_id, ic.category_name, NVL(i.product_family_id,i.base_item_id), 1 from msc_system_items i, msc_supplies s, msc_item_categories ic where i.inventory_item_id = s.inventory_item_id AND i.plan_id = s.plan_id AND i.sr_instance_id = s.sr_instance_id AND i.organization_id = s.organization_id AND i.inventory_item_id = ic.inventory_item_id AND i.sr_instance_id = ic.sr_instance_id AND i.organization_id = ic.organization_id AND ((order_type = 13) OR (order_type = 5 AND nvl(s.implemented_quantity,0)+nvl(s.quantity_in_process,0) < nvl(s.firm_quantity,s.new_order_quantity) and (nvl(i.lots_exist,0) <> 2 or s.new_order_quantity =0) AND (((s.source_organization_id <> s.organization_id OR s.source_sr_instance_id <> s.sr_instance_id OR s.source_supplier_id IS NOT NULL) AND i.purchasing_enabled_flag = 1) OR (s.source_organization_id IS NULL AND s.source_supplier_id IS NULL AND i.planning_make_buy_code = 2 AND i.purchasing_enabled_flag = 1) OR (s.source_organization_id = s.organization_id AND s.source_sr_instance_id =s.sr_instance_id AND i.build_in_wip_flag = 1) OR (s.source_organization_id IS NULL AND s.source_supplier_id IS NULL AND i.planning_make_buy_code = 1 AND i.build_in_wip_flag = 1))))

View Text - HTML Formatted

SELECT MIE.EXCEPTION_TYPE
, MIE.EXCEPTION_GROUP
, 2
, MIE.PLAN_ID
, MIE.ORGANIZATION_ID
, MIE.SR_INSTANCE_ID
, MIE.PROJECT_ID
, MIE.TASK_ID
, MIE.VERSION
, MIE.EXCEPTION_COUNT
, MIE.INVENTORY_ITEM_ID
, MIE.PLANNING_GROUP
, MIE.DEPARTMENT_ID
, MIE.RESOURCE_ID
, MIE.DISPLAY
, ROWIDTOCHAR(MIE.ROWID)
, MIE.SUPPLIER_ID
, MIE.SUPPLIER_SITE_ID
, TO_DATE(NULL)
, MIC.CATEGORY_SET_ID
, MIC.SR_CATEGORY_ID
, MIC.CATEGORY_NAME
, NVL(MSI.PRODUCT_FAMILY_ID
, MSI.BASE_ITEM_ID)
, NVL(MIE.NEW_EXCEPTION_COUNT
, MIE.EXCEPTION_COUNT)
FROM MSC_ITEM_EXCEPTIONS MIE
, MSC_SYSTEM_ITEMS MSI
, MSC_ITEM_CATEGORIES MIC
WHERE NVL(MIE.DISPLAY
, 1)=1
AND MIE.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID
AND MIE.SR_INSTANCE_ID = MIC.SR_INSTANCE_ID
AND MIE.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MIE.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MIE.SR_INSTANCE_ID = MSI.SR_INSTANCE_ID
AND MIE.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MIE.PLAN_ID = MSI.PLAN_ID
AND MIE.INVENTORY_ITEM_ID <> -1 UNION ALL SELECT MIE.EXCEPTION_TYPE
, MIE.EXCEPTION_GROUP
, 2
, MIE.PLAN_ID
, MIE.ORGANIZATION_ID
, MIE.SR_INSTANCE_ID
, MIE.PROJECT_ID
, MIE.TASK_ID
, MIE.VERSION
, MIE.EXCEPTION_COUNT
, MIE.INVENTORY_ITEM_ID
, MIE.PLANNING_GROUP
, MIE.DEPARTMENT_ID
, MIE.RESOURCE_ID
, MIE.DISPLAY
, ROWIDTOCHAR(MIE.ROWID)
, MIE.SUPPLIER_ID
, MIE.SUPPLIER_SITE_ID
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NVL(MIE.NEW_EXCEPTION_COUNT
, MIE.EXCEPTION_COUNT)
FROM MSC_ITEM_EXCEPTIONS MIE
WHERE NVL(MIE.DISPLAY
, 1)=1
AND MIE.INVENTORY_ITEM_ID = -1 UNION ALL SELECT /*+ FIRST_ROWS */ MSC_GET_NAME.IMPLEMENT_AS(S.ORDER_TYPE
, S.ORGANIZATION_ID
, S.SOURCE_ORGANIZATION_ID
, S.SOURCE_SUPPLIER_ID
, I.BUILD_IN_WIP_FLAG
, I.PLANNING_MAKE_BUY_CODE
, I.PURCHASING_ENABLED_FLAG
, S.CFM_ROUTING_FLAG)
, 10
, 2
, S.PLAN_ID
, S.ORGANIZATION_ID
, S.SR_INSTANCE_ID
, S.PROJECT_ID
, S.TASK_ID
, TO_NUMBER(NULL)
, 1
, S.INVENTORY_ITEM_ID
, S.PLANNING_GROUP
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 1
, NULL
, S.SOURCE_SUPPLIER_ID
, S.SOURCE_SUPPLIER_SITE_ID
, S.NEW_ORDER_PLACEMENT_DATE
, IC.CATEGORY_SET_ID
, IC.SR_CATEGORY_ID
, IC.CATEGORY_NAME
, NVL(I.PRODUCT_FAMILY_ID
, I.BASE_ITEM_ID)
, 1
FROM MSC_SYSTEM_ITEMS I
, MSC_SUPPLIES S
, MSC_ITEM_CATEGORIES IC
WHERE I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND I.PLAN_ID = S.PLAN_ID
AND I.SR_INSTANCE_ID = S.SR_INSTANCE_ID
AND I.ORGANIZATION_ID = S.ORGANIZATION_ID
AND I.INVENTORY_ITEM_ID = IC.INVENTORY_ITEM_ID
AND I.SR_INSTANCE_ID = IC.SR_INSTANCE_ID
AND I.ORGANIZATION_ID = IC.ORGANIZATION_ID
AND ((ORDER_TYPE = 13) OR (ORDER_TYPE = 5
AND NVL(S.IMPLEMENTED_QUANTITY
, 0)+NVL(S.QUANTITY_IN_PROCESS
, 0) < NVL(S.FIRM_QUANTITY
, S.NEW_ORDER_QUANTITY)
AND (NVL(I.LOTS_EXIST
, 0) <> 2 OR S.NEW_ORDER_QUANTITY =0)
AND (((S.SOURCE_ORGANIZATION_ID <> S.ORGANIZATION_ID OR S.SOURCE_SR_INSTANCE_ID <> S.SR_INSTANCE_ID OR S.SOURCE_SUPPLIER_ID IS NOT NULL)
AND I.PURCHASING_ENABLED_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID IS NULL
AND S.SOURCE_SUPPLIER_ID IS NULL
AND I.PLANNING_MAKE_BUY_CODE = 2
AND I.PURCHASING_ENABLED_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID = S.ORGANIZATION_ID
AND S.SOURCE_SR_INSTANCE_ID =S.SR_INSTANCE_ID
AND I.BUILD_IN_WIP_FLAG = 1) OR (S.SOURCE_ORGANIZATION_ID IS NULL
AND S.SOURCE_SUPPLIER_ID IS NULL
AND I.PLANNING_MAKE_BUY_CODE = 1
AND I.BUILD_IN_WIP_FLAG = 1))))