ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EE913869E053B46B63588994Y SELECT aicrg.cash_receipt_id CASH_RECEIPT_ID ,aicrg.receipt_number RECEIPT_NUMBER ,aicrg.receipt_date RECEIPT_DATE ,aicrg.receipt_status RECEIPT_STATUS ,aicrg.document_number DOCUMENT_NUMBER ,aicrg.receipt_amount RECEIPT_AMOUNT ,aicrg.currency CURRENCY ,aicrg.credit_card_no CREDIT_CARD_NO ,aicrg.credit_card_type CREDIT_CARD_TYPE ,aicrg.maturity_date MATURITY_DATE ,aicrg.method_name METHOD_NAME ,aicrg.bank_account BANK_ACCOUNT ,aicrg.bank_name BANK_NAME ,aicrg.bank_branch_name BANK_BRANCH_NAME ,aicrg.customer_name CUSTOMER_NAME ,aicrg.customer_number CUSTOMER_NUMBER ,aicrg.tax_registration_number TAX_REGISTRATION_NUMBER ,aicrg.name NAME ,aicrg.cust_account_id CUST_ACCOUNT_ID ,aicrg.cust_acct_site_id CUST_ACCT_SITE_ID ,aicrg.address_line1 ADDRESS_LINE1 ,aicrg.address_line2 ADDRESS_LINE2 ,aicrg.city CITY ,aicrg.postal_code POSTAL_CODE ,aicrg.copy_or_original COPY_OR_ORIGINAL ,aicrg.user_name USER_NAME ,aicrg.cust_tax_registration_num CUST_TAX_REGISTRATION_NUMBER FROM AR_IL_CASH_RECEIPTS2_GT aicrg AR ARCRPRRPT AR AR طباعة الإيصال في إسرائيل Application: المقبوضات Source: طباعة الإيصال في إسرائيل Short Name: ARCRPRRPT DB package: AR_CASH_RECEIPT_PRINT_PKG D AR Zahlungen drucken - Israel Application: Debitoren Source: Zahlungen drucken - Israel Short Name: ARCRPRRPT DB package: AR_CASH_RECEIPT_PRINT_PKG F AR Israël - Impression d'encaissement Application: Receivables Source: Israël - Impression d'encaissement Short Name: ARCRPRRPT DB package: AR_CASH_RECEIPT_PRINT_PKG US AR Israeli Receipt Print Application: Receivables Source: Israeli Receipt Print Short Name: ARCRPRRPT DB package: AR_CASH_RECEIPT_PRINT_PKG ZHS AR 以色列收款打印 Application: 应收帐款 Source: 以色列收款打印 Short Name: ARCRPRRPT DB package: AR_CASH_RECEIPT_PRINT_PKG BI Publisher :p_copy_or_original :p_customer_id :p_doc_seq_value_from :p_doc_seq_value_to :p_end_date :p_receipt_from :p_receipt_to :p_start_date 1 10 :p_copy_or_original LOV Oracle AR_PRINT_COPY_OR_ORIGINAL Y select ffvv.flex_value id, ffvv.flex_value value, ffvv.flex_value_meaning||nvl2(ffvv.description,': '||ffvv.description,null) description from fnd_flex_values_vl ffvv where ffvv.flex_value_set_id=1023519 order by ffvv.flex_value Y AR طبعة النسخة أو الأصل D Kopie oder Original drucken F Imprimer une copie ou l'original US Print Copy or Original ZHS 打印副本或原始收据 2 20 :p_start_date Date AR من تاريخ D Von Datum F Date - Du US From Date ZHS 自日期 3 30 :p_end_date Date AR إلى تاريخ D Bis Datum F Date - Au US To Date ZHS 至日期 4 40 :p_receipt_from LOV Oracle AR_REC_NUM_WITHOUT_MISC_UNAPP Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts_all cr2 where cr.receipt_number=cr2.receipt_number) and cr.status not in ('UNAPP','UNID') and cr.type!='MISC' order by cr.receipt_number,cr.cash_receipt_id AR رقم الإيصال من D Von Zahlungsnummer F Numéro de règlement - De US Receipt Number From ZHS 收款编号自 5 50 :p_receipt_to LOV Oracle AR_REC_NUM_WITHOUT_MISC_UNAPP Y select cr.receipt_number id, cr.receipt_number value, null description from ar_cash_receipts cr where cr.cash_receipt_id in (select max(cr2.cash_receipt_id) from ar_cash_receipts_all cr2 where cr.receipt_number=cr2.receipt_number) and cr.status not in ('UNAPP','UNID') and cr.type!='MISC' order by cr.receipt_number,cr.cash_receipt_id AR رقم الإيصال إلى D Bis Zahlungsnummer F Numéro de règlement - A US Receipt Number To ZHS 收款编号至 6 60 :p_doc_seq_value_from LOV Oracle AR_DOCUMENT_NUMBER Y select cr.doc_sequence_value id, cr.doc_sequence_value value, null description from ar_cash_receipts cr where cr.status in ('APP','REV','NSF','STOP') and cr.confirmed_flag='Y' order by value,description AR رقم المستند من D Von Belegnummer F Numéro de document - De US Document Number From ZHS 单据编号自 7 70 :p_doc_seq_value_to LOV Oracle AR_DOCUMENT_NUMBER Y select cr.doc_sequence_value id, cr.doc_sequence_value value, null description from ar_cash_receipts cr where cr.status in ('APP','REV','NSF','STOP') and cr.confirmed_flag='Y' order by value,description AR رقم المستند إلى D Bis Belegnummer F Numéro de document - A US Document Number To ZHS 单据编号至 8 80 :p_customer_id LOV Oracle AR_CC_CUSTOMER_NAME Y select cust_acct.cust_account_id id, party.party_name value, cust_acct.account_number description from hz_cust_accounts cust_acct,hz_parties party where cust_acct.party_id=party.party_id order by party.party_name AR العميل D Kunde F Client US Customer ZHS 客户