Can anyone tell me why in some tables in AR , AP, GL modules they r using int_all after every table2 9025
how to find out one organization using multi-org or single org?5 11117
What is Cross Journal?1 6537
whichever documents prepaired by the FUNCTIONAL CONSULTANT while implementing project by using AIM.8 10575
what is internal retairment?1 1306
Hi Friends!! I've completed my MBA in Finance and Systems and currently working in a Staffing firm. Recently I've joined in Oracle Apps training institute and can anyone let me know whether there are any chances of getting a job as a fresher. Please help me!!7 6988
what is orchitecture of oracle apps 11i and R12 ?1 8983
Is the multiple SOB architecture (MSOBA)supported in 11i ?1 3711
Can i assign a supplier type of bank account to more than one supplier ?5 10967
How many key flexfield in Receivables ?5 20522
Let me know to Support projects life cycles details?2 5188
What is receipt class & receipt source pls let me know2 6771
When we run the translation we can give only one rate type, then how can we run it for two different exchange rates?2 4833
how to load ap invoice from legacy to our system and should show the paid invoice as paid and un paid as unpaid3 2759
Can any tell me about R2R FINANCIAL PROCESS?5 66389
in transfer funds module, how you come to know that amount has been transferred successfully or not....explain in detail
how to create automation frame work ?
please send the drdo exam paper
What are the applications of different multistage amplifiers?Plz also write advantages of these amplifiers? Thaaaaaaaaanx
Is IS 2062 different from ASTM A 36 or both are almost same
In dcs panel we are using diff type of modules ?what is module ? what is the use of modules ?diff type of module?
What is the purpose of increasing the pressure on the F.O. system of the engine?
Hai anyone please "Explain about Framework in QTP?"
Hi, I am new in oracle(SQL), could anyone help me in writing a correct SQL. Below is the table structure. Table: Subsc Fields: 1. Sub_no (this field will hold values of subscriber nos, for e.g. S111111, S222222, S333333, S444444, etc.) 2. s_status (this field will hold values for different status of subscriber, for e.g. 'A', 'S', 'C', etc.) 3. cus_id (this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) Table: Bill Fields: 1. Bill_no this field will hold values of bill nos for e.g. 11111111, 22222222, 33333333, 44444444, etc.) 2. b_status = (this field will hold values for different status of bill for e.g. 'O', 'C', 'S', etc.) Note: 1. The Sub_no is a Primary key of Subsc table. 2. The cus_id is a foreign in Subsc table (referred from Bill_no field of Bill table) 3. The Bill_no field is the Primary key of Bill table. Query A --> I wrote a query to select cus_id/Bill_no which is in status open (b_status = 'O') and having more than two active subscriber (i.e. S_status = 'A') in it ( i.e. more the two subscribers in same bill). select s.cus_id from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id having count(sub_no) = 2 Problem : The above query will give the cus_id (or rather bill_no) which are in open status (b_status ='O) and which are having TWO ACTIVE Subscribers (s_status ='A') in it. However, this query will also lists the cus_id/bill_no which are having more than TWO subscribers in it (but only two subscriber will be in Active status (s_status = 'A') and the others will be in s_status = 'C' or s_status = 'S'. Help needed: I want to write a query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it. B--> If I include the sub_no in the above query then NO row are returned. select s.cus_id, s.sub_no from subsc s where exists (select 1 from bill where bill_no = s.cus_id and b_status = 'O') and s_status = 'A' group by s.cus_id, s.sub_no having count(sub_no) = 2 Help needed: I want to modify the above query which will fetch ONLY the cus_id/bill_no which are in open status (b_status ='O') and which are having ONLY TWO ACTIVE subscribers (s_status ='A') in it ALONG with the sub_no. Thanks a lot in advance. Regards, Nitin
is below 2 ohms earth resistance is good for mobile tower
what is the difference between testing techniques and principles of testing?Kindly explain both of them with an example.
suppose the price elasticly of demand for text books is two and the price of the texr book is increased by 10%.by how much does the quantity demand fall? inter result & discuss resons for the fall in quantity demand?
How to Determine if a given printer is capable of printing a PostScript file?
is there any phase difference occurs while primary and secondary side mutual induction occurs?
Why grounding is necessary? Give example with diagram.