DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on QA_PLAN_CHAR_ACTION_OUTPUTS

Line 2020: qa_plan_char_action_outputs qpcao,

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

Line 2036: qa_plan_char_action_outputs qpcao,

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

Line 2230: qa_plan_char_action_outputs qpcao,

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

Line 2245: qa_plan_char_action_outputs qpcao,

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

Line 2501: qa_plan_char_action_outputs qpcao

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

Line 2516: qa_plan_char_action_outputs qpcao

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
2519: and qpcat.PLAN_CHAR_ACTION_TRIGGER_ID = qpca.PLAN_CHAR_ACTION_TRIGGER_ID
2520: and qpcao.PLAN_CHAR_ACTION_ID = X_PCA_ID

Line 3001: FROM qa_plan_char_action_outputs

2997: --
2998: SELECT TRIM(token_name) tokenName,
2999: 'CHARID' || char_id bulk collect
3000: INTO token_rec_tab
3001: FROM qa_plan_char_action_outputs
3002: WHERE plan_char_action_id = p_plan_char_action_id
3003: order by length(tokenName) desc ;
3004:
3005: l_message_str := p_message_str;