ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 41D6D8E690C1CFABE06362FB0905C62A CRM Number Y SELECT PAA.ATTRIBUTE5 as value, null description FROM PA_AGREEMENTS_ALL PAA US Oracle Project Connected CRM Number 41D6D8E690C2CFABE06362FB0905C62A Customer Name LOV Test Y select customer_number value, customer_name description from ar_customers AR LOV لمدققي تقرير نفقات AP D LOV für Prüfer von AP-Ausgabenberichten E LOV para auditores de informes de gastos AP F LOV pour les auditeurs de notes de frais AP I LOV per i revisori dei rapporti di spesa AP JA LOV for AP経費報告書監査人 KO AP 경비 보고서 감사자를위한 LOV PTB LOV para o relatório de despesas da AP Auditores RU LOV для аудиторов отчетов о расходах ДП S LOV för AP Expense Report Auditors TR AP Gider Raporu Denetçileri için LOV US LOV For Customer Names ZHS 为亚太费用报告审计员提供的LOV 41D7A49F9F4BCFA9E06362FB09058781Y WITH OSM_ORDERS_DATA AS (SELECT PA.PROJECT_ID , PA.SEGMENT1 PROJECT_NUMBER , PA.NAME PROJECT_NAME , OU.NAME ORG_NAME , AC.CUSTOMER_NAME , PAA.AGREEMENT_NUM AGREEMENT_NUMBER , PAA.AGREEMENT_ID , PPF.PROJFUNC_ALLOCATED_AMOUNT AGREEMENT_AMOUNT , (SELECT SUM(PROJFUNC_ALLOCATED_AMOUNT) FROM PA_PROJECT_FUNDINGS WHERE PA_PROJECT_FUNDINGS.PROJECT_ID=PA.PROJECT_ID) TOTAL_AGREEMENT_AMOUNT , PPF.DATE_ALLOCATED AGREEMENT_CREATE_DATE , PAA.ATTRIBUTE6 CUSTOMER_PO_DATE , NVL(PPF.PROJFUNC_EXCHANGE_RATE,1) PROJFUNC_EXCHANGE_RATE FROM PA_PROJECTS_ALL PA , PA_AGREEMENTS_ALL PAA , PA_PROJECT_FUNDINGS PPF , AR_CUSTOMERS AC , HR_ALL_ORGANIZATION_UNITS_TL OU WHERE PA.PROJECT_ID = PPF.PROJECT_ID AND PPF.AGREEMENT_ID =PAA.AGREEMENT_ID AND PAA.CUSTOMER_ID = AC.CUSTOMER_ID AND PA.CARRYING_OUT_ORGANIZATION_ID = OU.ORGANIZATION_ID ) SELECT PROJECT_ID , PROJECT_NUMBER , PROJECT_NAME , NVL((SELECT MANAGER_NAME FROM PA_PROJ_INFO_VIEW WHERE (PROJECT_ID = A.PROJECT_ID)), ' ') AS PROJECT_MANAGER , CUSTOMER_NAME , AGREEMENT_NUMBER , AGREEMENT_AMOUNT , TOTAL_AGREEMENT_AMOUNT , NVL((SELECT PAA.ATTRIBUTE5 FROM PA_AGREEMENTS_ALL PAA WHERE PAA.AGREEMENT_ID = A.AGREEMENT_ID),' ') AS CRM_NUMBER , NVL((SELECT PAA.ATTRIBUTE1 FROM PA_AGREEMENTS_ALL PAA WHERE PAA.AGREEMENT_ID = A.AGREEMENT_ID),' ') AS INCO_TERMS , AGREEMENT_CREATE_DATE , CUSTOMER_PO_DATE , (SELECT SUM(RAW_COST) FROM PA_BUDGET_VERSIONS_BASELINED_V WHERE budget_type_code = 'AC' AND PROJECT_ID = A.PROJECT_ID AND BUDGET_STATUS_CODE IN ('B') AND CURRENT_ORIGINAL_FLAG = 'Y' ) AS PROJECT_ORIGINAL_BUDGET_COST , (SELECT SUM(REVENUE) FROM PA_BUDGET_VERSIONS_BASELINED_V WHERE budget_type_code = 'AR' AND PROJECT_ID = A.PROJECT_ID AND BUDGET_STATUS_CODE IN ('B') AND CURRENT_ORIGINAL_FLAG = 'Y' ) AS PROJECT_ORIGINAL_REVENUE_AMOUNT FROM OSM_ORDERS_DATA A where 1 = 1 US Project OSM Detailed Report Test Training Purposes 1=1 1 10 1=1 project_number=:p_project LOV custom Y select ppa.project_number value, ppa.project_type||': '||ppa.name description from ( select ppa.segment1 project_number, ppa.name, ppa.project_type, ppa.org_id, ppa.creation_date, ppa.project_id from pa_projects_all ppa union all select psm.project_number, psm.project_name, 'PJM Seiban' project_type, psm.operating_unit, psm.creation_date, psm.project_id from pjm_seiban_numbers psm ) ppa, org_organization_definitions ood where ppa.org_id=ood.operating_unit and ( :$flex$.organization_code is null and ood.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) or xxen_util.contains(:$flex$.organization_code,ood.organization_id)='Y' ) and ( :$flex$.organization_code is null or ppa.project_id in ( select mfd.project_id from mrp_forecast_dates mfd where mfd.project_id is not null and xxen_util.contains(mfd.organization_id,:$flex$.organization_code)='Y' ) ) order by ppa.creation_date desc, ppa.project_number desc US Project 2 20 1=1 crm_number=:p_crm_number LOV CRM Number 41D6D8E690C1CFABE06362FB0905C62A Y SELECT PAA.ATTRIBUTE5 as value, null description FROM PA_AGREEMENTS_ALL PAA US CRM Number 3 30 1=1 customer_name=:p_customer_name LOV Customer Name LOV Test 41D6D8E690C2CFABE06362FB0905C62A Y select customer_number value, customer_name description from ar_customers US Customer Name 4 40 1=1 Agreement_create_date>=:p_start_date DateTime US Agreement Created Start Date 5 50 1=1 Agreement_create_date<=:p_end_date DateTime US Agreement Created End Date