Product: | JTF - CRM Foundation |
---|---|
Description: | Internal View between Dependency Table and JTF_TASKS_B |
Implementation/DBA Data: | APPS.JTF_TASK_DEPENDS_V |
SELECT JTD.ROWID ROW_ID
, JTD.DEPENDENCY_ID
, JTD.TASK_ID
, JTD.DEPENDENT_ON_TASK_ID
, JTA.TASK_NUMBER DEPENDENT_ON_TASK_NUMBER
, JTA.TASK_NAME DEPENDENT_ON_TASK_NAME
, JTD.DEPENDENCY_TYPE_CODE
, JTD.ADJUSTMENT_TIME
, JTD.ADJUSTMENT_TIME_UOM
, JTD.TEMPLATE_FLAG
, JTD.CREATED_BY
, JTD.CREATION_DATE
, JTD.LAST_UPDATED_BY
, JTD.LAST_UPDATE_DATE
, JTD.LAST_UPDATE_LOGIN
, JTD.ATTRIBUTE1
, JTD.ATTRIBUTE2
, JTD.ATTRIBUTE3
, JTD.ATTRIBUTE4
, JTD.ATTRIBUTE5
, JTD.ATTRIBUTE6
, JTD.ATTRIBUTE7
, JTD.ATTRIBUTE8
, JTD.ATTRIBUTE9
, JTD.ATTRIBUTE10
, JTD.ATTRIBUTE11
, JTD.ATTRIBUTE12
, JTD.ATTRIBUTE13
, JTD.ATTRIBUTE14
, JTD.ATTRIBUTE15
, JTD.ATTRIBUTE_CATEGORY
, JTD.OBJECT_VERSION_NUMBER
, JTD.VALIDATED_FLAG
FROM JTF_TASK_DEPENDS JTD
, JTF_TASKS_VL JTA
WHERE JTD.DEPENDENT_ON_TASK_ID = JTA.TASK_ID
AND (JTD.TEMPLATE_FLAG != 'Y' OR JTD.TEMPLATE_FLAG IS NULL)