71: tc.shipfromzip,
72: tc.shiptozip
73: from iby_batches_all b,
74: iby_trxn_summaries_all ts,
75: iby_trxn_core tc
76: where b.mbatchid = P_MBATCH_ID
77: and b.mbatchid = ts.mbatchid
78: and ts.trxnmid = tc.trxnmid;
79:
233: tc.shipfromzip,
234: tc.shiptozip
235: from iby_batches_all b,
236: iby_trxn_summaries_all ts,
237: iby_trxn_core tc
238: where b.mbatchid = P_MBATCH_ID
239: and b.mbatchid = ts.mbatchid
240: and ts.trxnmid = tc.trxnmid;
241:
578: tc.shipfromzip,
579: tc.shiptozip
580: from iby_batches_all b,
581: iby_trxn_summaries_all ts,
582: iby_trxn_core tc
583: where b.mbatchid = P_MBATCH_ID
584: and b.mbatchid = ts.mbatchid
585: and ts.trxnmid = tc.trxnmid;
586: