DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_CHARS

Line 33: qa_chars qc,

29: qpct.high_value
30: FROM qa_plan_collection_triggers qpct,
31: qa_plan_transactions qpt,
32: qa_plans_val_v qp,
33: qa_chars qc,
34: qa_txn_collection_triggers qtct
35: WHERE qpt.plan_id = qp.plan_id
36: AND qpct.plan_transaction_id(+) = qpt.plan_transaction_id
37: AND qpct.collection_trigger_id = qtct.collection_trigger_id(+)

Line 172: qa_chars qc,

168: qpct.high_value
169: FROM qa_plan_collection_triggers qpct,
170: qa_plan_transactions qpt,
171: qa_plans qp,
172: qa_chars qc,
173: qa_txn_collection_triggers qtct
174: WHERE qp.plan_id = p_plan_id
175: and qpt.plan_id = qp.plan_id
176: and qpct.plan_transaction_id(+) = qpt.plan_transaction_id

Line 205: qa_chars qc

201: qpct.high_value
202: FROM qa_plan_collection_triggers qpct,
203: qa_plan_transactions qpt,
204: qa_plans qp,
205: qa_chars qc
206: WHERE qp.plan_id = p_plan_id
207: and qpt.plan_id = qp.plan_id
208: and qpct.plan_transaction_id(+) = qpt.plan_transaction_id
209: and qpct.collection_trigger_id = qc.char_id(+)