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.QLTDACTB dependencies on QA_PLAN_CHARS

Line 216: qa_plan_chars qpc,

212: nvl(qscqs.uom_code, qc.uom_code) SPEC_CHAR_UOM,
213: nvl(qpc.uom_code, qc.uom_code) PLAN_CHAR_UOM,
214: qpc.decimal_precision DECIMAL_PRECISION
215: FROM qa_chars qc,
216: qa_plan_chars qpc,
217: qa_plan_char_action_triggers qpcat,
218: qa_plan_char_actions qpca,
219: qa_actions qa,
220: (select

Line 301: FROM qa_plan_chars

297: -- Bug 4958762: SQL Repository Fix SQL ID: 15008214
298: Cursor MY_STEP(X_PLAN_ID NUMBER) is
299: SELECT
300: result_column_name
301: FROM qa_plan_chars
302: WHERE plan_id = x_plan_id
303: AND char_id = 23;
304: /*
305: select RESULT_COLUMN_NAME from qa_plan_chars

Line 305: select RESULT_COLUMN_NAME from qa_plan_chars

301: FROM qa_plan_chars
302: WHERE plan_id = x_plan_id
303: AND char_id = 23;
304: /*
305: select RESULT_COLUMN_NAME from qa_plan_chars
306: where PLAN_ID = X_PLAN_ID
307: and CHAR_ID in (select char_id
308: from qa_chars
309: where developer_name =

Line 329: FROM qa_plan_chars qpc,

325: CURSOR MY_RESULTS_COLUMN(X_PLAN_ID NUMBER) IS
326: SELECT
327: NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
328: qc.developer_name DEV_NAME
329: FROM qa_plan_chars qpc,
330: qa_chars qc
331: WHERE qpc.plan_id = X_PLAN_ID
332: AND qc.char_id = qpc.char_id
333: AND qc.char_context_flag <> 3

Line 339: FROM qa_plan_chars_v qpcv

335:
336: /*
337: SELECT NVL(qpcv.hardcoded_column,qpcv.result_column_name) Q_COLUMN,
338: qpcv.developer_name DEV_NAME
339: FROM qa_plan_chars_v qpcv
340: WHERE qpcv.plan_id = X_PLAN_ID
341: AND qpcv.char_context_flag <> 3
342: ORDER BY qpcv.char_id;
343: */

Line 359: from qa_plan_chars

355: --kaza
356:
357: CURSOR Get_result_column_name(elem_id NUMBER, col_plan_id NUMBER) IS
358: select result_column_name
359: from qa_plan_chars
360: where char_id = elem_id and
361: plan_id = col_plan_id;
362:
363:

Line 2099: qa_plan_chars qpc,

2095: qc.fk_lookup_type LOOKUP_TYPE,
2096: qc.char_id CHAR_ID,
2097: qc.datatype DATATYPE
2098: from qa_chars qc,
2099: qa_plan_chars qpc,
2100: qa_plan_char_action_outputs qpcao,
2101: qa_plan_char_actions qpca,
2102: qa_plan_char_action_triggers qpcat
2103: where qc.char_id = qpcao.char_id

Line 2134: FROM qa_plan_chars qpc,

2130: -- Bug 4958762: SQL Repository Fix SQL ID: 15008550
2131: CURSOR token_column_datatype (t_char_id number) IS
2132: SELECT
2133: qc.datatype
2134: FROM qa_plan_chars qpc,
2135: qa_chars qc
2136: WHERE qc.char_id = t_char_id
2137: AND qpc.char_id = qc.char_id
2138: AND qpc.plan_id = X_PLAN_ID;

Line 2141: FROM qa_plan_chars_v qpcv

2137: AND qpc.char_id = qc.char_id
2138: AND qpc.plan_id = X_PLAN_ID;
2139: /*
2140: SELECT qpcv.datatype
2141: FROM qa_plan_chars_v qpcv
2142: WHERE qpcv.char_id = t_char_id
2143: AND qpcv.plan_id = X_PLAN_ID;
2144: */
2145:

Line 2329: qa_plan_chars qpc,

2325: qpcao.token_name TOKEN_NAME,
2326: qc.fk_lookup_type LOOKUP_TYPE,
2327: qc.char_id CHAR_ID
2328: from qa_chars qc,
2329: qa_plan_chars qpc,
2330: qa_plan_char_action_outputs qpcao,
2331: qa_plan_char_actions qpca,
2332: qa_plan_char_action_triggers qpcat
2333: where qc.char_id = qpcao.char_id

Line 2378: SELECT result_column_name FROM qa_plan_chars

2374: WHERE plan_char_action_trigger_id = (select PLAN_CHAR_ACTION_TRIGGER_ID
2375: FROM QA_PLAN_CHAR_ACTIONS WHERE PLAN_CHAR_ACTION_ID = l_pca_id);
2376:
2377: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2378: SELECT result_column_name FROM qa_plan_chars
2379: WHERE plan_id = l_plan_id AND char_id = ( SELECT char_id
2380: FROM qa_plan_char_action_triggers WHERE
2381: plan_char_action_trigger_id = (SELECT plan_char_action_trigger_id
2382: FROM qa_plan_char_actions WHERE plan_char_action_id = l_pca_id));

Line 2627: qa_plan_chars qpc,

2623: qpcao.token_name TOKEN_NAME,
2624: qc.fk_lookup_type LOOKUP_TYPE,
2625: qc.char_id CHAR_ID
2626: from qa_chars qc,
2627: qa_plan_chars qpc,
2628: qa_plan_char_actions qpca,
2629: qa_plan_char_action_triggers qpcat,
2630: qa_plan_char_action_outputs qpcao
2631: where qc.char_id = qpcao.char_id

Line 2658: FROM qa_plan_chars qpc,

2654: SELECT
2655: NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
2656: qc.datatype,
2657: DECODE(qpc.decimal_precision, NULL, qc.decimal_precision, qpc.decimal_precision)
2658: FROM qa_plan_chars qpc,
2659: qa_chars qc
2660: WHERE qc.char_id = qpc.char_id
2661: AND qc.char_id = t_char_id
2662: AND qpc.plan_id = X_PLAN_ID;

Line 2666: FROM qa_plan_chars_v qpcv

2662: AND qpc.plan_id = X_PLAN_ID;
2663: /*
2664: SELECT NVL(qpcv.hardcoded_column,qpcv.result_column_name) Q_COLUMN,
2665: qpcv.datatype, qpcv.decimal_precision
2666: FROM qa_plan_chars_v qpcv
2667: WHERE qpcv.char_id = t_char_id
2668: AND qpcv.plan_id = X_PLAN_ID;
2669: */
2670: