ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223EF643869E053B46B63588994 select cidv.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, cidv.INVENTORY_REVISION REVISION, substr(msi.description,1,45) ITEM_DESCRIPTION, msi.concatenated_segments INVENTORY_ITEM, cidv.SERIAL_NUMBER SERIAL_NUMBER, cidv.LOT_NUMBER LOT_NUMBER, cidv.QUANTITY QUANTITY, cidv.INV_ORGANIZATION_ID ORGANIZATION_ID, cidv.PA_PROJECT_ID PROJECT_ID, cidv.PA_PROJECT_TASK_ID TASK_ID, to_char(cidv.TRANSACTION_DATE,'dd-mon-yy') TRANSACTION_DATE, cidv.SOURCE_TRANSACTION_DATE SOURCE_TRANSACTION_DATE, ppf.person_id PERSON_ID, ppf.full_name FULL_NAME, houv.name ORGANIZATION_NAME, pt.task_number TASK_NUMBER, ppa.segment1 PROJECT_NUMBER from per_people_f ppf, hr_organization_units_v houv, pa_tasks pt, pa_projects_all ppa, mtl_system_items_kfv msi, csi_inst_txn_details_v cidv where houv.name = nvl(:p_organization_name,houv.name) AND ppa.segment1 = nvl(:p_project_number, ppa.segment1) AND pt.task_number = nvl(:p_task_number, pt.task_number) AND msi.concatenated_segments = nvl(:p_inv_item, msi.concatenated_segments) AND cidv.inv_master_organization_id = houv.organization_id AND ppf.person_id(+) = cidv.transacted_by AND cidv.inventory_item_id = msi.inventory_item_id AND cidv.inv_master_organization_id = msi.organization_id AND cidv.pa_project_id = ppa.project_id AND cidv.pa_project_task_id = pt.task_id AND ppa.project_id = pt.project_id AND cidv.instance_usage_code = 'IN_PROCESS' AND to_number(sysdate - cidv.transaction_date) <= :p_day ORDER BY 17 ASC,16 ASC,15 ASC,3 ASC,4 ASC Y CSE CSELOSDR_XML AR CSE تقرير معدل الخسارة المتوقع (بتنسيق XML) Application: تتبع الأصل Source: تقرير معدل الخسارة المتوقع (بتنسيق XML) Short Name: CSELOSDR_XML DB package: CSE_CSELOSDR_XMLP_PKG D CSE Angenommene Verlustrate Application: Asset Tracking Source: Angenommene Verlustrate (XML) Short Name: CSELOSDR_XML DB package: CSE_CSELOSDR_XMLP_PKG F CSE Etat Taux de pertes prévisionnel Application: Asset Tracking Source: Etat Taux de pertes prévisionnel (XML) Short Name: CSELOSDR_XML DB package: CSE_CSELOSDR_XMLP_PKG US CSE Assumed Loss Rate Application: Asset Tracking Source: Assumed Loss Rate Report (XML) Short Name: CSELOSDR_XML DB package: CSE_CSELOSDR_XMLP_PKG ZHS CSE 假定损失率报表 Application: 资产跟踪 Source: 假定损失率报表 (XML) Short Name: CSELOSDR_XML DB package: CSE_CSELOSDR_XMLP_PKG BI Publisher :p_conc_request_id :p_day :p_inv_item :p_organization_name :p_project_number :p_report_type :p_task_number :p_transaction_date 1 10 :p_report_type LOV Oracle CSE_REPORT_TYPE Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='CSE_REPORT_TYPE' order by value,description Y AR نوع التقرير D Auswertungsart F Type d'état US Report Type ZHS 报表类型 2 20 :p_day Number 30 Y AR الأيام قبل الإصدار D Entnahme überfällig F Sortie - Jours de retard US Days Past Issue ZHS 过去发放的天数 3 30 :p_project_number LOV Oracle CSE_PROJECT_NUMBERS Y select segment1 id, segment1 value, name description from pa_projects_all where enabled_flag='Y' and template_flag!='Y' order by value,description AR رقم المشروع D Projektnummer F Numéro de projet US Project Number ZHS 项目编号 4 40 :p_task_number LOV Oracle CSE_TASKS Y select task_number id, task_number value, null description from pa_tasks where project_id in (select project_id from pa_projects_all where :$flex$.cse_project_numbers=segment1) order by value,description AR رقم المهمة D Teilprojektnummer F Numéro de tâche US Task Number ZHS 任务编号 5 50 :p_organization_name LOV Oracle CSE_ORG_NAME Y select a.name id, a.name value, null description from (select distinct name from hr_all_organization_units) a order by value,description AR التنظيم D Organisation F Organisation US Organization ZHS 组织 6 60 :p_inv_item LOV Oracle CSE_ITEM_NO Y select distinct(concatenated_segments) id, concatenated_segments value, null description from mtl_system_items_b_kfv where inventory_item_id in (select inventory_item_id from csi_inst_txn_details_v) order by value,description AR رقم الصنف D Artikelnummer F Numéro de l'article US Item Number ZHS 项目编号 :$flex$.cse_project_numbers Project Number Task Number