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

I am created credit memo in at but while trying to complete it showing error message-hz_party_location

963

---

Can I do a payment of 50 bills on a post date. If yes, then how?

1317

---

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

1617

---

What is Work Flow of AP,AR, Sales & Purchase

2001

---

difference between primary ledger and secondary ledger in r12

1096

---

---

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

748

---

Anyone provide the oracle fin/scm definetions

1908

---

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

616

---

What is the Process of Reconciliation Between AP to GL

1165

---

what r issues faced in gl

2277

---

What are the inventory report to check inventory status.

2005

---

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

704

---

What is the meaning holding tax?

668

---

what is the use of hr: security profile, while configure multiorg?

635

---

What is gap analysis, how do you defined?

649

---