View: MSC_FLP_OP_ATP_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_FLP_OP_ATP_V

View Text

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

Columns