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 REQ.ROUTING_SEQUENCE_ID= ROUT.ROUTING_SEQUENCE_ID AND REQ.PLAN_ID = OP.PLAN_ID AND REQ.SR_INSTANCE_ID = OP.SR_INSTANCE_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, to_char(null), 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 REQ.ROUTING_SEQUENCE_ID= ROUT.ROUTING_SEQUENCE_ID
AND REQ.PLAN_ID = OP.PLAN_ID
AND REQ.SR_INSTANCE_ID = OP.SR_INSTANCE_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
, TO_CHAR(NULL)
, 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