Product: | IPA - Capital Resource Logistics - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IPA_PROJECT_INTERESTS_V |
SELECT IPI.ROWID ROW_ID
, IPI.PROJECT_INTEREST_ID PROJECT_INTEREST_ID
, IPI.RATE_CODE RATE_CODE
, IPI.PROJECT_ID PROJECT_ID
, PAP.SEGMENT1 PROJECT_NUMBER
, PAP.NAME PROJECT_NAME
, IPI.CAPITALIZE_INTEREST CAPITALIZE_INTEREST
, IPI.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, IPI.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, IPI.THRESHOLD_AMOUNT THRESHOLD_AMOUNT
, IPI.COMMENTS COMMENTS
, IPI.CREATED_BY CREATED_BY
, IPI.CREATION_DATE CREATION_DATE
, IPI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, IPI.LAST_UPDATED_BY LAST_UPDATED_BY
, IPI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM PA_PROJECTS_ALL PAP
, IPA_PROJECT_INTERESTS IPI
WHERE IPI.PROJECT_ID = PAP.PROJECT_ID