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_CHARS

Line 411: FROM qa_pc_criteria qpc ,qa_chars qc

407: l_ret_value VARCHAR2(1);
408: l_datatype NUMBER;
409:
410: CURSOR c IS SELECT qpc.char_id,qpc.operator,qpc.low_value,qpc.high_value,qc.datatype
411: FROM qa_pc_criteria qpc ,qa_chars qc
412: WHERE qpc.plan_relationship_id = p_plan_relationship_id
413: AND qpc.char_id = qc.char_id;
414: BEGIN
415:

Line 680: FROM qa_plan_chars qpc, qa_chars qc

676:
677: -- Bug 4958734. SQL Repository Fix SQL ID: 15007931
678: CURSOR child_seq_char_ids(c_child_plan_id NUMBER) IS
679: SELECT qc.char_id
680: FROM qa_plan_chars qpc, qa_chars qc
681: WHERE qpc.plan_id = c_child_plan_id
682: AND qpc.char_id = qc.char_id
683: AND qpc.enabled_flag = 1
684: AND qc.datatype = 5

Line 695: qa_chars qc

691: AND child_enabled_flag = 1;
692: /*
693: SELECT qc.char_id
694: FROM qa_plan_chars qpc,
695: qa_chars qc
696: WHERE qpc.plan_id = c_child_plan_id
697: AND qpc.char_id = qc.char_id
698: AND qpc.enabled_flag = 1
699: AND qc.datatype = 5

Line 1980: from qa_plan_chars qpc, qa_chars qc

1976: -- of the DateTime type and whether its a Hardcoded
1977: -- element
1978: Cursor cur (p_plan_id in NUMBER, p_res_col in VARCHAR2) is
1979: Select 1, qc.hardcoded_column
1980: from qa_plan_chars qpc, qa_chars qc
1981: where qpc.plan_id = p_plan_id
1982: and qpc.char_id = qc.char_id
1983: and qpc.result_column_name = p_res_col
1984: and qc.datatype = 6;

Line 1987: hardcoded_column QA_CHARS.HARDCODED_COLUMN%TYPE := NULL;

1983: and qpc.result_column_name = p_res_col
1984: and qc.datatype = 6;
1985:
1986: data_found PLS_INTEGER := 0;
1987: hardcoded_column QA_CHARS.HARDCODED_COLUMN%TYPE := NULL;
1988:
1989: parent_is_date BOOLEAN := FALSE;
1990: child_is_date BOOLEAN := FALSE;
1991: parent_hardcoded_column BOOLEAN := FALSE;

Line 2372: FROM qa_chars qc,

2368:
2369: CURSOR seq_cursor is
2370: SELECT qpc.char_id,
2371: qpc.result_column_name
2372: FROM qa_chars qc,
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

Line 4488: qa_chars qc

4484: FROM qa_pc_plan_relationship qppr,
4485: qa_pc_criteria qpc,
4486: qa_results qr,
4487: qa_plan_chars qapc,
4488: qa_chars qc
4489: WHERE qpc.plan_relationship_id = qppr.plan_relationship_id
4490: AND qapc.char_id = qpc.char_id
4491: AND qapc.char_id = qc.char_id
4492: AND qr.occurrence = p_occurrence