APPS.JE_ITWHYE_AP_PKG dependencies on AP_INVOICES_ALL

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 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 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 =