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_ALTERNATE_RESOURCES_V

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

View Text

SELECT MOR.PLAN_ID
, MOR.ROUTING_SEQUENCE_ID
, MOR.OPERATION_SEQUENCE_ID
, MOR.SR_INSTANCE_ID
, MOR.RESOURCE_SEQ_NUM
, DEPT.DEPARTMENT_ID
, DEPT.DEPARTMENT_CODE
, MOR.RESOURCE_ID
, DEPT.RESOURCE_CODE
, MOR.ALTERNATE_NUMBER
, MOR.PRINCIPAL_FLAG
, MOR.BASIS_TYPE
, MOR.RESOURCE_USAGE
, MOR.MAX_RESOURCE_UNITS
, MOR.RESOURCE_UNITS
, MOR.UOM_CODE
, MOR.LAST_UPDATE_DATE
, MOR.LAST_UPDATED_BY
, MOR.CREATION_DATE
, MOR.CREATED_BY
, MOR.LAST_UPDATE_LOGIN
FROM MSC_DEPARTMENT_RESOURCES DEPT
, MSC_OPERATION_RESOURCE_SEQS MORS
, MSC_OPERATION_RESOURCES MOR
WHERE DEPT.DEPARTMENT_ID(+) = MORS.DEPARTMENT_ID
AND DEPT.RESOURCE_ID = MOR.RESOURCE_ID
AND DEPT.PLAN_ID = MOR.PLAN_ID
AND DEPT.SR_INSTANCE_ID = MOR.SR_INSTANCE_ID
AND MORS.PLAN_ID = MOR.PLAN_ID
AND MORS.ROUTING_SEQUENCE_ID = MOR.ROUTING_SEQUENCE_ID
AND MORS.OPERATION_SEQUENCE_ID = MOR.OPERATION_SEQUENCE_ID
AND MORS.RESOURCE_SEQ_NUM = MOR.RESOURCE_SEQ_NUM
AND MORS.SR_INSTANCE_ID = MOR.SR_INSTANCE_ID

Columns

Name
PLAN_ID
ROUTING_SEQUENCE_ID
OPERATION_SEQUENCE_ID
SR_INSTANCE_ID
RESOURCE_SEQ_NUM
DEPARTMENT_ID
DEPARTMENT_CODE
RESOURCE_ID
RESOURCE_CODE
ALTERNATE_NUMBER
PRINCIPAL_FLAG
BASIS_TYPE
RESOURCE_USAGE
MAX_RESOURCE_UNITS
RESOURCE_UNITS
UOM_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN