Daily SQL Details Rows Address Run Date Disk Reads Buffer Gets Sorts Executions Processed -------- -------------- ---------- ----------- --------- ---------- --------- SQL Text ----------------------------------------------------------------------------- 400ECB40 10/07/99 16:45 0 1538067 4 1 14 SELECT MAX ( CC.SEGMENT1 ) PBDATA , MAX ( CC.SEGMENT3 ) ACCTDATA , SUM ( decode(bal.period_name, 'JUL-99', nvl(begin_balance_dr, 0) - nvl(begin_balance_cr, 0), 0) ) BEGIN_BALANCE , SUM ( decode(bal.period_name, 'OCT-99', nvl(begin_balance_dr, 0) + nvl(period_net_dr, 0), 0) + decode(bal.period_name, 'JUL-99', - nvl(begin_balance_dr, 0), 0) ) PERIOD_DR , SUM ( decode(bal.period_name, 'OCT-99', nvl(begin_balance_cr, 0) + nvl(period_net_cr, 0), 0) + decode(bal.period_name, 'JUL-99', - nvl(begin_balance_cr, 0), 0) ) PERIOD_CR FROM GL_BALANCES BAL , GL_CODE_COMBINATIONS CC WHERE CC . CHART_OF_ACCOUNTS_ID = : STRUCT_NUM AND CC . TEMPLATE_ID IS NULL AND ''||CC.SEGMENT1 BETWEEN '1503' AND '1503' AND BAL . CODE_COMBINATION_ID = CC . CODE_COMBINATION_ID AND BAL . SET_OF_BOOKS_ID = : P_SET_OF_BOOKS_ID AND BAL . ACTUAL_FLAG = 'A' AND BAL . PERIOD_NAME IN ('OCT-99','JUL-99') AND BAL . CURRENCY_CODE = : P_CURRENCY_CODE AND (bal.translated_flag != 'R' or bal.translated_flag is null) AND ( CC.SEGMENT3 < '10000' OR CC.SEGMENT3 > '89999' ) GROUP BY CC.SEGMENT1 , CC.SEGMENT1 , CC.SEGMENT3 , CC.SEGMENT3 UNION ( SELECT MAX ( CC.SEGMENT1 ) PBDATA , '49999' ACCTDATA , SUM ( decode(bal.period_name, 'JUL-99', nvl(begin_balance_dr, 0) - nvl(begin_balance_cr, 0), 0) ) BEGIN_BALANCE , SUM ( decode(bal.period_name, 'OCT-99', nvl(begin_balance_dr, 0) + nvl(period_net_dr, 0), 0) + decode(bal.period_name, 'JUL-99', - nvl(begin_balance_dr, 0), 0) ) PERIOD_DR , SUM ( decode(bal.period_name, 'OCT-99', nvl(begin_balance_cr, 0) + nvl(period_net_cr, 0) 4312CEBC 10/07/99 13:30 0 244 4 1 2 SELECT PERIOD_NAME, PERIOD_NAME VALUE, PERIOD_NAME DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM GL_SRS_LEDGER_PERIOD_START WHERE (ACTUAL_FLAG = :A0 AND SET_OF_BOOKS_ID = :A1 AND DECODE(ACTUAL_FLAG, 'B', BUDGET_ENCUMBRANCE_ID, :A2) = :A3 AND PERIOD_YEAR = (SELECT PERIOD_YEAR FROM GL_SRS_LEDGER_PERIOD_START WHERE PERIOD_NAME = :A4 AND ACTUAL_FLAG = :A5 AND SET_OF_BOOKS_ID = :A6 AND DECODE(ACTUAL_FLAG, 'B', BUDGET_ENCUMBRANCE_ID, :A7) = :A8) AND PERIOD_NUM >= (SELECT PERIOD_NUM FROM GL_SRS_LEDGER_PERIOD_START WHERE PERIOD_NAME = :A90 AND ACTUAL_FLAG = :A91 AND SET_OF_BOOKS_ID = :A92 AND DECODE(ACTUAL_FLAG, 'B', BUDGET_ENCUMBRANCE_ID, :A93) = :A94)) ORDER BY PERIOD_YEAR DESC, PERIOD_NUM DESC 433367F8 10/07/99 14:00 0 52 4 1 0 select i.obj# idx, i.file# filenum, i.block# blocknum from ind$ i, ( select i.obj# obj# from icol$ i, user$ u, obj$ o, col$ c where i.bo# = o.obj# and i.col# = c.col# and o.owner# = u.user# and c.obj# = o.obj# and u.name = 'GL' and c.name = 'CODE_COMBINATION_ID' and o.name = 'GL_POSTING_INTERIM_28106' intersect select i.obj# obj# from icol$ i, user$ u, obj$ o, col$ c where i.bo# = o.obj# and i.col# = c.col# and o.owner# = u.user# and c.obj# = o.obj# and u.name = 'GL' and c.name = 'PERIOD_NAME' and o.name = 'GL_POSTING_INTERIM_28106' intersect select i.obj# obj# from icol$ i, user$ u, obj$ o, col$ c where i.bo# = o.obj# and i.col# = c.col# and o.owner# = u.user# and c.obj# = o.obj# and u.name = 'GL' and c.name = 'SET_OF_BOOKS_ID' and o.name = 'GL_POSTING_INTERIM_28106' intersect select i.obj# obj# from icol$ i, user$ u, obj$ o, col$ c where i.bo# = o.obj# and i.col# = c.col# and o.owner# = u.user# and c.obj# = o.obj# and u.name = 'GL' and c.name = 'CURRENCY_CODE' and o.name = 'GL_POSTING_INTERIM_28106') foo where i.obj# = foo.obj# and bitand(i.compress$, 02)=0 43DD4900 10/07/99 16:45 0 13902 7 179 179 SELECT pll . shipment_num pll_shipment_num , pll . due_date pll_due_date , round ( pll . quantity_ordered , : P_QTY_PRECISION ) pll_quantity_ordered , pll . release_price pll_release_price , round ( pll . quantity_cancelled , : P_QTY_PRECISION ) pll_quantity_cancelled , pll . cancel_flag pll_cancel_flag , pll . cancel_date pll_cancel_date , pll . cancel_reason pll_cancel_reason , pll . taxable_flag pll_taxable_flag , pll . ship_address_line1 pll_ship_address_line1 , pll . ship_address_line2 pll_ship_address_line2 , pll . ship_address_line3 pll_ship_address_line3 , pll . ship_city pll_ship_city , pll . ship_city || ', ' || pll . ship_state_province || ' ' || pll . ship_postal_code pll_ship_adr_info , pll . ship_country pll_ship_country , pll . po_line_id pll_po_line_id , pll . line_location_id pll_line_location_id , pll . ship_to_location_id pll_ship_to_location , nvl ( pll . po_release_id , - 1 ) pll_join_release_id FROM po_line_locations_print pll WHERE ( :pol_po_line_id = pll.po_line_id) AND ( :pol_join_release_id = nvl(pll.po_release_id,-1)) ORDER BY pll . shipment_num