ZX_WHT_FIRST_PTY_ORG_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
PARTY_TAX_PROFILE_ID PARTY_TYPE_CODE USE_LE_AS_SUBSCRIBER_FLAG BU_ID WHT_DATE_BASIS ALLOW_ZERO_AMT_WHT_INV_FLAG WHT_ROUNDING_LEVEL_CODE WHT_ROUNDING_RULE_CODE WHT_USE_LE_AS_SUBSCRIBER_FLAG WHT_EFFECTIVE_FROM_USE_LE

Query

SQL_Statement

SELECT PTP.PARTY_TAX_PROFILE_ID, PTP.PARTY_TYPE_CODE, PTP.USE_LE_AS_SUBSCRIBER_FLAG, -9999 BU_ID, PTP.WHT_DATE_BASIS, PTP.ALLOW_ZERO_AMT_WHT_INV_FLAG, PTP.WHT_ROUNDING_LEVEL_CODE, PTP.WHT_ROUNDING_RULE_CODE, PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG, PTP.WHT_EFFECTIVE_FROM_USE_LE FROM ZX_PARTY_TAX_PROFILE PTP, HZ_PARTIES HZP WHERE PTP.PARTY_ID = HZP.PARTY_ID AND PTP.PARTY_TYPE_CODE = 'FIRST_PARTY' UNION ALL SELECT PTP.PARTY_TAX_PROFILE_ID, PTP.PARTY_TYPE_CODE, PTP.USE_LE_AS_SUBSCRIBER_FLAG, FBU.BU_ID, PTP.WHT_DATE_BASIS, PTP.ALLOW_ZERO_AMT_WHT_INV_FLAG, PTP.WHT_ROUNDING_LEVEL_CODE, PTP.WHT_ROUNDING_RULE_CODE, PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG, PTP.WHT_EFFECTIVE_FROM_USE_LE FROM ZX_PARTY_TAX_PROFILE PTP, FUN_ALL_BUSINESS_UNITS_V FBU WHERE PTP.PARTY_TYPE_CODE = 'OU' AND PTP.PARTY_ID = FBU.BU_ID AND NVL(PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG, 'N') = 'N' UNION ALL SELECT PTP.PARTY_TAX_PROFILE_ID, PTP.PARTY_TYPE_CODE, PTP.USE_LE_AS_SUBSCRIBER_FLAG, -99 BU_ID, PTP.WHT_DATE_BASIS, PTP.ALLOW_ZERO_AMT_WHT_INV_FLAG, PTP.WHT_ROUNDING_LEVEL_CODE, PTP.WHT_ROUNDING_RULE_CODE, PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG, PTP.WHT_EFFECTIVE_FROM_USE_LE FROM ZX_PARTY_TAX_PROFILE PTP WHERE PTP.PARTY_TYPE_CODE = 'GCO' AND zx_profile.value('ZX_GCO_WRITE_ACCESS') = 'Y'