Home » Applications » Oracle Fusion Apps & E-Business Suite » how to get the Invoice Status?
icon5.gif  how to get the Invoice Status? [message #183764] Sun, 23 July 2006 08:20 Go to next message
luaim
Messages: 3
Registered: May 2006
Location: Jordan, Amman
Junior Member
hi,

how can i retrieve the invoice status,

or how can i run AP_INVOICES_PKG.GET_APPROVAL_STATUS??

[Updated on: Sun, 23 July 2006 08:42]

Report message to a moderator

Re: how to get the Invoice Status? [message #183780 is a reply to message #183764] Sun, 23 July 2006 15:28 Go to previous message
agostino_neto
Messages: 180
Registered: July 2005
Senior Member
From Sql*Plus set org id
---
begin
dbms_application_info.set_client_info('82');
end;

select AP_INVOICES_PKG.get_approval_status(10000,null, null, null) from dual

Report message to a moderator

Previous Topic: FND User Exit references
Next Topic: wat exactly Flexfield Qualifier is?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 04:40:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.