User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
Problem with query
Thu, 04/16/2009 - 2:40am
Hi,
I have a problem with a query in a delivered SQR which looks some thing like this
begin-select
field1
field2
.
.
FROM [PS_JRNL_HEADER_FS A, PS_JRNL_LN_FS B,:$HEADER_AND_LINE_REC] [$Rec_Alt_Account]
where
Could any help me understand how the From clause works here
Many Thanks,
Vamsi
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
Which delivered SQR is this? I'm on HR but cannot find the string '$HEADER_AND_LINE_REC' in searching through the delivered sqr's and sqc's.
Normally the []'s will substitute/interpret an actual value for the $ variable. The colon (:) in front of the variable normally is a returned/passed value from a function though I have never seen it used in a from clause before. If you can provide the sqr I'll take a look at it some more.
Hi oddnsends,
This is an SQR in finance. The delivered finance sqr is fin2002.sqr
Thanks,
Vamsi Krishna
Post new comment