VIEW: APPS.MSC_FLP_OP_V

Source

View Text - Preformatted

SELECT distinct req.plan_id, req.supply_id, req.sr_instance_id, req.routing_sequence_id, req.operation_sequence_id, rout.alternate_routing_designator, op.operation_seq_num, op.operation_description, req.organization_id FROM msc_resource_requirements req, msc_routings rout, msc_routing_operations op WHERE req.plan_id = rout.plan_id AND req.sr_instance_id = rout.sr_instance_id AND nvl(req.routing_sequence_id,-23453) = decode(nvl(req.routing_sequence_id,-23453), -23453,-23453, rout.routing_sequence_id) AND req.plan_id = op.plan_id AND req.sr_instance_id = op.sr_instance_id AND nvl(req.routing_sequence_id,-23453) = decode(nvl(req.routing_sequence_id,-23453), -23453, -23453, op.routing_sequence_id) AND req.operation_sequence_id = op.operation_sequence_id AND nvl(req.parent_id,2) = 2 UNION select distinct res.plan_id , res.supply_id , res.sr_instance_id , res.routing_sequence_id , nvl(res.operation_sequence_id,res.operation_seq_num), null, res.operation_seq_num , msc_get_name.op_desc(res.plan_id, res.sr_instance_id, res.routing_sequence_id, res.operation_sequence_id), res.organization_id from msc_resource_requirements res , msc_supplies mr where mr.transaction_id = res.supply_id and mr.sr_instance_id = res.sr_instance_id and mr.plan_id = res.plan_id and (res.operation_sequence_id is null or res.routing_sequence_id is null) and not (res.resource_id = -1 or res.department_id = -1) and nvl(res.parent_id,2) = 2

View Text - HTML Formatted

SELECT DISTINCT REQ.PLAN_ID
, REQ.SUPPLY_ID
, REQ.SR_INSTANCE_ID
, REQ.ROUTING_SEQUENCE_ID
, REQ.OPERATION_SEQUENCE_ID
, ROUT.ALTERNATE_ROUTING_DESIGNATOR
, OP.OPERATION_SEQ_NUM
, OP.OPERATION_DESCRIPTION
, REQ.ORGANIZATION_ID
FROM MSC_RESOURCE_REQUIREMENTS REQ
, MSC_ROUTINGS ROUT
, MSC_ROUTING_OPERATIONS OP
WHERE REQ.PLAN_ID = ROUT.PLAN_ID
AND REQ.SR_INSTANCE_ID = ROUT.SR_INSTANCE_ID
AND NVL(REQ.ROUTING_SEQUENCE_ID
, -23453) = DECODE(NVL(REQ.ROUTING_SEQUENCE_ID
, -23453)
, -23453
, -23453
, ROUT.ROUTING_SEQUENCE_ID)
AND REQ.PLAN_ID = OP.PLAN_ID
AND REQ.SR_INSTANCE_ID = OP.SR_INSTANCE_ID
AND NVL(REQ.ROUTING_SEQUENCE_ID
, -23453) = DECODE(NVL(REQ.ROUTING_SEQUENCE_ID
, -23453)
, -23453
, -23453
, OP.ROUTING_SEQUENCE_ID)
AND REQ.OPERATION_SEQUENCE_ID = OP.OPERATION_SEQUENCE_ID
AND NVL(REQ.PARENT_ID
, 2) = 2 UNION SELECT DISTINCT RES.PLAN_ID
, RES.SUPPLY_ID
, RES.SR_INSTANCE_ID
, RES.ROUTING_SEQUENCE_ID
, NVL(RES.OPERATION_SEQUENCE_ID
, RES.OPERATION_SEQ_NUM)
, NULL
, RES.OPERATION_SEQ_NUM
, MSC_GET_NAME.OP_DESC(RES.PLAN_ID
, RES.SR_INSTANCE_ID
, RES.ROUTING_SEQUENCE_ID
, RES.OPERATION_SEQUENCE_ID)
, RES.ORGANIZATION_ID
FROM MSC_RESOURCE_REQUIREMENTS RES
, MSC_SUPPLIES MR
WHERE MR.TRANSACTION_ID = RES.SUPPLY_ID
AND MR.SR_INSTANCE_ID = RES.SR_INSTANCE_ID
AND MR.PLAN_ID = RES.PLAN_ID
AND (RES.OPERATION_SEQUENCE_ID IS NULL OR RES.ROUTING_SEQUENCE_ID IS NULL)
AND NOT (RES.RESOURCE_ID = -1 OR RES.DEPARTMENT_ID = -1)
AND NVL(RES.PARENT_ID
, 2) = 2