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.
Oracle Apps Reports
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
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;
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;
Who is online
Users browsing this forum: No registered users and 8 guests