Query to Check locks on a table

Select object_id, session_id, oracle_username, os_user_name, Process, locked_mode From sys.v_$locked_object; Select a.object_name, b.oracle_username From all_objects a, v$locked_object b Where ...

GL Batches Query

SELECT jb.NAME, gh.period_name, gh.je_source, gh.je_category, gh.currency_code, gc.concatenated_segments, gl.entered_cr, gl.entered_dr, gl.accounted_cr, gl.accounted_dr FROM gl_je_batches jb, ...

iStore Setup and Customization Tips

ISTORE SETUP CATALOG CREATION Go to the below responsibility:- iStore Administrator 1. Navigate to Catalog Tab to see Hierarchy. 2. Click Section image in Accessories Section which is root ...

Supplier with Bank and Tax details query

select (SELECT hou.NAME FROM apps.hr_operating_units hou WHERE 1 = 1 AND hou.organization_id = aps.org_id) ou_name, (SELECT paym.payment_method_code FROM APPS.iby_ext_party_pmt_mthds paym WHERE ...

AP Invoice posted register query

select aia.INVOICE_NUM ,aba.batch_name ,aia.INVOICE_AMOUNT ,aia.PAY_GROUP_LOOKUP_CODE INv_group ,aia.INVOICE_CURRENCY_CODE ,aia.CREATION_DATE ,To_char(aia.creation_date,’MONTH’) ...

Start typing and press Enter to search