ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 5B33D18D70F34759E0630100007FE55FY select haouv.name operating_unit, adsa.distribution_set_name distribution_set, adsa.description, adsa.inactive_date, adsla.distribution_set_line_number line_number, adsla.description line_description, gcck.concatenated_segments account, xxen_util.segments_description(gcck.code_combination_id) account_description, adsla.percent_distribution, adsla.type_1099 income_tax_type, adsla.vat_code tax_classification, ppa.segment1 project, pt.task_number task, adsla.expenditure_type, haouv_exp.name expenditure_organization, xxen_util.user_name(adsa.created_by) created_by, xxen_util.client_time(adsa.creation_date) creation_date, xxen_util.user_name(adsa.last_updated_by) last_updated_by, xxen_util.client_time(adsa.last_update_date) last_update_date, xxen_util.user_name(adsla.last_updated_by) line_last_updated_by, xxen_util.client_time(adsla.last_update_date) line_last_update_date from ap_distribution_sets_all adsa, ap_distribution_set_lines_all adsla, hr_all_organization_units_vl haouv, gl_code_combinations_kfv gcck, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl haouv_exp where 1=1 and adsa.org_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) and adsa.distribution_set_id=adsla.distribution_set_id and adsa.org_id=haouv.organization_id and adsla.dist_code_combination_id=gcck.code_combination_id(+) and adsla.project_id=ppa.project_id(+) and adsla.task_id=pt.task_id(+) and adsla.expenditure_organization_id=haouv_exp.organization_id(+) order by haouv.name, adsa.distribution_set_name, adsla.distribution_set_line_number Initial version, converted from the Oracle standard Distribution Set Listing (APXGDGDL_XML). US AP Distribution Set Listing Payables distribution sets and their lines with account, percentage, income tax type, tax classification and project details, one row per distribution set line. Equivalent to the Oracle standard Distribution Set Listing (APXGDGDL). The Status parameter evaluates active or inactive as of the Effective Date. Enginatics 1=1 :effective_date 1 10 1=1 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 coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 2 20 1=1 adsa.distribution_set_name=:distribution_set LOV custom Y select adsa.distribution_set_name value, min(adsa.description) description from ap_distribution_sets_all adsa where (:$flex$.operating_unit is null or adsa.org_id in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and adsa.org_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) group by adsa.distribution_set_name order by adsa.distribution_set_name US Distribution Set 3 30 :effective_date Date trunc(sysdate) Y US Effective Date 4 40 1=1 (adsa.inactive_date is null or adsa.inactive_date>:effective_date) LOV custom Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='ACTIVE_OPTIONS' and flvv.view_application_id=200 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and flvv.lookup_code in ('Active','Inactive') order by flvv.lookup_code Active US Status 5 1=1 adsa.inactive_date<=:effective_date Inactive US Status