DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on QA_CHARS

Line 40: qa_chars qc,

36: qpct.high_value
37: FROM qa_plan_collection_triggers qpct,
38: qa_plan_transactions qpt,
39: qa_plans_val_v qp,
40: qa_chars qc,
41: qa_txn_collection_triggers qtct
42: WHERE qpt.plan_id = qp.plan_id
43: AND qpct.plan_transaction_id(+) = qpt.plan_transaction_id
44: AND qpct.collection_trigger_id = qtct.collection_trigger_id(+)

Line 179: qa_chars qc,

175: qpct.high_value
176: FROM qa_plan_collection_triggers qpct,
177: qa_plan_transactions qpt,
178: qa_plans qp,
179: qa_chars qc,
180: qa_txn_collection_triggers qtct
181: WHERE qp.plan_id = p_plan_id
182: and qpt.plan_id = qp.plan_id
183: and qpct.plan_transaction_id(+) = qpt.plan_transaction_id

Line 212: qa_chars qc

208: qpct.high_value
209: FROM qa_plan_collection_triggers qpct,
210: qa_plan_transactions qpt,
211: qa_plans qp,
212: qa_chars qc
213: WHERE qp.plan_id = p_plan_id
214: and qpt.plan_id = qp.plan_id
215: and qpct.plan_transaction_id(+) = qpt.plan_transaction_id
216: and qpct.collection_trigger_id = qc.char_id(+)