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
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
please explain with examples the below mentioned "Creating the end to end business scenarios and executing the scenarios to perform the regression testing".
how to do customization while doing oracle implementation. what is the role of functional consultant in customization?
can we define 2 different currency revaluation at a time??
1.what is the name of program to create invoice automatic from po.? 2.How to auto upload the bank statement? 3.PO tax has not flown to invoice . why? Debit memo not generated for return of goods.??
What is gap analysis, how do you defined?
What is the Use of Grouping Rule in Receivables ? is it mandatory field ?
What is multi org? What is difference between 11i and 12i multi org structure?
How to support projects life cycles details?
Explain about Localization (IND & US ) in Oracle Apps ?
What is difference between primary and secondary ledger
Re: what are the Issue that we face in Gl,PO and AP while Supporting
What is meaning of deprecation?
I am working on PPR process to print checks. Currently the checks are printing for each supplier, supplier site and payment method group. My requirement is the invoice level one DFF is available (like A and B are the input values). Please let me know how include this DFF at invoice grouping level.
While assigning the security by book in oracle assets..i am unable ot get the asset org in security profile form.This asset org was already defined in org description window.