Query To check Locks on a Table
Query To find out details of concurrent request submitted with certain conditions
GL Batches Query
Project Accounting and Purchasing Order Detail Query
Details of Projects closed in particular period query
Form personalization query on form
Segments used in DFF Query
PA Projects Details Query with GL
Query To Find GL Journal Header Summary
Query To Get The Details Which Are Posted To GL Through Payables
Query To Find GL Balances & Movements
Query to Find GL Journal Line Based On Trial Balance
Query to Find GL Budget Details Associated with Ledger
Query To find Employee Details in oracle apps
Query To find employee Salary details in oracle apps
Query to get employee Special Information
Query to get Employee Probation and Notice Period
Query to find Employee Tax Info State Tax rules
Query to find Employee tax info and fedral tax rules
Query to find Employee Entries and Element entries
Query to find Employee Absence And Other Info Details
Query to Show The Elements Entries Attached To A Person
Query Shows The Payment Elements And Element Sets Information
Query To Get Employee Payroll Name And Pay Bases
Query To Get Employee Address Details
To Get Receivables Ship To Query
To Get Receivables Bill To Query
Query to Get Open Transactions
Query to Get Drilled-down Transactions
How to find out Apps Instance Login URL from database
Query to Get Unapplied Receipts By Customer
Query to Get Application Details
Query to Get Database Details
Query to Get Value Sets
Query to Get Value Sets Details
Query to Get Database Registry listing database Components in use
Query to Get GL Exchange Rates
Query to Get NLS Parameters
Query to Get DB Parameters
Query to get DBA Directories
Query to get Database Links
Query to Get List of Asset Books by Operating Unit
Query to get Oracle form Details
Query to Get AOL Messages
Query To get workflow Details
Add Concurrent Program to Request Group From Backend
Query to get AP Invoice Audit details
GL Batches Query
Project Accounting and Purchasing Order Detail Query
Details of Projects closed in particular period query
Form personalization query on form
Segments used in DFF Query
PA Projects Details Query with GL
Query To Find GL Journal Header Summary
Query To Get The Details Which Are Posted To GL Through Payables
Query To Find GL Balances & Movements
Query to Find GL Journal Line Based On Trial Balance
Query to Find GL Budget Details Associated with Ledger
Query To find Employee Details in oracle apps
Query To find employee Salary details in oracle apps
Query to get employee Special Information
Query to get Employee Probation and Notice Period
Query to find Employee Tax Info State Tax rules
Query to find Employee tax info and fedral tax rules
Query to find Employee Entries and Element entries
Query to find Employee Absence And Other Info Details
Query to Show The Elements Entries Attached To A Person
Query Shows The Payment Elements And Element Sets Information
Query To Get Employee Payroll Name And Pay Bases
Query To Get Employee Address Details
To Get Receivables Ship To Query
To Get Receivables Bill To Query
Query to Get Open Transactions
Query to Get Drilled-down Transactions
How to find out Apps Instance Login URL from database
Query to Get Unapplied Receipts By Customer
Query to Get Application Details
Query to Get Database Details
Query to Get Value Sets
Query to Get Value Sets Details
Query to Get Database Registry listing database Components in use
Query to Get GL Exchange Rates
Query to Get NLS Parameters
Query to Get DB Parameters
Query to get DBA Directories
Query to get Database Links
Query to Get List of Asset Books by Operating Unit
Query to get Oracle form Details
Query to Get AOL Messages
Query To get workflow Details
Add Concurrent Program to Request Group From Backend
Query to get AP Invoice Audit details
Hi Dayakar,
ReplyDeleteBrilliant article, glad I slogged through the Oracle Apps Important Queries it seems that a whole lot of the details really come back to from my past project.
i creat a view as(see below)
the problem is that i get dublicat rows and with UNION they are deselected,
i dont want to use UNION ALL
so my question is, how can i rewrite the two "select .. " to a Group by expression, Group by: YEAR, Month
and get the same result as UNION ALL
CREAT VIEW v_test_rerytering (.......) AS
select
F.ALDER
age,
cast(P.AR as VARCHAR2(4)) year,
ccast((P.MANAD)as VARCHAR2(2)) month,
cast(K.KON_KOD as VARCHAR2(50)) SEX,
cast('Ext' as VARCHAR2(50)) R_KOD,
F.NR_REK
REK
from test.Table_anstallda F join test.PERIOD P on P.PERIOD =
F.PERIOD
union
select
F.ALDER
age,
cast(P.AR as VARCHAR2(4)) year,
ccast((P.MANAD)as VARCHAR2(2)) month,
cast(K.KON_KOD as VARCHAR2(50)) SEX,
cast('Internal' as VARCHAR2(50)) R_KOD,
F.NR_dism
REK
from test.Table_anstallda F join test.PERIOD P on P.PERIOD_SN =
F.PERIOD;
Please keep providing such valuable information.
Merci Beaucoup,
Irene Hynes
Hello There,
ReplyDeleteZoooooooom! That’s how speedy and easy this read was! Looking forward to more of such powerful content on Oracle Apps Important Queries!
I have data in a column
#abcd#efghi#jlmn#opqrs
I need to retrieve values between '#'. I need to get output as below
var1 = abcd
var2 = efghi
var3 = jlmn
var4 = opqrs
Similary if column value is
#abcd#efghi#jlmnopqrs
var1 = abcd
var2 = efghi
var3 = jlmnopqrs
var4 = null
But nice Article Mate! Great Information! Keep up the good work!
Thanks and Regards
Preethi.