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;

what are the different transaction clauses in AR?

2054

---

please send me forms, xml pulisher questions,answers

2067

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

2168

---

Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com

2313

---

Is soa a part of oracle fusion middleware?

1037

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

2162

---

What do you understand by concurrent programs?

1037

---

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

2826

---

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

2332

---

How can we import the data into a database using sql * loader?

1123

---

What does appl_top directory contain?

1078

---

What is instead of trigger in where we will use?

1124

---

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

2043

---

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

2071

---

Are you familiar with internet architecture of oracle apps 11i?

1015

---