ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471B551A9E05362FB09050512Y SELECT rrp.org_id, rrp.item_id, rrp.organization_id rrp_organization_id, decode(msi.inventory_item_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_ITEM, -- Bug18732768 decode(rrp.category_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_CAT, -- Bug18732768 --fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM, --fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE') C_FLEX_CAT, rrp.revision_num, rrp.category_id, rrp.item_description, rrp.un_num, rrp.un_description, rrp.hazard_class, rrp.routing_name, rrp.document_type_code, rrp.document_number, rrp.release_num, rrp.line_num, rrp.buyer_preparer_name, rrp.source_type, rrp.source, rrp.source_unit_of_measure, rrp.vendor_product_num, fnd_date.date_to_canonical(rrp.due_date) due_date, round(rrp.quantity_ordered, :P_QTY_PRECISION) quantity_ordered, rrp.note_to_receiver, rrp.pll_note_to_receiver, rrp.receipt_num RECEIPT_NUM, rrp.receipt_unit_of_measure, fnd_date.date_to_canonical(rrp.receipt_date) receipt_date, rrp.RECEIPT_LOCATION, rrp.receiver_first_name, rrp.receiver_last_name, rrp.freight_carrier, round(rrp.quantity_received, :P_QTY_PRECISION ) quantity_received, po_poxdlpdt_xmlp_pkg.quantity_received_fn(rrp.from_interface ,rrp.transaction_id ,rrp.primary_quantity ,:c_sum_corrected_qty ,rrp.quantity_received ,rrp.shipment_line_id ,rrp.receipt_unit_of_measure ,rrp.item_id) c_effective_qty_rcv , -- bug17161858 rrp.primary_quantity parent_primary_quantity, round(rrp.quantity_remaining, :P_QTY_PRECISION ) quantity_remaining, po_poxdlpdt_xmlp_pkg.c_quantity_remaining_printform (rrp.quantity_remaining, :source_doc_unit_of_measure, rrp.receipt_unit_of_measure, rrp.item_id, rrp.organization_id ) c_quantity_remaining_print, --Bug17161858 rrp.shipment_num, rrp.bill_of_lading, rrp.vendor_lot_num, rrp.packing_slip_num, rrp.containers, rrp.receiver_comment, rrp.transaction_type rrp_transaction_type, rrp.transaction_id rrp_transaction_id, rrp.shipment_line_id rrp_shipment_line_id, rrp.shipment_header_id rrp_shipment_header_id, rrp.distribution_id rrp_distribution_id, rrp.po_header_id, rrp.po_line_id, rrp.po_line_location_id, rrp.requisition_header_id, rrp.requisition_line_id, rrp.from_interface rrp_from_interface, rrp.deliver_to_location DELIVER_TO_LOCATION2, rrp.transfer_license_plate_number license_plate_number, rrp.locator_id LOCATOR_ID1, rrp.receiving_subinventory, PO_POXDLPDT_XMLP_PKG.BOILER_PLATE_DOC_TYPE(rrp.transaction_type) DOC_TYPE_BOILERPLATE, PO_POXDLPDT_XMLP_PKG.boiler_plate_buyer(rrp.transaction_type) Buyer_Preparer, PO_POXDLPDT_XMLP_PKG.boiler_plate_doc_num(rrp.transaction_type) Doc_Num_Boiler_Plate, PO_POXDLPDT_XMLP_PKG.CF_DIRECT_RCV_DLVFORMULA(rrp.transaction_id,rrp.from_interface) CF_DIRECT_RCV_DLV, PO_POXDLPDT_XMLP_PKG.CF_RECEIPT_LOCATIONFORMULA(rrp.locator_id ,rrp.RECEIPT_LOCATION,rrp.receiving_subinventory) CF_RECEIPT_LOCATION, PO_POXDLPDT_XMLP_PKG.CF_OPERATING_UNITFORMULA(rrp.org_id) CF_OPERATING_UNIT FROM &from_lexical , mtl_system_items msi, mtl_categories mca WHERE mca.category_id = rrp.category_id AND msi.inventory_item_id (+) = rrp.item_id &and_lexical AND &P_WHERE_GROUP_ID AND &P_WHERE_ITEM AND &P_WHERE_CAT AND &P_WHERE_RECEIPT_NUM_FROM AND &P_WHERE_RECEIPT_NUM_TO AND &P_WHERE_SHIP_TO_LOCATION AND &P_WHERE_DELIVER_TO_LOCATION AND &P_WHERE_ORG_ID order by 2,25 PO POXDLPDT_XML AR PO إيصال الاستلام (بتنسيق XML) Imported from BI Publisher Description: إيصال استلام Application: المشتريات Source: إيصال الاستلام (بتنسيق XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG D PO Warenbegleitschein Imported from BI Publisher Description: Warenbegleitschein Application: Einkauf Source: Warenbegleitschein (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG E PO Albarán de Recepción Imported from BI Publisher Description: Albarán de Recepción Application: Purchasing Source: Albarán de Recepción (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG F PO Bordereau de réception Imported from BI Publisher Description: Bordereau de réception Application: Purchasing Source: Bordereau de réception (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG I PO Bolla di accompagnamento Imported from BI Publisher Description: Bolla di accompagnamento Application: Purchasing Source: Bolla di accompagnamento (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG JA PO 受入伝票 Imported from BI Publisher Description: 受入伝票 Application: Purchasing Source: 受入伝票(XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG KO PO 입고 경로 티켓 Imported from BI Publisher Description: 입고 경로 티켓 Application: Purchasing Source: 입고 경로 티켓(XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG PTB PO Recibo de Viagem Imported from BI Publisher Description: Recibo de Viagem Application: Compra Source: Recibo de Viagem (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG RU PO Маршрутная квитанция Imported from BI Publisher Description: Маршрутная квитанция Application: Закупки Source: Маршрутная квитанция (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG S PO Följesedel Imported from BI Publisher Description: Följesedel Application: Purchasing Source: Följesedel (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG TR PO Teslim Alma Belgesi Imported from BI Publisher Description: Teslim Alma Belgesi Application: Satın Alma Yönetimi Source: Teslim Alma Belgesi (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG US PO Receipt Traveler Imported from BI Publisher Description: Receipt Traveler Application: Purchasing Source: Receipt Traveler (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG ZHS PO 接收记录卡 Imported from BI Publisher Description: 接收记录卡 Application: 采购管理系统 Source: 接收记录卡 (XML) Short Name: POXDLPDT_XML DB package: PO_POXDLPDT_XMLP_PKG BI Publisher &and_lexical &from_lexical &p_where_cat &p_where_deliver_to_location &p_where_group_id &p_where_item &p_where_org_id &p_where_receipt_num_from &p_where_receipt_num_to &p_where_ship_to_location :and_lexical :c_num_rts_printed :c_sum_corrected_qty :cp_category_from :cp_category_to :cp_delivery_location :cp_item_from :cp_item_to :cp_operating_unit_displayed :cp_org_displayed :cp_receipt_num_from :cp_receipt_num_to :cp_ship_to_location :cp_title :cp_wip_status :from_lexical :from_lexical_1 :p_category_from :p_category_to :p_conc_request_id :p_delivery_location :p_flex_cat :p_flex_item :p_flex_locator :p_group_id :p_inv_status :p_item_from :p_item_struct_num :p_item_to :p_operating_unit_displayed :p_operating_unit_id :p_orderby :p_org_displayed :p_org_id :p_qty_precision :p_receipt_location :p_receipt_num_from :p_receipt_num_to :p_receipt_source_type :p_select_distributions :p_select_receipts :p_ship_to_location :p_struct_num :p_supply_days :p_title :p_union_lower_lower :p_union_lower_upper :p_union_upper_lower :p_union_upper_upper :p_where_cat :p_where_deliver_to_location :p_where_group_id :p_where_item :p_where_org_id :p_where_receipt_num_from :p_where_receipt_num_to :p_where_ship_to_location :p_wip_from_dist :p_wip_select_dist :p_wip_status :p_wip_where_dist :qty_precision :serial_control_code :source_doc_unit_of_measure 1 -20 :p_struct_num Number select structure_id from mtl_default_sets_view where functional_area_id = 2 Y AR هيكل الفئة رقم هيكل P D Kategoriestruktur P Struct Num E Estructura de Categoría P Struct Num F Structure de catégorie P Numéro de structure I Struttura categoria P Numero struttura JA カテゴリ体系 P体系番号 KO 범주 구조 P 구조 번호 PTB Estrutura da Categoria P Nº Estrut. RU Структура категорий Номер структуры продукта S Kategoristruktur P: Strukturnr TR Kategori Yapısı P Yapı Numarası US Category Structure P Struct Num ZHS 类别结构 P 结构编号 2 10 :p_title Char AR العنوان العنوان D Titel Titel E Título Título F Titre Titre I Titolo Titolo JA タイトル タイトル KO 제목 제목 PTB Título Título RU Название Название S Titel Titel TR Başlık Başlık US Title Title ZHS 标题 标题 3 20 :p_operating_unit_id LOV Oracle FND_MO_OU Y select organization_id id, organization_name value, null description from mo_glob_org_access_tmp order by value,description AR وحدة التشغيل اسم وحدة التشغيل D Betriebseinheit Bezeichnung Betriebseinheit E Unidad Operativa Nombre de Unidad Operativa F Unité opérationnelle Nom de l'unité opérationnelle I Unità operativa Nome dell'unità operativa JA 営業単位 営業単位名 KO 운영 단위 운영 단위명 PTB Unidade Operacional Nome da Unidade Operacional RU Операционная единица Название операционной единицы S Operativ enhet Namn på operativ enhet TR Faaliyet Birimi Faaliyet Birimi Adı US Operating Unit Operating Unit Name ZHS 业务实体 业务实体名 4 30 :p_delivery_location LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR موقع التسليم موقع التسليم D Auslieferadresse Auslieferadresse E Ubicación de Entrega Ubicación de Entrega F Lieu mise à disposition Lieu mise à disposition I Ubicazione consegna Ubicazione consegna JA 搬送先事業所 搬送先事業所 KO 납품처 납품처 PTB Local de Distribuição Local de Distribuição RU Расположение доставки Расположение доставки S Intern leveransadress Intern leveransadress TR Teslimat Adresi Teslimat Adresi US Delivery Location Delivery Location ZHS 交货地点 交货地点 5 40 :p_org_id LOV Oracle PO_SRS_ORGANIZATIONS Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where nvl(disable_date,trunc(sysdate)+1)>trunc(sysdate) order by value,description Y AR اسم التنظيم اسم التنظيم D Organisationsbezeichnung Organisationsbezeichnung E Nombre de Organización Nombre de Organización F Nom de l'organisation Nom de l'organisation I Nome organizzazione Nome organizzazione JA 組織名 組織名 KO 조직명 조직명 PTB Nome da Organização Nome da Organização RU Организация Организация S Organisation Organisation TR Organizasyon Adı Organizasyon Adı US Organization Name Organization Name ZHS 组织名 组织名 6 50 :p_receipt_source_type LOV Oracle PO_SRS_RECEIPT_SOURCE_TYPE Y select displayed_field id, displayed_field value, null description from po_lookup_codes where lookup_type='REPORTS SHIPMENT SOURCE TYPE' order by value,description All Y AR نوع مصدر الاستلام نوع مصدر الاستلام D Herkunftsart Wareneingang Herkunftsart Wareneingang E Tipo de Origen de Recepción Tipo de Origen de Recepción F Type d'origine de réception Type d'origine de réception I Tipo origine incasso Tipo origine incasso JA 受入ソース・タイプ 受入ソース・タイプ KO 입고 출처 유형 입고 출처 유형 PTB Tipo de Origem do Recebimento Tipo de Origem do Recebimento RU Тип источника поступления Тип источника поступления S Betalningskälltyp Betalningskälltyp TR Teslim Alma Kaynak Tipi Teslim Alma Kaynak Tipi US Receipt Source Type Receipt Source Type ZHS 收款来源类型 收款来源类型 7 60 :p_receipt_num_from LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) AR أرقام الاستلام من أرقام الاستلام من D Von Wareneingangsnummer Von Wareneingangsnummer E De Número de Recepción De Número de Recepción F Numéros de réception - De Numéros de réception - De I Numeri ricevute - Da Numeri ricevute - Da JA 受入番号:自 受入番号:自 KO 입고 번호: 부터 입고 번호: 부터 PTB Números de Recebimento - De Números de Recebimento - De RU Номера поступлений с Номера поступлений с S Från mottagningsnummer Från mottagningsnummer TR Teslimat Numaraları: İlk Teslimat Numaraları: İlk US Receipt Numbers From Receipt Numbers From ZHS 接收编号自 接收编号自 8 70 :p_receipt_num_to LOV Oracle PO_SRS_RECEIPT_NUMBER Y select rsh.receipt_num id, rsh.receipt_num value, null description from rcv_shipment_headers rsh,po_system_parameters psp,org_organization_definitions ood where rsh.ship_to_org_id=ood.organization_id and ood.operating_unit=psp.org_id and exists ( select 'SHIPMENT HEADER EXISTS' from rcv_shipment_lines rsl where rsh.shipment_header_id=rsl.shipment_header_id and rsl.to_organization_id=:$flex$.po_srs_organizations) order by decode(psp.manual_receipt_num_type, 'NUMERIC', decode(rtrim (rsh.receipt_num,'0123456789'), null,to_number(rsh.receipt_num)), null), decode(psp.manual_receipt_num_type, 'ALPHANUMERIC',rsh.receipt_num) AR إلى أرقام الاستلام إلى D Bis Bis Wareneingangsnummer E A A Número de Recepción F A Numéros de réception - A I A Numeri ricevuta - A JA 至 受入番号:至 KO 까지 입고 번호: 까지 PTB Até Números de Recebimento - Até RU По Номера поступлений по S Till Inleveransnr till TR Son Teslimat Numaraları: Son US To Receipt Numbers To ZHS 至 接收编号至 9 80 :p_item_from Char AR الأصناف من الأصناف من D Von Artikel Von Artikel E De Artículo De Artículo F Articles - De Articles - De I Articoli - Da Articoli - Da JA 品目:自 品目:自 KO 품목: 부터 품목: 부터 PTB Itens - De Itens - De RU Позиции с Позиции с S Från artiklar Från artiklar TR Kalemler, İlk Kalemler, İlk US Items From Items From ZHS 物料自 物料自 10 90 :p_item_to Char AR إلى 2 الأصناف إلى D Bis 2 Bis Artikel E A 2 A Artículo F A 2 Articles - A I A 2 Articoli - A JA 至 2 品目:至 KO 까지 2 품목: 까지 PTB Até 2 Itens - Até RU По 2 Позиции по S Till 2 Till artiklar TR Son 2 Kalemler, Son US To 2 Items To ZHS 至 2 物料至 11 100 :p_category_from Char AR الفئات من الفئات من D Von Kategorie Von Kategorie E De Categoría De Categoría F Catégories - De Catégories - De I Categorie - Da Categorie - Da JA カテゴリ:自 カテゴリ:自 KO 범주: 부터 범주: 부터 PTB Categorias - De Categorias - De RU Категории с Категории с S Från kategorier Från kategorier TR Kategoriler, İlk Kategoriler, İlk US Categories From Categories From ZHS 类别自 类别自 12 110 :p_category_to Char AR إلى 3 إلى D Bis 3 Bis E A 3 A F A 3 A I A 3 A JA 至 3 至 KO 까지 3 까지 PTB Até 3 Até RU По 3 По S Till 3 Till TR Son 3 Son US To 3 To ZHS 至 3 至 13 120 :p_ship_to_location LOV Oracle PO_SRS_LOCATION Y select location_code id, location_code value, null description from hr_locations order by location_code AR شحن إلى الموقع شحن إلى الموقع D Lieferadresse Lieferadresse E Ubicación de Envío Ubicación de Envío F Lieu de livraison Lieu de livraison I Ubicazione di spedizione Ubicazione di spedizione JA 納入先事業所 納入先事業所 KO 납품처 위치 납품처 위치 PTB Local para Entrega Local para Entrega RU Расположение грузополучателя Расположение грузополучателя S Lev.adress, plats Lev.adress, plats TR Teslim Noktası Teslim Noktası US Ship to Location Ship to Location ZHS 收货地点 收货地点 14 130 :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 动态精确度选项 数量精确度 15 140 :p_group_id Number AR معرف المجموعة D Gruppenkennung E Id Grupo F ID groupe I ID gruppo JA グループID KO 그룹 ID PTB ID do Grupo RU Идентификатор группы S Grupp-id TR Grup No US Group ID ZHS 组标识