Home » Applications » Oracle Fusion Apps & E-Business Suite » from any table can get the status of the AP invoice status (AP R12.2.2)
from any table can get the status of the AP invoice status [message #476016] Mon, 20 September 2010 13:02 Go to next message
alaa_fouad2004
Messages: 64
Registered: January 2009
Member
Dear all

from any table can get the status of the AP invoice status?

Alaa Fouad
Re: from any table can get the status of the AP invoice status [message #476062 is a reply to message #476016] Tue, 21 September 2010 03:30 Go to previous messageGo to next message
eric62
Messages: 24
Registered: January 2009
Junior Member
Hello.

I think you use package AP_INVOICES_UTILITY_PKG.

Regards,
Eric.
Re: from any table can get the status of the AP invoice status [message #476170 is a reply to message #476062] Tue, 21 September 2010 18:57 Go to previous message
skimmer333
Messages: 23
Registered: August 2010
Location: Adelaide, Australia
Junior Member
Im on R12.0.5 so not sure if the packages have changed.
However the script behind AP_INVOICES_V shows:
AP_INVOICES_PKG.GET_APPROVAL_STATUS (AI.INVOICE_ID,AI.INVOICE_AMOUNT,AI.PAYMENT_STATUS_FLAG,AI.INVOICE_TYPE_LOOKUP_CODE) APPROVAL_STATUS_LOOKUP_CODE

Cheers,
Russell H.

Edit:
Looking at the function in AP_INVOICES_PKG, the function GET_APPROVAL_STATUS calls the AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS.
The functions in the AP_INVOICES_UTILITY_PKG performs multiple checks on the invoice, so i'd suggest calling the AP_INVOICES_PKG so it passes the correct invoice status back.

[Updated on: Tue, 21 September 2010 19:52]

Report message to a moderator

Previous Topic: Creating Oracle database account for Oracle Application User
Next Topic: Data Required from Inventory Module
Goto Forum:
  


Current Time: Wed Sep 22 06:01:44 CDT 2021