APPS.CSTPPINV dependencies on RCV_TRANSACTIONS

Line 231: from rcv_transactions rt, mtl_material_transactions mmt

227: -- they come in at PO price
228:
229: select nvl(rt.dropship_type_code, 3), mmt.transaction_cost, rt.parent_transaction_id
230: into l_dropship_type_code, l_txn_cost, l_parent_rcv_txn_id
231: from rcv_transactions rt, mtl_material_transactions mmt
232: where mmt.transaction_id = i_txn_id
233: and mmt.rcv_transaction_id = rt.transaction_id;
234:
235: END IF; /* end of check for consigned txfrs */

Line 247: from rcv_transactions

243: l_stmt_num := 66;
244: --"transaction_type = 'MATCH'" is added for bug 4892685, for non-dropship RTVs (unordered->Match->Deliver->RTV)
245: select dropship_type_code, transaction_id
246: into l_parent_ds_type_code, l_grandpa_rcv_txn_id
247: from rcv_transactions
248: where (transaction_type = 'RECEIVE' -- 'MATCH' cannot be parent because
249: and parent_transaction_id = -1)
250: OR transaction_type = 'MATCH'-- there won't be one in a true dropship
251: start with transaction_id = l_parent_rcv_txn_id