ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 C6E085D471C051A9E05362FB09050512Y SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) DECODE_PSP_MANUAL_REQ_NUM_TYPE , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) DECODE_PSP_MANUAL_REQ_NUM_TYP1 , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print = 1 AND prh.segment1 = :P_req_num_from AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print != 1 AND psp.manual_req_num_type = 'NUMERIC' AND decode(rtrim(prh.segment1,'0123456789'),NULL,to_number(prh.segment1),-1) BETWEEN decode(rtrim(nvl(:P_req_num_from,prh.segment1),'0123456789'),NULL, to_number(nvl(:P_req_num_from,prh.segment1)),-1) AND decode(rtrim(nvl(:P_req_num_to,prh.segment1),'0123456789'),NULL, to_number(nvl(:P_req_num_to,prh.segment1)),-1) AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print != 1 AND psp.manual_req_num_type = 'ALPHANUMERIC' AND :P_req_num_from IS NOT NULL AND :P_req_num_to IS NOT NULL AND prh.segment1 >= :P_req_num_from AND prh.segment1 <= :P_req_num_to AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print != 1 AND psp.manual_req_num_type = 'ALPHANUMERIC' AND :P_req_num_from IS NOT NULL AND :P_req_num_to IS NULL AND prh.segment1 >= :P_req_num_from AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print != 1 AND psp.manual_req_num_type = 'ALPHANUMERIC' AND :P_req_num_from IS NULL AND :P_req_num_to IS NOT NULL AND prh.segment1 <= :P_req_num_to AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') UNION ALL SELECT decode(psp.manual_req_num_type,'NUMERIC',null,prh.segment1) , decode(psp.manual_req_num_type,'NUMERIC',to_number(prh.segment1), null) , prh.segment1 Requisition , psp.manual_req_num_type req_num_type , ppf.full_name Preparer , prh.creation_date Creation_Date , ppf1.full_name Approver , t.type_name Req_type , prh.description Description , pah.note Note_To_Approver , prh.requisition_header_id Req_header, PO_POXPRREQ_XMLP_PKG.c_total_amount_precision(:GL_CURRENCY, :Total_amount) C_TOTAL_AMOUNT_PRECISION FROM po_requisition_headers prh , per_people_f ppf1 , per_people_f ppf , po_action_history pah , po_system_parameters psp , PO_DOCUMENT_TYPES_ALL_TL T , PO_DOCUMENT_TYPES_ALL_B B WHERE NVL(PRH.contractor_requisition_flag, 'N') <> 'Y' AND prh.preparer_id = ppf.person_id AND nvl(ppf.business_group_id, 0) = (select nvl(max(fsp.business_group_id), 0) from financials_system_parameters fsp) AND trunc(sysdate) BETWEEN nvl(ppf.effective_start_date, trunc(sysdate)) AND nvl(ppf.effective_end_date, trunc(sysdate)) AND trunc(sysdate) BETWEEN nvl(ppf1.effective_start_date, trunc(sysdate)) AND nvl(ppf1.effective_end_date, trunc(sysdate)) -- AND nvl(pah.action_code,'SUBMIT') in ('SUBMIT', 'FORWARD', 'REJECT', 'APPROVE', -- 'APPROVE AND RESERVE', 'RESERVE', 'ACCEPT','RETURN') AND :P_single_req_print != 1 AND psp.manual_req_num_type = 'ALPHANUMERIC' AND :P_req_num_from IS NULL AND :P_req_num_to IS NULL AND b.document_type_code = 'REQUISITION' AND b.document_subtype = prh.type_lookup_code AND EXISTS (SELECT null FROM po_requisition_lines prl WHERE prl.requisition_header_id = prh.requisition_header_id AND nvl(prl.modified_by_agent_flag,'N') = 'N' AND nvl(prl.closed_code,'OPEN') != 'FINALLY CLOSED') AND pah.object_id = prh.requisition_header_id AND pah.employee_id = ppf1.person_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code AND pah.sequence_num = (SELECT max(sequence_num) FROM po_action_history pah WHERE pah.object_id = prh.requisition_header_id AND pah.object_type_code = 'REQUISITION' AND pah.object_sub_type_code = prh.type_lookup_code) and B.DOCUMENT_TYPE_CODE = T.DOCUMENT_TYPE_CODE AND B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE AND B.ORG_ID = T.ORG_ID AND B.ORG_ID = prh.ORG_ID AND T.LANGUAGE = USERENV('LANG') ORDER BY 1,2 PO POXPRREQ_XML AR PO تقرير طلبات الشراء المطبوع (بتنسيق XML) Imported from BI Publisher Description: تقرير طلبات الشراء المطبوع Application: المشتريات Source: تقرير طلبات الشراء المطبوع (بتنسيق XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG D PO Anforderungen - gedruckt Imported from BI Publisher Description: Anforderungen - gedruckt Application: Einkauf Source: Anforderungen - gedruckt (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG E PO Informe Solicitudes Impresas Imported from BI Publisher Description: Informe de solicitudes impresas Application: Purchasing Source: Informe Solicitudes Impresas (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG F PO Etat d'impression des demandes d'approvisionnement Imported from BI Publisher Description: Etat d'impression des demandes d'approvisionnement Application: Purchasing Source: Etat d'impression des demandes d'approvisionnement (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG I PO Rapporto Richieste di acquisto stampate Imported from BI Publisher Description: Rapporto Richieste di acquisto stampato Application: Purchasing Source: Rapporto Richieste di acquisto stampate (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG JA PO 印刷済購買依頼レポート Imported from BI Publisher Description: 印刷済購買依頼レポート Application: Purchasing Source: 印刷済購買依頼レポート(XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG KO PO 인쇄된 구매요청 보고서 Imported from BI Publisher Description: 인쇄된 구매요청 보고서 Application: Purchasing Source: 인쇄된 구매요청 보고서(XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG PTB PO Relatório de Requisições Impressas Imported from BI Publisher Description: Relatório de Requisições Impressas Application: Compra Source: Relatório de Requisições Impressas (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG RU PO Отчет о печати заявок Imported from BI Publisher Description: Отчет о печати заявок Application: Закупки Source: Отчет о печати заявок (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG S PO Utskrift av rekvisitioner Imported from BI Publisher Description: Utskrift av rekvisitioner Application: Purchasing Source: Utskrift av rekvisitioner (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG TR PO Yazdırılmış Talepler Raporu Imported from BI Publisher Description: Yazdırılmış Talepler Raporu Application: Satın Alma Yönetimi Source: Yazdırılmış Talepler Raporu (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG US PO Printed Requisitions Imported from BI Publisher Description: Printed Requisitions Report Application: Purchasing Source: Printed Requisitions Report (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG ZHS PO 已打印申请报表 Imported from BI Publisher Description: 已打印申请报表 Application: 采购管理系统 Source: 已打印申请报表 (XML) Short Name: POXPRREQ_XML DB package: PO_POXPRREQ_XMLP_PKG BI Publisher :gl_currency :operating_unit :p_base_currency :p_chart_of_accounts_id :p_conc_request_id :p_flex_acc :p_flex_cat :p_flex_item :p_item_struct_num :p_qty_precision :p_req_num_from :p_req_num_to :p_single_req_print :p_struct_num :p_title :prl_po_item_id :total_amount 1 -40 :p_base_currency LOV Oracle PO_SRS_BASE_CURRENCY Y select gsb.currency_code id, gsb.currency_code value, null description from gl_sets_of_books gsb,financials_system_parameters fsp where gsb.set_of_books_id=fsp.set_of_books_id order by value,description SELECT GSB.CURRENCY_CODE FROM GL_SETS_OF_BOOKS GSB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID Y US P_BASE_CURRENCY P_BASE_CURRENCY 2 -30 :p_struct_num Number SELECT STRUCTURE_ID FROM MTL_DEFAULT_SETS_VIEW WHERE FUNCTIONAL_AREA_ID = 2 Y US P_STRUCT_NUM P_STRUCT_NUM 3 -20 :p_chart_of_accounts_id Number SELECT GSB.CHART_OF_ACCOUNTS_ID FROM GL_SETS_OF_BOOKS GSB, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE GSB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID Y AR P_CHART_OF_ACCOUNTS_ID رقم هيكل الأستاذ العام # المرن D P_CHART_OF_ACCOUNTS_ID RW# FlexFeld-Struktur-Nummer E P_CHART_OF_ACCOUNTS_ID Número de Tipo de Estructura de GL F P_CHART_OF_ACCOUNTS_ID Numéro de structure de champ flexible GL I P_CHART_OF_ACCOUNTS_ID Numero struttura flexfield GL JA P_CHART_OF_ACCOUNTS_ID GL#フレックス体系番号 KO P_CHART_OF_ACCOUNTS_ID GL# 가변 구조번호 PTB P_CHART_OF_ACCOUNTS_ID Número da estrutura do Flexfield GL# RU P_CHART_OF_ACCOUNTS_ID Номер структуры ГП ГК S P_CHART_OF_ACCOUNTS_ID Bokf.nr: flexfältstrukturnummer TR P_CHART_OF_ACCOUNTS_ID GL# Esnek yapı numarası US P_CHART_OF_ACCOUNTS_ID GL# Flex structure number ZHS P_CHART_OF_ACCOUNTS_ID GL# 弹性结构编号 4 0 :operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name select haouv.name from hr_all_organization_units_vl haouv where haouv.organization_id=nvl((select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1),fnd_global.org_id) Y US Operating Unit Required Operating Unit restriction for reports working in single operating unit mode only 5 10 :p_req_num_from LOV Oracle PO_SRS_APPROVED_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE') in ('APPROVED', 'REJECTED', 'IN PROCESS', 'PRE-APPROVED', 'RETURNED') ) order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)), decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1 ) AR أرقام طلب الشراء من أرقام طلب الشراء من D Von Anforderungsnummer Von Anforderungsnummer E De Número de Solicitud De Número de Solicitud F Numéros de demande d'approvisionnement - De Numéros de demande d'appro - De I Numeri RdA - Da Numeri RdA - Da JA 購買依頼番号:自 購買依頼番号:自 KO 구매요청 번호: 부터 구매요청 번호: 부터 PTB Números da Requisição - De Números de Requisição - De RU Номера заявок с Номера заявок с S Från rekvisitionsnummer Från rek.nummer TR Talep Numaraları, İlk Talep Numaraları: İlk US Requisition Numbers From Req Numbers From ZHS 申请编号自 申请编号自 6 20 :p_req_num_to LOV Oracle PO_SRS_APPROVED_REQUISITION_NUMBER Y select prh.segment1 id, prh.segment1 value, null description from po_requisition_headers prh,po_system_parameters psp where (nvl(prh.authorization_status,'INCOMPLETE') in ('APPROVED', 'REJECTED', 'IN PROCESS', 'PRE-APPROVED', 'RETURNED') ) order by decode(psp.manual_req_num_type,'NUMERIC', to_number(prh.segment1)), decode(psp.manual_req_num_type,'ALPHANUMERIC', prh.segment1 ) AR إلى أرقام طلب الشراء إلى D Bis Bis Anforderungsnummer E A A Número de Solicitud F A Numéros de demande d'appro - A I A Numeri richieste di acquisto - A JA 至 購買依頼番号:至 KO 까지 구매요청 번호: 까지 PTB Até Números de Requisição - Até RU По Номера заявок по S Till Till rek.nummer TR Son Talep Numaraları: Son US To Req Numbers To ZHS 至 申请编号至 7 30 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR خيار الدقة الديناميكية دقة الكمية D Option Nachkommastellen Nachkommastellen E Opción Precisión Dinámica Precisión de Cantidad F Option précision dynamique Précision des quantités I Opzione precisione dinamica Precisione quantità JA 動的演算精度オプション 数量精度 KO 동적 소수점자리 옵션 수량 소수점 이하 자릿수 PTB Opção de Precisão Dinâmica Precisão da Quantidade RU Динамическая точность Точность количества S Alternativ för dynamisk precision Kvantitetsprecision TR Dinamik Duyarlılık Seçeneği Miktar Duyarlılığı US Dynamic Precision Option Quantity Precision ZHS 动态精确度选项 数量精确度