You can apply discount on the purchase order by defining a discount type modifier.You can define discount modifier for the line level and group of line.-KH
bobayya
Jan 4th, 2006
For example for a 10% discount you multiply the amount by 0.9 etc..
for knowing the size of the database, you will calculate the size of datafile because database size is nothing your datafile size is database size.select count(*) from dba_data_files;
A concurrent program is an instance of an execution file, along withparameter definitions and incompatibilities. Concurrent programs useconcurrent program executables to locate the correct execution f...
We give Business Group name while defining Security Profile through local HR responsibility.Business Group name is required because in this way we are restricting to this business:- Organization Hiera...
While registering procedure as concurent program there we need to declare two mandatary OUT parameters in procedure.
1.Errbuf
2.Retcode
Errbuf : Errbuf is one the paramter which will define in p...
ram
Sep 20th, 2006
There is another parameter for apps procedure errbuff
Since Question is related to APPS If you want to see particular filed in particular table Go to Form, Click on that field --> press Help Button in Menu -->HistoryPopup window will show Table name
If you know the column name, you can find out what all tables the column is used. Use this SQL> Select table_name from all_tab_columns where column_name = '';
(P to P) cycle: There are different steps involved in P to P cycle they are ` S.NoStepDefined At1Define itemsInventory2Enter item informationPurchase Order3 Raise requisitionPurchase Order4R...
Try to insert/update a row into table <wf_all_user_roles> as per following statement with Role_Orig_System_id =20420select * from wf_all_user_roles where user_name = 'ZZPRASAU' and role_orig_system = 'FND_RESP'AND NOT role_name LIKE 'FND_RESP|%|ANY'
gannesunil
Mar 30th, 2007
we are not able to create table from oracle apps front end.we are suppose to create table from back end by usingAD_DD oracle package (try once)ad_dd.create table andad_dde.create column ue can use the...
In Oracle Apps, to get data from views we have to set the org id for the application so that we can fetch relevant data. This can be done using the following block : beginfnd_client_info.set_org_context( ) ;end;
ratnakar
Jan 24th, 2007
View is a virtual table we can create view by using following query Create view view_name as select * from table_namewe can select data from view by using following query.select * from view...
hi,rapid install uses some scripts ie utilites like adpreclone and adcfgclone . In this process templates r created and all the configuration files are changed and new context file are created automat...
Ans