Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Thursday, 21 April 2016

Oracle Apps Important Queries

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  




Share this article :

2 comments:

  1. Hi Dayakar,

    Brilliant 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

    ReplyDelete
  2. Hello There,

    Zoooooooom! 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.

    ReplyDelete