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
Previous Topic: FND User Exit references
Next Topic: wat exactly Flexfield Qualifier is?
Goto Forum:
  


Current Time: Thu Dec 08 03:47:23 CST 2016

Total time taken to generate the page: 0.08593 seconds