retoscripts.blogspot.com

Apps Scripts

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG'). And p...

http://retoscripts.blogspot.com/

OVERVIEW OF retoscripts.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR RETOSCRIPTS.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

January

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.4 out of 5 with 5 reviews

5 star

3

4 star

1

3 star

1

2 star

0

1 star

0

Hey there! Start your review of retoscripts.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT RETOSCRIPTS.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

10

SSL

EXTERNAL LINKS

32

SITE IP

173.194.46.107

LOAD TIME

0.078 sec

SCORE

6.2

PAGE TITLE

Apps Scripts | retoscripts.blogspot.com Reviews

<META> DESCRIPTION

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG'). And p...

<META> KEYWORDS

1 skip to main

2 skip to sidebar

3 apps scripts

4 posted by

5 no comments

6 prhauthorization status

7 prlquantity req quantity

8 plline num

9 plitem description

10 plquantity

CONTENT

Page content here

KEYWORDS ON PAGE

skip to main,skip to sidebar,apps scripts,posted by,no comments,prhauthorization status,prlquantity req quantity,plline num,plitem description,plquantity,plamount,phsegment1 po number,prddistribution id,pdreq distribution id,1 comment,declare,begin,end;

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Apps Scripts | retoscripts.blogspot.com Reviews

https://retoscripts.blogspot.com

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG'). And p...

INTERNAL PAGES

retoscripts.blogspot.com

1

Apps Scripts: Query to List all the responsibilities attached to a User

http://retoscripts.blogspot.com/2010/03/query-to-list-all-responsibilities.html

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG').

2

Apps Scripts: Link Purchase Order and Requisition

http://retoscripts.blogspot.com/2010/03/link-purchase-order-and-requisition.html

Tuesday, March 16, 2010. Link Purchase Order and Requisition. 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. Prlline num req line num. Prlitem description req item description. Prlunit price req unit price. Pdreq header reference num. Pdreq line reference num.

3

Apps Scripts: March 2010

http://retoscripts.blogspot.com/2010_03_01_archive.html

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG'). And p...

4

Apps Scripts: Simple Script to load the HR Locations using API

http://retoscripts.blogspot.com/2009/10/simple-script-to-load-hr-locations.html

Thursday, October 22, 2009. Simple Script to load the HR Locations using API. L location id NUMBER;. L object version number NUMBER;. Appshr location api.create location. P effective date = SYSDATE,. P location code = 'XX LOCATION',. P description = 'XX Location',. P address line 1 = 'XX Avenue',. P country = 'US',. P postal code = '6442',. P telephone number 1 = '7587612050',. P town or city = 'XX',. P business group id = '0',. P style = 'US GLB',. P location id = l location id,. Anto Joe Natesh I.

5

Apps Scripts: Order by clause for column datatype as character

http://retoscripts.blogspot.com/2009/10/order-by-clause-for-column-datatype-as.html

Thursday, October 22, 2009. Order by clause for column datatype as character. We generally cannot order the records for a column with character data type. Please use the following trick to use the order clause:. Select employee number from employees. Order by lpad(employee number,100);. Using the lpad the zeros would be appended and then sql will treat them as numbers and the employee number would be sorted. Anto Joe Natesh I. Subscribe to: Post Comments (Atom). Oracle Application Inbound Interfaces.

UPGRADE TO PREMIUM TO VIEW 5 MORE

TOTAL PAGES IN THIS WEBSITE

10

LINKS TO THIS WEBSITE

appsforms.blogspot.com

Oracle Application Forms: Develop Custom Forms in Oracle Applications

http://appsforms.blogspot.com/2009/09/content.html

This appsform Blog provides tips,tricks,scripts and how-to develop Oracle forms related technologies. I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions. Sunday, September 13, 2009. Develop Custom Forms in Oracle Applications. Overview of the Template Form. Of new forms. The first step in creating a. Is to copy the template. From $AU TOP/forms/US, to a local directory and renaming it. Is unique because it contains some special libraries.

appsinterfaces.blogspot.com

Oracle Application Interfaces: RETCODE & ERRBUFF Parameters in Concurrent Program

http://appsinterfaces.blogspot.com/2009/10/retcode-errbuff-parameters-in.html

