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 2019: qa_plan_chars qpc,

2015: qc.fk_lookup_type LOOKUP_TYPE,
2016: qc.char_id CHAR_ID,
2017: qc.datatype DATATYPE
2018: from qa_chars qc,
2019: qa_plan_chars qpc,
2020: qa_plan_char_action_outputs qpcao,
2021: qa_plan_char_actions qpca,
2022: qa_plan_char_action_triggers qpcat
2023: where qc.char_id = qpcao.char_id

Line 2054: FROM qa_plan_chars qpc,

2050: -- Bug 4958762: SQL Repository Fix SQL ID: 15008550
2051: CURSOR token_column_datatype (t_char_id number) IS
2052: SELECT
2053: qc.datatype
2054: FROM qa_plan_chars qpc,
2055: qa_chars qc
2056: WHERE qc.char_id = t_char_id
2057: AND qpc.char_id = qc.char_id
2058: AND qpc.plan_id = X_PLAN_ID;

Line 2061: FROM qa_plan_chars_v qpcv

2057: AND qpc.char_id = qc.char_id
2058: AND qpc.plan_id = X_PLAN_ID;
2059: /*
2060: SELECT qpcv.datatype
2061: FROM qa_plan_chars_v qpcv
2062: WHERE qpcv.char_id = t_char_id
2063: AND qpcv.plan_id = X_PLAN_ID;
2064: */
2065:

Line 2229: qa_plan_chars qpc,

2225: qpcao.token_name TOKEN_NAME,
2226: qc.fk_lookup_type LOOKUP_TYPE,
2227: qc.char_id CHAR_ID
2228: from qa_chars qc,
2229: qa_plan_chars qpc,
2230: qa_plan_char_action_outputs qpcao,
2231: qa_plan_char_actions qpca,
2232: qa_plan_char_action_triggers qpcat
2233: where qc.char_id = qpcao.char_id

Line 2278: SELECT result_column_name FROM qa_plan_chars

2274: WHERE plan_char_action_trigger_id = (select PLAN_CHAR_ACTION_TRIGGER_ID
2275: FROM QA_PLAN_CHAR_ACTIONS WHERE PLAN_CHAR_ACTION_ID = l_pca_id);
2276:
2277: CURSOR RESULT_COLUMN(l_plan_id number, l_pca_id number) IS
2278: SELECT result_column_name FROM qa_plan_chars
2279: WHERE plan_id = l_plan_id AND char_id = ( SELECT char_id
2280: FROM qa_plan_char_action_triggers WHERE
2281: plan_char_action_trigger_id = (SELECT plan_char_action_trigger_id
2282: FROM qa_plan_char_actions WHERE plan_char_action_id = l_pca_id));

Line 2498: qa_plan_chars qpc,

2494: qpcao.token_name TOKEN_NAME,
2495: qc.fk_lookup_type LOOKUP_TYPE,
2496: qc.char_id CHAR_ID
2497: from qa_chars qc,
2498: qa_plan_chars qpc,
2499: qa_plan_char_actions qpca,
2500: qa_plan_char_action_triggers qpcat,
2501: qa_plan_char_action_outputs qpcao
2502: where qc.char_id = qpcao.char_id

Line 2529: FROM qa_plan_chars qpc,

2525: SELECT
2526: NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
2527: qc.datatype,
2528: DECODE(qpc.decimal_precision, NULL, qc.decimal_precision, qpc.decimal_precision)
2529: FROM qa_plan_chars qpc,
2530: qa_chars qc
2531: WHERE qc.char_id = qpc.char_id
2532: AND qc.char_id = t_char_id
2533: AND qpc.plan_id = X_PLAN_ID;

Line 2537: FROM qa_plan_chars_v qpcv

2533: AND qpc.plan_id = X_PLAN_ID;
2534: /*
2535: SELECT NVL(qpcv.hardcoded_column,qpcv.result_column_name) Q_COLUMN,
2536: qpcv.datatype, qpcv.decimal_precision
2537: FROM qa_plan_chars_v qpcv
2538: WHERE qpcv.char_id = t_char_id
2539: AND qpcv.plan_id = X_PLAN_ID;
2540: */
2541: