ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 35CE5787109A8597E06362FB09056AFA SELECT DISTINCT TO_CHAR(sysdate, 'MM-DD-YYYY') SYSTEM_DATE, QA.ID QUOTE_ID, QA.QUOTE_NUMBER QUOTE_NUMBER, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='OKL_QUOTE_TYPE' AND LANGUAGE = 'US' AND LOOKUP_CODE = QA.QUOTE_TYPE) QUOTE_TYPE, QA.QUOTE_STATUS QUOTE_STATUS, QA.QUOTE_REASON_DESCRIPTION QUOTE_REASON, QA.DATE_EFFECTIVE_FROM QUOTE_EFFECTIVE_FROMDISTI, QA.DATE_EFFECTIVE_TO QUOTE_EFFECTIVE_TO, QA.KHR_ID CONTRACT_ID, QA.CONTRACT_NUMBER CONTRACT_NUMBER, QA.CONTRACT_START_DATE CONTRACT_START_DATE, QA.CONTRACT_END_DATE CONTRACT_END_DATE, ROUND(MONTHS_BETWEEN(QA.CONTRACT_START_DATE,QA.CONTRACT_END_DATE)) CONTRACT_TERM, QA.CONTRACT_STATUS_MEANING CONTRACT_STATUS, QA.DATE_SENT DATE_SENT, QT.DATE_REQUESTED QUOTE_CREATION_DATE, QA.COMMENTS COMMENTS, QA.CURRENCY_CODE CURRENCY, QA.RECIPIENT_ID RECIPIENT_ID, QA.RECIPIENT_NAME RECIPIENT_NAME, QT.LAST_UPDATED_BY REQUESTOR_ID, NVL(PPF.FULL_NAME,FU.USER_NAME) REQUESTOR, QUOTE_ORG_ID ORG_ID, QA.AMOUNT QUOTE_TOTAL FROM OKL_AM_ASSET_QUOTES_UV QA, OKL_TRX_QUOTES_B QT, FND_USER FU, PER_PEOPLE_F PPF WHERE QA.ID= :P_QUOTE_ID AND QT.ID = QA.ID AND FU.USER_ID = QT.LAST_UPDATED_BY AND FU.EMPLOYEE_ID = PPF.PERSON_ID(+) AND PPF.EFFECTIVE_END_DATE >= sysdate Y OKL OKLACCEPTQUOTE AR OKL قبول عرض الأسعار (1) Imported from BI Publisher Application: إدارة الإيجار Source: Short Name: OKLACCEPTQUOTE DB package: D OKL Angebot akzeptieren (1) Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: E OKL Aceptar Oferta Imported from BI Publisher Application: Leasing and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: F OKL Accepter un devis (1) Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: I OKL Accetta preventivo Imported from BI Publisher Application: Leasing and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: JA OKL 見積の受入 Imported from BI Publisher Application: リースおよびファイナンス管理 Source: Short Name: OKLACCEPTQUOTE DB package: KO OKL 견적 수락 Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: PTB OKL Aceitar Cota Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: RU OKL Принять котировку Imported from BI Publisher Application: Управление лизингом и финансами Source: Short Name: OKLACCEPTQUOTE DB package: S OKL Acceptera offert Imported from BI Publisher Application: Hyres- och ekonomihantering Source: Short Name: OKLACCEPTQUOTE DB package: TR OKL Teklifi Kabul Et Imported from BI Publisher Application: Kiralama ve Finans Yönetimi Source: Short Name: OKLACCEPTQUOTE DB package: US OKL Accept Quote (1) Imported from BI Publisher Application: Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: ZHS OKL 接受报价 (1) Imported from BI Publisher Application: Oracle Lease and Finance Management Source: Short Name: OKLACCEPTQUOTE DB package: BI Publisher 1=1