ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4702051A9E05362FB09050512Y select o.organization_name from_org, o.chart_of_accounts_id acct_struct_num, lu1.meaning intransit_status, i.to_organization_distance distance, i.distance_uom_code uom, lu2.meaning transfer_code, lu3.meaning fob_point, rcv.routing_name primary_rcv_routing_type, lu4.meaning internal_order_required, i.interorg_trnsfr_charge_percent charge_percent, &P_inv_acct_flex C_inv_acct_flex_f, &P_trf_acct_flex C_trf_acct_flex_f, &P_rcv_acct_flex C_rcv_acct_flex_f, &P_pay_acct_flex C_pay_acct_flex_f, &P_pva_acct_flex C_pva_acct_flex_f, inv.code_combination_id inv_acct_id, trf.code_combination_id trf_acct_id, rcv.code_combination_id rcv_acct_id, pay.code_combination_id pay_acct_id, pva.code_combination_id pva_acct_id ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_inv_acct_field_f', 'SQLGL', 'GL#', INV.CHART_OF_ACCOUNTS_ID, NULL, INV.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_inv_acct_field_f ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_trf_acct_field_f', 'SQLGL', 'GL#', TRF.CHART_OF_ACCOUNTS_ID, NULL, TRF.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_trf_acct_field_f ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_rcv_acct_field_f', 'SQLGL', 'GL#', RCV.CHART_OF_ACCOUNTS_ID, NULL, RCV.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_rcv_acct_field_f ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pay_acct_field_f', 'SQLGL', 'GL#', PAY.CHART_OF_ACCOUNTS_ID, NULL, PAY.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_pay_acct_field_f ,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_pva_acct_field_f', 'SQLGL', 'GL#', PVA.CHART_OF_ACCOUNTS_ID, NULL, PVA.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') C_pva_acct_field_f from mtl_interorg_parameters i, rcv_routing_headers rcv, mfg_lookups lu1, mfg_lookups lu2, mfg_lookups lu3, mfg_lookups lu4, org_organization_definitions o, gl_code_combinations inv, gl_code_combinations trf, gl_code_combinations rcv, gl_code_combinations pay, gl_code_combinations pva where i.to_organization_id = :P_org_id and i.routing_header_id = rcv.routing_header_id(+) and i.intransit_type = lu1.lookup_code(+) and lu1.lookup_type(+) = 'ORG_INTRANSIT' and i.matl_interorg_transfer_code = lu2.lookup_code(+) and lu2.lookup_type(+) = 'MTL_INTER_INV_TRANSFER' and i.fob_point = lu3.lookup_code(+) and lu3.lookup_type(+) = 'MTL_FOB_POINT' and i.internal_order_required_flag = lu4.lookup_code(+) and lu4.lookup_type(+) = 'SYS_YES_NO' and i.INTRANSIT_INV_ACCOUNT = inv.code_combination_id(+) and i.INTERORG_TRANSFER_CR_ACCOUNT = trf.code_combination_id(+) and i.INTERORG_RECEIVABLES_ACCOUNT = rcv.code_combination_id(+) and i.INTERORG_PAYABLES_ACCOUNT = pay.code_combination_id(+) and i.INTERORG_PRICE_VAR_ACCOUNT = pva.code_combination_id(+) and o.organization_id = i.from_organization_id and o.organization_id <> :P_org_id &C_org_where order by 1 INV INVSRIOS_XML AR INV قائمة معلومات الشحن داخل التنظيم (بتنسيق XML) Imported from BI Publisher Description: قائمة معلومات الشحن داخل التنظيم Application: المخازن Source: قائمة معلومات الشحن داخل التنظيم (بتنسيق XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG D INV Zwischenbetriebliche Lieferdaten Imported from BI Publisher Description: Zwischenbetriebliche Lieferdaten Application: Lager Source: Zwischenbetriebliche Lieferdaten (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG E INV Listado de Información de Envío entre Organizaciones Imported from BI Publisher Description: Listado de Envíos entre Organizaciones Application: Inventory Source: Listado de Información de Envío entre Organizaciones (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG F INV Informations de livraison inter-organisations Imported from BI Publisher Description: Informations de livraison inter-organisations Application: Inventory Source: Informations de livraison inter-organisations (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG I INV Elenco informazioni spedizione tra organizzazioni Imported from BI Publisher Description: Elenco informazioni spedizione tra organizzazioni Application: Inventory Source: Elenco informazioni spedizione tra organizzazioni (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG JA INV 組織間出荷情報リスト Imported from BI Publisher Description: 組織間出荷情報リスト Application: Inventory Source: 組織間出荷情報リスト(XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG KO INV 조직간 출하 정보 목록 Imported from BI Publisher Description: 조직간 출하정보 목록 Application: Inventory Source: 조직간 출하 정보 목록(XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG PTB INV Lista de informações sobre entrega interorganizações Imported from BI Publisher Description: Lista de informações sobre entrega interorganizações Application: Inventário Source: Lista de informações sobre entrega interorganizações (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG RU INV Список сведений об отгрузке между организациями Imported from BI Publisher Description: Список сведений об отгрузке между организациями Application: Запасы Source: Список сведений об отгрузке между организациями (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG S INV Information om leveranser mellan organisationer - lista Imported from BI Publisher Description: Leverans mellan organisationer - information - lista Application: Inventory Source: Information om leveranser mellan organisationer - lista (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG TR INV Organizasyonlararası sevkiyat bilgileri listeleme Imported from BI Publisher Description: Organizasyonlararası sevkiyat bilgileri listeleme Application: Stok Yönetimi Source: Organizasyonlararası sevkiyat bilgileri listeleme (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG US INV Inter-organization shipping information listing Imported from BI Publisher Description: Inter-organization shipping information listing Application: Inventory Source: Inter-organization shipping information listing (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG ZHS INV 组织间发运信息列表 Imported from BI Publisher Description: 组织间发运信息列表 Application: 库存管理系统 Source: 组织间发运信息列表 (XML) Short Name: INVSRIOS_XML DB package: INV_INVSRIOS_XMLP_PKG BI Publisher &c_org_where &p_inv_acct_flex &p_pay_acct_flex &p_pva_acct_flex &p_rcv_acct_flex &p_trf_acct_flex :p_conc_request_id :p_condition :p_inv_acct_flex :p_org_id :p_org_lo :p_pay_acct_flex :p_pva_acct_flex :p_rcv_acct_flex :p_trf_acct_flex 1 -20 :p_org_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR التنظيم التنظيم D Organisation Organisation E Organización Organización F Organisation Organisation I Organizzazione Organizzazione JA 組織 組織 KO 조직 조직 PTB Organização Organização RU Организация Организация S Organisation Organisation TR Organizasyon Organizasyon US Organization Organization ZHS 组织 组织 2 10 :p_org_lo LOV Oracle INV_SRS_ORGANIZATION_RANGE Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where organization_id<>fnd_profile.value('MFG_ORGANIZATION_ID') order by organization_code AR من/إلى تنظيم تنظيم الشبكة D Von/Bis Organisation Netzwerkorganisation E De/A Organización Organización de Red F Org. départ/destinat. Organisation réseau I Da/A organizzazione Organizzazione di rete JA 組織:自/至 ネットワーク組織 KO From/To 조직 네트워크 조직 PTB Organização - De/Até Organização de Rede RU Организация 2 Сетевая организация S Från/Till organisation Nätverksorganisation TR İlk/Son Organizasyon Network Organizasyonu US From/To Organization Network Organization ZHS 起始地/目的地组织 网络组织