SELECT LPAD (MONTH, 20 – (20 – LENGTH (MONTH)) / 2) MONTH, “Sun”, “Mon”,“Tue”, “Wed”, “Thu”, “Fri”, “Sat”FROM (SELECT TO_CHAR (dt, ‘fmMonthfm YYYY’) MONTH,TO_CHAR (dt + 1, ‘iw’) week,MAX (DECODE (TO_CHAR (dt, ‘d’),‘1’, LPAD (TO_CHAR (dt, ‘fmdd’), 2))) “Sun”,MAX (DECODE (TO_CHAR (dt, ‘d’),‘2’, LPAD (TO_CHAR (dt, ‘fmdd’), 2))) “Mon”,MAX (DECODE (TO_CHAR (dt, ‘d’),‘3’, LPAD (TO_CHAR […]
You have a purchase order and you have a requisition, but wait how do you know how this purchase order is linked with requisition. Here is the query thats answers this. Use this query find linked Purchase order and Requisition. This could be really a helpful one. SELECT prh.segment1 req_number ,prh.authorization_status ,prl.line_num req_line_num […]
Based on a request from one of the reader here is the query which he was looking for. He needed query that can list all the responsibilities attached to a user. select fu.user_name, fr.responsibility_name, furg.START_DATE, furg.END_DATE from fnd_user_resp_groups_direct furg, fnd_user fu, fnd_responsibility_tl fr where fu.user_user_name = :user_name and furg.user_id = fu.user_id and furg.responsibility_id = fr.responsibility_id […]
Some of the new terminologies used in Oracle Applications Release 12 are: 11i Vs. 12 Sets of Books = LedgersGlobal Accounting Engine = Subledger AccountingAX Posting Sets of Books = Secondary LedgersGlobal Intercompany System = Advanced Global Intercompany SystemGL Intercompany Accounts = Intracompany BalancingTranslated Currency = Balance level RCsMultiple Reporting Currencies = Reporting CurrenciesMRC Primary […]
Oracle Reports: Fixed format reports delivered with the 11i release were built on this tool. This is the most used tool for reporting on Oracle Applications. Most of reports customizations are built with this tool. Once customized the output of the report can be in Excel (Not group By Report), word, Acrobat documents or text […]
Recent Comments