APPS.CSD_DEPOT_REPAIR_CNTR dependencies on RCV_TRANSACTIONS

Line 179: FROM rcv_transactions rcvt,

175: rcvt.transaction_id,
176: rcvt.last_updated_by who_col,
177: rcvt.subinventory,
178: hou.name organization_name
179: FROM rcv_transactions rcvt,
180: oe_order_headers_all oeh,
181: oe_order_lines_all oel,
182: hr_organization_units hou
183: WHERE oel.header_id = oeh.header_id

Line 235: from rcv_transactions

231: and nvl(cpt.serial_number_control_code,1) > 1;
232:
233: Cursor c_rcv_slnum_txn ( p_txn_id number ) is
234: select transaction_id
235: from rcv_transactions
236: where parent_transaction_id = p_txn_id;
237:
238: Cursor c_rcv_txn_serial_num ( p_txn_id number ) is
239: select serial_num