APPS.QA_WEB_TXN_API dependencies on QA_TXN_COLLECTION_TRIGGERS

Line 34: qa_txn_collection_triggers qtct

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(+)
38: AND qpct.collection_trigger_id = qc.char_id(+)

Line 173: qa_txn_collection_triggers qtct

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
177: and qpct.collection_trigger_id = qtct.collection_trigger_id(+)

Line 187: -- 'qa_txn_collection_triggers qtct' is used in FROM clause

183: ORDER BY qpt.plan_transaction_id;
184:
185: --
186: -- Bug 2891093
187: -- 'qa_txn_collection_triggers qtct' is used in FROM clause
188: -- which is not required at all.
189: -- Removed this to fix the SQL Repository issue
190: --
191: -- rkunchal Mon Apr 7 21:58:22 PDT 2003