ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN EEE75CEB4A926AD8E05362FB09051F8BY select x.* from ( SELECT * FROM ( SELECT DISTINCT oec.ecc_spec_id ,oec.invoice_num ,oec.customer_name ,oec.site_use_id ,oec.currency_code ,oec.due_date ,oec.amount ,oec.balance ,oec.ar_invoice_id ,oec.usage_period ,oec.invoice_date ,oec.bill_to_site_use_id ,oec.customer_acct_id ,oec.org_id ,oec.customer_number ,oec.contract_number ,oec.asset_number ,payout_basis.description payout_basis ,payment_basis.description payment_basis ,payout_basis.language ,oec.contract_id ,oec.invoice_line_number ,oec.line_type ,oec.line_amount ,oec.tax_amount ,oec.revenue_amount ,oec.amount_due_remaining ,oec.receivable_application_id ,oec.cash_receipt_id ,oec.customer_trx_id ,oec.customer_trx_line_id ,oec.invoice_number ,oec.stream_type ,oec.due_date_receipt ,oec.balance_amount ,oec.applied_amount ,oec.line_applied ,oec.tax_applied ,oec.line_balance ,oec.tax_balance ,oec.original_applied_amount ,oec.total_line_amount ,oec.gl_date ,oec.invoice_currency_code ,oec.receipt_number ,oec.tax_current_amount_due ,oec.original_line_applied ,oec.original_tax_applied ,oec.original_gl_date ,oec.vendor ,oec.vendor_site ,oec.ar_link ,oec.ap_inv_num ,oec.invoice_amount ,oec.line_number ,oec.ap_line_amount ,oec.ap_tax_amount ,oec.payment_date ,oec.payment_number ,oec.ap_inv_date ,oec.paid_amount ,oec.receipt_date FROM okl_ecc_charges_data oec ,fnd_lookup_values payout_basis ,fnd_lookup_values payment_basis WHERE payout_basis.lookup_code = nvl(oec.payout_basis,payout_basis.lookup_code) AND nvl(payout_basis.lookup_type,'OKL_PAYOUT_BASIS') = 'OKL_PAYOUT_BASIS' AND payment_basis.lookup_code = nvl(oec.payment_basis,payment_basis.lookup_code) AND payment_basis.lookup_type(+) = 'OKL_PAYMENT_BASIS' AND payment_basis.language = payout_basis.language AND payment_basis.language in ('US') AND oec.spec_flag ='N') PIVOT (MAX(payout_basis) AS payout_basis, MAX(payment_basis) AS payment_basis for language in('US' "US")) ) x where 2=2 AR ECC عقود الإيجار, بيانات الفاتورة بعقد الإيجار Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues D ECC Leasingverträge, Leasing - Rechnungsdaten Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues E ECC Lease Contracts, Información de Factura de Leasing Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues F ECC Contrats Lease, Informations de facture Lease Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues I ECC Contratti leasing, Informazioni fattura leasing Imported from Enterprise Command Center Description: Informazioni fattura di leasing Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues JA ECC リース契約, リース請求書情報 Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues KO ECC 리스 계약, 리스 송장 정보 Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues RU ECC Контракты на лизинг, Лизинг: сведения о счете-фактуре Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues S ECC Hyresavtal: Kontrakt, Hyresavtal: Fakturainformation Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues TR ECC Kiralama Sözleşmeleri, Kiralama Fatura Bilgileri Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues US ECC Lease Contracts, Lease Invoice Information Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues ZHS ECC Lease Contracts, 租赁发票信息 Imported from Enterprise Command Center Dataset Key: okl-couter-ar Query Procedure: OKL_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO Security Procedure: okl_ecc_datasecurity_pkg_pub.GetFilterAttributeValues Enterprise Command Center 1 10 2=2 x.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where haouv.name=: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) US Operating Unit