Answer / jay

Lexical parameters are used to substitute multiple values
at runtime and are identified by a preceding ‘&’. Lexical s
can consist of as little a one line where clause to an
entire select statement

Lexical parameter is a feature used for building a dynamic
query.

Example: An example of a lexical parameter usage in a
select statement is as follows

select *
from emp
where &L_EMP; (Report can assign a value as :L_EMP:=
emp.dept = 20 and salary > 20000)

WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?

4 Answers  

---

Can functions be overloaded ?

2 Answers  

---

IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?

7 Answers   Accenture,

---

how to set org context?

3 Answers  

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

define steps of assigning items to an organization.

1 Answers   Scan Steel,

---

what are centralized and decentralized level of control of item attributes?

2 Answers   Scan Steel,

---

What are profile options?

4 Answers   Accenture,

---

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

---

What are the validations you don in .CTL file in inbound interface process?

1 Answers  

---

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

---

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers  

---