VIEW: APPS.MSC_SETUP_TRANSITION_V

Source

View Text - Preformatted

SELECT mst.rowid, mst.PLAN_ID, mst.SR_INSTANCE_ID, mst.RESOURCE_ID, mst.ORGANIZATION_ID, mdr.department_id, mst.FROM_SETUP_ID, mst.TO_SETUP_ID, mdr.DEPARTMENT_CODE, mdr.RESOURCE_CODE, mtp.ORGANIZATION_CODE, mrs1.setup_code setup_type_from, mrs2.setup_code setup_type_to, mst.TRANSITION_TIME, mst.TRANSITION_UOM, mst.TRANSITION_PENALTY, msc_get_name.operation_code(mst.plan_id,mst.sr_instance_id,mst.standard_operation_id), mst.RING_SEQUENCE_NUMBER, mst.ORIG_TRANSITION_TIME from msc_setup_transitions mst, msc_department_resources mdr, msc_resource_setups mrs1, msc_resource_setups mrs2, msc_trading_partners mtp WHERE mdr.plan_id = mst.plan_id and mdr.sr_instance_id = mst.sr_instance_id and mdr.resource_id = mst.resource_id and mdr.organization_id = mst.organization_id and mtp.sr_tp_id = mst.organization_id and mtp.sr_instance_id = mst.sr_instance_id and mtp.partner_type=3 and mrs1.plan_id(+) = mst.plan_id and mrs1.sr_instance_id(+) = mst.sr_instance_id and mrs1.resource_id(+) = mst.resource_id and mrs1.organization_id(+) = mst.organization_id and mrs1.setup_id(+) = mst.from_setup_id and mrs2.plan_id(+) = mst.plan_id and mrs2.sr_instance_id(+) = mst.sr_instance_id and mrs2.resource_id(+) = mst.resource_id and mrs2.organization_id(+) = mst.organization_id and mrs2.setup_id(+) = mst.to_setup_id

View Text - HTML Formatted

SELECT MST.ROWID
, MST.PLAN_ID
, MST.SR_INSTANCE_ID
, MST.RESOURCE_ID
, MST.ORGANIZATION_ID
, MDR.DEPARTMENT_ID
, MST.FROM_SETUP_ID
, MST.TO_SETUP_ID
, MDR.DEPARTMENT_CODE
, MDR.RESOURCE_CODE
, MTP.ORGANIZATION_CODE
, MRS1.SETUP_CODE SETUP_TYPE_FROM
, MRS2.SETUP_CODE SETUP_TYPE_TO
, MST.TRANSITION_TIME
, MST.TRANSITION_UOM
, MST.TRANSITION_PENALTY
, MSC_GET_NAME.OPERATION_CODE(MST.PLAN_ID
, MST.SR_INSTANCE_ID
, MST.STANDARD_OPERATION_ID)
, MST.RING_SEQUENCE_NUMBER
, MST.ORIG_TRANSITION_TIME
FROM MSC_SETUP_TRANSITIONS MST
, MSC_DEPARTMENT_RESOURCES MDR
, MSC_RESOURCE_SETUPS MRS1
, MSC_RESOURCE_SETUPS MRS2
, MSC_TRADING_PARTNERS MTP
WHERE MDR.PLAN_ID = MST.PLAN_ID
AND MDR.SR_INSTANCE_ID = MST.SR_INSTANCE_ID
AND MDR.RESOURCE_ID = MST.RESOURCE_ID
AND MDR.ORGANIZATION_ID = MST.ORGANIZATION_ID
AND MTP.SR_TP_ID = MST.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID = MST.SR_INSTANCE_ID
AND MTP.PARTNER_TYPE=3
AND MRS1.PLAN_ID(+) = MST.PLAN_ID
AND MRS1.SR_INSTANCE_ID(+) = MST.SR_INSTANCE_ID
AND MRS1.RESOURCE_ID(+) = MST.RESOURCE_ID
AND MRS1.ORGANIZATION_ID(+) = MST.ORGANIZATION_ID
AND MRS1.SETUP_ID(+) = MST.FROM_SETUP_ID
AND MRS2.PLAN_ID(+) = MST.PLAN_ID
AND MRS2.SR_INSTANCE_ID(+) = MST.SR_INSTANCE_ID
AND MRS2.RESOURCE_ID(+) = MST.RESOURCE_ID
AND MRS2.ORGANIZATION_ID(+) = MST.ORGANIZATION_ID
AND MRS2.SETUP_ID(+) = MST.TO_SETUP_ID