Query: select name,argument_text from (SELECT prog.user_concurrent_program_name || DECODE (req.description, NULL, NULL, ‘:’ || req.description) name, req.request_id, req.parent_request_id, req.request_date, DECODE (req.request_type, ‘P’, actual_start_date, requested_start_date), req.actual_completion_date, FLOOR( ( (actual_completion_date – DECODE (req.request_type,…
Read MoreQuery: SELECT rs.user_request_set_name “Request Set”, rss.display_sequence seq, cp.user_concurrent_program_name “Concurrent Program”, e.executable_name, e.execution_file_name, lv.meaning file_type, fat.application_name “Application Name” FROM fnd_request_sets_vl rs, fnd_req_set_stages_form_v rss, fnd_request_set_programs rsp, fnd_concurrent_programs_vl cp, fnd_executables e, fnd_lookup_values lv,…
Read MoreSELECT hca.account_number, ( SELECT hp.party_name FROM apps.hz_parties hp WHERE hp.party_id = hca.party_id ) customer_name, jnb.creation_date notes_creation_date, jnb.note_type note_type, fls.meaning note_type_meaning, jnt.notes notes FROM apps.hz_cust_accounts hca, apps.jtf_notes_b jnb, apps.jtf_notes_tl jnt, apps.fnd_lookups…
Read MoreSELECT DISTINCT –gcck.concatenated_segments, gcck.segment1 company, gcck.segment2 location, gcck.segment3 product, gcck.segment4 function, gcck.segment5 account, gcck.segment6 intercompany, gcck.segment7 subaccount, gcck.segment8 future1, gcck.segment9 future2, rctld.gl_date, gjb.name batch_name, gjh.name journal_name, ( SELECT user_je_category_name FROM…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreSyntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreSyntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreIn this blog, you will find the SQL query to extract the Employee expense payments in Oracle apps R12.1.3 Query: select aps.vendor_name “Supplier”, aca.AMOUNT “Payment amount”, aca.currency_code “Currency”, aca.check_date “Payment…
Read MoreIntroduction This Query will help to Extract the Customer Wise Accrual Details in Trade Management in Oracle Apps. SQL Query: SELECT DECODE (qualifier_context, ‘CUSTOMER’, (SELECT b.party_name FROM hz_cust_accounts a, hz_parties…
Read More