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
How do u bridge the gaps in functional understanding of AP,GL,FA. explain with some live examples.
Hi guys, any person available ap,ar material pls send me this mail.id sreenathapps09@gmail.com
I have a requirement where during the consolidation into USD (from GBP books) I want use two different exchange rates for two consolidations. Child SOB is same but the Parent SOB's are different. How can this be done in Oracle Financials? Answers will be Appreciable. Thank You.
What is the Invoicing System in Oracle R12
encumbrence set ups?
Hi I'm new in ERP - Oracle Application i appriciate if any one help me in this issue i need SQL to get badeget balance Acutal Balance Encumbrance Balance fund Avalable thanx ahmed
Can I do a payment of 50 bills on a post date. If yes, then how?
Give examples & explain the below mentioned activity. "Analyzing the documents provided by the client and thereby identifying the test cases to be tested for the application assigned (FA, AP and GL)"
What is automation of accounts payable activities (evaluated receipt settlement)?
How to support projects life cycles details?
Invoice Approval Process?
Charge Back Setups ?
what is the use of hr: security profile, while configure multiorg?
What is meaning of deprecation?
explain your project plan with exam pal? i am preparing inter view .............