VIEW: APPS.MSC_ALTERNATE_RESOURCES_V

Source

View Text - Preformatted

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 AND mor.principal_flag <> 2

View Text - HTML Formatted

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
AND MOR.PRINCIPAL_FLAG <> 2