APPS.JE_IL_TAX_PKG dependencies on AP_INVOICES_ALL

Line 42: FROM ap_invoices_all ai,

38: -- constant for payment details
39: --------------------------------------------------------------------------------
40: C_PAYMENT_INFO_QUERY VARCHAR2(8000) :=
41: 'SELECT aag.name awt_group_name, ''A'' awt_flag
42: FROM ap_invoices_all ai,
43: ap_invoice_payments_all aip,
44: ap_awt_groups aag,
45: ap_checks_all ac
46: WHERE ac.check_id = :check_id

Line 417: FROM ap_invoices_all ai,

413: SUM(nvl(nvl(aid.base_amount, aid.amount) *-1, 0))) < 0
414: THEN 0
415: ELSE 1
416: END) countv
417: FROM ap_invoices_all ai,
418: ap_invoice_distributions_all aid,
419: ap_checks_all ac,
420: ap_invoice_payments_all aip,
421: po_vendors pvend,

Line 461: FROM ap_invoices_all ai

457: THEN 0
458: ELSE 1
459: END ) countv,
460: COUNT(distinct(ac.vendor_site_id)) countt
461: FROM ap_invoices_all ai
462: ,ap_invoice_distributions_all aid
463: ,ap_checks_all ac
464: ,ap_invoice_payments_all aip
465: WHERE ai.invoice_id = aid.invoice_id

Line 665: ap_invoices_all ai

661: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
662: SELECT ai.invoice_id invoice_id
663: FROM ap_invoice_payments_all aip,
664: ap_invoice_distributions_all aid,
665: ap_invoices_all ai
666: WHERE ai.invoice_id = cn_invoice_id
667: AND ai.invoice_id = aip.invoice_id
668: AND aip.invoice_id = aid.invoice_id
669: AND aid.line_type_lookup_code = 'AWT'

Line 832: FROM ap_invoices_all WHERE invoice_id = ln_invoice_id;

828: ln_gross_amount := ln_gross_amount * ln_sign;
829:
830: BEGIN
831: SELECT invoice_type_lookup_code INTO lv_invoice_type
832: FROM ap_invoices_all WHERE invoice_id = ln_invoice_id;
833: EXCEPTION
834: WHEN others THEN
835: lv_invoice_type := 'STANDARD';
836: END;

Line 886: ap_invoices_all ai

882: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
883: SELECT ai.invoice_id invoice_id
884: FROM ap_invoice_payments_all aip,
885: ap_invoice_distributions_all aid,
886: ap_invoices_all ai
887: WHERE ai.invoice_id = cn_invoice_id
888: AND ai.invoice_id = aip.invoice_id
889: AND aip.invoice_id = aid.invoice_id
890: AND aid.line_type_lookup_code = 'AWT'

Line 997: select count(1) into v_tot_cnt from ap_invoices_all where invoice_id in (

993: */
994:
995: if t=0 then
996:
997: select count(1) into v_tot_cnt from ap_invoices_all where invoice_id in (
998: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id);
999:
1000: select count(1) into v_cre_cnt from ap_invoices_all where invoice_id in (
1001: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id)

Line 1000: select count(1) into v_cre_cnt from ap_invoices_all where invoice_id in (

996:
997: select count(1) into v_tot_cnt from ap_invoices_all where invoice_id in (
998: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id);
999:
1000: select count(1) into v_cre_cnt from ap_invoices_all where invoice_id in (
1001: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id)
1002: and INVOICE_TYPE_LOOKUP_CODE = 'CREDIT';
1003:
1004: if nvl(v_tot_cnt,0) > nvl(v_cre_cnt,0) then

Line 1006: select 'N' into v_temp from ap_invoices_all where invoice_id = pn_invoice_id

1002: and INVOICE_TYPE_LOOKUP_CODE = 'CREDIT';
1003:
1004: if nvl(v_tot_cnt,0) > nvl(v_cre_cnt,0) then
1005: begin
1006: select 'N' into v_temp from ap_invoices_all where invoice_id = pn_invoice_id
1007: and INVOICE_TYPE_LOOKUP_CODE = 'CREDIT';
1008: exception when others then
1009: v_temp := 'Y';
1010: end;