ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 4E79AFD780FCF1CCE0630100007F703B select null action_, null status_, null message_, null modified_columns_, mp.organization_code, qpp.name parent_plan, qpc.name child_plan, qpc.description child_plan_description, xxen_util.meaning(qppr.data_entry_mode,'QA_PC_DATA_ENTRY_MODE',250) entry_mode, xxen_util.meaning(qppr.layout_mode,'QA_PC_LAYOUT_MODE',250) layout_mode, qppr.auto_row_count, xxen_util.meaning(decode(qppr.default_parent_spec,1,'Y','N'),'YES_NO',0) default_parent_spec, qc_p.name parent_element, qc_c.name child_element, xxen_util.meaning(qper.element_relationship_type,'QA_PC_ELEMENT_RELATIONSHIP',250) element_rel_type, xxen_util.meaning(decode(qper.link_flag,1,'Y','N'),'YES_NO',0) link_flag, qc_cr.name criteria_element, xxen_util.meaning(qpcc.operator,'QA_PC_OPERATOR',700) criteria_operator, qpcc.low_value criteria_from_value, qpcc.high_value criteria_to_value, null delete_record, qppr.plan_relationship_id, qper.element_relationship_id, qpcc.criteria_id from mtl_parameters mp, qa_plans qpp, qa_pc_plan_relationship qppr, qa_plans qpc, qa_pc_element_relationship qper, qa_chars qc_p, qa_chars qc_c, qa_pc_criteria qpcc, qa_chars qc_cr where 1=1 and qpp.organization_id=mp.organization_id and qppr.parent_plan_id=qpp.plan_id and qpc.plan_id=qppr.child_plan_id and qper.plan_relationship_id(+)=qppr.plan_relationship_id and qc_p.char_id(+)=qper.parent_char_id and qc_c.char_id(+)=qper.child_char_id and qpcc.plan_relationship_id(+)=qppr.plan_relationship_id and qc_cr.char_id(+)=qpcc.char_id Y U A xxen_qa_upload.plan_relationship US QA Plan Relationship Upload Upload to create, update, or delete Quality Collection Plan parent-child relationships using the standard Oracle API qa_ss_parent_child_pkg. This upload manages: - Parent-Child Plan Relationships (QA_PC_PLAN_RELATIONSHIP) - Element Relationships between parent and child plans (QA_PC_ELEMENT_RELATIONSHIP) - Criteria for automatic child record creation (QA_PC_CRITERIA) Entry Modes: - Immediate: Child data entered immediately after parent record - Delayed: Child records entered manually later - Automatic: Child records auto-created when parent matches criteria - History: Child records auto-created when changes made to parent Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV custom 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 2 20 1=1 mp.organization_code=:p_organization LOV custom Y select distinct mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where mp.organization_id=ood.organization_id and exists (select null from qa_plans qp where qp.organization_id=mp.organization_id) order by mp.organization_code US Organization 3 30 1=1 qpp.name=:p_parent_plan LOV custom Y select qp.name value, qp.description description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id and (:$flex$.Organization is null or mp.organization_code=:$flex$.Organization) order by qp.name US Parent Plan 4 40 1=1 qpc.name=:p_child_plan LOV custom Y select qp.name value, qp.description description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id and (:$flex$.Organization is null or mp.organization_code=:$flex$.Organization) order by qp.name US Child Plan :$flex$.Organization Organization Child Plan :$flex$.Organization Organization Parent Plan 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORGANIZATION_CODE LOV custom varchar2 Y select mp.organization_id id, mp.organization_code value, ood.organization_name description from mtl_parameters mp, org_organization_definitions ood where mp.organization_id=ood.organization_id and exists (select null from qa_plans qp where qp.organization_id=mp.organization_id) order by mp.organization_code Y 6 PARENT_PLAN LOV custom varchar2 Y select qp.plan_id id, qp.name value, qp.description description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id and (:$column$.organization_code is null or mp.organization_code=:$column$.organization_code) order by qp.name Y 7 CHILD_PLAN LOV custom varchar2 Y select qp.plan_id id, qp.name value, qp.description description from qa_plans qp, mtl_parameters mp where qp.organization_id=mp.organization_id and (:$column$.organization_code is null or mp.organization_code=:$column$.organization_code) order by qp.name Y 8 CHILD_PLAN_DESCRIPTION Char varchar2 Y 9 ENTRY_MODE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='QA_PC_DATA_ENTRY_MODE' and flvv.view_application_id=250 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning Y 10 LAYOUT_MODE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='QA_PC_LAYOUT_MODE' and flvv.view_application_id=250 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning 11 AUTO_ROW_COUNT Number number 12 DEFAULT_PARENT_SPEC LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' order by fl.meaning 13 PARENT_ELEMENT LOV custom varchar2 select distinct qc.char_id id, qc.name value, qc.prompt description from qa_chars qc, qa_plan_chars qpc, qa_plans qp, mtl_parameters mp where qc.char_id=qpc.char_id and qpc.plan_id=qp.plan_id and qp.organization_id=mp.organization_id and (:$column$.organization_code is null or mp.organization_code=:$column$.organization_code) and (:$column$.parent_plan is null or qp.name=:$column$.parent_plan) order by qc.name 14 CHILD_ELEMENT LOV custom varchar2 select distinct qc.char_id id, qc.name value, qc.prompt description from qa_chars qc, qa_plan_chars qpc, qa_plans qp, mtl_parameters mp where qc.char_id=qpc.char_id and qpc.plan_id=qp.plan_id and qp.organization_id=mp.organization_id and (:$column$.organization_code is null or mp.organization_code=:$column$.organization_code) and (:$column$.child_plan is null or qp.name=:$column$.child_plan) order by qc.name 15 ELEMENT_REL_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='QA_PC_ELEMENT_RELATIONSHIP' and flvv.view_application_id=250 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning 16 LINK_FLAG LOV custom varchar2 Y select fl.lookup_code id, fl.meaning value, null description from fnd_lookups fl where fl.lookup_type='YES_NO' order by fl.meaning 17 CRITERIA_ELEMENT LOV custom varchar2 select distinct qc.char_id id, qc.name value, qc.prompt description from qa_chars qc, qa_plan_chars qpc, qa_plans qp, mtl_parameters mp where qc.char_id=qpc.char_id and qpc.plan_id=qp.plan_id and qp.organization_id=mp.organization_id and (:$column$.organization_code is null or mp.organization_code=:$column$.organization_code) and (:$column$.parent_plan is null or qp.name=:$column$.parent_plan) order by qc.name 18 CRITERIA_OPERATOR LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='QA_PC_OPERATOR' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) 19 CRITERIA_FROM_VALUE Char varchar2 20 CRITERIA_TO_VALUE Char varchar2 21 DELETE_RECORD LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.parent_plan is not null and :$column$.child_plan is not null 22 PLAN_RELATIONSHIP_ID Number number Y 23 ELEMENT_RELATIONSHIP_ID Number number Y 24 CRITERIA_ID Number number Y U 2 p_parent_plan in Number PARENT_PLAN U 3 p_child_plan in Number CHILD_PLAN U 4 p_entry_mode in Number ENTRY_MODE U 5 p_layout_mode in Number LAYOUT_MODE U 6 p_auto_row_count in Number AUTO_ROW_COUNT U 7 p_default_parent_spec in Char DEFAULT_PARENT_SPEC U 8 p_parent_element in Number PARENT_ELEMENT U 9 p_child_element in Number CHILD_ELEMENT U 10 p_element_rel_type in Number ELEMENT_REL_TYPE U 11 p_link_flag in Char LINK_FLAG U 12 p_criteria_element in Number CRITERIA_ELEMENT U 13 p_criteria_operator in Number CRITERIA_OPERATOR U 14 p_criteria_from_value in Char CRITERIA_FROM_VALUE U 15 p_criteria_to_value in Char CRITERIA_TO_VALUE U 16 p_delete_record in Char DELETE_RECORD U 17 status_ out Char STATUS_CODE_ U 18 message_ out Char MESSAGE_ Error SQL Order By organization_code, parent_plan, child_plan, parent_element, child_element Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, mp.organization_code, qpp.name parent_plan, qpc.name child_plan, qpc.description child_plan_description, xxen_util.meaning(qppr.data_entry_mode,'QA_PC_DATA_ENTRY_MODE',250) entry_mode, xxen_util.meaning(qppr.layout_mode,'QA_PC_LAYOUT_MODE',250) layout_mode, qppr.auto_row_count, xxen_util.meaning(decode(qppr.default_parent_spec,1,'Y','N'),'YES_NO',0) default_parent_spec, qc_p.name parent_element, qc_c.name child_element, xxen_util.meaning(qper.element_relationship_type,'QA_PC_ELEMENT_RELATIONSHIP',250) element_rel_type, xxen_util.meaning(decode(qper.link_flag,1,'Y','N'),'YES_NO',0) link_flag, qc_cr.name criteria_element, xxen_util.meaning(qpcc.operator,'QA_PC_OPERATOR',700) criteria_operator, qpcc.low_value criteria_from_value, qpcc.high_value criteria_to_value, null delete_record, qppr.plan_relationship_id, qper.element_relationship_id, qpcc.criteria_id from xxen_qa_plan_relationsh_1618_u xu, mtl_parameters mp, qa_plans qpp, qa_pc_plan_relationship qppr, qa_plans qpc, qa_pc_element_relationship qper, qa_chars qc_p, qa_chars qc_c, qa_pc_criteria qpcc, qa_chars qc_cr where xu.status_code_='S' and xu.organization_code=mp.organization_code and xu.parent_plan=qpp.name and qpp.organization_id=mp.organization_id and qppr.parent_plan_id=qpp.plan_id and xu.child_plan=qpc.name and qpc.plan_id=qppr.child_plan_id and qper.plan_relationship_id(+)=qppr.plan_relationship_id and qc_p.char_id(+)=qper.parent_char_id and qc_c.char_id(+)=qper.child_char_id and qpcc.plan_relationship_id(+)=qppr.plan_relationship_id and qc_cr.char_id(+)=qpcc.char_id LOV query :$column$.child_plan CHILD_PLAN CHILD_ELEMENT LOV query :$column$.organization_code ORGANIZATION_CODE CHILD_ELEMENT LOV query :$column$.organization_code ORGANIZATION_CODE CHILD_PLAN LOV query :$column$.organization_code ORGANIZATION_CODE CRITERIA_ELEMENT LOV query :$column$.parent_plan PARENT_PLAN CRITERIA_ELEMENT LOV query :$column$.child_plan CHILD_PLAN DELETE_RECORD LOV query :$column$.parent_plan PARENT_PLAN DELETE_RECORD LOV query :$column$.organization_code ORGANIZATION_CODE PARENT_ELEMENT LOV query :$column$.parent_plan PARENT_PLAN PARENT_ELEMENT LOV query :$column$.organization_code ORGANIZATION_CODE PARENT_PLAN Value to id query :$column$.child_plan CHILD_PLAN p_child_element Value to id query :$column$.child_plan CHILD_PLAN p_delete_record Value to id query :$column$.organization_code ORGANIZATION_CODE p_child_element Value to id query :$column$.organization_code ORGANIZATION_CODE p_child_plan Value to id query :$column$.organization_code ORGANIZATION_CODE p_criteria_element Value to id query :$column$.organization_code ORGANIZATION_CODE p_parent_element Value to id query :$column$.organization_code ORGANIZATION_CODE p_parent_plan Value to id query :$column$.parent_plan PARENT_PLAN p_criteria_element Value to id query :$column$.parent_plan PARENT_PLAN p_delete_record Value to id query :$column$.parent_plan PARENT_PLAN p_parent_element