What are the tables associated with Invoice?

Answer Posted / moksh

Don't consider the table aliases

the tables are:-
ap_invoices_all ai,
ap_batches_all ab,
ap_lookup_codes alc1,
ap_lookup_codes alc2,
ap_lookup_codes alc4,
ap_other_period_types aopt,
ap_recurring_payments_all arp,
ap_terms AT,
ap_system_parameters asp,
fnd_currencies fc,
fnd_document_sequences fds,
fnd_doc_sequence_categories fdsc,
gl_sets_of_books gsob,
gl_daily_conversion_types gdct,
hr_organization_units hou,
po_vendors pv,
po_vendor_sites_all pvs,
ap_awt_groups awt,
pa_projects_all pap,
pa_tasks pat,
zx_fc_business_categories_v zbc,
fnd_territories_tl fnd,
ap_distribution_sets dset,
po_headers ph,
iby_payment_methods_vl iby1,
iby_payment_reasons_vl iby2,
fnd_lookups iby3,
iby_delivery_channels_vl iby4,
fnd_lookups iby5,
iby_ext_bank_accounts ibybnk,
hz_parties hp

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of mo: security profile, while configure multiorg?

600


Explain about Localization (IND & US ) in Oracle Apps ?

2692


In Subinventories Form, how to enable the Locator Control. A message displayed when changing the drop down list "FRM-40200: Field is protected against update.

2397


Anyone provide the oracle fin/scm definetions

1894


What kind of budgets have you worked on?

1868






What is the use of hr: user type, while configure multiorg?

691


What is the use of gl set of books name, while configure multiorg?

632


What is the entry in oracle apps ap,ar,gl for following transations1.one pipe purchase at rs.1002.one pipe sales at rs.150

972


what is the meaning of purchase default and what are the types

1665


What is gap analysis, what are the pre-requisities?

717


How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.

2058


On what different real time issues you worked while doing P2P cycle implementation?

998


What do you mean by controlling buyers workload?

8897


Recurring Problem Posting i have Journals for sep 2018 that i approved but they are not available to post even though the period is open in Oracle R12 Issues

1242


Re: what are the Issue that we face in Gl,PO and AP while Supporting

1823