XLA_THIRD_PARTIES_V

Details

• Schema: FUSION

• Object owner: XLA

• Object type: VIEW

Columns

Name
THIRD_PARTY_ID THIRD_PARTY_TYPE THIRD_PARTY_NUMBER

Query

SQL_Statement
SELECT v.VENDOR_ID THIRD_PARTY_ID , 'S' THIRD_PARTY_TYPE , v.SEGMENT1 THIRD_PARTY_NUMBER FROM poz_SUPPLIERS v UNION ALL SELECT hca.CUST_ACCOUNT_ID THIRD_PARTY_ID , 'C' THIRD_PARTY_TYPE , hca.ACCOUNT_NUMBER THIRD_PARTY_NUMBER FROM HZ_CUST_ACCOUNTS hca