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(+)
45: AND qpct.collection_trigger_id = qc.char_id(+)
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
184: and qpct.collection_trigger_id = qtct.collection_trigger_id(+)
190: ORDER BY qpt.plan_transaction_id;
191:
192: --
193: -- Bug 2891093
194: -- 'qa_txn_collection_triggers qtct' is used in FROM clause
195: -- which is not required at all.
196: -- Removed this to fix the SQL Repository issue
197: --
198: -- rkunchal Mon Apr 7 21:58:22 PDT 2003