Search results for query: *

Check ap_invoices_All table

You can refer to metalink.oracle.com or the Implementation guide for 11i /Data Upgrade for Sales order

Hi Ronbo3554, I have tried to save the report output as an html page and report formatting remains the same atleast for html page. Instead of saving Reports Preview use File-> Administration->Generate Docs.. I donot remember its exact name. But this particular option of 'Generate' has 4-5...

Hi tyb : I would think your issues table would also be looking as receipts e.g : -Except of course date and time would be changed Receipt Sr# Date Qty Rate 1. 09-29-04 1,000 6.50 2. 09-30-04 1,500 8.00 3. 10-02-04 800 5.50 Q: do you want to keep track...

I am not sure of how it works in VB but for Oracle forms as fron end -if you have to get the no. of elements present in the List box, You have an option of GET_LIST_ELEMENT_COUNT(list_id); Where you first find what is the Id corresponding to the list item defined thru' (ithink...

ORacle Apps does not provide any functionality for 'CALL FORM' . In fact it strictly advises against using CALL FORM. Instead it recommends to use 'FND_FUNCTION_EXECUTE' which uses OPEN FORM (form built in). Rgds Lavanya

Hi Justin Have you set any break order on any of the columns displayed??? and can you specify the query.. Rgds Lavanya

Hi, To answer your Q: Any table which ends with "_tl " means it is used for translation purpose. And hence you see many records in the backend corresponding to the same id in different languages. The front end language actually corresponds to the language which it is set. Which...

Are you running "Transaction Import" in Projects module to transfer the data from Payables to Projects ? If yes then PA transaction import generates a report which indiciates whether the data being imported is successfully. It shall be considered successful if there is no data in...

Hi Naveen, What do you want to know about Performance Tuning. Are you referring to a)Tuning of SQL statements b) Or you want to learn about Performance tuning and hence a reference book sought of. Regards Lavanya

Hi girivasan, try setting the property 'Print Object On' of the field to 'LAST PAGE' --Hope this helps.

Hi, If I understand your requirement correctly : a) f1 and f2 are 2 fields then : You need sum of f1 and f2 If this is the requirement. write a formula column that returns sUM(f1,f2). But this shall be running total i.e if f1 and f2 change value then formula column value also should change...

Hi , You can try writing a format trigger where you check if the address Line2 is NULL. Return False when NULL else return true. Hope this helps

Hi , Please check the Where condition : where m1.account_id = 'a1' and m1.account_id = 'a2' and m1.account_id = 'a3 a1,a2,a3 are account id and are being used as an alias name to the account_id from the table tblbillxtract . By...

Hi nguyenb9 , Please find the Query for the output desired: SELECT distinct m1.account_id ,lsdm1||'/'||lsdm2||'/'||lsdm3 lsdm from (select distinct lsdm lsdm1,account_id a1 from mytable where lsdm='UNEP') , (SELECT distinct lsdm lsdm2,account_id a2 from...