QUEST4APPS

Category: SQL

  • Oracle SQL and PLSQL Beginner Resources

    Oracle SQL and PLSQL Beginner Resources

    —

    by

    Arun Raj
    in , ,

    In this post lets take a look at few of the free Oracle SQL and PLSQL Beginner resources. These can also be used by Intermediate and advanced users!! Oracle Dev Gym Here is a great blog by Steven Feuerstein about Oracle Dev Gym. The portal has got 4 main sections: Classes: there are some really…

  • Create XML Using SQL Statements

    —

    by

    Arun Raj
    in , ,

    In this post we will take a look at how to create XML using SQL Statements. The following functions will be used to generate the output in XML Format. XMLElement () XMLForest () XMLSequence () XMLAgg () The combination of the above three functions will let us create some very fancy and complex XML Outputs. Lets…

  • Useful Oracle Apps Queries

    —

    by

    Arun Raj
    in , ,

    Below are a list of SQL Queries that will be useful during your day to day activities. 1. Concurrent Programs Assigned to a Request Group SELECT fcpv.concurrent_program_name SHORT_NAME ,fcpv.user_concurrent_program_name CONC_PROG_NAME ,frg.request_group_name REQ_GROUP_NAME FROM fnd_concurrent_programs_vl fcpv ,fnd_request_groups frg ,fnd_request_group_units frgu WHERE fcpv.concurrent_program_id = frgu.request_unit_id AND fcpv.enabled_flag = ‘Y’ AND frgu.request_group_id = frg.request_group_id AND frg.request_group_name = ‘&request_group_name’;…