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 many schemas we have? how many you have used?

1603

---

What is a flexfield? List out its types.

656

---

Can you explain the difference between architecture followed in 10g & 11g?

650

---

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2083

---

what are the balancing segments in AR?

1642

---

---

Can you define an erp system?

670

---

tell my any difficult situtation you solved in your experience in your company?

1864

---

is it possible to run the interface without using oracle apps?

1512

---

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

1884

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2121

---

What does appl_top directory contain?

639

---

What is a value set? List its various types.

646

---

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

1640

---

where to define interorganization transaction charges and what are the different options?

1942

---

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

1974

---