APPS.IBY_FNDCPT_VLD_PUB dependencies on IBY_TRXN_CORE

Line 121: iby_trxn_core tc

117: tc.shipfromzip,
118: tc.shiptozip
119: from iby_batches_all b,
120: iby_trxn_summaries_all ts,
121: iby_trxn_core tc
122: where b.mbatchid = P_MBATCH_ID
123: and b.mbatchid = ts.mbatchid
124: and ts.trxnmid = tc.trxnmid;
125:

Line 284: iby_trxn_core tc

280: tc.shipfromzip,
281: tc.shiptozip
282: from iby_batches_all b,
283: iby_trxn_summaries_all ts,
284: iby_trxn_core tc
285: where b.mbatchid = P_MBATCH_ID
286: and b.mbatchid = ts.mbatchid
287: and ts.trxnmid = tc.trxnmid;
288:

Line 637: select /*+INDEX(TC IBY_TRXN_CORE_TRXNMID_U1)*/

633: l_ship_to_zip VARCHAR2(80);
634: l_ship_to_country VARCHAR2(10);
635:
636: cursor level2_trxn is
637: select /*+INDEX(TC IBY_TRXN_CORE_TRXNMID_U1)*/
638: ts.instrtype,
639: tc.card_data_level,
640: ts.tangibleid,
641: tc.instr_owner_postalcode,

Line 647: iby_trxn_core tc

643: tc.shipfromzip,
644: tc.shiptozip
645: from iby_batches_all b,
646: iby_trxn_summaries_all ts,
647: iby_trxn_core tc
648: where b.mbatchid = P_MBATCH_ID
649: and b.mbatchid = ts.mbatchid
650: and ts.trxnmid = tc.trxnmid;
651: