View: GMP_SCHEDULING_EXCEPTIONS_V

Product:	GMP - Process Manufacturing Process Planning
Description:
Implementation/DBA Data:	APPS.GMP_SCHEDULING_EXCEPTIONS_V

View Text

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

Columns