APPS.RCV_RMA_TRANSACTIONS dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;

2557: x_parent_txn_id rcv_transactions.transaction_id%type;
2558: x_parent_txn_date rcv_transactions.transaction_date%type;
2559: x_oe_order_line_id oe_order_lines_all.line_id%type;
2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;
2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;
2562: x_item_id mtl_material_transactions.inventory_item_id%type;
2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;
2564: x_oe_reference_order_line varchar2(30);
2565: -- Bug 12582249 End

Line 2562: x_item_id mtl_material_transactions.inventory_item_id%type;

2558: x_parent_txn_date rcv_transactions.transaction_date%type;
2559: x_oe_order_line_id oe_order_lines_all.line_id%type;
2560: x_oe_reference_order_line_id oe_order_lines_all.reference_line_id%type;
2561: x_so_issue_transaction_date mtl_material_transactions.transaction_date%type;
2562: x_item_id mtl_material_transactions.inventory_item_id%type;
2563: x_oe_reference_order_num oe_order_headers_all.order_number%type;
2564: x_oe_reference_order_line varchar2(30);
2565: -- Bug 12582249 End
2566: BEGIN

Line 2709: FROM mtl_material_transactions mmt

2705: BEGIN
2706: x_item_id := x_cascaded_table(n).item_id;
2707: SELECT max(mmt.transaction_date)
2708: INTO x_so_issue_transaction_date
2709: FROM mtl_material_transactions mmt
2710: WHERE mmt.inventory_item_id = x_item_id
2711: -- AND mmt.transaction_type_id = 33 -- Bug 16511481 removed
2712: AND mmt.transaction_action_id in (1, 7) -- Bug 16511481 added
2713: AND mmt.transaction_source_type_id = 2