Product: | IPA - Capital Resource Logistics - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IPA_TASK_INTERESTS_V |
SELECT ITI.ROWID ROW_ID
, ITI.TASK_INTEREST_ID TASK_INTEREST_ID
, ITI.RATE_CODE RATE_CODE
, ITI.TASK_ID TASK_ID
, PAT.TASK_NUMBER TASK_NUMBER
, PAT.TASK_NAME TASK_NAME
, ITI.PROJECT_ID PROJECT_ID
, PAP.SEGMENT1 PROJECT_NUMBER
, ITI.CAPITALIZE_INTEREST CAPITALIZE_INTEREST
, ITI.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, ITI.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, ITI.TASK_THRESHOLD TASK_THRESHOLD
, ITI.COMMENTS COMMENTS
, ITI.CREATED_BY CREATED_BY
, ITI.CREATION_DATE CREATION_DATE
, ITI.LAST_UPDATED_BY LAST_UPDATED_BY
, ITI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ITI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IPA_TASK_INTERESTS ITI
, PA_PROJECTS_ALL PAP
, PA_TASKS PAT
WHERE PAT.PROJECT_ID = PAP.PROJECT_ID
AND ITI.TASK_ID = PAT.TASK_ID