DBA Data[Home] [Help]

APPS.INV_PICK_SLIP_REPORT dependencies on DUAL

Line 305: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_header_id FROM DUAL;

301: FROM mtl_system_items
302: WHERE inventory_item_id = v_mo_line_rec.inventory_item_id
303: AND organization_id = p_org_id;
304:
305: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_header_id FROM DUAL;
306:
307: inv_replenish_detail_pub.line_details_pub(
308: x_return_status => x_return_status
309: , x_msg_count => l_msg_count