APPS.QLTDACTB dependencies on QA_CHARS

Line 215: FROM qa_chars qc,

211: qpcat.plan_char_action_trigger_id PCAT_ID,
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,

Line 308: from qa_chars

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 =
310: 'TO_INTRAOPERATION_STEP');
311: */
312:

Line 330: qa_chars qc

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
334: ORDER BY qc.char_id;

Line 2018: from qa_chars qc,

2014: qpcao.token_name TOKEN_NAME,
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

Line 2035: from qa_chars qc,

2031: qpcao.token_name TOKEN_NAME,
2032: qc.fk_lookup_type LOOKUP_TYPE,
2033: qc.char_id CHAR_ID,
2034: qc.datatype DATATYPE
2035: from qa_chars qc,
2036: qa_plan_char_action_outputs qpcao,
2037: qa_plan_char_actions qpca,
2038: qa_plan_char_action_triggers qpcat
2039: where qc.char_id = qpcao.char_id

Line 2055: qa_chars qc

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;
2059: /*

Line 2228: from qa_chars qc,

2224: SELECT NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
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

Line 2244: from qa_chars qc,

2240: UNION SELECT qc.hardcoded_column Q_COLUMN,
2241: qpcao.token_name TOKEN_NAME,
2242: qc.fk_lookup_type LOOKUP_TYPE,
2243: qc.char_id CHAR_ID
2244: from qa_chars qc,
2245: qa_plan_char_action_outputs qpcao,
2246: qa_plan_char_actions qpca,
2247: qa_plan_char_action_triggers qpcat
2248: where qc.char_id = qpcao.char_id

Line 2309: IF (qa_chars_api.datatype(prec.char_id) = 4) THEN

2305: ACTUAL_OUTPUT := QLTSMENB.LOOKUP(prec.CHAR_ID, ACTUAL_OUTPUT);
2306: end IF;
2307:
2308: /*kashyap, rkaza 06/14/2002. as part of fix for Bug 2408728 */
2309: IF (qa_chars_api.datatype(prec.char_id) = 4) THEN
2310:
2311: -- Bug 2640953. If the ACTUAL_OUTPUT is NULL, set the l_count to 0.
2312: -- Added the NVL() below. kabalakr.
2313:

Line 2497: from qa_chars qc,

2493: SELECT NVL(qc.hardcoded_column,qpc.result_column_name) Q_COLUMN,
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

Line 2513: from qa_chars qc,

2509: UNION SELECT qc.hardcoded_column Q_COLUMN,
2510: qpcao.token_name TOKEN_NAME,
2511: qc.fk_lookup_type LOOKUP_TYPE,
2512: qc.char_id CHAR_ID
2513: from qa_chars qc,
2514: qa_plan_char_actions qpca,
2515: qa_plan_char_action_triggers qpcat,
2516: qa_plan_char_action_outputs qpcao
2517: where qc.char_id = qpcao.char_id

Line 2530: qa_chars qc

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;
2534: /*