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_RESULT_COLUMNS_V

Line 664: FROM qa_pc_result_columns_v

660: -- are copied.
661:
662: CURSOR char_id_cur(c_child_plan_id NUMBER) IS
663: SELECT parent_char_id, child_char_id
664: FROM qa_pc_result_columns_v
665: WHERE parent_plan_id = p_plan_id
666: AND child_plan_id = c_child_plan_id
667: AND parent_enabled_flag = 1
668: AND child_enabled_flag = 1;

Line 687: FROM qa_pc_result_columns_v

683: AND qpc.enabled_flag = 1
684: AND qc.datatype = 5
685: MINUS
686: SELECT child_char_id
687: FROM qa_pc_result_columns_v
688: WHERE parent_plan_id = p_plan_id
689: AND child_plan_id = c_child_plan_id
690: AND parent_enabled_flag = 1
691: AND child_enabled_flag = 1;

Line 702: FROM qa_pc_result_columns_v

698: AND qpc.enabled_flag = 1
699: AND qc.datatype = 5
700: AND qc.char_id NOT IN
701: (SELECT child_char_id
702: FROM qa_pc_result_columns_v
703: WHERE parent_plan_id = p_plan_id
704: AND child_plan_id = c_child_plan_id
705: AND parent_enabled_flag = 1
706: AND child_enabled_flag = 1);

Line 1696: FROM qa_pc_result_columns_v

1692: SELECT parent_database_column,
1693: child_database_column,
1694: element_relationship_type,
1695: parent_char_id
1696: FROM qa_pc_result_columns_v
1697: WHERE parent_plan_id = p_parent_plan_id
1698: AND child_plan_id = p_child_plan_id
1699: AND element_relationship_type in (2,3,4,5,6,7,8)
1700: AND parent_enabled_flag = 1

Line 2331: -- qa_pc_result_columns_v. I added link_flag in where clause.

2327: p_child_occurrence IN NUMBER)
2328: RETURN VARCHAR2 IS
2329:
2330: -- the following cursor contains sql text used for the view
2331: -- qa_pc_result_columns_v. I added link_flag in where clause.
2332:
2333: -- anagarwa Mon Dec 16 16:55:09 PST 2002
2334: -- Bug 2701777
2335: -- added parent_enabled_flag and child_enabled_flag to where clause

Line 2342: qa_pc_result_columns_v qprc

2338: CURSOR element_cursor IS
2339: SELECT qprc.parent_database_column,
2340: qprc.child_database_column
2341: FROM
2342: qa_pc_result_columns_v qprc
2343: WHERE
2344: qprc.parent_plan_id = p_parent_plan_id and
2345: qprc.child_plan_id = p_child_plan_id and
2346: qprc.element_relationship_type = 1 and

Line 2459: qa_pc_result_columns_v qprc

2455: Cursor element_cur(p_parentdbcol VARCHAR2) IS
2456: SELECT qprc.parent_database_column parent_database_column,
2457: qprc.child_database_column child_database_column
2458: FROM
2459: qa_pc_result_columns_v qprc
2460: WHERE
2461: qprc.parent_plan_id = p_parent_plan_id and
2462: qprc.child_plan_id = p_child_plan_id and
2463: qprc.element_relationship_type = 1 and

Line 2476: qa_pc_result_columns_v qprc

2472: SELECT qprc.parent_database_column parent_database_column,
2473: qprc.child_database_column child_database_column
2474: BULK COLLECT INTO p_elements_tab
2475: FROM
2476: qa_pc_result_columns_v qprc
2477: WHERE
2478: qprc.parent_plan_id = p_parent_plan_id and
2479: qprc.child_plan_id = p_child_plan_id and
2480: qprc.element_relationship_type = 1 and

Line 3154: FROM qa_pc_result_columns_v

3150: p_txn_or_child_flag IN NUMBER)
3151: RETURN VARCHAR2 IS
3152:
3153: CURSOR c IS SELECT 1
3154: FROM qa_pc_result_columns_v
3155: WHERE child_plan_id = p_plan_id and
3156: child_char_id = p_char_id and
3157: parent_plan_id = p_parent_plan_id and
3158: ELEMENT_RELATIONSHIP_TYPE = 1;

Line 3188: FROM qa_pc_result_columns_v

3184: p_plan_id IN NUMBER)
3185: RETURN VARCHAR2 IS
3186:
3187: CURSOR c IS SELECT parent_char_id
3188: FROM qa_pc_result_columns_v
3189: WHERE parent_plan_id = p_plan_id and
3190: child_char_id = p_child_char_id and
3191: element_relationship_type = 1;
3192:

Line 3381: FROM qa_pc_result_columns_v

3377: SELECT parent_database_column,
3378: child_database_column,
3379: element_relationship_type,
3380: parent_char_id
3381: FROM qa_pc_result_columns_v
3382: WHERE parent_plan_id = p_parent_plan_id
3383: AND child_plan_id = p_child_plan_id
3384: AND element_relationship_type in (2,3,4,5,6,7,8)
3385: AND parent_enabled_flag = 1

Line 3855: FROM qa_pc_result_columns_v qprc

3851:
3852: CURSOR C IS
3853: SELECT qprc.parent_database_column,
3854: qprc.child_database_column
3855: FROM qa_pc_result_columns_v qprc
3856: WHERE qprc.parent_plan_id = p_parent_plan_id and
3857: qprc.child_plan_id = p_child_plan_id and
3858: qprc.element_relationship_type = 1 and
3859: parent_enabled_flag = 1 and