ZX_FIRST_PARTY_ORGS_MOAC_V

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
PARTY_TAX_PROFILE_ID PARTY_NAME LEGAL_ENTITY_IDENTIFIER LEGAL_ENTITY_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, XLEP.NAME PARTY_NAME, XLEP.LEGAL_ENTITY_IDENTIFIER, XLEP.LEGAL_ENTITY_ID , PTP.PARTY_TYPE_CODE, 'N' AS 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, 'N' AS WHT_USE_LE_AS_SUBSCRIBER_FLAG, PTP.WHT_EFFECTIVE_FROM_USE_LE FROM ZX_PARTY_TAX_PROFILE PTP, HZ_PARTIES HZP, XLE_ENTITY_PROFILES XLEP, xle_registrations xler WHERE PTP.PARTY_ID = HZP.PARTY_ID AND PTP.PARTY_TYPE_CODE IN ('FIRST_PARTY') AND HZP.PARTY_ID = XLEP.PARTY_ID AND xlep.legal_entity_id = xler.source_id AND xler.source_table = 'XLE_ENTITY_PROFILES' AND xler.IDENTIFYING_FLAG IS NOT NULL AND xler.IDENTIFYING_FLAG = 'Y' UNION ALL SELECT PTP.PARTY_TAX_PROFILE_ID, FBU.BU_NAME PARTY_NAME, NULL AS LEGAL_ENTITY_IDENTIFIER, NULL AS LEGAL_ENTITY_ID, PTP.PARTY_TYPE_CODE, NVL(PTP.USE_LE_AS_SUBSCRIBER_FLAG,'N'), FBU.BU_ID, PTP.WHT_DATE_BASIS, PTP.ALLOW_ZERO_AMT_WHT_INV_FLAG, PTP.WHT_ROUNDING_LEVEL_CODE, PTP.WHT_ROUNDING_RULE_CODE, NVL(PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG,'N'), 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.USE_LE_AS_SUBSCRIBER_FLAG,'N') = 'N' OR NVL(PTP.WHT_USE_LE_AS_SUBSCRIBER_FLAG,'N') = 'N' ) UNION ALL SELECT PTP.PARTY_TAX_PROFILE_ID, LU.MEANING PARTY_NAME, NULL AS LEGAL_ENTITY_IDENTIFIER, NULL AS LEGAL_ENTITY_ID, PTP.PARTY_TYPE_CODE, 'N' AS 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, 'N' AS WHT_USE_LE_AS_SUBSCRIBER_FLAG, PTP.WHT_EFFECTIVE_FROM_USE_LE FROM ZX_PARTY_TAX_PROFILE PTP, FND_LOOKUPS LU WHERE PTP.PARTY_TYPE_CODE = 'GCO' AND PTP.PARTY_TYPE_CODE = LU.LOOKUP_CODE AND LU.LOOKUP_TYPE = 'ZX_PTP_PARTY_TYPE'