oraapps11i.blogspot.com
Technology at its Best: Hierarchical Query Example
http://oraapps11i.blogspot.com/2007/01/hierarchial-query-example.html
Technology at its Best. Oracle Applications R11i related information. Thursday, January 25, 2007. This query lists the employee details with their manager in hierarchical manner from employees table. SELECT a.employee id, a.first name, a.last name, a.manager id,. Bfirst name mgr first name, b.last name mgr last name. Select employee id, first name, last name, manager id. Start with employee id = 100. Connect by prior employee id = manager id. WHERE a.manager id = b.employee id. Top-n and nth Least query.
oraapps11i.blogspot.com
Technology at its Best: Reports Using XML Publisher
http://oraapps11i.blogspot.com/2006/11/reports-using-xml-publisher.html
Technology at its Best. Oracle Applications R11i related information. Monday, November 27, 2006. Reports Using XML Publisher. XML Publisher Concurrent Program - XMLP. Written by Anil Passi. One of the Author I like. He writes very well. Friday, 24 November 2006. In this article I have listed a step by step demo of XML Publisher as a Concurrent Program in Oracle Apps. Before I explain the steps in details with screenshots, let me brief them:-. B Build a Data Definition and XML Template using XML Publisher.
oraapps11i.blogspot.com
Technology at its Best: Image File Attachment in Oracle 11i.
http://oraapps11i.blogspot.com/2006/11/image-file-attachment-in-oracle-11i.html
Technology at its Best. Oracle Applications R11i related information. Tuesday, November 14, 2006. Image File Attachment in Oracle 11i. Technical Details of Image File Attachment in Oracle Applications 11i. Attaching an image file in Oracle Apps say, you attach an image of an Item. For this you will click on the attachments icon(Paperclip Icon) of the toolbar in Apps Window and this will take you to Attachment Window. Here You can specify Category, Description,Datatype. FROM fnd documents tl. From a custo...
oraapps11i.blogspot.com
Technology at its Best: February 2007
http://oraapps11i.blogspot.com/2007_02_01_archive.html
Technology at its Best. Oracle Applications R11i related information. Saturday, February 03, 2007. In the custom.pll, modify the below given function and procedure:. Function zoom available return boolean is. Form name varchar2(30) := name in('system.current form');. Block name varchar2(30) := name in('system.cursor block');. If (form name = 'POXPOEPO' and block name = 'PO LINES'). End zoom available;. Procedure event(event name varchar2) is. Form name varchar2(30) := name in('system.current form');.
oraapps11i.blogspot.com
Technology at its Best: November 2006
http://oraapps11i.blogspot.com/2006_11_01_archive.html
Technology at its Best. Oracle Applications R11i related information. Monday, November 27, 2006. Reports Using XML Publisher. XML Publisher Concurrent Program - XMLP. Written by Anil Passi. One of the Author I like. He writes very well. Friday, 24 November 2006. In this article I have listed a step by step demo of XML Publisher as a Concurrent Program in Oracle Apps. Before I explain the steps in details with screenshots, let me brief them:-. B Build a Data Definition and XML Template using XML Publisher.
oraapps11i.blogspot.com
Technology at its Best: Top-n and nth Least query
http://oraapps11i.blogspot.com/2007/01/top-n-and-nth-least-query.html
Technology at its Best. Oracle Applications R11i related information. Thursday, January 18, 2007. Top-n and nth Least query. Query to find the nth highest salary and the. Associated employees from employees table. Select a.last name,a.salary. Where n = (select count(distinct(b.salary). Query to find the nth least or say 2nd least salary and. The associated employees from employees table. Select a.last name,a.salary. Where n = (select count(distinct(b.salary). Where a.salary = b.salary).
oraapps11i.blogspot.com
Technology at its Best: January 2007
http://oraapps11i.blogspot.com/2007_01_01_archive.html
Technology at its Best. Oracle Applications R11i related information. Thursday, January 25, 2007. This query lists the employee details with their manager in hierarchical manner from employees table. SELECT a.employee id, a.first name, a.last name, a.manager id,. Bfirst name mgr first name, b.last name mgr last name. Select employee id, first name, last name, manager id. Start with employee id = 100. Connect by prior employee id = manager id. WHERE a.manager id = b.employee id. Thursday, January 18, 2007.
oraapps11i.blogspot.com
Technology at its Best: External Table feature of Oracle 10g on Windows
http://oraapps11i.blogspot.com/2006/11/external-table-feature-of-oracle-10g.html
Technology at its Best. Oracle Applications R11i related information. Saturday, November 04, 2006. External Table feature of Oracle 10g on Windows. Using External Table feature of Oracle 10g on Windows. External Tables are used for dataloading to oracle 10g Database. 1 Create a Directory C: wkdir. 2 connect to sqlplus as system or sysdba. 3 Execute the below statement. Create or replace directory ext tab dir as 'c: wkdir';. Grant read,write on directory ext tab dir to scott;. 4 disconnect from sqlplus.
oraapps11i.blogspot.com
Technology at its Best: Returning a Table from a PL/SQL function
http://oraapps11i.blogspot.com/2006/11/returning-table-from-plsql-function.html
Technology at its Best. Oracle Applications R11i related information. Tuesday, November 07, 2006. Returning a Table from a PL/SQL function. 1 Create an object type for the record. Create or replace type emp rec t as object. Employee id number,. First name varchar2(25),. Manager id number,. 2 create a SQL table type object. Create or replace type emp tab as table of emp rec t;. 3 Define a function in the following way. Function demo proc( p start row in number,. P end row in number ). L cnt := l cnt 1;.
oraapps11i.blogspot.com
Technology at its Best: Implementing Zoom
http://oraapps11i.blogspot.com/2007/02/implementing-zoom.html
Technology at its Best. Oracle Applications R11i related information. Saturday, February 03, 2007. In the custom.pll, modify the below given function and procedure:. Function zoom available return boolean is. Form name varchar2(30) := name in('system.current form');. Block name varchar2(30) := name in('system.cursor block');. If (form name = 'POXPOEPO' and block name = 'PO LINES'). End zoom available;. Procedure event(event name varchar2) is. Form name varchar2(30) := name in('system.current form');.