[Home] [Help]
1663: c_org_id NUMBER,
1664: c_trx_date DATE)
1665: IS
1666: SELECT c.tax_code
1667: FROM HZ_CUST_ACCOUNTS_ALL c, ZX_OUTPUT_CLASSIFICATIONS_V l
1668: WHERE c.cust_account_id = c_customer_id
1669: AND c.org_id = c_org_id
1670: AND l.lookup_code = c.tax_code
1671: AND l.org_id IN (c_org_id, -99)