DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on QA_PLAN_CHAR_ACTION_OUTPUTS

Line 2100: qa_plan_char_action_outputs qpcao,

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

Line 2116: qa_plan_char_action_outputs qpcao,

2112: qc.fk_lookup_type LOOKUP_TYPE,
2113: qc.char_id CHAR_ID,
2114: qc.datatype DATATYPE
2115: from qa_chars qc,
2116: qa_plan_char_action_outputs qpcao,
2117: qa_plan_char_actions qpca,
2118: qa_plan_char_action_triggers qpcat
2119: where qc.char_id = qpcao.char_id
2120: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID

Line 2330: qa_plan_char_action_outputs qpcao,

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

Line 2345: qa_plan_char_action_outputs qpcao,

2341: qpcao.token_name TOKEN_NAME,
2342: qc.fk_lookup_type LOOKUP_TYPE,
2343: qc.char_id CHAR_ID
2344: from qa_chars qc,
2345: qa_plan_char_action_outputs qpcao,
2346: qa_plan_char_actions qpca,
2347: qa_plan_char_action_triggers qpcat
2348: where qc.char_id = qpcao.char_id
2349: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID

Line 2630: qa_plan_char_action_outputs qpcao

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
2632: and qpc.char_id = qpcao.char_id
2633: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2634: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID

Line 2645: qa_plan_char_action_outputs qpcao

2641: qc.char_id CHAR_ID
2642: from qa_chars qc,
2643: qa_plan_char_actions qpca,
2644: qa_plan_char_action_triggers qpcat,
2645: qa_plan_char_action_outputs qpcao
2646: where qc.char_id = qpcao.char_id
2647: and qpcao.PLAN_CHAR_ACTION_ID = qpca.PLAN_CHAR_ACTION_ID
2648: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2649: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID

Line 3132: FROM qa_plan_char_action_outputs

3128: --
3129: SELECT TRIM(token_name) tokenName,
3130: 'CHARID' || char_id bulk collect
3131: INTO token_rec_tab
3132: FROM qa_plan_char_action_outputs
3133: WHERE plan_char_action_id = p_plan_char_action_id
3134: order by length(tokenName) desc ;
3135:
3136: l_message_str := p_message_str;