Andyblg's Blog

October 9, 2012

approval status for invoice in r12

Filed under: ebs — andyblg @ 16:46
Tags: ,

list of approval status can be selected based on ap_invoices_utility_pkg.get_approval_status.

it returns:

'CANCELLED'
'APPROVED'
'NEEDS REAPPROVAL'
'NEVER APPROVED'
'UNPAID'
'FULL'
'PERMANENT'
'AVAILABLE'
'UNAPPROVED'

for displayed approval status we can use lookups like


select *
 from (select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'NLS TRANSLATION'
 and lookup_code = 'APPROVED'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'NLS TRANSLATION'
 and lookup_code = 'NEVER APPROVED'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'NLS TRANSLATION'
 and lookup_code = 'CANCELLED'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'NLS TRANSLATION'
 and lookup_code = 'NEEDS REAPPROVAL'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'PREPAY STATUS'
 and lookup_code = 'UNPAID'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'PREPAY STATUS'
 and lookup_code = 'FULL'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'PREPAY STATUS'
 and lookup_code = 'PERMANENT'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'PREPAY STATUS'
 and lookup_code = 'AVAILABLE'
 union all
 select meaning, lookup_code, language
 from FND_LOOKUP_VALUES
 where lookup_type = 'PREPAY STATUS'
 and lookup_code = 'UNAPPROVED')
 where language = 'US'

for Validation status:
http://www.shareoracleapps.com/2010/10/api-to-find-ap-invoice-status.html
MOS: Where Is The Invoice Validation Status Stored? How Is The Invoice Validation Status Determined? [ID 301806.1]

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: