important Query links r12

1.   Query which gives the joining between om, wsh, ar tables

2.   po approval history query in oracle apps

3.   how to create supplier as a customer in r12

4.   query to find out responsibilities assigned to a user

5.   what are the major difference between oracle 11i and r12 ?

6.   oracle api for lookup code and value creation

7.   query for employee information: oracle apps employee data extract

8.   profile option values for responsibility

9.   query to check rtp stuck records in r12

10.       supplier master details in r12 query

11.       po created and receipt not done,for partially received pos

12.       inv period closing important queries r12

13.       query to finde orders with no stock for shipping in r12

14.       query to find orders for specific item in r12

15.       query to check inventory periods status

16.       query to find receipt details based on po number in r12 po and rcv link po and receipt

17.       query to check discrepancy in stock r12 stock discrepancy

18.       to get the time of the particular ,to get the current time of the db

19.       query to find templates details xml publisher reports

20.       query to find complete supplier details bank ,tax address and accounting information

21.       query to compare responsibility between users

22.       query to find list of responsibilities assigned to a particular user

23.       query to find requisitions approval pending

24.       query to find person and position r12 , link between per_all_people and per_all_positions

25.       query to find the owner name of the table

26.       query to find organization information ,tables and links ,organization_id based on ship to branch plant

27.       material transactions query

28.       query to find form attached to responsibility and users

29.       query to find costing error date wise

30.       concurrent program is running more than once in same timing

31.       query to concurrent program running and status checking with parameters

32.       query to find concurrent job run time

33.       query to find concurrent program attached to which responsibility

34.       cogs query r12 ,cost of goods sold, cogs query oracle apps 12

35.       query to find pos which not used blanket purchase agreement

36.       active organization query r12 based on material transactions

37.       accruals query , po accruals r12 query

38.       plsql important question and answers

39.       plsql interview questions part 4,

40.       po requisition and purchase order po req link to po

41.       how to check workflow status from backend workflow status workflow activity_status

42.       interface trip stop functionality,interface trip stop program technical details , its program

43.       po position hierarchy in oracle apps

44.       po requisition and purchase order po req link to po

45.       Complete Order to Cash(O2C) Techno-Functional flow in R12 order to cash o2c flow o2c Query R12 joining between OM, WSH, AR Tables

46.       RANK, DENSE_RANK, FIRST and LAST Analytic Functions

47.       R12 TCA (TRADING COMMUNITY ARCHITECTURE)