APPS.JE_ITWHYE_AP_PKG dependencies on AP_INVOICES

Line 283: FROM ap_invoice_distributions_all dist1,ap_invoices_all inv1

279: 0
280: )
281: ) exempt_amount
282: ,dist1.invoice_id
283: FROM ap_invoice_distributions_all dist1,ap_invoices_all inv1
284: WHERE dist1.invoice_id = inv1.invoice_id
285: AND dist1.line_type_lookup_code = 'ITEM'
286: -- AND dist1.awt_group_id IS NULL
287: group by dist1.invoice_id)dist

Line 288: ,ap_invoices_all inv,

284: WHERE dist1.invoice_id = inv1.invoice_id
285: AND dist1.line_type_lookup_code = 'ITEM'
286: -- AND dist1.awt_group_id IS NULL
287: group by dist1.invoice_id)dist
288: ,ap_invoices_all inv,
289: ap_invoice_payments_all aip,
290: ap_checks_all checks,
291: zx_party_tax_profile zpt --Bug 14136822
292: WHERE inv.legal_entity_id = p_legal_entity_id

Line 371: ap_invoices_all inv

367: FROM ap_awt_group_taxes_all awt
368: WHERE awt.GROUP_ID IN (
369: SELECT DISTINCT dist.awt_origin_group_id
370: FROM ap_invoice_distributions_all dist,
371: ap_invoices_all inv
372: WHERE dist.invoice_id = inv.invoice_id
373: AND dist.line_type_lookup_code ='AWT'
374: AND inv.invoice_id = p_invoice_id
375: );

Line 592: from ap_invoices inv

588: decode(inv.invoice_currency_code,inv.payment_currency_code, l_amount_etrd, l_amount_paid)
589: into l_inv_gctot_amt,
590: l_inv_whtot_amt,
591: l_pay_amount
592: from ap_invoices inv
593: where inv.invoice_id = cur_withholding_extract_rec.invoice_id;
594:
595: fnd_file.put_line(fnd_file.log,'l_inv_gctot_amt:'||l_inv_gctot_amt);
596: fnd_file.put_line(fnd_file.log,'l_inv_whtot_amt:'||l_inv_whtot_amt);

Line 624: ap_invoices_all inv

620: FROM ap_awt_group_taxes_all awt
621: WHERE awt.GROUP_ID IN (
622: SELECT DISTINCT dist.awt_origin_group_id
623: FROM ap_invoice_distributions_all dist,
624: ap_invoices_all inv
625: WHERE dist.invoice_id = inv.invoice_id
626: AND dist.line_type_lookup_code ='AWT'
627: AND inv.invoice_id = cur_withholding_extract_rec.invoice_id
628: );

Line 694: ap_invoices inv1,

690: ln_irpef_wthamount,
691: lc_irpef_vendor_name
692: FROM ap_invoice_distributions dist,
693: ap_tax_codes atc,
694: ap_invoices inv1,
695: ap_awt_tax_rates awt,
696: ap_suppliers aps
697: WHERE dist.invoice_id = inv1.invoice_id
698: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id

Line 746: ap_invoices inv1,

742: ln_inps_wthamount,
743: lc_inps_vendor_name
744: FROM ap_invoice_distributions dist,
745: ap_tax_codes atc,
746: ap_invoices inv1,
747: ap_awt_tax_rates awt,
748: ap_suppliers aps
749: WHERE dist.invoice_id = inv1.invoice_id
750: AND inv1.invoice_id = cur_withholding_extract_rec.invoice_id

Line 804: FROM ap_invoices_all apinv_sub,

800:
801: BEGIN
802: SELECT DISTINCT apinv_sub.invoice_num
803: INTO ln_inv_num
804: FROM ap_invoices_all apinv_sub,
805: ap_invoice_distributions_all apdist1_sub,
806: ap_invoice_distributions_all apdist2_sub
807: WHERE apdist2_sub.invoice_id = cur_withholding_extract_rec.invoice_id
808: AND apdist2_sub.invoice_distribution_id =