Wednesday, 27 November 2019

AP Invoice source table in oracle apps

AP Invoice source table in oracle apps

In this post , We will be discuss about AP invoice source table in oracle apps. This Invoice source table helps to store the different AP invoice sources. AP invoice sources helps to identify the AP invoice created from which sources in oracle payable. Based on that AP Invoice source , We do differentiate the AP invoice. Here below i will share the AP Invoice source table in oracle apps and the detail sql query to find out the AP Invoice source values in oracle apps.

When we import the AP invoices from the external source , We need to given the source name to identify from which source we are importing these external invoices in to oracle apps payable.

AP Invoice source table in oracle apps

AP Invoice source table in oracle apps

In oracle apps , System store the AP invoice source values in Lookup table as below.

1.FND_LOOKUP_VALUES_VL 

 

SQL query to find out the AP Invoice source values in oracle apps.


select lookup_type,LOOKUP_CODE,ENABLED_FLAG,START_DATE_ACTIVE,MEANING,DESCRIPTION from apps.FND_LOOKUP_VALUES_VL
where lookup_type='SOURCE'

 

  AP Invoice source table in oracle apps

0 comments:

Post a Comment

Contact us for any Collaboration, Project Support & On Job Support Work

Name

Email *

Message *