Answer Posted / m.n

declare
v_query VARCHAR2 (200);
v_inv_item_id VARCHAR2 (50);
BEGIN
v_query := 'SELECT inventory_item_id from
mtl_onhand_quantities_detail where inventory_item_id =107';
EXECUTE IMMEDIATE v_query
INTO v_inv_item_id;
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
exception
when others then
DBMS_OUTPUT.put_line ('inventory_item_id ' ||
v_inv_item_id);
END;

how to print multi lay outs,muti currency,muti language in xml publisher

12301

---

what is pay run id ?

2203

---

Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

2133

---

Tell me how to debug the report?

1127

---

please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in

3666

---

Do you know what are user profiles in apps. Any examples you can give?

1098

---

What is a value set? List its various types.

1103

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

2112

---

what are the prerequisites for costing transactions?

3145

---

Which oracle applications pl/sql standard apis you are familiar, have you used most of them?

1123

---

How to create a purchase order without a requisition?

1203

---

Do you know where we can check the status of po?

1293

---

Plz anybody send me Technical specification for AP Interface

2569

---

can we get profile values in report without using user exists is it possible how?

2888

---

What does appl_top directory contain?

1133

---