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 58F730E8D8015189E0630100007F1D15Y 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, qp.effective_from, qp.effective_to, 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, qc.display_length, nvl(qpc.decimal_precision,qc.decimal_precision) decimal_precision, (select mumv.unit_of_measure from mtl_units_of_measure_vl mumv where nvl(qpc.uom_code,qc.uom_code)=mumv.uom_code) unit_of_measure, xxen_util.yes(case when qpc.mandatory_flag=1 then 'Y' end) mandatory, xxen_util.yes(case when qpc.enabled_flag=1 then 'Y' end) enabled, xxen_util.yes(case when qpc.displayed_flag=1 then 'Y' end) displayed, xxen_util.yes(case when qpc.read_only_flag=1 then 'Y' end) read_only, xxen_util.yes(case when qpc.information_flag=1 then 'Y' end) information, xxen_util.yes(case when qpc.ss_poplist_flag=1 then 'Y' end) poplist, qpc.default_value, qc.default_value element_default_value, qpc.result_column_name result_column, xxen_util.meaning(qc.char_context_flag,'QA_CHAR_CONTEXT_FLAG',700) context_element, qc.hardcoded_column, xxen_util.yes(case when qpc.values_exist_flag=1 then 'Y' end) values_exist, (select count(*) from qa_plan_char_value_lookups qpcvl where qpc.plan_id=qpcvl.plan_id and qpc.char_id=qpcvl.char_id) value_count, qc.fk_table_name validation_table, qc.fk_add_where validation_where_clause, qc.sql_validation_string, qc.data_entry_hint, qc.target_value, qc.upper_spec_limit, qc.lower_spec_limit, xxen_util.user_name(qpc.created_by) created_by, xxen_util.client_time(qpc.creation_date) creation_date, xxen_util.user_name(qpc.last_updated_by) last_updated_by, xxen_util.client_time(qpc.last_update_date) last_update_date 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 (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 order by mp.organization_code, qp.name, qpc.prompt_sequence, qc.name Initial version. Lists every collection element assigned to an Oracle Quality collection plan with its prompt, sequence, type, datatype, precision, UOM, default values and plan level flags, plus the result column that maps the element onto qa_results, the element's native hardcoded column, the context element classification and the validation table, where clause, SQL validation string and plan value count. Plans are outer joined to their elements and mtl_parameters so plans with no elements and the seeded template plans in organization 0 are still listed; org_access_view inventory organization security with organization 0 admitted. Optional Organization, Collection Plan, Plan Type, Collection Element, Element Type and Enabled Elements Only parameters. LOV reuse corrections. Plan Type and Element Type now reference the Oracle standard value sets QA_SRS_PLAN_TYPE_CODE and QA_SRS_ELEMENT_TYPE_CODE instead of hand written lookup queries; both value sets are seeded on R12 and 11i and return the same lookup_code id and translated meaning, so the bind and the SQL_TEXT are unchanged. Collection Element now references the new shared LOV QA Collection Element rather than duplicating the query in each report, 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 that a multi select Organization no longer returns an empty Collection Plan list. Table names in the description lowercased for consistency with the sibling report. US QA Collection Plan Elements Every collection element assigned to an Oracle Quality collection plan, with the element's prompt and sequence on the plan, its element type, datatype, display length, decimal precision and unit of measure, the plan level and element level default values, and the Mandatory, Enabled, Displayed, Read Only, Information and Poplist flags. Collection plans that have no elements are listed too. Oracle Quality stores every collection result generically in qa_results, whose character1 to character100 columns carry no meaning of their own: the element to column mapping is held per plan in qa_plan_chars.result_column_name, and each plan gets its own dynamically generated results view. This report exposes that mapping as the Result Column, shown verbatim next to the element's native Hardcoded Column so that a divergence between the two is visible at a glance. It also shows the Context Element classification, which separates a quality characteristic the operator enters from predefined reference information captured automatically from the transaction, and all three validation sources an element can use: a validation table with its additional where clause, a SQL validation string, and the number of plan level values the element offers. Use it to document or audit a Quality setup, and as the specification when building an interface or an upload that writes collection results. Filter with the optional Organization, Collection Plan, Plan Type, Collection Element and Element Type parameters, or set Enabled Elements Only to Yes to hide elements that are disabled on the plan. Leaving Organization blank returns every collection plan the responsibility has inventory organization access to, plus the seeded template plans, which are not owned by an inventory organization and therefore show a blank Organization Code. Enginatics 1=1 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 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 3 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 4 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 5 50 1=1 qc.char_type_code=:element_type LOV Oracle QA_SRS_ELEMENT_TYPE_CODE Y select lookup_code id, meaning value, null description from fnd_common_lookups where lookup_type='ELEMENT_TYPE' order by meaning US Element Type 6 60 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