SELECT
TO_CHAR(hca.account_number) account_number,
(
SELECT
name
FROM
apps.hr_operating_units hou
WHERE
hou.organization_id = hcasa.org_id
) organization_name,
hca.status account_status,
hl.address1,
hl.address2,
hl.address3,
hl.address4,
hl.city,
hl.postal_code,
hl.state,
hl.province,
hl.county,
hl.country,
hcsua.site_use_code business_purpose,
hcsua.location location_description, hcsua.primary_flag primary_tickbox_selection,
rt.name payment_term
FROM
apps.hz_cust_accounts hca,
apps.hz_cust_acct_sites_all hcasa,
apps.hz_party_sites hps,
apps.hz_locations hl,
apps.hz_cust_site_uses_all hcsua,
apps.ra_terms rt
WHERE
hca.account_number LIKE ‘9082113.%’
AND hca.cust_account_id = hcasa.cust_account_id
AND hcasa.org_id IN (
3183, 107, 207)
AND hcasa.party_site_id = hps.party_site_id
AND hps.location_id = hl.location_id
AND hcasa.cust_acct_site_id = hcsua.cust_acct_site_id (+)
AND hcsua.payment_term_id = rt.term_id (+)
ORDER BY
1
Recommended Posts
