Answer / ashok

Through NVL function.

select * from FND_User a
where user_name = nvl(:User_Name, a.user_name)

Answer / ahmed mazen

select * from fnd_user a
where (a.user_name = :user_name or :user_name is null)

what is instead of trigger. what is the use of that?

3 Answers  

---

types of invoices?

7 Answers   BelAir Store, Convergys, Wings Biotech,

---

Tell me some errors names and number what u got while developing the reports?

1 Answers  

---

Hoe to skip middle of the record by using SQL*Loader?

5 Answers  

---

differentiate between intra & inter UOM class conversion with examples.

1 Answers   Scan Steel,

---

Is that Possible To create package Overloading , If Yes Give any Examples

1 Answers   PWC,

---

how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  

---

What is Formula Column?

4 Answers  

---

while doing the process of conversion if got any data error out what is the next step to reprocess

1 Answers  

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

what are the prerequisites for costing transactions?

0 Answers   Scan Steel,

---

35—how to create ldt lct files? 36—how to tranfor on file from one instance to another instance?

2 Answers   Accenture,

---