VIEW: APPS.MSC_FLP_OP_ATP_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

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