ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3E93869E053B46B63588994Y SELECT hrlt1.location_code Location_code , hrlt1.description Description , decode(hrl1.ship_to_site_flag,'Y', :yes, :no) Ship_to , decode(hrl1.bill_to_site_flag,'Y', :yes, :no) Bill_to , decode(hrl1.office_site_flag,'Y', :yes, :no) Office , decode(hrl1.in_organization_flag,'N', :no, :yes) Internal , decode(hrl1.receiving_site_flag,'Y', :yes, :no) Receiving_site , hrl1.inactive_date Inactive_date , ood.organization_name Inventory_Organization , hrlt2.location_code Ship_to_location , hrl1.tax_name Tax , hrl1.address_line_1 Address , hrl1.address_line_2 Address2 , hrl1.address_line_3 Address3 , hrl1.town_or_city City , hrl1.region_1 State , hrl1.region_2 Province , hrl1.postal_code Zip , hrl1.country Country FROM org_organization_definitions ood , hr_locations_all hrl2 , hr_locations_all_tl hrlt2 , hr_locations_all hrl1 , hr_locations_all_tl hrlt1 WHERE (decode(:P_active_inactive,'ACTIVE',nvl(hrl1.inactive_date,sysdate+1)-sysdate, 'INACTIVE',sysdate-nvl(hrl1.inactive_date,sysdate+1),1) > 0 OR :P_active_inactive = 'BOTH') AND ood.organization_id (+) = hrl1.inventory_organization_id AND nvl (hrl1.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl (hr_general.get_business_group_id, -99) AND hrl1.location_id = hrlt1.location_id AND hrlt1.language = userenv('LANG') AND hrl2.location_id (+) = hrl1.ship_to_location_id AND nvl (hrl2.business_group_id, nvl(hr_general.get_business_group_id, -99) ) = nvl (hr_general.get_business_group_id, -99) AND hrl2.location_id = hrlt2.location_id (+) AND hrlt2.language (+) = userenv('LANG') AND ((hrl1.ship_to_site_flag = decode(:P_site,'SHIP-TO','Y','FAIL')) OR (hrl1.bill_to_site_flag = decode(:P_site,'BILL-TO','Y','FAIL')) OR (hrl1.office_site_flag = decode(:P_site,'OFFICE','Y','FAIL')) OR (hrl1.in_organization_flag = decode(:P_site,'EXTERNAL','N','FAIL')) OR (hrl1.receiving_site_flag = decode(:P_site, 'RECEIVING','Y','FAIL')) OR (nvl(:P_site,'ALL') = 'ALL')) ORDER BY &orderby_clause PO POXSURLC_XML AR PO قائمة الموقع (بتنسيق XML) Application: المشتريات Source: قائمة الموقع (بتنسيق XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG D PO Einkauf - Standorte Application: Einkauf Source: Einkauf - Standorte (XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG F PO Liste des lieux Application: Purchasing Source: Liste des lieux (XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG US PO Location Listing Application: Purchasing Source: Location Listing (XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG ZHS PO 地点列表 Application: 采购管理系统 Source: 地点列表 (XML) Short Name: POXSURLC_XML DB package: PO_POXSURLC_XMLP_PKG BI Publisher &orderby_clause :no :operating_unit :p_active_inactive :p_active_inactive_disp :p_conc_request_id :p_site :p_site_disp :p_sort :p_sort_disp :p_title :yes 1 10 :p_title Char AR العنوان D Titel F Titre US Title ZHS 标题 2 20 :p_site LOV Oracle PO_SRS_LOCATION_SITE Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SITE_TYPE' order by displayed_field Y AR الموقع D Standort US Site ZHS 地点 3 30 :p_active_inactive LOV Oracle PO_SRS_ACTIVE_OPTIONS Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='ACTIVE_INACTIVE' order by displayed_field Y AR ساري/غير ساري D Gültig/Ungültig F Activé/Désactivé US Active/Inactive ZHS 有效/无效 4 40 :p_sort LOV Oracle PO_SRS_POXSURLC_SORT Y select lookup_code id, displayed_field value, null description from po_lookup_codes where lookup_type='SRS ORDER BY' and lookup_code in ('COUNTRY','STATE','LOCATION') order by displayed_field AR فرز بواسطة D Sortieren nach F Tri par US Sort By ZHS 排序依据