View: GMP_RSRC_UNAVAIL_DTL_V

Product:	GMP - Process Manufacturing Process Planning
Description:	Resource Unavailable Detail view
Implementation/DBA Data:	APPS.GMP_RSRC_UNAVAIL_DTL_V

View Text

SELECT H.EXCEPTION_ID
, H.EXCEPTION_CODE
, A.RESOURCE_ID
, A.INSTANCE_ID
, A.RESOURCE_UNITS
, D.FROM_DATE
, D.TO_DATE
, TO_NUMBER(NULL) WIP_ENTITY_ID
, TO_NUMBER(NULL) OP_SEQ
, TO_NUMBER(NULL) MAINT_ORG_ID
, D.REASON_CODE
, MTR.DESCRIPTION
FROM GMP_RSRC_EXCP_ASNMT A
, GMP_RSRC_EXCP_DTL D
, GMP_RSRC_EXCP_HDR H
, MTL_TRANSACTION_REASONS MTR
WHERE H.EXCEPTION_ID = D.EXCEPTION_ID
AND D.EXCEPTION_ID = A.EXCEPTION_ID
AND MTR.REASON_NAME = D.REASON_CODE
AND H.INACTIVE_IND = 0 UNION SELECT 0
, NULL
, GRU.RESOURCE_ID
, GRU.INSTANCE_ID
, GRU.RESOURCE_UNITS
, GRU.FROM_DATE
, GRU.TO_DATE
, GRU.WIP_ENTITY_ID
, GRU.OP_SEQ
, GRU.MAINT_ORG_ID
, GRU.REASON_CODE
, MTR.DESCRIPTION
FROM GMP_RSRC_UNAVAIL_MAN GRU
, MTL_TRANSACTION_REASONS MTR
WHERE MTR.REASON_NAME = GRU.REASON_CODE

Columns