VIEW: APPS.GMP_RESOURCE_AVAIL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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