ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit 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 Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 FAEA24CB5B4E92CCE0530100007F4C87 PN Lease Class Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_LEASE_CLASS' and view_application_id=0 and enabled_flag='Y' order by value,description US 2F9413DFCBFD085CE0636DFB0905FB02 PN Lease Name - with Schedules Y Y select plv.lease_name value, plv.lease_number || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US 2F9FAC2F4D57086AE0636DFB09056994 PN Lease Number - with Schedules Y Y select plv.lease_number value, plv.lease_name || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US FAEA382CD59B9A20E0530100007FBCAB PN Lease Type Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_LEASE_TYPE' and view_application_id=0 and enabled_flag='Y' order by value,description US 2F97920750BD0858E0636DFB0905569A PN Location Y select pl.location_code id, pl.location_code value, pl.description description from pn_locations pl order by value, description US 2F97920750BC0858E0636DFB0905569A select null action_, null status_, null message_, null request_id_, null modified_columns_, ppsv.payment_schedule_id, -- haouv.name operating_unit, ppsv.lease_name, ppsv.lease_number, xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) lease_approval_status, xxen_util.meaning(ppsv.lease_class_code,'PN_LEASE_CLASS',0) lease_class, xxen_util.user_name(plda.responsible_user,'N') responsible_user, ppsv.schedule_date, xxen_util.meaning(ppsv.payment_status_lookup_code,'PN_PAYMENT_STATUS_TYPE',0) payment_billing_status, ppsv.user_approved_by approved_by, ppsv.period_name period, pnp_util_func.get_total_payment_item_amt (ppsv.payment_status_lookup_code, :p_sob_currency, ppsv.payment_schedule_id, 'PNTAUPMT' ) total_amount, ppsv.user_transferred_by, ppsv.approval_date, ppsv.transfer_date, -- xxen_util.meaning(ppsv.lease_status,'PN_LEASESTATUS_TYPE',0) lease_status, ppsv.lease_id, ppsv.lease_change_id, :p_set_of_books_id set_of_books_id, :p_sob_currency set_of_books_currency from pn_payment_schedules_v ppsv, pn_leases_v plv, pn_lease_details plda, hr_all_organization_units_vl haouv where 1=1 and :p_upload_mode like '%' || xxen_upload.action_update || '%' and :p_set_of_books_id=:p_set_of_books_id and ppsv.lease_id = plv.lease_id and ppsv.lease_id = plda.lease_id and ppsv.org_id = haouv.organization_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D') ) Y U A xxen_pn_upload.upload_schedule_status US PN Schedule Approval Status Upload Property Management - Schedule Approval Status Upload This upload allows users to Approve (Approved status), Un-Approve (Draft status), or place On Hold Payment and Billing Schedules in Property Management. This upload offers the same functionality as the Oracle Authorize Payments and the Authorize Billings forms. Upload Mode ================= When run in “Create, Update” mode, the Payment/Billing Schedules matching the criteria specified in the report parameters will be downloaded into Excel where the user can review and amend the Payment/Billing Approval Status and, for approved schedules, the Approver and the Period. When run in “Create” mode, an empty excel will be generated. This mode allows the user to paste Payment/Billing schedule data from another source. In this mode the upload will find the matching Payment/Billing Schedule based on the data in each excel row and apply the approval change. The upload will return an error message if the upload cannot find a matching schedule, or if it finds multiple matching schedules. Approved Schedules ================= - if the Approver is not specified in the upload excel, then the username of the user executing the upload is used. - if the Period is not specified in the upload excel, then this will be derived during the upload based on the Schedule Date Notes ================= You cannot create new Payment/Billing schedules using this upload. It can only be used for updating the approval status of existing Payment/Billing Schedules. Enginatics R12 only Upload 1=1 :p_set_of_books_id :p_sob_currency :p_upload_mode 1 -20 :p_set_of_books_id LOV Oracle PN_SETS_OF_BOOKS Y select set_of_books_id id, name value, null description from gl_sets_of_books where name in (select name from gl_ledgers where ledger_id in (select ledger_id from gl_access_set_ledgers where access_set_id=fnd_profile.value('GL_ACCESS_SET_ID'))) order by value,description select pn.set_of_books_id from pn_system_setup_options pn, hr_operating_units hou where pn.org_id = hou.organization_id and (xxen_util.contains(:$flex$.operating_unit,hou.name) = 'Y' or (:$flex$.operating_unit is null and hou.organization_id = fnd_profile.value('ORG_ID')) ) and rownum = 1 US Ledger ID 2 -10 :p_sob_currency Char select gsob.currency_code from gl_sets_of_books gsob where gsob.set_of_books_id = :$flex$.Ledger_ID US Ledger Currency 3 10 :p_upload_mode LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 4 20 1=1 haouv.name=:p_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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 5 30 1=1 nvl(plv.customer_name,plv.supplier_name) = :p_third_party_name LOV custom Y Y select distinct nvl(plv.customer_name,plv.supplier_name) value, null description from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y') order by value US Third Party Name 6 40 1=1 plv.lease_class = :p_lease_class LOV PN Lease Class FAEA24CB5B4E92CCE0530100007F4C87 Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_LEASE_CLASS' and view_application_id=0 and enabled_flag='Y' order by value,description US Lease Class 7 50 1=1 plv.lease_type = :p_lease_type LOV PN Lease Type FAEA382CD59B9A20E0530100007FBCAB Y select meaning value, description description from fnd_lookup_values_vl where lookup_type='PN_LEASE_TYPE' and view_application_id=0 and enabled_flag='Y' order by value,description US Lease Type 8 60 1=1 plv.lease_name = :p_lease_name LOV PN Lease Name - with Schedules 2F9413DFCBFD085CE0636DFB0905FB02 Y Y select plv.lease_name value, plv.lease_number || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US Lease Name 9 70 1=1 plv.lease_name >= :p_lease_name_fr LOV PN Lease Name - with Schedules 2F9413DFCBFD085CE0636DFB0905FB02 Y Y select plv.lease_name value, plv.lease_number || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US Lease Name From 10 80 1=1 plv.lease_name <= :p_lease_name_to LOV PN Lease Name - with Schedules 2F9413DFCBFD085CE0636DFB0905FB02 Y Y select plv.lease_name value, plv.lease_number || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value :$flex$.Lease_Name_From US Lease Name To 11 90 1=1 plv.lease_number = :p_lease_number LOV PN Lease Number - with Schedules 2F9FAC2F4D57086AE0636DFB09056994 Y Y select plv.lease_number value, plv.lease_name || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US Lease Number 12 100 1=1 plv.lease_number >= :p_lease_number_fr LOV PN Lease Number - with Schedules 2F9FAC2F4D57086AE0636DFB09056994 Y Y select plv.lease_number value, plv.lease_name || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value US Lease Number From 13 110 1=1 plv.lease_number <= :p_lease_number_to LOV PN Lease Number - with Schedules 2F9FAC2F4D57086AE0636DFB09056994 Y Y select plv.lease_number value, plv.lease_name || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') and (:$flex$.final_draft_status is null or plv.status = xxen_util.lookup_code(:$flex$.final_draft_status,'PN_LEASE_STATUS_TYPE',0)) and (:$flex$.lease_class is null or plv.lease_class = :$flex$.lease_class) and (:$flex$.lease_status is null or xxen_util.contains(:$flex$.lease_status,xxen_util.meaning(plv.lease_status,'PN_LEASESTATUS_TYPE',0))='Y') and (:$flex$.lease_type is null or xxen_util.contains(:$flex$.lease_type,plv.lease_type)='Y') and (:$flex$.third_party_name is null or xxen_util.contains(:$flex$.third_party_name,nvl(plv.customer_name,plv.supplier_name))='Y') and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value :$flex$.Lease_Number_From US Lease Number To 14 115 1=1 ppsv.payment_status_lookup_code=:p_schedule_status LOV custom Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='PN_PAYMENT_STATUS_TYPE' order by value,description DRAFT US Schedule Status 15 120 1=1 ppsv.schedule_date>=:p_schedule_from_date Date US Schedule Date From 16 130 1=1 ppsv.schedule_date<trunc(:p_schedule_to_date)+1 Date :$flex$.Schedule_Date_From US Schedule Date To 17 140 1=1 exists ( select null from pn_payment_items_all ppia where ppia.payment_schedule_id = ppsv.payment_schedule_id and ppia.due_date >= :p_trx_from_date ) Date US Transaction Date From 18 150 1=1 exists ( select null from pn_payment_items_all ppia where ppia.payment_schedule_id = ppsv.payment_schedule_id and ppia.due_date < trunc(:p_trx_to_date)+1 ) Date :$flex$.Transaction_Date_From US Transaction Date To 19 160 1=1 exists ( select null from pn_tenancies_all pta, pn_locations_all pla where pta.lease_id = ppsv.lease_id and pta.location_id = pla.location_id and pla.location_code = :p_location_code ) LOV PN Location 2F97920750BD0858E0636DFB0905569A Y select pl.location_code id, pl.location_code value, pl.description description from pn_locations pl order by value, description US Location 20 170 1=1 exists ( select null from pn_tenancies_all pta, pn_locations_all pla where pta.lease_id = ppsv.lease_id and pta.location_id = pla.location_id and pla.location_code >= :p_location_from_code ) LOV PN Location 2F97920750BD0858E0636DFB0905569A Y select pl.location_code id, pl.location_code value, pl.description description from pn_locations pl order by value, description US Location From 21 180 1=1 exists ( select null from pn_tenancies_all pta, pn_locations_all pla where pta.lease_id = ppsv.lease_id and pta.location_id = pla.location_id and pla.location_code <= :p_location_to_code ) LOV PN Location 2F97920750BD0858E0636DFB0905569A Y select pl.location_code id, pl.location_code value, pl.description description from pn_locations pl order by value, description :$flex$.Location_From US Location To 22 250 1=1 plda.responsible_user=xxen_util.user_id(:p_responsible_user) LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Lease Responsible User 23 260 1=1 ppsv.user_approved_by=:p_approved_by_user LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US Schedule Approved By User 24 270 1=1 ppsv.period_name=:p_approved_period LOV custom Y select distinct gps.period_name id, gps.period_name value, gps.start_date || ' - ' || gps.end_date || ' (' || gps.closing_status || ')' description, gps.start_date from gl_period_statuses gps, gl_sets_of_books gsob where gps.set_of_books_id=:$flex$.ledger_id and gsob.set_of_books_id=gps.set_of_books_id and gsob.accounted_period_type=gps.period_type and gps.adjustment_period_flag='N' and gps.closing_status in ('O','F') and gps.application_id in (200,222) order by gps.start_date desc, gps.period_name US Schedule Approved Period :$flex$.Lease_Name_From Lease Name From Lease Name To :$flex$.Lease_Number_From Lease Number From Lease Number To :$flex$.Ledger_ID Ledger ID Ledger Currency :$flex$.Location_From Location From Location To :$flex$.Schedule_Date_From Schedule Date From Y Schedule Date To :$flex$.Transaction_Date_From Transaction Date From Y Transaction Date To :$flex$.lease_class Lease Class Lease Name :$flex$.lease_class Lease Class Lease Name From :$flex$.lease_class Lease Class Lease Name To :$flex$.lease_class Lease Class Lease Number :$flex$.lease_class Lease Class Lease Number From :$flex$.lease_class Lease Class Lease Number To :$flex$.lease_type Lease Type Lease Name :$flex$.lease_type Lease Type Lease Name From :$flex$.lease_type Lease Type Lease Name To :$flex$.lease_type Lease Type Lease Number :$flex$.lease_type Lease Type Lease Number From :$flex$.lease_type Lease Type Lease Number To :$flex$.ledger_id Ledger ID Schedule Approved Period :$flex$.operating_unit Operating Unit Lease Name :$flex$.operating_unit Operating Unit Lease Name From :$flex$.operating_unit Operating Unit Lease Name To :$flex$.operating_unit Operating Unit Lease Number :$flex$.operating_unit Operating Unit Lease Number From :$flex$.operating_unit Operating Unit Lease Number To :$flex$.operating_unit Operating Unit Ledger ID :$flex$.operating_unit Operating Unit Third Party Name :$flex$.third_party_name Third Party Name Lease Name :$flex$.third_party_name Third Party Name Lease Name From :$flex$.third_party_name Third Party Name Lease Name To :$flex$.third_party_name Third Party Name Lease Number :$flex$.third_party_name Third Party Name Lease Number From :$flex$.third_party_name Third Party Name Lease Number To 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 PAYMENT_SCHEDULE_ID Number number Y 7 OPERATING_UNIT LOV varchar2 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 Y Y 8 LEASE_NAME LOV custom varchar2 Y select plv.lease_name value, plv.lease_number || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and (:$column$.lease_number is null or (plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) ) ) and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value select plv.lease_name from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) Y 9 LEASE_NUMBER LOV custom varchar2 Y select plv.lease_number value, plv.lease_name || ' - ' || plv.lease_class || ' - ' || plv.lease_type || ' - ' || nvl(plv.customer_name,plv.supplier_name) || ' - ' || xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) description from pn_leases_v plv, hr_all_organization_units haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and (:$column$.lease_name is null or plv.lease_name = :$column$.lease_name) and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) order by value Y Y 10 LEASE_APPROVAL_STATUS LOV custom varchar2 Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type = 'PN_LEASE_STATUS_TYPE' and enabled_flag = 'Y' and lookup_code in ( select plv.status from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) ) order by value,description select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'PN_LEASE_STATUS_TYPE' and fl.enabled_flag = 'Y' select xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and exists (select null from pn_payment_schedules_v ppsv where ppsv.lease_id = plv.lease_id and (ppsv.status = 'F' or (ppsv.lease_status in ('LOF','SGN') and ppsv.status ='D')) ) Y Y 11 LEASE_CLASS LOV custom varchar2 Y select lookup_code id, meaning value, description description from fnd_lookups where lookup_type='PN_LEASE_CLASS' and enabled_flag='Y' and lookup_code in ( select plv.lease_class_code from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) ) order by value,description select plv.lease_class from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) Y 12 RESPONSIBLE_USER LOV custom varchar2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') and fu.user_id in ( select plda.responsible_user from pn_leases_v plv, pn_lease_details plda, hr_all_organization_units_vl haouv where plv.lease_id = plda.lease_id and plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) ) order by fu.inactive desc, fu.user_name select fu.user_name from fnd_user fu where fu.user_id in ( select plda.responsible_user from pn_leases_v plv, pn_lease_details plda, hr_all_organization_units_vl haouv where plv.lease_id = plda.lease_id and plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) ) Y 13 SCHEDULE_DATE Date date Y Y 14 PAYMENT_BILLING_STATUS LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='PN_PAYMENT_STATUS_TYPE' order by value,description select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'PN_PAYMENT_STATUS_TYPE' and fl.enabled_flag = 'Y' Y 15 APPROVED_BY LOV custom varchar2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') and :$column$.payment_billing_status = xxen_util.meaning('APPROVED','PN_PAYMENT_STATUS_TYPE',0) order by fu.inactive desc, fu.user_name select fu.user_id id, fu.user_name value from fnd_user fu select fnd_global.user_name from dual where :$column$.payment_billing_status = xxen_util.meaning('APPROVED','PN_PAYMENT_STATUS_TYPE',0) 16 PERIOD LOV custom varchar2 Y select distinct gps.period_name id, gps.period_name value, to_char(gps.start_date,'DD-MON-RR') || ' - ' || to_char(gps.end_date,'DD-MON-RR') || ' (' || gps.closing_status || ')' description, gps.start_date from gl_period_statuses gps, gl_sets_of_books gsob where gps.set_of_books_id=:$flex$.ledger_id and gsob.set_of_books_id=gps.set_of_books_id and gsob.accounted_period_type=gps.period_type and gps.adjustment_period_flag='N' and gps.closing_status in ('O','F') and gps.application_id = (select decode(plv.lease_class_code,'DIRECT',200,222) from pn_leases_v plv where plv.lease_number = :$column$.lease_number and plv.status = xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0)) and :$column$.payment_billing_status = xxen_util.meaning('APPROVED','PN_PAYMENT_STATUS_TYPE',0) order by gps.start_date desc, gps.period_name select pnp_util_func.get_default_gl_period (:$column$.schedule_date, decode(plv.lease_class_code,'DIRECT',200,222), plv.org_id ) from pn_leases_v plv, hr_all_organization_units_vl haouv where plv.org_id = haouv.organization_id and haouv.name = :$column$.operating_unit and plv.lease_number = :$column$.lease_number and plv.status = nvl(xxen_util.lookup_code(:$column$.lease_approval_status,'PN_LEASE_STATUS_TYPE',0),plv.status) and :$column$.payment_billing_status = xxen_util.meaning('APPROVED','PN_PAYMENT_STATUS_TYPE',0) 17 TOTAL_AMOUNT Number number Y 18 USER_TRANSFERRED_BY Char varchar2 Y 19 APPROVAL_DATE Date date Y 20 TRANSFER_DATE Date date Y 21 LEASE_STATUS Char varchar2 Y 22 LEASE_ID Number number Y 23 LEASE_CHANGE_ID Number number Y 24 SET_OF_BOOKS_ID Char varchar2 :$flex$.Ledger_ID Y Y 25 SET_OF_BOOKS_CURRENCY Char varchar2 :$flex$.Ledger_Currency Y Y U 2 p_operating_unit in Char OPERATING_UNIT U 3 p_lease_number in Char LEASE_NUMBER U 4 p_lease_name in Char LEASE_NAME U 5 p_lease_approval_status in Char LEASE_APPROVAL_STATUS U 6 p_schedule_date in Date SCHEDULE_DATE U 7 p_payment_status_lookup_code in Char PAYMENT_BILLING_STATUS U 8 p_approved_by_user_id in Number APPROVED_BY U 9 p_period in Char PERIOD U 10 p_set_of_books_id in Number SET_OF_BOOKS_ID U 11 p_set_of_books_currency in Char SET_OF_BOOKS_CURRENCY U 12 p_payment_schedule_id in/out Char PAYMENT_SCHEDULE_ID U 13 request_id_ out Number REQUEST_ID_ U 14 status_ out Char STATUS_CODE_ U 15 message_ out Char MESSAGE_ Error SQL Order By lease_name, lease_number, lease_id, schedule_date Success SQL select xxen_upload.action_meaning(xxen_upload.action_update) action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.payment_schedule_id, -- haouv.name operating_unit, ppsv.lease_name, ppsv.lease_number, xxen_util.meaning(plv.status,'PN_LEASE_STATUS_TYPE',0) lease_approval_status, xxen_util.meaning(ppsv.lease_class_code,'PN_LEASE_CLASS',0) lease_class, xxen_util.user_name(plda.responsible_user,'N') responsible_user, ppsv.schedule_date, xxen_util.meaning(ppsv.payment_status_lookup_code,'PN_PAYMENT_STATUS_TYPE',0) payment_billing_status, ppsv.user_approved_by approved_by, ppsv.period_name period, pnp_util_func.get_total_payment_item_amt (ppsv.payment_status_lookup_code, :p_sob_currency, ppsv.payment_schedule_id, 'PNTAUPMT' ) total_amount, ppsv.user_transferred_by, ppsv.approval_date, ppsv.transfer_date, -- xxen_util.meaning(ppsv.lease_status,'PN_LEASESTATUS_TYPE',0) lease_status, ppsv.lease_id, ppsv.lease_change_id, xu.set_of_books_id, xu.set_of_books_currency from xxen_pn_schedule_approv_7305_u xu, pn_payment_schedules_v ppsv, pn_leases_v plv, pn_lease_details plda, hr_all_organization_units_vl haouv where xu.status_code_ = xxen_upload.status_success and xu.payment_schedule_id = ppsv.payment_schedule_id and ppsv.lease_id = plv.lease_id and ppsv.lease_id = plda.lease_id and ppsv.org_id = haouv.organization_id LOV query :$column$.payment_billing_status PAYMENT_BILLING_STATUS APPROVED_BY Default value :$column$.payment_billing_status PAYMENT_BILLING_STATUS APPROVED_BY LOV query :$column$.lease_number LEASE_NUMBER LEASE_APPROVAL_STATUS Default value :$column$.lease_number LEASE_NUMBER LEASE_APPROVAL_STATUS LOV query :$column$.operating_unit OPERATING_UNIT LEASE_APPROVAL_STATUS Default value :$column$.operating_unit OPERATING_UNIT LEASE_APPROVAL_STATUS LOV query :$column$.lease_approval_status LEASE_APPROVAL_STATUS LEASE_CLASS Default value :$column$.lease_approval_status LEASE_APPROVAL_STATUS LEASE_CLASS LOV query :$column$.lease_number LEASE_NUMBER LEASE_CLASS Default value :$column$.lease_number LEASE_NUMBER LEASE_CLASS Default value :$column$.operating_unit OPERATING_UNIT LEASE_CLASS LOV query :$column$.operating_unit OPERATING_UNIT LEASE_CLASS LOV query :$column$.lease_approval_status LEASE_APPROVAL_STATUS LEASE_NAME Default value :$column$.lease_approval_status LEASE_APPROVAL_STATUS LEASE_NAME LOV query :$column$.lease_number LEASE_NUMBER LEASE_NAME Default value :$column$.lease_number LEASE_NUMBER LEASE_NAME Default value :$column$.operating_unit OPERATING_UNIT LEASE_NAME LOV query :$column$.operating_unit OPERATING_UNIT LEASE_NAME LOV query :$column$.lease_name LEASE_NAME LEASE_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT LEASE_NUMBER LOV query :$column$.lease_approval_status LEASE_APPROVAL_STATUS PERIOD Default value :$column$.lease_approval_status LEASE_APPROVAL_STATUS PERIOD Default value :$column$.lease_number LEASE_NUMBER PERIOD LOV query :$column$.lease_number LEASE_NUMBER PERIOD Default value :$column$.operating_unit OPERATING_UNIT PERIOD Default value :$column$.payment_billing_status PAYMENT_BILLING_STATUS PERIOD LOV query :$column$.payment_billing_status PAYMENT_BILLING_STATUS PERIOD Default value :$column$.schedule_date SCHEDULE_DATE PERIOD LOV query :$flex$.ledger_id Ledger ID|:p_set_of_books_id| PERIOD Default value :$column$.lease_approval_status LEASE_APPROVAL_STATUS RESPONSIBLE_USER LOV query :$column$.lease_approval_status LEASE_APPROVAL_STATUS RESPONSIBLE_USER LOV query :$column$.lease_number LEASE_NUMBER RESPONSIBLE_USER Default value :$column$.lease_number LEASE_NUMBER RESPONSIBLE_USER LOV query :$column$.operating_unit OPERATING_UNIT RESPONSIBLE_USER Default value :$column$.operating_unit OPERATING_UNIT RESPONSIBLE_USER Default value :$flex$.Ledger_Currency Ledger Currency|:p_sob_currency| SET_OF_BOOKS_CURRENCY Default value :$flex$.Ledger_ID Ledger ID|:p_set_of_books_id| SET_OF_BOOKS_ID