eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_PARENT_CHILD_PKG dependencies on QA_PC_ELEMENT_RELATIONSHIP

Line 1192: -- link_flag = 1 in qa_pc_element_relationship table.

1188: --
1189: -- This function intelligently finding out parent plan record when child plan record information
1190: -- is passed. First find out parent_plan_id from qa_pc_plan_relationship. Then findout all
1191: -- element ids with which parent and child plans are related. Take only those elements which have
1192: -- link_flag = 1 in qa_pc_element_relationship table.
1193:
1194: -- Find the values of the elements from qa_results for the child plan. Then find the first record
1195: -- for the parent plan which has all the elements (only those related in the qa_pc_element_relation)
1196: -- same value for those of child plan. Return the parent record information.

Line 1230: qa_pc_element_relationship pe,

1226: pe.child_char_id,
1227: qpc2.result_column_name child_database_column
1228: from
1229: qa_pc_plan_relationship pr,
1230: qa_pc_element_relationship pe,
1231: qa_plan_chars qpc1,
1232: qa_plan_chars qpc2
1233: where
1234: pr.plan_relationship_id = pe.plan_relationship_id and

Line 2377: FROM qa_pc_element_relationship qper,

2373: qa_plan_chars qpc
2374: WHERE qpc.plan_id = p_child_plan_id
2375: AND qpc.char_id NOT IN
2376: (SELECT child_char_id
2377: FROM qa_pc_element_relationship qper,
2378: qa_pc_plan_relationship qppr
2379: WHERE qper.plan_relationship_id = qppr.plan_relationship_id
2380: AND qppr.parent_plan_id = p_parent_plan_id
2381: AND qppr.child_plan_id = p_child_plan_id