APPS.GMF_LC_ADJ_TRANSACTIONS_PKG dependencies on RCV_TRANSACTIONS

Line 92: rcv_transactions rt

88: SELECT NVL(pll.lcm_flag,'N'), NVL(pl.item_id,0)
89: FROM
90: po_line_locations_all pll,
91: po_lines_all pl,
92: rcv_transactions rt
93: WHERE
94: pll.line_location_id = rt.po_line_location_id
95: AND pl.po_line_id = rt.po_line_id
96: AND pl.po_line_id = pll.po_line_id

Line 155: rcv_transactions rt

151: CURSOR cur_asset_inventory(cp_rcv_transaction_id NUMBER ) IS
152: SELECT asset_inventory
153: FROM mtl_secondary_inventories subinv,
154: mtl_material_transactions mmt,
155: rcv_transactions rt
156: WHERE subinv.secondary_inventory_name = mmt.subinventory_code
157: AND subinv.organization_id = mmt.organization_id
158: AND rt.transaction_id = mmt.rcv_transaction_id
159: AND rt.transaction_id = cp_rcv_transaction_id;

Line 194: FROM rcv_transactions

190: */
191:
192: CURSOR get_rcv_trans(cp_transaction_id NUMBER) IS
193: SELECT parent_transaction_id, primary_quantity, destination_type_code
194: FROM rcv_transactions
195: WHERE transaction_id = cp_transaction_id;
196:
197: l_parent_rt_id NUMBER;
198: l_rcv_primary_qty NUMBER;

Line 340: FROM rcv_transactions rt

336: SELECT ABS(DECODE(p_adjustment_row.currency_code,rt.currency_code,
337: NVL(rt.po_unit_price,0) * NVL(rt.source_doc_quantity,0) ,
338: NVL(rt.po_unit_price,0) * NVL(rt.source_doc_quantity,0) * rt.currency_conversion_rate))
339: INTO p_adjustment_row.prior_landed_cost
340: FROM rcv_transactions rt
341: WHERE rt.transaction_id = p_adjustment_row.rcv_transaction_id;
342:
343: IF l_debug_level >= l_debug_level_low THEN
344: fnd_file.put_line(fnd_file.log,'Prior Landed Cost for Estimated: ' || p_adjustment_row.prior_landed_cost);