ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EEA13869E053B46B63588994Y SELECT acr.receipt_number RECEIPT_NUMBER, receipt_date RECEIPT_DATE, hca.account_number CUSTOMER_NUMBER, hp.party_name PARTY_NAME, acr.currency_code CURRENCY_CODE, acr.amount RECEIPT_AMT, decode(acr.status, 'UNAPP', ABS(aps.amount_due_remaining), 0) UNAPP_AMT, decode(acr.status, 'UNID', ABS(aps.amount_due_remaining), 0) UNID_AMT, acr.work_item_assignment_date WORK_ITEM_ASSIGNMENT_DATE, fu.user_name USER_NAME, lu.meaning WORK_ITEM_STATUS FROM ar_cash_receipts_all acr, ar_payment_schedules_all aps, fnd_user fu, hz_cust_accounts_all hca, hz_parties hp, ar_lookups lu WHERE 'Y' = :p_detail AND fu.user_id = acr.cash_appln_owner_id AND acr.cash_receipt_id = aps.cash_receipt_id AND hca.party_id = hp.party_id (+) AND acr.pay_from_customer = hca.cust_account_id (+) AND acr.work_item_status_code = lu.lookup_code AND lu.lookup_type = 'WORK_ITEM_STATUS' &gc_org_id &gc_cash_appln_owner &gc_recpt_date &gc_cust &gc_work_item_status &gc_assgn_date ORDER BY RECEIPT_NUMBER AR ARWLREW AR AR تقرير مراجعة حمل العمل Application: المقبوضات Source: تقرير مراجعة حمل العمل Short Name: ARWLREW DB package: AR_WL_REW_PKG D AR Auslastung prüfen Application: Debitoren Source: Auslastung prüfen Short Name: ARWLREW DB package: AR_WL_REW_PKG F AR Etat de vérification de la charge de travail Application: Receivables Source: Etat de vérification de la charge de travail Short Name: ARWLREW DB package: AR_WL_REW_PKG US AR Work Load Review Application: Receivables Source: Work Load Review Report Short Name: ARWLREW DB package: AR_WL_REW_PKG ZHS AR 工作量复核报表 Application: 应收帐款 Source: 工作量复核报表 Short Name: ARWLREW DB package: AR_WL_REW_PKG BI Publisher &gc_assgn_date &gc_cash_appln_owner &gc_cust &gc_org_id &gc_recpt_date &gc_work_item_status :gc_assgn_date :gc_cash_appln_owner :gc_cust :gc_detail :gc_org_id :gc_recpt_date :gc_work_item_status :p_assgn_date_from :p_assgn_date_to :p_cash_appln_owner_from :p_cash_appln_owner_to :p_cust_from :p_cust_to :p_detail :p_org_id :p_recpt_date_from :p_recpt_date_to :p_work_item_status_from :p_work_item_status_to 1 10 :p_org_id LOV Oracle AR_SRS_OPERATING_UNITS Y select organization_id id, name value, null description from hr_operating_units hr where mo_global.check_access(hr.organization_id)='Y' order by value,description AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 2 20 :p_cash_appln_owner_from LOV Oracle AR_CASH_APPLN_OWNER_NAMES Y select f.user_name id, f.user_name value, f.description description from fnd_user f where ar_cao_assign_pkg.check_access(f.user_id,'N')=1 order by f.user_name AR مالك تطبيق النقدية من D Von Zahlungszuordnungsverantwortlicher F Responsable de lettrage d'encaissements - De US Cash Application Owner From ZHS 现金核销责任人自 3 30 :p_cash_appln_owner_to LOV Oracle AR_CASH_APPLN_OWNER_NAMES Y select f.user_name id, f.user_name value, f.description description from fnd_user f where ar_cao_assign_pkg.check_access(f.user_id,'N')=1 order by f.user_name AR مالك تطبيق النقدية إلى D Bis Zahlungszuordnungsverantwortlicher F Responsable de lettrage d'encaissements - A US Cash Application Owner To ZHS 现金核销责任人至 4 40 :p_recpt_date_from Date AR تاريخ الإيصال من D Von Zahlungsdatum F Date de règlement - Du US Receipt Date From ZHS 收款起始日期 5 50 :p_recpt_date_to Date AR تاريخ الإيصال إلى D Bis Zahlungsdatum F Date de règlement - Au US Receipt Date To ZHS 收款终止日期 6 60 :p_cust_from LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل من D Von Kundennummer F Numéro de client - De US Customer Number From ZHS 客户编号自 7 70 :p_cust_to LOV Oracle AR_CUSTOMER_NUMBER Y Y select cust.account_number id, cust.account_number value, null description from hz_cust_accounts cust,hz_parties party where cust.party_id=party.party_id order by cust.account_number AR رقم العميل إلى D Bis Kundennummer F Numéro de client - A US Customer Number To ZHS 客户编号至 8 80 :p_work_item_status_from LOV Oracle AR_WORK_ITEM_STATUS Y select meaning id, meaning value, null description from ar_lookups where lookup_type='WORK_ITEM_STATUS' and (end_date_active is null or end_date_active>=trunc(sysdate)) and enabled_flag='Y' order by meaning AR موقف بند العمل من D Von Aufgabenelementstatus F Statut d'élément de travail - De US Work Item Status From ZHS 工作项状态自 9 90 :p_work_item_status_to LOV Oracle AR_WORK_ITEM_STATUS Y select meaning id, meaning value, null description from ar_lookups where lookup_type='WORK_ITEM_STATUS' and (end_date_active is null or end_date_active>=trunc(sysdate)) and enabled_flag='Y' order by meaning AR موقف بند العمل إلى D Bis Aufgabenelementstatus F Statut de l'élément de travail - A US Work Item Status To ZHS 工作项状态至 10 100 :p_assgn_date_from Date AR تاريخ التخصيص من D Von Zuordnungsdatum F Date d'affectation - Du US Assignment Date From ZHS 分配日期自 11 110 :p_assgn_date_to Date AR تاريخ التخصيص إلى D Bis Zuordnungsdatum F Date d'affectation - Au US Assignment Date To ZHS 分配日期至 12 120 :p_detail LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description AR التفاصيل D Details F Détail US Detail ZHS 详细信息