AP关会计期检查的内容.docAP10»aM^U^»->AE±E^pA^IpE^Iu^AEiEzEpA>o°0£^E'■QaAE±E"EpA1E^EE-'Od^oAEtEzEpAAE^aj£ --checkifanyunconfirmedpaymentbatchesSELECT1Y1FROMap_inv_selection_criteria_allAlSC,iby_pay_SGrvicG_rQquestsIPSRrap_selected_invoices_allASIWHERE IPSR•call_app_pay_service_req_code (+) =AISC•checkrun_nameAND trune(aisc•check_date)betweeng_period_starandg_period_end_dateANDDECODE(,NULL,AISC•status,AP_PAYMENT_UTIL_PKG•get_psr_status(:Q_:request_idIPSR•payment_service_request_status))NOTIN『CONFIRMED1,'CANCELED*,*QUICKCHECK'z'CANCELLEDNOPAYMENTSJ'TERMINATED*)ANDaisc•checkrun_id=(_gtt)ANDrownum=1;——=1ISSUED1andc•future_pay_due_datebetweeng_period_start_dateand g_period_end_dateand _idin(_gtt)and rownum=1;(P_API_VERSION=>1,X_RETURN_STATUS=>p_validation_flag, P_APPLICATION_ID =>G_AP_APPLICATION_ID,P_LEDGER_ID =>g_ledger_idfP_PERIOD_NAME =>g_period_name);--xlaEy^Y^i2eAUEYOUAP_PERIOD_CLOSE_PKG•get_unposted_transactionsOD^i2eAPpAO»iAEy^Yj£---bAaDBIz^OEpAEy^<ai•invoice_num,ai•doc_sequence_value,ai•invoice_date,ai•invoice_amountfai•,aid-accounting_event_id,,aid•amo
AP关会计期检查的内容 来自淘豆网www.taodocs.com转载请标明出处.