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 58FCD7736ABA6044E0630100007F05D3Y 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, 'Plan' action_level, qpc.prompt_sequence, qc.name element_name, qpc.prompt element_prompt, qpcat.trigger_sequence action_trigger_sequence, xxen_util.meaning(qpcat.operator,'QA_OPERATOR',700) trigger_operator, nvl(qpcat.low_value_other,xxen_util.meaning(qpcat.low_value_lookup,'QA_ACTION_TRIGGER_VALUE',700)) trigger_low_value, nvl(qpcat.high_value_other,xxen_util.meaning(qpcat.high_value_lookup,'QA_ACTION_TRIGGER_VALUE',700)) trigger_high_value, qa.description action_name, xxen_util.yes(case when qa.online_flag=1 then 'Y' end) online_action, case when qpca.assigned_char_id is not null then decode(qpca.assign_type,'F','Formula','S','SQL Statement') end assign_type, qc_assigned.name assigned_element, aas.name alert_action_set, aa.name alert_action, qpca.status_code, qpca.message action_message, (select listagg(qpcao.token_name,', ') within group (order by qpcao.token_name) from qa_plan_char_action_outputs qpcao where qpca.plan_char_action_id=qpcao.plan_char_action_id) output_variable, ( select listagg(qc_output.name,', ') within group (order by qpcao.token_name) from qa_plan_char_action_outputs qpcao, qa_chars qc_output where qpca.plan_char_action_id=qpcao.plan_char_action_id and qpcao.char_id=qc_output.char_id ) output_element, xxen_util.yes(case when qpc.enabled_flag=1 then 'Y' end) element_enabled, xxen_util.yes(case when qa.enabled_flag=1 then 'Y' end) action_enabled, xxen_util.user_name(nvl(qpca.created_by,qpcat.created_by)) created_by, xxen_util.client_time(nvl(qpca.creation_date,qpcat.creation_date)) creation_date, xxen_util.user_name(nvl(qpca.last_updated_by,qpcat.last_updated_by)) last_updated_by, xxen_util.client_time(nvl(qpca.last_update_date,qpcat.last_update_date)) last_update_date from qa_plans qp, mtl_parameters mp, qa_plan_char_action_triggers qpcat, qa_chars qc, qa_plan_chars qpc, qa_plan_char_actions qpca, qa_actions qa, qa_chars qc_assigned, alr_action_sets aas, alr_actions aa where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpcat.plan_id and qpcat.char_id=qc.char_id and qpcat.plan_id=qpc.plan_id(+) and qpcat.char_id=qpc.char_id(+) and qpcat.plan_char_action_trigger_id=qpca.plan_char_action_trigger_id(+) and qpca.action_id=qa.action_id(+) and qpca.assigned_char_id=qc_assigned.char_id(+) and qpca.alr_action_set_id=aas.action_set_id(+) and qpca.alr_action_id=aa.action_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 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, 'Element' action_level, qpc.prompt_sequence, qc.name element_name, qpc.prompt element_prompt, qcat.trigger_sequence action_trigger_sequence, xxen_util.meaning(qcat.operator,'QA_OPERATOR',700) trigger_operator, nvl(qcat.low_value_other,xxen_util.meaning(qcat.low_value_lookup,'QA_ACTION_TRIGGER_VALUE',700)) trigger_low_value, nvl(qcat.high_value_other,xxen_util.meaning(qcat.high_value_lookup,'QA_ACTION_TRIGGER_VALUE',700)) trigger_high_value, qa.description action_name, xxen_util.yes(case when qa.online_flag=1 then 'Y' end) online_action, to_char(null) assign_type, to_char(null) assigned_element, aas.name alert_action_set, aa.name alert_action, qca.status_code, qca.message action_message, (select listagg(qcao.token_name,', ') within group (order by qcao.token_name) from qa_char_action_outputs qcao where qca.char_action_id=qcao.char_action_id) output_variable, ( select listagg(qc_output.name,', ') within group (order by qcao.token_name) from qa_char_action_outputs qcao, qa_chars qc_output where qca.char_action_id=qcao.char_action_id and qcao.char_id=qc_output.char_id ) output_element, xxen_util.yes(case when qpc.enabled_flag=1 then 'Y' end) element_enabled, xxen_util.yes(case when qa.enabled_flag=1 then 'Y' end) action_enabled, xxen_util.user_name(nvl(qca.created_by,qcat.created_by)) created_by, xxen_util.client_time(nvl(qca.creation_date,qcat.creation_date)) creation_date, xxen_util.user_name(nvl(qca.last_updated_by,qcat.last_updated_by)) last_updated_by, xxen_util.client_time(nvl(qca.last_update_date,qcat.last_update_date)) last_update_date from qa_plans qp, mtl_parameters mp, qa_plan_chars qpc, qa_chars qc, qa_char_action_triggers qcat, qa_char_actions qca, qa_actions qa, alr_action_sets aas, alr_actions aa where qp.organization_id=mp.organization_id(+) and qp.plan_id=qpc.plan_id and qpc.char_id=qc.char_id and qc.char_id=qcat.char_id and qcat.char_action_trigger_id=qca.char_action_trigger_id(+) and qca.action_id=qa.action_id(+) and qca.alr_action_set_id=aas.action_set_id(+) and qca.alr_action_id=aa.action_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 3=3 ) x where 2=2 order by x.organization_code, x.plan_name, x.prompt_sequence, x.element_name, x.action_trigger_sequence, x.action_name Review corrections, none altering the row set or any column value. The description now records that Status Code is the status string the action assigns and that Oracle Quality stores it as free text with no lookup behind it, so it is shown untranslated by nature of the source; no lookup on r12 carries the values in use. The Collection Plan picker widens, the shared QA Collection Plan list of values having excluded the seeded template plans this report returns; it now admits organization 0 and outer joins mtl_parameters. The three form assignments on the QLTPLMDF action blocks were reviewed as suspected duplicates and are confirmed correct and kept: one per block, distinguished by the stored block name, which is what makes a zoom block specific. Lists the Oracle Quality action rules behind collection plans as a union of the rules held on the plan itself (qa_plan_char_action_triggers, qa_plan_char_actions, qa_plan_char_action_outputs) and the rules held on the collection element master (qa_char_action_triggers, qa_char_actions, qa_char_action_outputs), discriminated by an Action Level column, at a grain of one row per plan, element, trigger condition and action. The action tables are outer joined to the trigger so a trigger condition defined without an action is still listed, and qa_plan_chars is outer joined so the element still names itself if a trigger ever referenced an element outside the plan. Element name and trigger element are one column because qa_plan_char_action_triggers.char_id is the plan element, verified with no exceptions. Action outputs are two paired listagg columns ordered by the same token name, so the token and the collection element it reads line up positionally without fanning the row out; the widest measured action binds 38 outputs at 627 bytes, well inside the listagg limit. Audit columns fall back from the action to the trigger so each row reports the audit data of the row actually shown. 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 / Action / Online Actions Only / Enabled Elements Only parameters filter both branches, Action Level filters the combined result. Decisions and limitations. No R12 only column exists in any of the seven action tables, so this ships as one dual-use definition with no 11i twin and no translate rule; the statement was parsed and executed on both a 19c R12 instance and an 11.2 EBS 11i instance, with a deliberately broken control statement confirming the 11i harness detects the pre 12c outer-join restriction. Assign Type is a hardcoded Formula / SQL Statement decode because no seeded lookup exists behind qa_plan_char_actions.assign_type, and it is gated on assigned_char_id being present because assign_type carries a filler value on every action that assigns nothing. There is no action type attribute in qa_actions, so Online Action carries the engine's own online versus deferred classification instead; it describes when the engine evaluates the action and does not assert the firing behaviour of any individual import path. The element branch is plan scoped exactly as the sibling element values report, so an element master rule on an element that no collection plan uses is not listed; such a rule can never apply to a plan. The second union branch carries its own 3=3 anchor and each of the seven shared branch filters has a no display sequence sub row on it, so the documented one anchor per sql position model is followed and a predicate referencing an alias present in only one branch can no longer be injected into the other. Note the Plan and Element action_level literals in the two union branches and the Action Level LOV values are a coupled pair with no seeded lookup behind them and must always be changed together. US QA Collection Plan Actions Lists every action rule defined against an Oracle Quality collection plan - the trigger condition that fires the rule, the action it runs, the element it assigns, the alert it raises and the collection elements bound into its message - as a union of the rules attached to the collection plan itself and the rules defined on the collection element master, discriminated by an Action Level column. Trigger conditions that carry no action are listed too. Oracle Quality evaluates these rules while quality results are entered. A rule is a trigger condition on one collection element - the element is entered, equals a value, falls outside its specification limits - paired with one or more actions. The rules are stored in two independent places. A collection plan carries its own rules in qa_plan_char_action_triggers and qa_plan_char_actions, and a collection element carries master rules in qa_char_action_triggers and qa_char_actions. The two are not linked: an element master rule is never copied into a plan, it simply applies to every plan that uses the element. The Action Level column says which is which. Plan means the rule is defined on this collection plan. Element means the rule is defined on the collection element master and therefore applies to every plan carrying that element, this one included. Online Action separates the actions the results entry engine evaluates inline, as values are entered, from the actions it defers to background processing. The inline ones - display a message to the operator, reject the input, assign a value to a collection element - are the class of action that can change or refuse the data a results load submits. The deferred ones - alerts, workflow, holds - do not alter the collected values inline. Assign Type and Assigned Element are populated only where the action assigns a value to another collection element; the formula or SQL statement itself is in Action Message. Output Variable and Output Element are a matched pair listing the tokens bound into that message and the collection element each token reads, so a formula referencing several elements can be resolved from the row. A trigger bound may be a literal or a statistical limit, and both are rendered. Status Code is the status string the action assigns to the quality result; Oracle Quality stores it as free text with no lookup behind it, so it is shown exactly as it was configured and is not translated. Leave the parameters blank for the full picture, or narrow with Organization, Collection Plan, Plan Type, Collection Element and Action. Online Actions Only restricts to the actions evaluated inline during results entry, Enabled Elements Only to elements still enabled on the plan, and Action Level isolates plan level or element level rules. Element level rules are shown against the collection plans that use the element, so a rule on an element that no collection plan uses is not listed. 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 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 qa.description=:action LOV custom Y select qa.description value, null description from qa_actions qa where qa.enabled_flag=1 order by qa.description US Action 10 3=3 qa.description=:action US Action 11 60 1=1 qa.online_flag=1 LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Online Actions Only 12 3=3 qa.online_flag=1 Y US Online Actions Only 13 70 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 14 3=3 qpc.enabled_flag=1 Y US Enabled Elements Only 15 80 2=2 x.action_level=:action_level LOV custom Y select 'Plan' value, 'Action rule defined on this collection plan' description from dual union all select 'Element' value, 'Defined on the collection element master, shown against every plan that uses the element' description from dual US Action Level