Product: | IPA - Capital Resource Logistics - Projects |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IPA_ORGANIZATION_INTERESTS_V |
SELECT ORGI.ROWID ROW_ID
, ORGI.ORGANIZATION_INTEREST_ID ORGANIZATION_INTEREST_ID
, ORGI.RATE_CODE RATE_CODE
, ORGI.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGI.ORGANIZATION_ID ORGANIZATION_ID
, ORGI.LAST_UPDATED_BY LAST_UPDATED_BY
, ORGI.CREATION_DATE CREATION_DATE
, ORGI.CREATED_BY CREATED_BY
, ORGI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ORGI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ORGI.THRESHOLD_AMOUNT THRESHOLD_AMOUNT
, ORGI.CAPITALIZE_INTEREST CAPITALIZE_INTEREST
, ORGI.EFFECTIVE_DATE_TO EFFECTIVE_DATE_TO
, ORGI.EFFECTIVE_DATE_FROM EFFECTIVE_DATE_FROM
, ORGI.COMMENTS COMMENTS
, HOU.NAME ORGANIZATION_NAME
FROM IPA_ORGANIZATION_INTERESTS ORGI
, HR_ORGANIZATION_UNITS HOU
WHERE ORGI.ORGANIZATION_ID = HOU.ORGANIZATION_ID