JV_OWNER_PERCENT_LINES_VL

Details

• Schema: FUSION

• Object owner: JV

• Object type: VIEW

Columns

Name

OWNERSHIP_PERCENT_SHORT_NAME JOINT_VENTURE_ID OWNERSHIP_STATUS_CODE EFFECTIVE_START_DATE EFFECTIVE_END_DATE OWNERSHIP_CHANGE_FLAG CHANGE_REASON_CODE CHANGE_REASON_ADDITIONAL_TEXT ROW_ID OWNERSHIP_PERCENTAGE_ID OWNERSHIP_LINE_ID OBJECT_VERSION_NUMBER STAKEHOLDER_ID PERCENTAGE_OF_INTEREST ROUNDING_PARTNER_FLAG DISTRIBUTION_ONLY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5

Query

SQL_Statement

SELECT b.OWNERSHIP_PERCENT_SHORT_NAME, b.JOINT_VENTURE_ID, b.OWNERSHIP_STATUS_CODE, b.EFFECTIVE_START_DATE, b.EFFECTIVE_END_DATE, b.OWNERSHIP_CHANGE_FLAG, b.CHANGE_REASON_CODE, b.CHANGE_REASON_ADDITIONAL_TEXT, l.ROWID ROW_ID, l.OWNERSHIP_PERCENTAGE_ID, l.OWNERSHIP_LINE_ID, l.OBJECT_VERSION_NUMBER, l.STAKEHOLDER_ID, l.PERCENTAGE_OF_INTEREST, l.ROUNDING_PARTNER_FLAG, l.DISTRIBUTION_ONLY_FLAG, l.CREATED_BY, l.CREATION_DATE, l.LAST_UPDATED_BY, l.LAST_UPDATE_DATE, l.LAST_UPDATE_LOGIN, l.ATTRIBUTE_CATEGORY, l.ATTRIBUTE_CHAR1, l.ATTRIBUTE_CHAR2, l.ATTRIBUTE_CHAR3, l.ATTRIBUTE_CHAR4, l.ATTRIBUTE_CHAR5, l.ATTRIBUTE_CHAR6, l.ATTRIBUTE_CHAR7, l.ATTRIBUTE_CHAR8, l.ATTRIBUTE_CHAR9, l.ATTRIBUTE_CHAR10, l.ATTRIBUTE_NUMBER1, l.ATTRIBUTE_NUMBER2, l.ATTRIBUTE_NUMBER3, l.ATTRIBUTE_NUMBER4, l.ATTRIBUTE_NUMBER5, l.ATTRIBUTE_DATE1, l.ATTRIBUTE_DATE2, l.ATTRIBUTE_DATE3, l.ATTRIBUTE_DATE4, l.ATTRIBUTE_DATE5 FROM JV_OWNER_PERCENTS_F_B b, JV_OWNER_PERCENT_LINES l WHERE b.OWNERSHIP_PERCENTAGE_ID = l.OWNERSHIP_PERCENTAGE_ID