Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_AVAIL_RESOURCE_DETAIL_V |
SELECT RES.ROWID
, RES.PARENT_ID
, RES.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(RES.ORGANIZATION_ID
, RES.SR_INSTANCE_ID)
, RES.PLAN_ID
, RES.DEPARTMENT_ID
, MSC_GET_NAME.DEPARTMENT_CODE(DECODE(RES.RESOURCE_ID
, -1
, 1
, 2)
, RES.DEPARTMENT_ID
, RES.ORGANIZATION_ID
, RES.PLAN_ID
, RES.SR_INSTANCE_ID)
, RES.RESOURCE_ID
, MSC_GET_NAME.RESOURCE_CODE(RES.RESOURCE_ID
, RES.DEPARTMENT_ID
, RES.ORGANIZATION_ID
, RES.PLAN_ID
, RES.SR_INSTANCE_ID)
, RES.SHIFT_DATE
, RES.SHIFT_NUM
, TO_CHAR(RES.SHIFT_DATE+(RES.FROM_TIME/86400.0)
, 'HH24:MI:SS')
, TO_CHAR(RES.SHIFT_DATE+(RES.TO_TIME/86400.0)
, 'HH24:MI:SS')
, DECODE(RES.RESOURCE_ID
, -1
, TO_NUMBER(NULL)
, RES.CAPACITY_UNITS)
, DECODE(RES.RESOURCE_ID
, -1
, RES.CAPACITY_UNITS
, TO_NUMBER(NULL))
, RES.UPDATED
, RES.STATUS
, RES.APPLIED
, RES.LAST_UPDATE_DATE
, RES.LAST_UPDATED_BY
, RES.CREATION_DATE
, RES.CREATED_BY
, RES.LAST_UPDATE_LOGIN
, RES.ATTRIBUTE_CATEGORY
, RES.ATTRIBUTE1
, RES.ATTRIBUTE2
, RES.ATTRIBUTE3
, RES.ATTRIBUTE4
, RES.ATTRIBUTE5
, RES.ATTRIBUTE6
, RES.ATTRIBUTE7
, RES.ATTRIBUTE8
, RES.ATTRIBUTE9
, RES.ATTRIBUTE10
, RES.ATTRIBUTE11
, RES.ATTRIBUTE12
, RES.ATTRIBUTE13
, RES.ATTRIBUTE14
, RES.ATTRIBUTE15
, RES.SR_INSTANCE_ID
, RES.TRANSACTION_ID
, RES.FROM_TIME
, RES.TO_TIME
, RES.CAPACITY_UNITS
FROM MSC_NET_RESOURCE_AVAIL RES
WHERE (RES.PLAN_ID <> -1 OR (RES.PLAN_ID = -1
AND RES.PARENT_ID IS NULL))
AND RES.CAPACITY_UNITS > 0