[Home] [Help]
View: AHL_RT_OPER_DEPENDENCIES_V
View Text
SELECT OD.RT_OP_DEPENDENCY_ID
, OD.OBJECT_VERSION_NUMBER
, OD.LAST_UPDATE_DATE
, OD.LAST_UPDATED_BY
, OD.CREATION_DATE
, OD.CREATED_BY
, OD.LAST_UPDATE_LOGIN
, OD.FROM_RT_OP_ID
, OD.FROM_OP_STEP
, OPF.CONCATENATED_SEGMENTS
, OD.DEPENDENCY_CODE
, FDT.MEANING
, OD.TO_RT_OP_ID
, OD.TO_OP_STEP
, OPT.CONCATENATED_SEGMENTS
, ROF.ROUTE_ID
, OD.SECURITY_GROUP_ID
, OD.ATTRIBUTE_CATEGORY
, OD.ATTRIBUTE1
, OD.ATTRIBUTE2
, OD.ATTRIBUTE3
, OD.ATTRIBUTE4
, OD.ATTRIBUTE5
, OD.ATTRIBUTE6
, OD.ATTRIBUTE7
, OD.ATTRIBUTE8
, OD.ATTRIBUTE9
, OD.ATTRIBUTE10
, OD.ATTRIBUTE11
, OD.ATTRIBUTE12
, OD.ATTRIBUTE13
, OD.ATTRIBUTE14
, OD.ATTRIBUTE15
FROM AHL_OPERATIONS_VL OPF
, AHL_OPERATIONS_VL OPT
, AHL_ROUTE_OPERATIONS ROF
, AHL_ROUTE_OPERATIONS ROT
, AHL_RT_OPER_DEPENDENCIES OD
, FND_LOOKUP_VALUES_VL FDT
WHERE
OPF.OPERATION_ID = ROF.OPERATION_ID
AND OPT.OPERATION_ID = ROT.OPERATION_ID
AND ROF.ROUTE_OPERATION_ID = OD.FROM_RT_OP_ID
AND ROT.ROUTE_OPERATION_ID = OD.TO_RT_OP_ID
AND FDT.LOOKUP_TYPE = 'AHL_OPER_DEP_TYPE'
AND FDT.LOOKUP_CODE (+) = OD.DEPENDENCY_CODE
AND TRUNC(NVL(OPF.END_DATE_ACTIVE
, SYSDATE + 1)) > TRUNC(SYSDATE)
AND TRUNC(NVL(OPT.END_DATE_ACTIVE
, SYSDATE + 1)) > TRUNC(SYSDATE)