View: GMP_RESOURCE_AVAIL_V

Product:	GMP - Process Manufacturing Process Planning
Description:	Resource Availability view
Implementation/DBA Data:	APPS.GMP_RESOURCE_AVAIL_V

View Text

SELECT DISTINCT A.ORGANIZATION_ID
, A.CALENDAR_CODE
, A.RESOURCE_ID
, A.RESOURCE_INSTANCE_ID
FROM GMP_RESOURCE_AVAIL A
, CR_RSRC_DTL B
WHERE B.RESOURCE_ID = A.RESOURCE_ID
AND DECODE(B.SCHEDULE_IND
, 2
, A.RESOURCE_INSTANCE_ID
, DECODE(A.RESOURCE_INSTANCE_ID
, 0
, 0
, -1)) <> -1

Columns