VIEW: APPS.AHL_RT_OPER_DEPENDENCIES_V

Source

View Text - Preformatted

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)
   

View Text - HTML Formatted

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)