Nov 7, 2022 · Query 9: SQL to view all types of request Application wise. SELECT fa.application_short_name, fcpv.user_concurrent_program_name, description, DECODE (fcpv.execution_method_code, ‘B’, ‘Request Set Stage Function’, ‘Q’, ‘SQL*Plus’, ‘H’, ‘Host’, ‘L’, ‘SQL*Loader’, ‘A’, ‘Spawned’, ‘I’, ‘PL/SQL Stored ...

Jun 7, 2013 · Execute below query to see the onhand inventory information in oracle applications. SELECT NVL(substr(org.organization_ code, 1,3), ‘ ‘) orgcode,NVL(substr(msi.segment1, 1, 8), ‘ ‘) seg11,NVL(substr(msi.segment1, 9, 8), ‘ ‘) seg12,NVL(substr(msi.segment1, 17, 4), ‘ ‘) seg13,NVL(moq.subinventory_code, ‘ ‘) sub_inv_code

Here, we cover some of the most useful and important SQL queries for Oracle R12, focusing on real-world scenarios involving multiple tables. We’ve also included top sql queries asked in interview and examples from the Sysadmin, Application Developer (FND), Procedure-to-Pay, Order-to-Cash, Schedule-to-Delivery, and Finance modules.

Aug 17, 2020 · SELECT to_char (sq.sql_fulltext) FROM v$session ses, v$sqlarea sq WHERE ses.module LIKE '%INVTTMTX%' AND sq.sql_id = ses.prev_sql_id; In this article, we have demonstrated how to find SQL query behind oracle forms LOV in oracle apps r12 .

Feb 18, 2013 · Query 8: SQL to view all requests who have attached to a responsibility SELECT responsibility_name , frg.request_group_name, fcpv.user_concurrent_program_name, fcpv.description

Apr 17, 2020 · We will be able to extract the list of lookup values using this sql query in oracle. This is one of the important query regarding oracle lookup details. Here below is the complete details about Query to check lookup values.

Nov 25, 2019 · In this post , We will be discuss about the SQL query , which will help to extract the complete payments in oracle apps r12. This query will extract the important payment , Invoice details against which we have created those payments so we will get the complete information from Payments to Supplier Invoices in oracle apps r12.

Sep 16, 2013 · In that case I use the SQL statement below to quickly provide me a list of the values of a profile option for all levels. The profile option name (column profile_option_name from table applsys.fnd_profile_options) can be found within the definition of the profile itself through responsibility Application Developer – menu Profile.

Jul 2, 2014 · SQL query to find Open/Close Periods in Oracle Apps R12 Query to find the Gl Set of Books. To find SET_OF_BOOKS_ID: SELECT * FROM gl_sets_of_books Inventory SELECT DISTINCT opu.na...

Jan 20, 2017 · How to query service contracts tables and tables from other schemas to find underlying data about contract headers, lines, sublines and contract billing in R12. This article provides a variety of queries which can be used to find the required data for a particular contract.