We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
select distinct p.last_name || ', ' || p.first_name as MANAGER, (SELECT LAST_NAME || ', ' || FIRST_NAME FROM PERSON P1 WHERE P1.ID = fm.employee_person_id) AS AUDITOR, client.name CUSTOMER, deals.name as deals, aut.account_number as ACCOUNT_NUMBER, address.state_abbrev, to_char(trunc(posting_date))posting_date, (SELECT COUNT(*) FROM (SELECT start_date + LEVEL d FROM (SELECT to_date(posting_date,'dd-MON-RR') start_date, trunc(sysdate) end_date FROM DUAL) CONNECT BY start_date + LEVEL <= end_date) WHERE TO_CHAR(d, 'Dy') NOT IN ('Sat', 'Sun')) as D1, aut.deals_id, client_deals.audit_interval, to_char(trunc(client_deals.last_audit_date))last_audit_date from autr,client_deals, deals_address,address, client, deals, AVI_QUADRANTS avq, field_manager fm, person p where client.id IN (select distinct aut.CLIENT_ID from aut, client where client.id = aut.client_id and trunc(sysdate) > trunc(posting_date)+14 and inspection_status_id in (3,7) and client_id <> 100) and aut.client_id = client.id and deals.id = aut.deals_id and deals.id = client_deals.deals_id and client.id = client_deals.client_id and deals_address.deals_ID = aut.deals_id and deals_address.address_id = address.ID and trunc(sysdate) > trunc(posting_date)+14 and inspection_status_id in (3,7) AND aut.avizone_id = avq.quadrant_id AND avq.TERRITORY_ID = fm.avizone_id and p.ID=get_FM(fm.employee_person_id)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Create table from select - oracle||6||68|
|Problem with duplicate records in Oracle query||16||51|
|Alternative to GTT for a temp table for further reuse in Oracle||8||47|
|why truncate is faster than delete in oracle ?||4||48|