Friday, 2 October 2015
WHEN-NEW-FORM-INSTANCE trigger in oracle forms
WHEN-NEW-FORM-INSTANCE trigger will work when you are opening form this will fetch all records available in your table and fetch into your block.
go_block('XXCAD_SR_REFUND_NOTIFICATIONS');
if :XXCAD_SR_REFUND_NOTIFICATIONS.task_status = 'Open'
then
do_key('execute_query');
else
fnd_message.set_string ('There is no Open SRs in your Bin');
fnd_message.show;
end if;
Subscribe to:
Posts (Atom)
Script to update salespersons customer site wise in oracle apps R12
SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'DEENA VISION%'; SELECT * FROM HZ_CUST_ACCOUNTS_ALL WHERE PARTY_ID =94043 ; SE...
-
I faced some issues when I query the below table data is not fetching in my query: SELECT * FROM hr_operating_units SELECT * FROM MTL_CAT...
-
For this error need to Check RTF template there should be tags are not correctly and if you are developing new RTF latest version. Just se...
-
select * from all_objects where object_name like 'GME%BATCH%' and object_type = 'TABLE' --------------------------------...