FND Design Data [Home] [Help]

View: AR_CUSTOMER_VENDOR_NIF_V

Product: AR - Receivables
Description: Customer and Vendor NIF codes
Implementation/DBA Data: ViewAPPS.AR_CUSTOMER_VENDOR_NIF_V
View Text

SELECT PARTY.JGZZ_FISCAL_CODE NIF_CODE
FROM HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID UNION SELECT NUM_1099 NIF_CODE
FROM PO_VENDORS

Columns

Name
NIF_CODE