[Home] [Help]
82: 'Y', AI.exclusive_payment_flag, 'N'),
83: asp.interest_accts_pay_ccid,
84: ai.org_id
85: FROM ap_interest_periods,
86: ap_invoices AI, --Bug6040657. Changed from ap_invoices_all to ap_invoices
87: ap_selected_invoices_all ASI,
88: po_vendors pov,
89: ap_system_parameters_all asp
90: WHERE ASI.checkrun_id = P_checkrun_id
344: checkrun_id,
345: payment_currency_code)
346: SELECT
347: P_checkrun_name,
348: ap_invoices_s.NEXTVAL,
349: l_vendor_id,
350: l_site_id,
351: l_int_vendor_num,
352: l_int_vendor_name,
616: ps.due_date,
617: ps.discount_amount_available,
618: ps.discount_date
619: FROM ap_supplier_sites_all sites,
620: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
621: ap_payment_schedules ps,
622: ap_suppliers suppliers,
623: hz_parties hz
624: where inv.invoice_id = ps.invoice_id
964: ipm.support_bills_payable_flag, -- Bug 5357689, 5479979
965: (trunc(aps.due_date) + nvl(ipm.maturity_date_offset_days,0)) due_date -- Bug 5357689
966: --Bug 543942 added NVL in the above scenario
967: from ap_selected_invoices_all asi,
968: ap_invoices ai, --Bug6040657. Changed from ap_invoices_all to ap_invoices
969: ap_inv_selection_criteria_all aisc,
970: ap_payment_schedules_all aps,
971: fv_tpp_assignments_v fv, --5017076
972: iby_payment_methods_vl ipm -- Bug 5357689
1989: ,inv.org_id org_id
1990: ,inv.payment_currency_code payment_currency_code
1991: ,ps.external_bank_account_id external_bank_account_id
1992: ,inv.legal_entity_id legal_entity_id
1993: /* Bug 5192018 we will insert global attribute values from ap_invoices table */
1994: ,inv.global_attribute1 global_attribute1
1995: ,inv.global_attribute2 global_attribute2
1996: ,inv.global_attribute3 global_attribute3
1997: ,inv.global_attribute4 global_attribute4
2039: ,Null payment_exchange_rate_type
2040: ,Null payment_exchange_date
2041: FROM ap_supplier_sites_all sites,
2042: ap_suppliers suppliers,
2043: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2044: ap_payment_schedules_all ps,
2045: ap_system_parameters_all asp,
2046: hz_parties hzp,
2047: hz_party_sites hzps, -- Bug 5620285
2103: AND nvl(hzps.location_id,-99) = hzl.location_id (+) -- Bug 5620285
2104: --End of 5929034
2105: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,
2106: p_check_date, due_date, ps.discount_amount_available, ps.discount_date) = 'Y'
2107: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in
2108: ('NOT REQUIRED','WFAPPROVED','MANUALLY APPROVED')
2109: AND (p_inv_batch_id IS NULL OR
2110: (p_inv_batch_id IS NOT NULL AND inv.batch_id = p_inv_batch_id))
2111: AND inv.vendor_id = nvl(p_inv_vendor_id,inv.vendor_id)
2147: FROM ap_holds H
2148: WHERE H.invoice_id = inv.invoice_id
2149: AND H.release_lookup_code is null)
2150: AND NOT EXISTS (SELECT 'Invoice is not fully approved'
2151: FROM ap_invoices_derived_v AIDV
2152: WHERE AIDV.invoice_id = inv.invoice_id
2153: AND AIDV.approval_status_lookup_code IN
2154: ('NEVER APPROVED', 'NEEDS REAPPROVAL', 'UNAPPROVED'))
2155: AND EXISTS (SELECT 'Distributions exist'
2283: ,inv.org_id org_id
2284: ,inv.payment_currency_code payment_currency_code
2285: ,ps.external_bank_account_id external_bank_account_id
2286: ,inv.legal_entity_id legal_entity_id
2287: /* Bug 5192018 we will insert global attribute values from ap_invoices table */
2288: ,inv.global_attribute1 global_attribute1
2289: ,inv.global_attribute2 global_attribute2
2290: ,inv.global_attribute3 global_attribute3
2291: ,inv.global_attribute4 global_attribute4
2333: ,Null payment_exchange_rate_type
2334: ,Null payment_exchange_date
2335: FROM ap_supplier_sites_all sites,
2336: ap_suppliers suppliers,
2337: ap_invoices inv, --Bug6040657. Changed from ap_invoices_all to ap_invoices
2338: ap_payment_schedules_all ps,
2339: ap_system_parameters_all asp,
2340: hz_parties hzp,
2341: hz_party_sites hzps, -- Bug 5620285
2397: AND nvl(hzps.location_id,-99) = hzl.location_id(+) -- Bug 5620285
2398: --End Bug 5929034
2399: AND fv_econ_benf_disc.ebd_check(p_checkrun_name, inv.invoice_id,
2400: p_check_date, due_date, ps.discount_amount_available, ps.discount_date) = 'Y'
2401: AND AP_INVOICES_PKG.get_wfapproval_status(inv.invoice_id, inv.org_id) in
2402: ('NOT REQUIRED','WFAPPROVED','MANUALLY APPROVED')
2403: AND (p_inv_batch_id IS NULL OR
2404: (p_inv_batch_id IS NOT NULL AND inv.batch_id = p_inv_batch_id))
2405: AND inv.vendor_id = nvl(p_inv_vendor_id,inv.vendor_id)
3606: * (PS.AMOUNT_REMAINING / DECODE(PS.GROSS_AMOUNT,
3607: 0, 1,
3608: PS.GROSS_AMOUNT))))
3609: FROM ap_payment_schedules_all PS,
3610: ap_invoices ai --Bug6040657. Changed from ap_invoices_all to ap_invoices
3611: WHERE PS.invoice_id = asi.invoice_id
3612: AND PS.payment_num = asi.payment_num
3613: and ai.invoice_id = ps.invoice_id)
3614: WHERE checkrun_id = l_checkrun_id;