Oracle Apps Reports

[venkatxmi]

Please If anybody can help me out for how to use the temporary tables in reports. And how to manipulate data in temporary tables in reports.
How to delete data from the temporary tables after report execution.

[ahmadbilal]

You can populate or create table by writing code in <b>before report</b> trigger
i am just adding a small example here
function BeforeReport return boolean is
begin

delete from temp;
/* You can also write here create statement */
commit;


insert into temp (SELECT '200'||';'||splno||';'||TO_CHAR(P_DATE,'DDMMYYYY')||';'||'KOOR'||';'||'30295'||';'||lpad(pO_iD,8,'0')||';'
FROM CONTRACT C,PACKING_LIST P
WHERE C.CON_ID = P.CON_ID
AND P.PL_NO = PLNO);
commit;


return (TRUE);
end;