Answer / subrahmanyam

base tables are in Customers

Hz_parties
hz_party_sites
Hz_locations
Hz_cust_accounts
Hz_cust_site_uses_all
Hz_cust_acct_sites_all
Hz_party_site_uses

Answer / venkat kolla

Why tables.
Now we have strong APIs.
Use them

ex. hz_parties_v2pub
hz_cust_accounts_v2pub
hz_locations_v2pub

how many sections are there in report?

1 Answers  

---

What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,

---

Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---

Difference between Bind and Lexical parameters?

3 Answers  

---

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,

---

Stored procedure?

4 Answers  

---

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

0 Answers  

---

What are profile options?

4 Answers   Accenture,

---

What are different execution methods of executabls?

1 Answers   Genpact, TCS,

---

INBOUND INTERFACE: Suppose I have 100 Records of employees in flat file.When moving the records from flat file to STAGING table using .CTl file, I want to restrict the records whose salary is less than 500.what are the validations(or conditions) you write to achieve this.

2 Answers  

---

What is the package?

2 Answers  

---