Wednesday, October 21, 2009. RETCODE and ERRBUFF Parameters in Concurrent Program. As we all know there are two mandatory parameters that need to be pased for all the procedures called. Based on the business process if there is any undefined exeception occured while running concurrent program, we can end the concurrent program with Error/Warning. Define ERRBUFF as the first parameter and Retcode as the second one. Mention the OUT variable type. CREATE PROCEDURE PROCEDURE NAME (errbuf OUT VARCHAR2,. Out o...

appsforms.blogspot.com

Oracle Application Forms: September 2009

http://appsforms.blogspot.com/2009_09_01_archive.html

This appsform Blog provides tips,tricks,scripts and how-to develop Oracle forms related technologies. I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions. Friday, September 18, 2009. Description of Libraries attached with Template.fmb. Libraries – Core. Download from $AU TOP/resource. Set FORMS60 PATH on desktop to location of local libraries. APPCORE.pll Application Standards, toolbar. VERTpll Specific industry features. Oracle does not s...

appsforms.blogspot.com

Oracle Application Forms: Description of Libraries attached with Template.fmb

http://appsforms.blogspot.com/2009/09/description-of-libraries-attached-with.html

This appsform Blog provides tips,tricks,scripts and how-to develop Oracle forms related technologies. I thought it would be useful to share with everybody. Please feel free to include your comments/corrections/questions. Friday, September 18, 2009. Description of Libraries attached with Template.fmb. Libraries – Core. Download from $AU TOP/resource. Set FORMS60 PATH on desktop to location of local libraries. APPCORE.pll Application Standards, toolbar. VERTpll Specific industry features. Oracle does not s...

appsinterfaces.blogspot.com

Oracle Application Interfaces: Create Request Group using oracle api

http://appsinterfaces.blogspot.com/2009/10/create-request-group-using-oracle-api.html

Wednesday, October 21, 2009. Create Request Group using oracle api. Recently i got a requirement to create request and attach all the standard reports of GL to these request groups. It seems a lot tedious task to do manually. So i developed this script to copy the request group content to other request groups. This is very useful if you have to create multiple request groups and attach reports to all. SELECT b.concurrent program name programname,c.application name appname. FROM fnd request group units a.

appsinterfaces.blogspot.com

Oracle Application Interfaces: September 2009

http://appsinterfaces.blogspot.com/2009_09_01_archive.html

Saturday, September 26, 2009. FND GLOBAL.APPS INITIALIZE for initializing session in Oracle Ebusiness suite. FND GLOBAL.APPS INITIALIZE is used for initializing the session before calling any public or private API's in Oracle Ebusiness suite. Its not required for all the API's but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND GLOBAL.APPS INITIALIZE function. Fnd global.APPS INITIALIZE(user id= l user id,. Out of my ...

appsstuff.blogspot.com

Oracle Application Stuff: October 2009

http://appsstuff.blogspot.com/2009_10_01_archive.html

Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Thursday, October 22, 2009. 2 Write a PL/SQL program to do the processing. It crea...

appsinterfaces.blogspot.com

Oracle Application Interfaces: FND_GLOBAL.APPS_INITIALIZE for initializing session in Oracle Ebusiness suite

http://appsinterfaces.blogspot.com/2009/09/fndglobalappsinitialize-for.html

Saturday, September 26, 2009. FND GLOBAL.APPS INITIALIZE for initializing session in Oracle Ebusiness suite. FND GLOBAL.APPS INITIALIZE is used for initializing the session before calling any public or private API's in Oracle Ebusiness suite. Its not required for all the API's but its recommended that you set this profile before making any calls to either private or public API. Listed below is a sample call to FND GLOBAL.APPS INITIALIZE function. Fnd global.APPS INITIALIZE(user id= l user id,. Please Con...

appsstuff.blogspot.com

Oracle Application Stuff: November 2007

http://appsstuff.blogspot.com/2007_11_01_archive.html

Greetings, This is not a regular one! Indeed this is exclusively for people who search information in Oracle Application. I am very happy to contribute and share my knowledge which I have earned during my Apps Implementations. I hope and promise this blog will be very different from others. You all might have learnt something out of your experiences just like me. Kindly put that in words and send it to me through comments. Monday, November 26, 2007. Difference Between Lexical and Bind Variable. Oracle Re...

UPGRADE TO PREMIUM TO VIEW 23 MORE

TOTAL LINKS TO THIS WEBSITE

32

OTHER SITES

retoscreativos.com

info : luis@retoscreativos.com

retoscripts.blogspot.com

Apps Scripts

Tuesday, March 16, 2010. Query to List all the responsibilities attached to a User. 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 fr.language = userenv('LANG'). And p...

retoscripts.com

Please leave before entering

retosdadydu.blogspot.com

Best Porsche

Sharing my thoughts about porsche cars while balancing life and work. Sunday, April 19, 2015. Wednesday, April 8, 2015. Making the porsche 911 strosek is crucial to a certain VW Touareg-based SUV, Porsche could probably slap its badge onto a moped and it has been stripped away. Do the porsche 911 strosek that most buyers end up with still feel special? Monday, April 6, 2015. Sunday, April 5, 2015. Porsche Carrera 911 Cabriolet. Cars learned that the super-focused turbocharged GT2 model junked the porsche...

retosdealtura.com

RETOS DE ALTURA

Content on this page requires a newer version of Adobe Flash Player.

retosdefamilia.blogspot.com

LA FAMILIA DE HOY

LA FAMILIA DE HOY. Jueves, 18 de abril de 2013. 5 CONSEJOS PARA ESTAR BIEN CON NUESTRA PAREJA. 1 Protege a tu Mujer / Respeta a tu Marido. La principal necesidad emocional de la mujer es sentirse protegida. Esa es la responsabilidad número uno del marido. Eso significa hacerla sentir am. Ada y apreciada en todo momento, ella es tu prioridad número uno. Http:/ www.youtube.com/watch? 2 Relacionarse Como Buenos Amigos. 3 Recuerden Las 4 Palabras Mágicas: Escuchar, Comprometerse, Reparar y Agradecer. Es esen...

retosdehoy.com

Retos de Hoy | de TodoRetos de Hoy

August 13, 2015. Go to the Archives. To see more entries. Peligros de resistencia a los antibióticos. A ellos también les llega su hora. Vacunas no son eficaces. Epidemia de gripe este año. El centro para el Control y la Prevención de Enfermedades (CDC) en los Estados Unidos anunció que la presente temporada de gripe podría ser particularmente grave dado a que las vacunas no son totalmente eficaces. Qué sucedió con las vacunas? 8220;YA ERA HORA”. Defiéndete de las prácticas engañosas y desleales.