ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 0B22DF18E239D64AE0630100007FBD85 INV Organization Code (including master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code US All active inventory organization codes, restricted to the current user's org access view 58F7B0E8A74E1DC4E0630100007F880E QA Collection Element Y select distinct qc.name value, qc.prompt description from qa_plans qp, mtl_parameters mp, qa_plan_chars qpc, qa_chars qc where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpc.plan_id and qpc.char_id=qc.char_id and (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,mp.organization_code)='Y') and (:$flex$.Collection_Plan is null or xxen_util.contains(:$flex$.Collection_Plan,qp.name)='Y') and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) order by qc.name US 52162B9B8C221F1DE0630100007FADC0 QA Collection Plan Y select qp.name value, qp.description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id(+) and (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,mp.organization_code)='Y') and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) order by qp.name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 58F72EE3DD834F60E0630100007F35F5Y select x.* from ( select mp.organization_code, qp.name plan_name, qp.description plan_description, xxen_util.meaning(qp.plan_type_code,'COLLECTION_PLAN_TYPE',3) plan_type, qpc.prompt_sequence, qc.name element_name, qpc.prompt element_prompt, xxen_util.meaning(qc.char_type_code,'ELEMENT_TYPE',3) element_type, xxen_util.meaning(qc.datatype,'QA_CHAR_DATATYPE',700) datatype, xxen_util.meaning(qc.char_context_flag,'QA_CHAR_CONTEXT_FLAG',700) context_element, 'Plan' value_level, qpcvl.short_code, qpcvl.description value_description, qcvl.description element_master_description, xxen_util.yes(case when qcvl.short_code is not null then 'Y' end) in_element_master, xxen_util.yes(case when qcvl.short_code is not null and nvl(qpcvl.description,chr(1))<>nvl(qcvl.description,chr(1)) then 'Y' end) description_overridden, qpc.result_column_name result_column, xxen_util.yes(case when qpc.enabled_flag=1 then 'Y' end) element_enabled, xxen_util.yes(case when qpc.mandatory_flag=1 then 'Y' end) element_mandatory, xxen_util.user_name(qpcvl.created_by) created_by, xxen_util.client_time(qpcvl.creation_date) creation_date, xxen_util.user_name(qpcvl.last_updated_by) last_updated_by, xxen_util.client_time(qpcvl.last_update_date) last_update_date from qa_plans qp, mtl_parameters mp, qa_plan_chars qpc, qa_chars qc, qa_plan_char_value_lookups qpcvl, qa_char_value_lookups qcvl where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpc.plan_id and qpc.char_id=qc.char_id and qpc.plan_id=qpcvl.plan_id and qpc.char_id=qpcvl.char_id and qpcvl.char_id=qcvl.char_id(+) and qpcvl.short_code=qcvl.short_code(+) and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) and 1=1 union all select mp.organization_code, qp.name plan_name, qp.description plan_description, xxen_util.meaning(qp.plan_type_code,'COLLECTION_PLAN_TYPE',3) plan_type, qpc.prompt_sequence, qc.name element_name, qpc.prompt element_prompt, xxen_util.meaning(qc.char_type_code,'ELEMENT_TYPE',3) element_type, xxen_util.meaning(qc.datatype,'QA_CHAR_DATATYPE',700) datatype, xxen_util.meaning(qc.char_context_flag,'QA_CHAR_CONTEXT_FLAG',700) context_element, 'Element' value_level, qcvl.short_code, qcvl.description value_description, to_char(null) element_master_description, xxen_util.yes('Y') in_element_master, to_char(null) description_overridden, qpc.result_column_name result_column, xxen_util.yes(case when qpc.enabled_flag=1 then 'Y' end) element_enabled, xxen_util.yes(case when qpc.mandatory_flag=1 then 'Y' end) element_mandatory, xxen_util.user_name(qcvl.created_by) created_by, xxen_util.client_time(qcvl.creation_date) creation_date, xxen_util.user_name(qcvl.last_updated_by) last_updated_by, xxen_util.client_time(qcvl.last_update_date) last_update_date from qa_plans qp, mtl_parameters mp, qa_plan_chars qpc, qa_chars qc, qa_char_value_lookups qcvl where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpc.plan_id and qpc.char_id=qc.char_id and qpc.char_id=qcvl.char_id and not exists (select null from qa_plan_char_value_lookups qpcvl where qpc.plan_id=qpcvl.plan_id and qcvl.char_id=qpcvl.char_id and qcvl.short_code=qpcvl.short_code) and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) and 3=3 ) x where 2=2 order by x.organization_code, x.plan_name, x.prompt_sequence, x.element_name, x.short_code New report. Lists the allowed values behind list-validated Oracle Quality collection elements, as a union of the values carried by each collection plan (qa_plan_char_value_lookups) and the collection element master values that were not carried into the plan (qa_char_value_lookups), discriminated by a Value Level column. Plan rows additionally carry the master description, an In Element Master flag and a Description Overridden flag, so plan-versus-master divergence is visible per row. mtl_parameters is outer joined and organization 0 is admitted explicitly so the seeded template plans are not dropped; org_access_view inventory-org security otherwise applies. Optional Organization / Collection Plan / Plan Type / Collection Element / Enabled Elements Only parameters filter both branches, Value Level and Short Code filter the combined result. Anchor and LOV reuse corrections. The second union branch now carries its own 3=3 anchor instead of repeating 1=1, and each of the five shared branch filters gained a no display sequence sub row on that anchor, so the documented one anchor per sql position model is followed rather than relying on the engine replacing every occurrence of 1=1; a future parameter can now filter a single branch, and one that references an alias existing in only one branch can no longer be injected into the other. Plan Type references the Oracle standard value set QA_SRS_PLAN_TYPE_CODE instead of a hand written lookup query, and Collection Element references the new shared LOV QA Collection Element rather than duplicating the query, keeping the query as the documented fallback payload. The Collection Plan fallback query compares the Organization parent with xxen_util.contains instead of equality, matching the corrected shared QA Collection Plan LOV, so a multi select Organization no longer returns an empty Collection Plan list. Note the Plan and Element value_level literals in the two union branches and the Value Level LOV values are a coupled pair with no seeded lookup behind them and must always be changed together. US QA Collection Plan Element Values Lists the allowed values behind every list-validated Oracle Quality collection element - the entries an operator can pick when entering quality results, and the collection element master values each plan was seeded from. Oracle Quality holds these values in two independent places. A collection plan carries its own value list, and the collection element carries a master list. A plan is seeded from the master but is not tied to it afterwards: it can carry codes that were never in the master, override a master value's description, and leave master values out. The Value Level column says which is which. Plan means the value is offered on this collection plan, and is what quality results entry or a quality results upload must validate against. Element means the value is defined on the collection element master but was not carried into this plan, so it is not offered here. On a Plan row, Element Master Description shows the master's own wording for the same short code, In Element Master flags whether the code exists in the master at all, and Description Overridden flags the rows where the plan's wording differs from the master's. Result Column is the qa_results column this element's value is stored in, so a short code can be traced to the column that will hold it. Collection results are stored generically, so this mapping is what turns a stored value back into a business meaning. Leave the parameters blank for the full picture, or narrow with Organization, Collection Plan, Plan Type and Collection Element. Enabled Elements Only restricts to elements still enabled on the plan. Value Level isolates one of the two levels, and Short Code finds a particular value across plans. Enginatics 1=1 2=2 3=3 1 10 1=1 mp.organization_code=:organization LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code xxen_util.previous_parameter_value(:parameter_id) US Organization 2 3=3 mp.organization_code=:organization US Organization 3 20 1=1 qp.name=:collection_plan LOV QA Collection Plan 52162B9B8C221F1DE0630100007FADC0 Y select qp.name value, qp.description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id(+) and (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,mp.organization_code)='Y') and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) order by qp.name US Collection Plan 4 3=3 qp.name=:collection_plan US Collection Plan 5 30 1=1 qp.plan_type_code=:plan_type LOV Oracle QA_SRS_PLAN_TYPE_CODE Y select lookup_code id, meaning value, null description from fnd_common_lookups where lookup_type='COLLECTION_PLAN_TYPE' order by meaning US Plan Type 6 3=3 qp.plan_type_code=:plan_type US Plan Type 7 40 1=1 qc.name=:collection_element LOV QA Collection Element 58F7B0E8A74E1DC4E0630100007F880E Y select distinct qc.name value, qc.prompt description from qa_plans qp, mtl_parameters mp, qa_plan_chars qpc, qa_chars qc where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpc.plan_id and qpc.char_id=qc.char_id and (:$flex$.Organization is null or xxen_util.contains(:$flex$.Organization,mp.organization_code)='Y') and (:$flex$.Collection_Plan is null or xxen_util.contains(:$flex$.Collection_Plan,qp.name)='Y') and (qp.organization_id=0 or qp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id)) order by qc.name US Collection Element 8 3=3 qc.name=:collection_element US Collection Element 9 50 1=1 qpc.enabled_flag=1 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Enabled Elements Only 10 3=3 qpc.enabled_flag=1 Y US Enabled Elements Only 11 60 2=2 x.value_level=:value_level LOV custom Y select 'Plan' value, 'Value carried by this collection plan' description from dual union all select 'Element' value, 'Defined on the collection element but not carried into this plan' description from dual US Value Level 12 70 2=2 x.short_code=:short_code Char US Short Code