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.

[Home] [Help]

APPS.QLTDACTB dependencies on QA_PLAN_CHAR_ACTIONS

Line 218: qa_plan_char_actions qpca,

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
221: qsc.CHAR_ID,
222: qsc.ENABLED_FLAG,

Line 252: select MESSAGE, ASSIGN_TYPE from qa_plan_char_actions

248: ORDER BY qpc.prompt_sequence, qpcat.trigger_sequence,
249: qpcat.plan_char_action_trigger_id;
250:
251: Cursor MY_MESSAGE(X_PCA_ID NUMBER) is
252: select MESSAGE, ASSIGN_TYPE from qa_plan_char_actions
253: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
254:
255: Cursor WORKFLOW_itemtype(X_PCA_ID VARCHAR2) is
256: select MESSAGE from qa_plan_char_actions

Line 256: select MESSAGE from qa_plan_char_actions

252: select MESSAGE, ASSIGN_TYPE from qa_plan_char_actions
253: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
254:
255: Cursor WORKFLOW_itemtype(X_PCA_ID VARCHAR2) is
256: select MESSAGE from qa_plan_char_actions
257: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
258:
259: Cursor WF_ITEMTYPE_SELECTOR(WORKFLOW_ITEMTYPE VARCHAR2) IS
260: select wf_selector

Line 270: select STATUS_CODE from qa_plan_char_actions

266: from wf_runnable_processes_v
267: where item_type = WORKFLOW_ITEMTYPE;
268:
269: Cursor MY_STATUS(X_PCA_ID NUMBER) is
270: select STATUS_CODE from qa_plan_char_actions
271: where PLAN_CHAR_ACTION_ID = X_PCA_ID;
272:
273:
274: -- Bug 5196076. SQL Repository Fix SQL ID 17898864.

Line 320: from QA_PLAN_CHAR_ACTIONS

316: and lookup_type = 'WIP_INTRAOPERATION_STEP';
317:
318: Cursor MY_ASSIGNED_CHAR_ID(X_PCA_ID NUMBER, X_ACTION_ID NUMBER) is
319: select ASSIGNED_CHAR_ID
320: from QA_PLAN_CHAR_ACTIONS
321: where PLAN_CHAR_ACTION_ID = X_PCA_ID
322: and ACTION_ID = X_ACTION_ID;
323:
324: -- Bug 4958762: SQL Repository Fix SQL ID: 15008263

Line 366: from qa_plan_char_actions qpca, qa_plan_char_action_triggers qpcat

362:
363:
364: CURSOR Get_user_message(elem_id NUMBER,col_plan_id NUMBER, act_id NUMBER) IS
365: select qpca.message
366: from qa_plan_char_actions qpca, qa_plan_char_action_triggers qpcat
367: where qpcat.char_id = elem_id and
368: qpcat.plan_id = col_plan_id and
369: qpcat.plan_char_action_trigger_id = qpca.plan_char_action_trigger_id and
370: qpca.action_id = act_id;

Line 403: SELECT STATUS_ID FROM QA_PLAN_CHAR_ACTIONS

399:
400: -- used for action 18, 19 to
401: -- get status id for lot/serial statuses
402: CURSOR MY_STATUS_ID (X_PCA_ID NUMBER) IS
403: SELECT STATUS_ID FROM QA_PLAN_CHAR_ACTIONS
404: WHERE PLAN_CHAR_ACTION_ID = X_PCA_ID;
405:
406:
407: Y_SPEC_ID NUMBER;

Line 2021: qa_plan_char_actions qpca,

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
2024: and qpc.char_id = qpcao.char_id
2025: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID

Line 2037: qa_plan_char_actions qpca,

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
2040: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2041: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID

Line 2231: qa_plan_char_actions qpca,

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
2234: and qpc.char_id = qpcao.char_id
2235: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID

Line 2246: qa_plan_char_actions qpca,

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
2249: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2250: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID

Line 2256: FROM QA_PLAN_CHAR_ACTIONS qpca,

2252: and qc.char_context_flag = 3;
2253:
2254: CURSOR ACTION_SET_NAME IS
2255: SELECT aas.NAME
2256: FROM QA_PLAN_CHAR_ACTIONS qpca,
2257: ALR_ACTION_SETS aas
2258: WHERE qpca.PLAN_CHAR_ACTION_ID = X_PCA_ID
2259: AND qpca.ALR_ACTION_SET_ID = aas.ACTION_SET_ID
2260: AND aas.APPLICATION_ID = 250;

Line 2275: FROM QA_PLAN_CHAR_ACTIONS WHERE PLAN_CHAR_ACTION_ID = l_pca_id);

2271:
2272: CURSOR CPLAN(l_pca_id number) IS
2273: SELECT plan_id FROM qa_plan_char_action_triggers
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

Line 2282: FROM qa_plan_char_actions WHERE plan_char_action_id = l_pca_id));

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));
2283:
2284: l_result_column_name VARCHAR2(100);
2285: l_result_column_value VARCHAR2(2000);
2286: l_plan_id NUMBER;

Line 2499: qa_plan_char_actions qpca,

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
2503: and qpc.char_id = qpcao.char_id

Line 2514: qa_plan_char_actions qpca,

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
2518: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID