DBA Data[Home] [Help]

VIEW: APPS.AR_CUSTOMER_VENDOR_NIF_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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