eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MSC_AVAIL_RESOURCE_SUMMARY_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_AVAIL_RESOURCE_SUMMARY_V

View Text

SELECT RES.ROWID
, RES.TRANSACTION_ID
, RES.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(RES.ORGANIZATION_ID
, RES.SR_INSTANCE_ID)
, RES.PLAN_ID
, RES.DEPARTMENT_ID
, DEP.DEPARTMENT_CODE
, RES.RESOURCE_ID
, DEP.RESOURCE_CODE
, RES.SHIFT_DATE
, BUCKET.BKT_END_DATE
, RES.CAPACITY_UNITS
, DECODE(RES.RESOURCE_ID
, -1
, NULL
, FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE'))
, 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
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, DEP.LINE_FLAG
FROM MSC_PLAN_BUCKETS BUCKET
, MSC_NET_RESOURCE_AVAIL RES
, MSC_DEPARTMENT_RESOURCES DEP
WHERE RES.PARENT_ID =-1
AND RES.SIMULATION_SET IS NULL
AND BUCKET.PLAN_ID = RES.PLAN_ID
AND TO_CHAR(BUCKET.BKT_START_DATE
, 'J') = TO_CHAR(RES.SHIFT_DATE
, 'J')
AND RES.CAPACITY_UNITS > 0
AND RES.PLAN_ID <> -1
AND RES.PLAN_ID = DEP.PLAN_ID
AND RES.ORGANIZATION_ID = DEP.ORGANIZATION_ID
AND RES.SR_INSTANCE_ID = DEP.SR_INSTANCE_ID
AND RES.DEPARTMENT_ID = DEP.DEPARTMENT_ID
AND RES.RESOURCE_ID = DEP.RESOURCE_ID UNION ALL SELECT RES.ROWID
, RES.TRANSACTION_ID
, RES.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(RES.ORGANIZATION_ID
, RES.SR_INSTANCE_ID)
, RES.PLAN_ID
, RES.DEPARTMENT_ID
, DEP.DEPARTMENT_CODE
, RES.RESOURCE_ID
, DEP.RESOURCE_CODE
, RES.SHIFT_DATE
, RES.SHIFT_DATE
, RES.CAPACITY_UNITS*(RES.TO_TIME-RES.FROM_TIME)/3600
, DECODE(RES.RESOURCE_ID
, -1
, NULL
, FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE'))
, 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
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, DEP.LINE_FLAG
FROM MSC_NET_RESOURCE_AVAIL RES
, MSC_DEPARTMENT_RESOURCES DEP
WHERE RES.SIMULATION_SET IS NULL
AND RES.PLAN_ID =-1
AND RES.FROM_TIME < RES.TO_TIME
AND RES.PLAN_ID = DEP.PLAN_ID
AND RES.ORGANIZATION_ID = DEP.ORGANIZATION_ID
AND RES.SR_INSTANCE_ID = DEP.SR_INSTANCE_ID
AND RES.DEPARTMENT_ID = DEP.DEPARTMENT_ID
AND RES.RESOURCE_ID = DEP.RESOURCE_ID UNION ALL SELECT RES.ROWID
, RES.TRANSACTION_ID
, RES.ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(RES.ORGANIZATION_ID
, RES.SR_INSTANCE_ID)
, RES.PLAN_ID
, RES.DEPARTMENT_ID
, DEP.DEPARTMENT_CODE
, RES.RESOURCE_ID
, DEP.RESOURCE_CODE
, RES.SHIFT_DATE
, RES.SHIFT_DATE
, RES.CAPACITY_UNITS*(RES.TO_TIME+86400-RES.FROM_TIME)/3600
, DECODE(RES.RESOURCE_ID
, -1
, NULL
, FND_PROFILE.VALUE('BOM:HOUR_UOM_CODE'))
, 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
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, DEP.LINE_FLAG
FROM MSC_NET_RESOURCE_AVAIL RES
, MSC_DEPARTMENT_RESOURCES DEP
WHERE RES.SIMULATION_SET IS NULL
AND RES.PLAN_ID =-1
AND RES.TO_TIME < RES.FROM_TIME
AND RES.PLAN_ID = DEP.PLAN_ID
AND RES.ORGANIZATION_ID = DEP.ORGANIZATION_ID
AND RES.SR_INSTANCE_ID = DEP.SR_INSTANCE_ID
AND RES.DEPARTMENT_ID = DEP.DEPARTMENT_ID
AND RES.RESOURCE_ID = DEP.RESOURCE_ID UNION ALL SELECT SM.ROWID
, SM.TRANSACTION_ID
, SM.TO_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(SM.TO_ORGANIZATION_ID
, SM.SR_INSTANCE_ID)
, SM.PLAN_ID
, SM.FROM_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(SM.FROM_ORGANIZATION_ID
, SM.SR_INSTANCE_ID)
, SM.TRANSACTION_ID
, SM.SHIP_METHOD
, TO_DATE(NULL)
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, SM.LAST_UPDATE_DATE
, SM.LAST_UPDATED_BY
, SM.CREATION_DATE
, SM.CREATED_BY
, SM.LAST_UPDATE_LOGIN
, SM.ATTRIBUTE_CATEGORY
, SM.ATTRIBUTE1
, SM.ATTRIBUTE2
, SM.ATTRIBUTE3
, SM.ATTRIBUTE4
, SM.ATTRIBUTE5
, SM.ATTRIBUTE6
, SM.ATTRIBUTE7
, SM.ATTRIBUTE8
, SM.ATTRIBUTE9
, SM.ATTRIBUTE10
, SM.ATTRIBUTE11
, SM.ATTRIBUTE12
, SM.ATTRIBUTE13
, SM.ATTRIBUTE14
, SM.ATTRIBUTE15
, SM.SR_INSTANCE_ID
, SM.WEIGHT_CAPACITY
, SM.WEIGHT_UOM
, SM.VOLUME_CAPACITY
, SM.VOLUME_UOM
, TO_NUMBER(NULL)
FROM MSC_INTERORG_SHIP_METHODS SM

Columns

Name
ROW_ID
TRANSACTION_ID
ORGANIZATION_ID
ORGANIZATION_CODE
PLAN_ID
DEPARTMENT_ID
DEPT_LINE_CODE
RESOURCE_ID
RESOURCE_CODE
RESOURCE_START_DATE
RESOURCE_END_DATE
TOTAL_AVAILABILITY
UOM
MAX_RATE
UPDATED
STATUS
APPLIED
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
SR_INSTANCE_ID
WEIGHT_CAPACITY
WEIGHT_UOM
VOLUME_CAPACITY
VOLUME_UOM
LINE_FLAG