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.GMP_SCHEDULING_EXCEPTIONS_V

Source

View Text - Preformatted


SELECT gbh.batch_no job_name, mp.organization_code, msi.concatenated_segments assembly, msi.description assembly_desc, msi.inventory_item_id primary_item_id, wse.scheduling_source, wse.scheduling_source_id, wse.mesg_sequence, wse.message_type, wse.reported_date, gbh.batch_status, gbh.plan_start_date planned_start, gbh.plan_cmplt_date planned_completion, gbh.due_date required_completion, gbh.priority_value scheduling_priority, wse.wip_entity_id, msi.organization_id, gbh.recipe_validity_rule_id, gbh.routing_id, gbh.formula_id FROM wip_scheduling_exceptions wse, gme_batch_header gbh, gmd_recipe_validity_rules grvr, mtl_system_items_kfv msi, mtl_parameters mp WHERE wse.wip_entity_id = gbh.batch_id AND gbh.delete_mark = 0 AND mp.organization_id = gbh.organization_id AND mp.process_enabled_flag = 'Y' AND msi.organization_id = gbh.organization_id AND grvr.recipe_validity_rule_id = gbh.recipe_validity_rule_id AND msi.inventory_item_id = grvr.inventory_item_id

View Text - HTML Formatted

SELECT GBH.BATCH_NO JOB_NAME
, MP.ORGANIZATION_CODE
, MSI.CONCATENATED_SEGMENTS ASSEMBLY
, MSI.DESCRIPTION ASSEMBLY_DESC
, MSI.INVENTORY_ITEM_ID PRIMARY_ITEM_ID
, WSE.SCHEDULING_SOURCE
, WSE.SCHEDULING_SOURCE_ID
, WSE.MESG_SEQUENCE
, WSE.MESSAGE_TYPE
, WSE.REPORTED_DATE
, GBH.BATCH_STATUS
, GBH.PLAN_START_DATE PLANNED_START
, GBH.PLAN_CMPLT_DATE PLANNED_COMPLETION
, GBH.DUE_DATE REQUIRED_COMPLETION
, GBH.PRIORITY_VALUE SCHEDULING_PRIORITY
, WSE.WIP_ENTITY_ID
, MSI.ORGANIZATION_ID
, GBH.RECIPE_VALIDITY_RULE_ID
, GBH.ROUTING_ID
, GBH.FORMULA_ID
FROM WIP_SCHEDULING_EXCEPTIONS WSE
, GME_BATCH_HEADER GBH
, GMD_RECIPE_VALIDITY_RULES GRVR
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_PARAMETERS MP
WHERE WSE.WIP_ENTITY_ID = GBH.BATCH_ID
AND GBH.DELETE_MARK = 0
AND MP.ORGANIZATION_ID = GBH.ORGANIZATION_ID
AND MP.PROCESS_ENABLED_FLAG = 'Y'
AND MSI.ORGANIZATION_ID = GBH.ORGANIZATION_ID
AND GRVR.RECIPE_VALIDITY_RULE_ID = GBH.RECIPE_VALIDITY_RULE_ID
AND MSI.INVENTORY_ITEM_ID = GRVR.INVENTORY_ITEM_ID