ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F2383869E053B46B63588994 SELECT CHR.CONTRACT_NUMBER VND_CONTRACT_NUMBER , HOU.NAME VND_OPERATING_UNIT , CHR.START_DATE VND_START_DATE , CHR.END_DATE VND_END_DATE , APS_PARTY.VENDOR_NAME VND_PARTY_NAME , FL.MEANING VND_PARTY_ROLE , APS_VENDOR.VENDOR_NAME VND_VENDOR_NAME , APS_PARTY.VENDOR_NAME VND_PARTY_VENDOR_NAME FROM OKL_PARTY_PAYMENT_DTLS PPD , OKC_K_PARTY_ROLES_B CPL , OKC_K_HEADERS_ALL_B CHR , AP_SUPPLIERS APS_PARTY , AP_SUPPLIERS APS_VENDOR , HR_OPERATING_UNITS HOU , FND_LOOKUPS FL WHERE CHR.ID = CPL.CHR_ID AND PPD.CPL_ID = CPL.ID AND CPL.RLE_CODE = 'OKL_VENDOR' AND APS_PARTY.VENDOR_ID = CPL.OBJECT1_ID1 AND APS_VENDOR.VENDOR_ID = PPD.VENDOR_ID AND PPD.VENDOR_ID <> APS_PARTY.VENDOR_ID AND HOU.ORGANIZATION_ID = CHR.ORG_ID AND MO_GLOBAL.CHECK_ACCESS(CHR.ORG_ID) = 'Y' AND FL.LOOKUP_TYPE = 'OKC_ROLE' AND FL.LOOKUP_CODE = CPL.RLE_CODE AND CHR.ORG_ID = NVL(:P_OPERATING_UNIT,CHR.ORG_ID) AND CHR.SCS_CODE = DECODE(NVL(:P_OBJECT_TYPE,'PROGRAM'),'PROGRAM','PROGRAM') AND CHR.START_DATE BETWEEN NVL(:P_START_DATE_FROM, CHR.START_DATE) AND NVL(:P_START_DATE_TO, TO_DATE('31-12-9999','dd-mm-yyyy')) UNION SELECT CHR.CONTRACT_NUMBER VND_CONTRACT_NUMBER , HOU.NAME VND_OPERATING_UNIT , CHR.START_DATE VND_START_DATE , CHR.END_DATE VND_END_DATE , HZP.PARTY_NAME VND_PARTY_NAME , FL.MEANING VND_PARTY_ROLE , APS_VENDOR.VENDOR_NAME VND_VENDOR_NAME , APS_PARTY.VENDOR_NAME VND_PARTY_VENDOR_NAME FROM OKL_PARTY_PAYMENT_DTLS PPD , OKC_K_PARTY_ROLES_B CPL , OKC_K_HEADERS_ALL_B CHR , AP_SUPPLIERS APS_PARTY , AP_SUPPLIERS APS_VENDOR , HZ_PARTIES HZP , HR_OPERATING_UNITS HOU , FND_LOOKUPS FL WHERE CHR.ID = CPL.CHR_ID AND PPD.CPL_ID = CPL.ID AND CPL.RLE_CODE NOT IN ('OKL_VENDOR','LEASE HR') AND PPD.VENDOR_ID = APS_VENDOR.VENDOR_ID AND HZP.PARTY_ID = CPL.OBJECT1_ID1 AND APS_VENDOR.PARTY_ID <> HZP.PARTY_ID AND APS_PARTY.PARTY_ID(+) = HZP.PARTY_ID AND HOU.ORGANIZATION_ID = CHR.ORG_ID AND MO_GLOBAL.CHECK_ACCESS(CHR.ORG_ID) = 'Y' AND FL.LOOKUP_TYPE = 'OKC_ROLE' AND FL.LOOKUP_CODE = CPL.RLE_CODE AND CHR.ORG_ID = NVL(:P_OPERATING_UNIT,CHR.ORG_ID) AND CHR.SCS_CODE = DECODE(NVL(:P_OBJECT_TYPE,'PROGRAM'),'PROGRAM','PROGRAM') AND CHR.START_DATE BETWEEN NVL(:P_START_DATE_FROM, CHR.START_DATE) AND NVL(:P_START_DATE_TO, TO_DATE('31-12-9999','dd-mm-yyyy')) Y OKL OKLVNDMISMATCH AR OKL تقرير بعدم التطابق بين طرف البائع وعقد الإيجار Application: إدارة الإيجار Source: تقرير بعدم التطابق بين طرف البائع وعقد الإيجار Short Name: OKLVNDMISMATCH DB package: D OKL Leasing - Lieferantenpartei - Unstimmigkeit Application: Lease and Finance Management Source: Leasing - Lieferantenpartei - Unstimmigkeit Short Name: OKLVNDMISMATCH DB package: F OKL Crédit-bail - Etat des incohérences de partie fournisseur Application: Lease and Finance Management Source: Crédit-bail - Etat des incohérences de partie fournisseur Short Name: OKLVNDMISMATCH DB package: US OKL Lease Vendor Party Mismatch Application: Lease and Finance Management Source: Lease Vendor Party Mismatch Report Short Name: OKLVNDMISMATCH DB package: ZHS OKL 租赁供应商交易方的不匹配报表 Application: Oracle Lease and Finance Management Source: 租赁供应商交易方的不匹配报表 Short Name: OKLVNDMISMATCH DB package: BI Publisher :p_object_type :p_operating_unit :p_start_date_from :p_start_date_to 1 10 :p_operating_unit LOV Oracle OKL_OPERATING_UNITS_MO Y select organization_id id, name value, null description from hr_operating_units where mo_global.check_access(organization_id)='Y' order by value,description AR وحدة التشغيل D Betriebseinheit F Unité opérationnelle US Operating Unit ZHS 业务实体 2 20 :p_object_type LOV Oracle OKL_SUBCLASS_TYPE Y select code id, meaning value, description description from okc_subclasses_v where code in ('LEASE','PROGRAM','INVESTOR') and cls_code='OKL' order by value,description AR نوع الوحدة D Objektart F Type d'objet US Object Type ZHS 对象类型 3 30 :p_start_date_from Date AR تاريخ البداية من D Von Startdatum F Date de début - Du US Start Date From ZHS 起始日期自 4 40 :p_start_date_to Date AR تاريخ البداية إلى D Bis Startdatum F Date de début - Au US Start Date To ZHS 起始日期至